Sink Activity issue

Rohit Kulkarni 441 Reputation points
2021-02-18T13:00:02.193+00:00

Hello team,

I have created a dataflow .And it is working fine.

69555-image.png

But when i mapp this dataflow to pipeline and run the pipeline at that time i am getting the below mentioned error :

{"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'Deletecompanyrows': shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Cannot create a global temporary table.","Details":"at Sink 'Deletecompanyrows': shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Cannot create a global temporary table."}

Please refer the screenshot and marked in blue and advise .

Thanks
RK

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,219 questions
{count} votes

Accepted answer
  1. Rohit Kulkarni 441 Reputation points
    2021-02-19T11:33:14.593+00:00

    even after uncheck the Use TempDB.I am getting the same error .

    Error :DF-TBL-003 at Sink 'Deletrows': Key column(s) should be specified for non-insertable operations (updates/deletes) - RunId: 5047e016-dc36-41a6-9fc5-6398cdbb86f1

    70091-image.png


6 additional answers

Sort by: Most helpful
  1. Kiran-MSFT 696 Reputation points Microsoft Employee
    2021-02-18T17:37:18.96+00:00

    SQL sink uses global temp db to stage data. Make sure that is configured for the account

    0 comments No comments

  2. Rohit Kulkarni 441 Reputation points
    2021-02-18T17:58:50.813+00:00

    If you have any useful link Please share it

    Regards
    RK

    0 comments No comments

  3. Rohit Kulkarni 441 Reputation points
    2021-02-19T09:48:38.233+00:00

    Please share the link for configuration.

    Thanks

    RK

    0 comments No comments

  4. Rohit Kulkarni 441 Reputation points
    2021-02-19T09:57:31.597+00:00

    I have removed the alter row in Pipeline and used only source and delete rows

    And i have used as a Trucate Table in sink activity.But still i am getting error :

    DF-TBL-003 at Sink 'sink1': Key column(s) should be specified for non-insertable operations (updates/deletes) - RunId: f7c75ce6-8c32-4f6c-b3d0-33e353dfa5b8

    Please refer the screenshot:

    70010-image.png

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.