Symptom
- Job RC_COLLECT_ANALYSIS_DATA cancels with the following error:
Error occurs with Financial Data Quality data collection job TMW_RC_FDQ_DATA_COLL.
Job cancelled after system exception ERROR_MESSAGE - Job TMW_RC_FDQ_DATA_COLL cancels with errors:
Internal session terminated with runtime error SAPSQL_INVALID_TABLENAME (see ST22)
The details of runtime error SAPSQL_INVALID_TABLENAME can be different. It's needed to check the detailed dump Error Analysis in transaction ST22.
- Dump one
Runtime Errors SAPSQL_INVALID_TABLENAME
Exception CX_SY_DYNAMIC_OSQL_SEMANTICSError analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was not caught in
procedure "GET_MAX_RUNID" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the exception would occur,
the current program is terminated.
The reason for the exception is:
An invalid table name "FIN_AA_CORR_PACK" was specified in an Open SQL command:Due to one of the following reasons, the error occurs only at runtime:
- the table name was specified dynamically, or
- the SELECT clause, WHERE clause, GROUP-BY clause, HAVING clause, or
ORDER-BY clause was specified dynamically. - Dump two
Runtime Errors SAPSQL_INVALID_TABLENAME
Exception CX_SY_DYNAMIC_OSQL_SEMANTICSError analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was not caught in
procedure "GET_MAX_RUNID" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the exception would occur,
the current program is terminated.
The reason for the exception is:
An invalid table name "FIN_ML_CORR_PACK" was specified in an Open SQL command:Due to one of the following reasons, the error occurs only at runtime:
- the table name was specified dynamically, or
- the SELECT clause, WHERE clause, GROUP-BY clause, HAVING clause, or
ORDER-BY clause was specified dynamically. - Dump three
Category ABAP programming error
Runtime Errors SAPSQL_PARSE_ERROR
Except. CX_SY_DYNAMIC_OSQL_SEMANTICS
ABAP Program CL_RC_FDQ_ML_MONITOR==========CP
Application Component SV-SMG-DVMError analysis
An exception has occurred which is explained in more detail below. The
exception is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS' and was not
caught in procedure
"GET_MAX_RUNID" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated this
exception, the current program was terminated.
The reason for the exception is:
The current ABAP program attempted to execute an Open SQL statement
containing a dynamic entry. The parser returned the following error:""FIN_ML_CORR_PACK" is not defined in the ABAP Dictionary as a table,
projection view, or database view."
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
SAP ERP
Product
Keywords
ABAP program "CL_RC_FDQ_FI_AA_MONITOR=======CP" CX_SY_DYNAMIC_OSQL_SEMANTICS, GET_MAX_RUNID, RC_COLLECT_ANALYSIS_DATA, FIN_AA_CORR_PACK, FIN_ML_CORR_PACK , KBA , SV-SCS-S4R , SAP Readiness Check , CO-PC-ACT , Actual Costing , FIN-MIG-AA , Data migration for Asset Accounting , Problem
About this page
This 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.
SAP Knowledge Base Article - Preview