short dump during CIF RIMODGEN

[AA3]

Hi,

Some of our CIF jobs are failing with the error as below

SAPSQL_ARRAY_INSERT_DUPREC - CX_SY_OPEN_SQl_DB

Termination occurred in ABAP program SAPLCSRS in CIF_IMOD_MAP_T_SRCI, the main program was RIMODGEN

In the source code termination at line ---147 of the include program LCSRSU18

The termination is caused because exception CX_SY_OPEN_SQl_DB occurred in procedure CIF_IMOD_MAP_T_SRCI

Can anyone please explain me what this error means and are there any Notes to resolve this issue of standard program.

I am currently on SCM7 - ECC

[former_member197994 · Accepted solution]

Hi,

Please highlight more about the coding places where the dump happens, it may vary if the ECC version is different.

• read corresponding filter object key

SELECT * FROM cif_imsrci

INTO TABLE lt_cif_imsrci

FOR ALL ENTRIES IN it_segpos

WHERE segment = it_segpos-segment

AND pos = it_segpos-pos.

Best regards/Tiemin

[AA3 · Accepted solution]

I am currently on ECC 6 (ehp3) and SCM 7

[AA3 · Accepted solution]

Hi please find the code below

117| l_tabix = sy-tabix. |

118	MOVE-CORRESPONDING lt_t_srci TO lt_cif_imsrci. " Keys
119	PERFORM find_unused_imod_slot IN PROGRAM saplcmq2
120	USING
121	'CIF_IMSRCI'
122	CHANGING
123	l_next_segment
124	l_next_pos.
125	lt_cif_imsrci-segment = l_next_segment.
126	lt_cif_imsrci-pos = l_next_pos.
127	insert at the correct position for a binary search
128	INSERT lt_cif_imsrci INDEX l_tabix.
129	remember for later database insert
130	APPEND lt_cif_imsrci TO lt_cif_imsrci_ins.
131	return generated combination
132	MOVE-CORRESPONDING lt_cif_imsrci TO ot_segpos.
133	ELSE.
134	just checking, create a dummy entry so input and output table
135	correspond
136	CLEAR ot_segpos.
137	ENDIF.
138	ELSE.
139	found entry (either on DB or already generated), so return it
140	MOVE-CORRESPONDING lt_cif_imsrci TO ot_segpos.
141	ENDIF.
142	APPEND ot_segpos.
143	ENDLOOP.
144
145	store all newly generated combinations on the database
146	IF NOT lt_cif_imsrci_ins[] IS INITIAL.

|>>>>>| INSERT cif_imsrci |Failed here| 148| FROM TABLE lt_cif_imsrci_ins. |

149	ENDIF.
150

| 151| ENDIF.

[former_member197994 · Accepted solution]

Thank you for the details. Please run RCIFIMAX and RCIFIMDL. Note 1375209 should be applied if it's not in your system yet.

Best regards/Tiemin

[AA3 · Accepted solution]

Hi ,

The NOTE mentions about RIMODACT, our problem is during RIMODGEN.

Do we need to delete all the superfulous enties from RCIFIMDL ?