Skip to Content

SDI - Data Provisioning Task Monitor - START & SCHEDULE flowgraph

I create a flowgraph which reads a table from source system to a virtual table in target SDI system and into a) SDI Hana table and also testing with target table as a "template' table.

Editor - Execute manually Flowgraph => Successful. Target tables loaded perfect.

ERROR occur when starting the exact same task from the Data Provisioning Task Monitor: What is causing this issue?

Starting Task <my-user>.system-local.public.ICC_NAV_NTS::FG_DD02L_MYSCHEMA

Error while starting Task: Code: 686, Message: dberror($.hdb.Connection.executeUpdate): 686 - SQL error, server error code: 686. start task error: [2620] executor: plan operation failed;Error executing "INSERT INTO "my-user"."TemplateTableDD02L"

Could not insert into table due to a unique constraint violation. at /data/jenkins/workspace/HANA__MT_CO_LIN64GCC48HAPPY_rel_122_06_ /s/ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/

Q: what is causing this error

Q2: Who is Jenkins? An SAP ghost?

SAP HANA v. 122.06, DU 1.3.8, DPA 1.3.9

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 18, 2017 at 10:19 PM

    I found that there is note open for this and a bug in the Task Monitor which is resolved in SP 2.0

    The Task monitor is not able to truncate the table.

    Solution: Starting the flowgraphs from the Data provisioning Design Time Object Monitor in the Hana Cockpit resolves this issue.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.