SAP Knowledge Base Article - Preview

2937535 - Upgrade of SAP HANA fails with error "User _SYS_TASK is not authorized"

Symptom

The upgrade of an SAP HANA System fails with the following exceptions on indexserver trace:

[78103]{-1}[-1/-1] 2020-06-06 17:21:49.693584 i Service_Startup catalog.cc(02118) : AutoMigration: Definition of system view _SYS_SCHEMAS_WITH_PRIVILEGES_ON has been changed. It's dropped and will be created again.
[78119]{-1}[-1/-1] 2020-06-06 17:21:49.724323 e Authorization InsufficientPrivilegeThrow.cpp(00116) : Keep authorization error: User _SYS_TASK is not authorized to access the 'VIEW' object "SYS"."HAS_NEEDED_SYSTEM_PRIV". The privilege 'SELECT' is missing.
[78227]{-1}[-1/-1] 2020-06-06 17:21:51.301823 e SQLScript so_transient_plan_generator.cc(00597) : Failed to generate scenario: _SYS_SS_CE_3389122_vers4_lang6_type1_CS_4_2_RET
[78103]{-1}[10/35928801] 2020-06-06 17:21:51.302702 e ddl qx_recompile.cc(00148) : exception 1: no.71002899 (ptime/query/sqlscript/codegen/so_transient_plan_generator.cc:597) TID: 78227
SQLScript internal error: SQLScript internal error: Failed to generate scenario: _SYS_SS_CE_3389122_vers4_lang6_type1_CS_4_2_RET
exception throw location:
1: 0x00007fb2d0bac3ed in ptime::so_transient_plan_generator::generateInMemoryCalculationScenario(ptime::Transaction&, char const*, char const*, ptime::so_transient_plan_generator::CreationMode)+0xb29 at so_transient_plan_generator.cc:597 (libhdbrskernel.so)
2: 0x00007fb2e764d8b5 in TrexCalculationEngine::CalculationEngineManager::getSQLScriptOnTheFlyScenarioName(TrexBase::IndexName const&, bool)+0x131 at ceManager.cpp:875 (libhdbcalcengine.so)
3: 0x00007fb2e77911aa in TrexCalculationEngine::Utils::resolveSqlProcedureReference(ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const&, TrexBase::IndexName&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >&)+0xa6 at ceUtils.cpp:1641 (libhdbcalcengine.so)
4: 0x00007fb2e7791cc0 in TrexCalculationEngine::Utils::resolveScenarioNameFromCalcIndexConfigInternal(TRexConfig::CalcIndex const&, TrexBase::IndexName&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >&, TRexCommonObjects::TRexApiError&)+0x330 at ceUtils.cpp:1765 (libhdbcalcengine.so)
5: 0x00007fb2e77922cc in TrexCalculationEngine::Utils::resolveScenarioNameFromCalcIndexConfig(TRexConfig::CalcIndex const&, TrexBase::IndexName&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >&, bool)+0x28 at ceUtils.cpp:1731 (libhdbcalcengine.so)
6: 0x00007fb2e794b74d in bool TrexCalculationEngine::CalcScenarioHandler::processNode<TRexConfig::CalcEngine::CalculationScenario, TRexConfig::CalcEngine::CalculationScenarioWriter>(TRexConfig::CalcEngine::CalculationNode&, TRexConfig::CalcEngine::CalculationScenario const&, TRexConfig::CalcEngine::CalculationScenarioWriter&, ltt::map<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> >, TRexConfig::CalcEngine::CalculationNode, ltt::less<ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > >, ltt::rb_tree_balancier> const&, unsigned int, unsigned int, TRexCommonObjects::SchemaError&, TrexCalculationEngine::CalcScenarioHandler::StateInfo&)+0x7499 at ceCalcScenarioDSNode.cpp:148 (libhdbcalcengine.so)
7: 0x00007fb2e7932407 in bool TrexCalculationEngine::CalcScenarioHandler::processInternal<TRexConfig::CalcEngine::CalculationScenario, TRexConfig::CalcEngine::CalculationScenarioWriter>(ltt::vector<TRexConfig::CalcEngine::CalculationNode>&, TRexConfig::CalcEngine::CalculationScenario const&, TRexConfig::CalcEngine::CalculationScenarioWriter&, unsigned int, TrexCalculationEngine::ScenarioHandleAccessor&, ltt::optional<TrexCalculationEngine::CalcScenarioHandler::StateInfo>&&, TRexCommonObjects::SchemaError&)+0x2c3 at ceCalcScenarioHandler.cpp:1433 (libhdbcalcengine.so)
8: 0x00007fb2e794f4f2 in TrexCalculationEngine::CalcScenarioHandler::process(TRexConfig::CalcEngine::CalculationScenario const&, TRexConfig::CalcEngine::CalculationScenarioWriter&, unsigned int, TrexCalculationEngine::ScenarioHandleAccessor&, ltt::optional<TrexCalculationEngine::CalcScenarioHandler::StateInfo>&&, TRexCommonObjects::SchemaError&)+0xa0 at ceCalcScenarioHandler.cpp:1312 (libhdbcalcengine.so)
9: 0x00007fb2e71bf81f in TrexCalculationEngine::CalculationEngineManager::createAndCheckScenarioInstance(TrexBase::IndexName const&, TrexCalculationEngine::CalculationEngineManager::ScenarioCreationOptions, ltt::optional<TrexCalculationEngine::CalcScenarioHandler::StateInfo>&&, TREX_ERROR::TRexError&, TRexCommonObjects::SchemaError&) [clone .constprop.979]+0xb9b at ceCalcScenarioHandler.h:1164 (libhdbcalcengine.so)
10: 0x00007fb2e764d3ad in TrexCalculationEngine::CalculationEngineManager::loadScenarioFromMetadata(TrexBase::IndexName const&, TrexCalculationEngine::CalculationEngineManager::ScenarioCreationOptions, ltt::optional<TrexCalculationEngine::CalcScenarioHandler::StateInfo>&&, TREX_ERROR::TRexError&)+0x79 at ceManager.cpp:1216 (libhdbcalcengine.so)
11: 0x00007fb2e763cd46 in TrexCalculationEngine::CalculationEngineManager::isCalcViewValid(TrexBase::IndexName const&)+0x3a2 at ceManager.cpp:3270 (libhdbcalcengine.so)
12: 0x00007fb2d75bf7ad in ptime::TrexMD::checkCalcViewValidity() const+0x39 at trex_metadata.cc:568 (libhdbcswrapper.so)
13: 0x00007fb2d15e7f5f in ptime::QueryExecutor::check_valid_calc_view(Metadata::CSCalcIndexInfo*)+0x26b at qx_cube.cc:880 (libhdbrskernel.so)
14: 0x00007fb2d15e9bff in ptime::QueryExecutor::alter_cube_main(ptime::ClassPtr<Metadata::ViewInfo>, ptime::qp_parse_tree const*)+0x68b at qx_cube.cc:602 (libhdbrskernel.so)
15: 0x00007fb2d13017e2 in ptime::QueryExecutor::alter_view(ptime::ClassPtr<Metadata::ViewInfo>, ptime::qp_parse_tree const*, bool, ptime::ViewRecompile)+0x160 at qx_view.cc:621 (libhdbrskernel.so)
16: 0x00007fb2d1620edd in ptime::QueryExecutor::recompile_related_object_view(ptime::ClassPtr<Metadata::ViewInfo>, bool, ptime::ViewRecompile)+0xb9 at qx.cc:3201 (libhdbrskernel.so)
17: 0x00007fb2d1621976 in ptime::QueryExecutor::recompile_related_object(long, ptime::object_type_t, bool, bool, bool, ptime::qp_list<ptime::qp_cstring_wrapper>*, ptime::ViewRecompile, bool)+0x102 at qx.cc:2949 (libhdbrskernel.so)
18: 0x00007fb2d14abdee in ptime::MetadataObjectRecompiler::recompileSingleObject(MultiDB::ObjectID const&, ptime::object_type_t, ptime::DistanceGroup&, ltt_adp::vector<ptime::DistanceGroup, ltt::integral_constant<bool, true> >&) const+0x18a at qx_recompile.cc:987 (libhdbrskernel.so)
19: 0x00007fb2d14b3c04 in ptime::ContinuousRecompileJobNode::run(Execution::Context&, Execution::JobObject&)+0x1c0 at qx_recompile.cc:239 (libhdbrskernel.so)
20: 0x00007fb2c3f6b868 in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x2174 at JobExecutorImpl.cpp:1157 (libhdbbasis.so)
21: 0x00007fb2c3f557d7 in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x313 at JobExecutorThreads.cpp:381 (libhdbbasis.so)
22: 0x00007fb2c3f57635 in Execution::JobWorker::run(void*&)+0xd51 at JobExecutorThreads.cpp:1278 (libhdbbasis.so)
23: 0x00007fb2c3f16b48 in Execution::Thread::staticMainImp(Execution::Thread*)+0x534 at Thread.cpp:529 (libhdbbasis.so)
24: 0x00007fb2c3f0679d in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x169 at ThreadInterposition.cpp:636 (libhdbbasis.so)
25: 0x00007fb2c3692ea5 in start_thread+0xc1 (libpthread.so.0)
26: 0x00007fb2c1f068dd in __clone+0x69 (libc.so.6)
exception type information:
- 0: public ltt::exception@0x7fb2c35f9960
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.392462 e Row_Engine ptime_error_code.cc(01515) : CAUTION!! no error description is found for error code: 2899
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.392488 e Row_Engine systables.cc(00064) : error during execution of CREATE VIEW _SYS_GRANTED_OBJECTS ( OBJ_ID, OBJ_TYPE ) AS SELECT EXTERNALOBJID OBJ_ID, O.NAME OBJ_TYPE FROM SYS.P_GRANTEDPRIVS_ G join SYS.P_OBJTYPES_ O on G.TYPEID = O.OID WHERE SUBTYPEID = 0 AND PRINCIPALID IN (SELECT OID FROM SYS._SYS_GRANTEE_OIDS) WITH READ ONLY. (ecode: 2899) detail : (no error description): SQLScript internal error: $msg$
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.392491 e Row_Engine systables.cc(00064) :
13969[thr=78103]: Assign at
1: 0x00007fb2c3ff06c9 in Diagnose::impl::dumpInfoSelfCtx(ltt::basic_ostream<char, ltt::char_traits<char> >&, bool, bool, bool, bool, bool, bool, unsigned long)+0x65 at Trace.cpp:32 (libhdbbasis.so)
2: 0x00007fb2d280490a in ptime::trace_exception_msg(ptime::PtimeException const&, char const*)+0x1b3 at systables.cc:64 (libhdbrskernel.so)
3: 0x00007fb2d18fec26 in ptime::create_internal_sys_views(ptime::Transaction&, bool)+0xa42 at systables.cc:212 (libhdbrskernel.so)
4: 0x00007fb2d195b435 in ptime::Catalog::runAutomatedMigration(bool)+0x701 at catalog.cc:2985 (libhdbrskernel.so)
5: 0x00007fb2d196c575 in ptime::Catalog::convertDBImageAfterRestart()+0x211 at catalog.cc:947 (libhdbrskernel.so)
6: 0x00007fb2d086001f in ptime::PTimeFactory::checkAndCompensateMetadata()+0x9b at ptime_factory.cc:794 (libhdbrskernel.so)
7: 0x000055c17fcad586 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0x952 at TREXIndexServer.cpp:1415 (hdbindexserver)
8: 0x000055c17fcb6a69 in TRexAPI::AssignThread::run(void*)+0x35 at TREXIndexServer.cpp:533 (hdbindexserver)
9: 0x00007fb2c8eaad1b in TrexThreads::PoolThread::run()+0x787 at PoolThread.cpp:462 (libhdbbasement.so)
10: 0x00007fb2c8ead7e0 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:143 (libhdbbasement.so)
11: 0x00007fb2c3f16b48 in Execution::Thread::staticMainImp(Execution::Thread*)+0x534 at Thread.cpp:529 (libhdbbasis.so)
12: 0x00007fb2c3f0679d in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x169 at ThreadInterposition.cpp:636 (libhdbbasis.so)
13: 0x00007fb2c3692ea5 in start_thread+0xc1 (libpthread.so.0)
14: 0x00007fb2c1f068dd in __clone+0x69 (libc.so.6)
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.401392 e Row_Engine ptime_error_code.cc(01515) : CAUTION!! no error description is found for error code: 2899
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.401404 e Row_Engine systables.cc(00064) : error during execution of Auto migration. (ecode: 2899) detail : (no error description): SQLScript internal error: $msg$
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.401406 e Row_Engine systables.cc(00064) :
13969[thr=78103]: Assign at
1: 0x00007fb2c3ff06c9 in Diagnose::impl::dumpInfoSelfCtx(ltt::basic_ostream<char, ltt::char_traits<char> >&, bool, bool, bool, bool, bool, bool, unsigned long)+0x65 at Trace.cpp:32 (libhdbbasis.so)
2: 0x00007fb2d280490a in ptime::trace_exception_msg(ptime::PtimeException const&, char const*)+0x1b3 at systables.cc:64 (libhdbrskernel.so)
3: 0x00007fb2d1962720 in ptime::Catalog::runAutomatedMigration(bool)+0x79f0 at catalog.cc:3743 (libhdbrskernel.so)
4: 0x00007fb2d196c575 in ptime::Catalog::convertDBImageAfterRestart()+0x211 at catalog.cc:947 (libhdbrskernel.so)
5: 0x00007fb2d086001f in ptime::PTimeFactory::checkAndCompensateMetadata()+0x9b at ptime_factory.cc:794 (libhdbrskernel.so)
6: 0x000055c17fcad586 in TRexAPI::TREXIndexServer::assign(NameServer::ServiceStartInfo&, bool, TREX_ERROR::TRexError&)+0x952 at TREXIndexServer.cpp:1415 (hdbindexserver)
7: 0x000055c17fcb6a69 in TRexAPI::AssignThread::run(void*)+0x35 at TREXIndexServer.cpp:533 (hdbindexserver)
8: 0x00007fb2c8eaad1b in TrexThreads::PoolThread::run()+0x787 at PoolThread.cpp:462 (libhdbbasement.so)
9: 0x00007fb2c8ead7e0 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:143 (libhdbbasement.so)
10: 0x00007fb2c3f16b48 in Execution::Thread::staticMainImp(Execution::Thread*)+0x534 at Thread.cpp:529 (libhdbbasis.so)
11: 0x00007fb2c3f0679d in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x169 at ThreadInterposition.cpp:636 (libhdbbasis.so)
12: 0x00007fb2c3692ea5 in start_thread+0xc1 (libpthread.so.0)
13: 0x00007fb2c1f068dd in __clone+0x69 (libc.so.6)
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.403125 e Row_Engine ptime_error_code.cc(01515) : CAUTION!! no error description is found for error code: 2899
[78103]{-1}[-1/-1] 2020-06-06 17:21:51.403115 e assign TREXIndexServer.cpp(01947) : assign failed with ltt exception. stopping service... :
ERROR [CODE-2899] (no error description): SQLScript internal error: $msg$
exception 1: no.71002899 (ptime/query/plan_executor/ddl/qx_recompile.cc:151) TID: 78103
SQLScript internal error: $msg$
NO exception throw location recorded. Stack generation suppressed.
exception type information:
- 0: public ptime::PtimeError@0x7fb2c93eb8b8 SI
- 0: public ptime::PtimeException@0x7fb2c93eb918 SI
- 0: public ltt_adp::exception@0x7fb2c93eb840 SI
- 0: public ltt::exception@0x7fb2c35f9960


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

upgrade, fails, incorrect, _SYS_TASK, user, authorized, authorised, update , KBA , HAN-LM-UPG-DB , Upgrade of HANA Database , HAN-DB-SEC , SAP HANA Security & User Management , HAN-DB-ENG , SAP HANA DB Engines , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.