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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello team,
I have created a dataflow .And it is working fine.
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
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
SQL sink uses global temp db to stage data. Make sure that is configured for the account
If you have any useful link Please share it
Regards
RK
Please share the link for configuration.
Thanks
RK
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: