2139211 - SAPSQL_ARRAY_INSERT_DUPREC or DBSQL_SQL_ERROR dump in "WRITE_ICFACT" during Infocube update | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2139211 - SAPSQL_ARRAY_INSERT_DUPREC or DBSQL_SQL_ERROR dump in "WRITE_ICFACT" during Infocube update

Symptom

While updating an Infocube with DTP or a Transactional cube with rsdri_cube_write_package the following dump happens:

Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC
Except.                CX_SY_OPEN_SQL_DB

 The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
    procedure "WRITE_ICFACT" "(FORM)", but it was neither handled locally nor
     declared
    in the RAISING clause of its signature.
 
 OR

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

 SQL error "SQL code: 1204" occurred while accessing table "/BIC/Fxxxxx"
"WRITE_ICFACT"

The main program was "RSBATCH_EXECUTE_PROZESS

 4276   KEY_xxxxx
 4277   KEY_xxxxx
 4278   KEY_xxxxx
 4279   .
 4280
>>>>> INSERT (l_facttab) FROM TABLE g_t_u.
 4282 c_lines  = sy-dbcnt.
 4283


Read more...

Environment

SAP NetWeaver

Product

SAP NetWeaver all versions

Keywords

Business Warehouse, BW, coherency, RSCV661 , KBA , BW-WHM-DBA , Data Basis , BW-WHM-DST-DTP , Data Transfer Process , 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.