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

Search for additional results

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