1999317 - Upgrade to Data Services 4.2 causes Lookup issues | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1999317 - Upgrade to Data Services 4.2 causes Lookup issues

Symptom

During a migration from 12.2.3.5 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.
 

Read more...

Environment

  • Data Services from 12.2.3.5 (to ver. 4.2 SP01)
  • Windows Server
  • Database: SQL Server 2008

Product

SAP Data Services 4.2 ; SAP Data Services XI 3.2

Keywords

KBA , EIM-DS-EXE , Data Services 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 ONE Support launchpad (Login required).

Search for additional results

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