- 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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.