Help needed :sapsql_array_insert_duprec Error

[Former Member]

hi friends,

When i try loading data to info cube iam getting the this short dump sapsql_array_insert_duprec,the load was successful previously but from today yesterday iam getting this message ,

i gues this is the problem with Number Ranges ,im not sure ....

How do i correct this error ...

please help me solving this ...

Thank you

Regards,

Ravi

[Former Member]

solved myself

[former_member415714]

Hi ravi kanth

I am facing the same question.

Could you please share me the solution?

[Former Member]

Check SAP Note 668466 - Loading master data: SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

hi ,

the following is the dump info i got

Information on where terminated

Termination occurred in the ABAP program "SAPLRSDV" - in

"RSDV_INSERT_VALID_TAB".

The main program was "RSBATCH_EXECUTE_PROZESS ".

In the source code you have the termination point in line 51

of the (Include) program "LRSDVU04".

The program "SAPLRSDV" was started as a background job.

Job Name....... "BIDTPR_9012_1"

Job Initiator.. "RAVIKANTHM"

Job Number..... 23153200

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

procedure "RSDV_INSERT_VALID_TAB" "(FUNCTION)", but it was neither handled

locally nor declared

in the RAISING clause of its signature.

The procedure is in program "SAPLRSDV "; its source code begins in line

1 of the (Include program "LRSDVU04 ".

Source Code Extract

Line SourceCde

21

22 PERFORM enqueue

23 USING i_infocube.

24

25 * Get metadata of cube

26 PERFORM get_cube

27 USING i_infocube

28 CHANGING l_s_cube

29 l_t_ic_val_iobj.

30

31 * if there is already some data for the same request

32 * append this data to the internal table and delete

33 * the data out of the db-table

34 * (this allows mass operations instead of single insert/update)

35 PERFORM get_data_of_same_request

36 USING l_s_cube

37 l_t_ic_val_iobj

38 CHANGING c_t_valid.

39

40 * compute lower and upper bound of validity slices

41 CREATE DATA l_dref LIKE c_t_valid.

42 ASSIGN l_dref->* TO <l_t_valid>.

43

44 PERFORM valid_from_to

45 USING l_s_cube-ncumtim

46 rs_c_false

47 l_t_ic_val_iobj

48 CHANGING c_t_valid

49 <l_t_valid>.

50

Source Code Extract

Line SourceCde

21

22 PERFORM enqueue

23 USING i_infocube.

24

25 * Get metadata of cube

26 PERFORM get_cube

27 USING i_infocube

28 CHANGING l_s_cube

29 l_t_ic_val_iobj.

30

31 * if there is already some data for the same request

32 * append this data to the internal table and delete

33 * the data out of the db-table

34 * (this allows mass operations instead of single insert/update)

35 PERFORM get_data_of_same_request

36 USING l_s_cube

37 l_t_ic_val_iobj

38 CHANGING c_t_valid.

39

40 * compute lower and upper bound of validity slices

41 CREATE DATA l_dref LIKE c_t_valid.

42 ASSIGN l_dref->* TO <l_t_valid>.

43

44 PERFORM valid_from_to

45 USING l_s_cube-ncumtim

46 rs_c_false

47 l_t_ic_val_iobj

48 CHANGING c_t_valid

49 <l_t_valid>.

50

Source Code Extract

Line SourceCde

21

22 PERFORM enqueue

23 USING i_infocube.

24

25 * Get metadata of cube

26 PERFORM get_cube

27 USING i_infocube

28 CHANGING l_s_cube

29 l_t_ic_val_iobj.

30

31 * if there is already some data for the same request

32 * append this data to the internal table and delete

33 * the data out of the db-table

34 * (this allows mass operations instead of single insert/update)

35 PERFORM get_data_of_same_request

36 USING l_s_cube

37 l_t_ic_val_iobj

38 CHANGING c_t_valid.

39

40 * compute lower and upper bound of validity slices

41 CREATE DATA l_dref LIKE c_t_valid.

42 ASSIGN l_dref->* TO <l_t_valid>.

43

44 PERFORM valid_from_to

45 USING l_s_cube-ncumtim

46 rs_c_false

47 l_t_ic_val_iobj

48 CHANGING c_t_valid

49 <l_t_valid>.

50

>>>>> INSERT (l_s_cube-ncumvaltab) FROM TABLE <l_t_valid>.

52 CLEAR c_t_valid.

53

54 ENDFUNCTION.

Regards,

Ravi