SAP Knowledge Base Article - Preview

3202875 - Process chain on APD fails with dump DBSQL_SQL_ERROR Except. CX_SY_OPEN_SQL_DB

Symptom

Process chain execution on APD execution step fails with dump:

--------------------------------------------------
Category               Installation error
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

SQL error "SQL code: -10802" occurred while accessing table "/BIC/000APG*".

Database error text: "SQL message: Invalid numeric value for parameter/column (12) source type UCS2 (LE), target type FIXED8, value ''"

Return value of the database layer: "SQL dbsl rc: 99" 

"DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
"CL_RSAN_RT_GENERIC_RUNTIME====CP" bzw. CL_RSAN_RTG_IMP_GEN_SORT_DB
"P_OPEN"
--------------------------------------------------

The same APD execution is successful from RSANWB transaction.


Read more...

Environment

SAP NetWeaver 7.5

Product

SAP NetWeaver 7.5

Keywords

"DBSQL_SQL_ERROR", "CX_SY_OPEN_SQL_DB", "CL_RSAN_RT_GENERIC_RUNTIME====CP", "CL_RSAN_RTG_IMP_GEN_SORT_DB", "P_OPEN", "-10802", APD, "process chain", PC , KBA , BW-EI-APD , Analysis Process Designer , 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.