- 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.
SAP Data Services 14.x
SAP Data Services 4.2
KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.