SAP Knowledge Base Article - Preview

1900538 - Error: "ORA-00904: "TABLENAME"."COLUMN_NAME": invalid identifier - Data Services


  • After upgrade from Data Services 3.x or earlier to Data Services 4.x or later, Oracle statements are failing on jobs that were previously working fine.
  • Error:  "SQL submitted to Oracle Server <oracle_server> resulted in error <ORA-00904: "TABLENAME"."COLUMN_NAME": invalid identifier>. The SQL submitted is <sql statement>."
  • Can no longer run jobs successfully after upgrading repositories using Repository Manager to 4.x versions from 3.x or 11.x versions.
  • Upgrade using Repository Manager or repoman ran successfully with no errors.



  • SAP Data Services
  • AIX
  • Oracle


SAP Data Services all versions


BODS, DSXI, lower case, upper case, Oracle, ORA 00904, invalid identifier , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.