Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,467 questions
ADF Copy Activity failed with ORA-00928: missing SELECT keyword
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 96%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vivek, Anand
20
Reputation points
ADF Copy activity is failing with following error.
Its happening after copying certain amount of data. So don't think its issue with pipeline.
Also same pipeline works in another environment(PROD/DEV) so mostly its data issue. How to identify what is causing this issue? I am using Self hosted IR.
Operation on target Copy <XXXXX> failed: Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00928: missing SELECT keyword ,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00928: missing SELECT keyword ,Source=msora28.dll,'
{count} votes
-
ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee2024-05-13T06:37:32.8033333+00:00 Hi Vivek, Anand,
Thank you for posting query in Microsoft Q&A Platform.
Could you please share more details about ADF Copy activity configuration?
What is source dataset and configuration details?
What is Sink dataset and configuration details?As you are saying, its failing after partial copy, Did you tried to enable
Fault toleranceoptions under settings of copy activity? -
Vivek, Anand 20 Reputation points
2024-05-13T06:57:35.4033333+00:00 Source is SQL Server
Sink/Target is Oracle 19CTried Fault tolerance as with "Skip incompatible rows". No Luck.
-
ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
2024-05-15T05:06:49.5666667+00:00 Hi Vivek, Anand,
Thank you for sharing it. Could you please share more about configuration details of source and sink tabs? That helps to get an idea what might be reason. -
ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
2024-05-20T10:53:23.73+00:00 Hi Vivek, Anand, Just checking if you get chance to share updates? Thank you.
Sign in to comment