Forum Discussion
Incremental Copy Job error from NetSuite
I am trying to configure a copy job to incrementally load data from NetSuite SuiteAnalytics Connect.
The source is accessed using the NetSuite ODBC driver installed on an on-prem data gateway.
I receive this error when trying to run the job, regardless of table selected:
Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Error getting the literal value of right operand.[10169],Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Error getting the literal value of right operand.[10169],Source=NQoa27.dll,'
The field used as a watermark is recognised by Fabric as a datetime column.
Before I raise a support request with MS, has anyone else encountered this issue and found a solution?
5 Replies
HI jacob9hawkes ,
Did not encounter this situation , however, we might not know how Fabric formats the water mark column value, we can try using TO_CHAR or TO_DATE for comparison of date column instead of using the built-in watermark logic, so as NetSuite to understand.
Let me know if you try the above and if it works.
Thanks
Ati Puri
Hi jacob9hawkes ,
Thankyou for reaching out to Microsoft Fabric Community and thanks to ati_puri for providing meaningful insights.It looks like the error is happening when Fabric builds the incremental filter for the watermark column and the NetSuite ODBC driver tries to interpret the datetime value.
Could you check whether the copy job completes if it is set to a full load with incremental refresh turned off? If that works, it would point to the generated watermark predicate rather than a connectivity or table access problem.
Please also confirm that the watermark column is surfaced as a native DateTime/Timestamp field in SuiteAnalytics Connect, not as a calculated or text-based field. It may also be worth checking the NetSuite ODBC driver version on the gateway machine, since driver-specific SQL translation issues can sometimes impact incremental loads.
If the problem continues across multiple tables with valid datetime watermark columns, it may indicate a compatibility issue between Fabric's generated incremental query and the NetSuite ODBC driver, and the next step would be to open a support ticket.
For Reference;
Incremental copy in Copy job - Microsoft Fabric | Microsoft LearnTo create a Fabric or Power BI support ticket, please refer to:
https://learn.microsoft.com/en-us/power-bi/support/service-support
Best Regards,
Abdul Rafi.
Hi jacob9hawkes ,
I wanted to follow up on this issue. Have you had an opportunity to review the information provided above?
Could you please let us know whether you were able to raise a support ticket and, if so, whether any findings or resolution were shared? This information could be helpful for other community members who may encounter the same NetSuite incremental copy job error
Thank you for your understanding.
Best Regards,
Abdul RafiHi v-moharafi-msft,
I raised a support ticket and was informed that NetSuite does not currently support incremental copy jobs.
The specific explanation was 'NetSuite's ODBC driver does not support the parameterized WHERE clause syntax' used by Fabric data factory.
No ETA on a solution, but has been passed onto relevant teams.
Hi jacob9hawkes,
Thank you for sharing the update from the support team.Based on the support investigation, NetSuite’s ODBC driver currently does not support the parameterized WHERE clause syntax required by Fabric Data Factory incremental copy jobs, which explains the behavior observed. We appreciate you sharing this information, as it may help other community members facing the same issue.
Best Regards,
Abdul Rafi
