on 06-11-2009 5:23 PM
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
Hi All,
prolem solved. deleted and re-created the indexes of the BCS cube.
Thanks,
Harry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.