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 for Me (Login required).

Search for additional results

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