An upgraded job fails in SAP Data Services with the following:
SQL submitted to ODBC data source <srv095> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL Server]'row_number' is not a recognized function name.
Note: Job is upgraded from DS 14.0 to DS 14.2 SP6
Data Services: 18.104.22.1683
Repository: Oracle 11gR2
Source: SQL Server 2000
Target: Oracle 11g
Data Services, BODS, DS, Optimized SQL is not correct, job only has inner join, no left outer join , KBA , EIM-DS-EXE , Data Services Job Execution , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.