1981341 - Error: "ORA-00942 when executing an imported FIM job" - FIM | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1981341 - Error: "ORA-00942 when executing an imported FIM job" - FIM

Symptom

An imported FIM job fails to run, producing the error "ORA-00942 - Table or view does not exist".

The folliowing other terms may be found in the FIM error log:

"DBS-070300: |Data flow DF_EXPORT_<job_name>|Loader FilterExport_SOURCE_<job_name> SQL submitted to Oracle Server resulted in error . The SQL submitted is . (14.0) <date and time> (E) (5428:6060) RUN-051005: |Data flow DF_EXPORT_<job_name>|Loader FilterExport_SOURCE_<job_name> Execution of for target <SOURCE_<job_name>> failed.

Possible causes: (1) Error in the SQL syntax; (2) Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.

(14.0) <date and time> (E) (6888:3496) RUN-050316: |Session <job_name> SQL submitted to Oracle Server resulted in error . The SQL submitted is .||<SOURCE_<job_name>> (14.0) <date and time> (E) (6888:3496) RUN-050304: |Session <job_name> Function call <raise_exception ( SQL submitted to Oracle Server resulted in error . The SQL submitted is .||<SOURCE_<job_name>> ) > failed, due to error : resulted in error . The SQL submitted is .||<SOURCE_<job_name>>>. (14.0) <date and time> (E) (6888:3496) RUN-050316: |Session <job_name> SQL submitted to Oracle Server resulted in error . The SQL submitted is .||<SOURCE_<job_name>>"


Read more...

Environment

SAP Financial Information Management (FIM) 10.0

Product

SAP Financial Information Management 10.0

Keywords

RUN-050316,RUN-051005,RUN-050304,DBS-070300,ORA-00942,Oracle,FIM,DS,Data Services,job,package,failure,fails,error,"Table or view does not exist",case,sensitive,sensitivity,upper case,lower case,mixed case , KBA , 3rd party tools config and system admin , EPM-FIM-DS , FIM & 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.