During a migration from 184.108.40.206 to 4.2 SP01, many of Data Flows of the same kind failing execution.
The dataflow has four sources from two different schemasof the same database (FRED_MART). It has a normal join into a Query transformation. In this Query transformation a few lookups into another database and pull the necessary fields (in the format "Double") into the Querytransformation.
A few calculations based out of the lookup values extracted was done and the dataflow resulted in the following errors:
1. SQL submitted to ODBC data source <lonssqldev01> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or  are not allowed. Change the alias to a valid name.
2. SQL submitted to ODBC data source <lonssqldev01> resulted in error <*****>. The SQL submitted is <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account.
- Data Services from 220.127.116.11 (to ver. 4.2 SP01)
- Windows Server
- Database: SQL Server 2008
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.