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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.