SAP Knowledge Base Article - Preview

3368782 - Runtime Errors SAPSQL_INVALID_TABLENAME when collecting the Financial Data Quality data in SAP Readiness Check Report 2.0

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_SEMANTICS

Error 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_SEMANTICS

Error 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.

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

SAP ERP all versions

Keywords

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.