SAP Knowledge Base Article - Preview

1999317 - Upgrade to Data Services 4.2 causes Lookup issues


During a migration from 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 (to ver. 4.2 SP01)
  • Windows Server
  • Database: SQL Server 2008


SAP Data Services 4.2 ; SAP Data Services XI 3.2


KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.