SAP Knowledge Base Article - Preview

2870742 - Datasource 1CL_ : SQL error -302 occurs during the extraction

Symptom

When extracting classifications using 1CL_ Datasource, the dump below is generated in the BW system:

SQL error "-302" while accessing table "/BIC/B0000nnnnnn".     <----- PSA table
Database error text: "SQL0302N The value of a host variable in the EXECUTE or
OPEN statement is out of range for its corresponding use. SQLSTATE=22003
row=1142"


Read more...

Environment

  • Source System of BW system
  • SAP R/3
  • SAP R/3 Enterprise
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA 

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

1CL, 1CL_*, CLBW 031, CLBW031, CONVT_OVERFLOW, ORA-01438, 01438, CTBW_GET_CLASSIFY_DATA, INSERT_ODS, overflow , KBA , BW-BCT-CL , BW only - Classification System , 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.