How To Fix SZDM_CC_CHKS_TITLES126 - An XPRA report accessed a table with Native-SQL

SAP Error Message - Details

• Message type: E = Error

• Message class: SZDM_CC_CHKS_TITLES - Title messages related to check classes

• Message number: 126

• Message text: An XPRA report accessed a table with Native-SQL

What causes this issue?

A trace in one of the SAP internal test systems has found that your XPRA
accessed a database table by native SQL (either EXEC-SQL or ADBC).
The name of the XPRA and the name of the system where the trace was
executed and where you can find the call stack leading to the native SQL
command can be found in the detailed messages. Inspect the call stack in
order to find out the name of the accessed database table.

System Response

If the XPRA runs as part of a zero-downtime-upgrade in a customer
system, then the upgrade procedure aborts with an error message. Solving
this kind of errors requires help from the SAP development support.

How to fix this error?

If you have already declared the table that your XPRA accesses via
native SQL, then apply for an exemption for this ATC-message.
If you have not yet declared the table, then make the necessary
declaration in your development or maintenance system:

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Call transaction SLAPI
Search for an entry with name
SAP_XPRA_<name of the XPRA-report> or
<namespace>SAP_XPRA_<name of the XPRA-report>.
If there is no such entry, then create a new one with this name.
For this SLAPI-entry, select "Used database tables" in the navigation
area.
Enter the names of the accessed tables with an appropriate value for
"Access type" and "Lock mode".
If the RFC-module calls an APIs that is listed in transaction SLAPI,
then enter the name of this APIs in "Ref to other API".
If the RFC-module calls an API that is not listed in transaction SLAPI
then ask the owner of the API to create an SLAPI entry for this API and
declare all accessed tables there.
<DS:TX.SZDM_CC_GENERAL_ZDO>Further information ...</>

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SZDM_CC_CHKS_TITLES126 - An XPRA report accessed a table with Native-SQL ?

  The SAP error message SZDM_CC_CHKS_TITLES126 indicates that an XPRA (a type of report used in SAP for data migration or adjustments during upgrades) has accessed a table using Native SQL, which is not allowed in certain contexts. This error typically arises during system upgrades or when executing specific reports that are not compliant with the current system's data access rules.
  Cause:
  
  Native SQL Usage: The XPRA report is trying to access database tables directly using Native SQL, which can lead to inconsistencies and is generally discouraged in favor of Open SQL.
  Upgrade Issues: This error often occurs during system upgrades when certain reports or programs are not updated to comply with the new standards or restrictions.
  Custom Code: If there are custom developments or modifications that utilize Native SQL inappropriately, this can trigger the error.
  
  Solution:
  
  Review the XPRA Report: Check the specific XPRA report that is causing the error. If it is a standard SAP report, ensure that you are on the latest version of the software, as SAP may have released a fix.
  Modify Custom Code: If the error is due to custom code, refactor the code to use Open SQL instead of Native SQL. This will ensure better compatibility with SAP's data access rules.
  Check for Notes: Look for SAP Notes related to the specific XPRA report or the error message. SAP often provides patches or workarounds for known issues.
  Consult Documentation: Review the documentation for the XPRA report to understand its requirements and limitations.
  Contact SAP Support: If the issue persists and you cannot find a resolution, consider reaching out to SAP Support for assistance.
  
  Related Information:
  
  XPRA Reports: These are programs that are executed during system upgrades to adjust data structures or migrate data.
  Native SQL vs. Open SQL: Native SQL allows direct access to the database, while Open SQL is a database-independent way of accessing data in SAP, which is preferred for compatibility and maintainability.
  SAP Notes: Regularly check the SAP Support Portal for notes that may address specific issues related to your version of SAP.
  
  By addressing the underlying cause of the error and ensuring compliance with SAP's data access standards, you can resolve the issue effectively.