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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.