Dump error - currency translation task in BCS (SAPSQL_ARRAY_INSERT_DUPREC)

[Former Member]

Hi All,

I am getting dump error SAPSQL_ARRAY_INSERT_DUPREC while executing currency translation task in SEM - BCS for only some of consolidation units.

The below syntax is from dump.

INSERT (l_facttab) FROM TABLE g_t_u.

c_lines = sy-dbcnt.

• Check requid if no inconsistency is happened********************

CALL FUNCTION 'RSM_INFOCUBE_WRITE_CHECK'

EXPORTING

i_infocube = 'YBCS_C10'

i_rnsid = i_req_sid

EXCEPTIONS

write_not_allowed = 1

OTHERS = 2.

• shortdump if write is not allowed in the current state *********

• If no entry in the table RSMDATASTATE ===> no abort *********

IF sy-subrc = 1.

MESSAGE x299(brain)

WITH sy-repid i_req_sid.

ENDIF.

ENDFORM. "WRITE_ICFACT

Please help me out to resolve this issue.

Thanks,

Harry

[Former Member]

Hi All,

prolem solved. deleted and re-created the indexes of the BCS cube.

Thanks,

Harry

[Former Member]

HI

Analysing the code

Possibly reason must be that when you are executing the C/T task ,at same time

another load task creates SID values or master data for the same characteristic at the same time when attributes are loaded, you can only solve the problem by rescheduling. The load task in question must be scheduled in such a way that you can exclude simultaneous processing.

For further analysis send across the error message number

rgds

Dheeraj

[Former Member]

Hi Harry

Usually, the BW system clearly says that the transactional BCS' totals cube is switched off. But, several times I spent a few hours trying to find this simple reason when the system was very vague in explanation of the error.

Please check it out first.