Azure Data factory got error when getting information from SSMS(Epicor DB)

Question

Operation on target CP_Full_SqlServer_OnPrem_WinAuth failed: Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'ORDER BY list of RANGE window frame has total size of 8000 bytes. Largest size supported is 900 bytes.',Source=,''Type=System.Data.SqlClient.SqlException,Message=ORDER BY list of RANGE window frame has total size of 8000 bytes. Largest size supported is 900 bytes.,Source=.Net SqlClient Data Provider,SqlErrorNumber=8729,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=8729,State=1,Message=ORDER BY list of RANGE window frame has total size of 8000 bytes. Largest size supported is 900 bytes.,},],'

Answer 1

@Ripal Amin '

Thanks for reaching out MS Q&A

 The error message you’re seeing is related to a SQL operation that failed due to the size of the ORDER BY list in a RANGE window frame. The total size of the ORDER BY list is 8000 bytes, but the maximum supported size is 900 bytes. This is likely causing the SqlOperationFailed error.

To resolve this issue, you might need to reduce the size of the ORDER BY list in your RANGE window frame to be less than or equal to 900 bytes. If the issue persists, it could be beneficial to check the source database or adjust settings in Azure Data Factory.

1. Check the data types of the columns: If there are columns with large data types in the ORDER BY list, consider if they are necessary for sorting. Removing or replacing them with columns of smaller data types could resolve the issue.
2. Review your query logic: If the large ORDER BY list is necessary for your query, you might need to revise your query logic. Consider breaking down complex operations into simpler ones or using different methods to achieve the same result.

Please note that without more specific details about your database schema and the exact operation you’re trying to perform, it’s difficult to provide a more precise solution. If you’re still encountering issues, I would recommend reaching out to a database administrator or a professional with experience in SQL Server and Azure Data Factory for further assistance.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.