This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(278.4, 42%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Hello,
I 'm trying to use "Copy Data" action to copy data from Azure SQLDB to Oracle. It 's about 10 mins. later it gives an error like below. When I check column 205 in source, there are some data that it's size zero. I found a workaround exception number 1048576 to add my Azure Data Factory but I also use another workaround 536870912.
How can I use multiple workaround in Azure Data Factory. I tried to add "workarounds=536870912"
and "workarounds2=1048576" like on the picture where I attached. But it does not work.
Could you please help me?
UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY104] [Microsoft][ODBC Oracle Wire Protocol driver]Character, decimal, and binary parameters cannot have a precision of zero. Error in parameter 205.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY104] [Microsoft][ODBC Oracle Wire Protocol driver]Character, decimal, and binary parameters cannot have a precision of zero. Error in parameter 205.,Source=msora28.dll,'
Hello,
I still have same problem. Is there anyone to help me to add multiple workaround on Azure Data Factory?
![](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(310.4, 34%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYD%3C/text%3E%3C/svg%3E)
interestingly, we also got this error when assigning string data type. We found the problematic column. The column value is not "null", just "blank ('')".
We solved the problem by changing this column to nullif(column_name,'0') in the view table.
![](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(48, 37%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Hello team,
We have a source system(sqlserver) that might have blank values in many varchar columns instead of null - how we can handle those cases more dynamically instead of adding nullif in each and every view?
My case that using adf i want to copy data from sql server in oracle and i have 220 views that might contain varchar /char columns and i don't want to apply nullif in each and every view can we handle some how dynamically in adf?