When running an XS job which calls a stored procedure to start a task flowgraph, if the user that excecute the job is different from the user that created the stored procedure & flowgraph, an error arises:
"InternalError: dberror(CallableStatement.execute): 686 - start task error: "<Schema>"."<Job name>": line 21 col 1 (at pos 1072):
 (range 3) start task error exception: start task error:
 executor: plan operation failed;Error executing "UPSERT "<SCHEMA>"."<TABLE>" ( <table column names> ) SELECT <table column names> FROM "<SCHEMA>"."_SYS_CE__popid_4_5BAD2492B58C11AFE10000000A68AA77_214"": insufficient privilege: Not authorized at sapmnt/ld7272/a/HDB/jenkins_prod/workspace/8uyiojyvla/s/ptime/session/eapi/jdbc/ExternalStatement.cc:954
SAP HANA Smart Data Integration
KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this pageThis 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.