SAP Knowledge Base Article - Preview

2921205 - ORA-01722 error when using calculated views - Data Services

Symptom

  • A job using an Oracle calcuated view suddenly fails with the following error:
    Error "<ORA-01722: invalid number>. The SQL submitted is SELECT " " FROM "database"."Table""
  • Same error is seen when viewing data in the datastore connection.
  • When the calculated view is refreshed on the Database side, the error is resolved for a short time only.


Read more...

Environment

SAP Data Services 14.x

Product

SAP Data Services 4.2

Keywords

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.