(BW-IP) Integrated Planning dump in all planning queries CL_RSR_TIME_RELATION_HDB======CP

[Former Member]

Dear all,

We have a problem in BW 7.31 with all planning queries (only with IP queries), when we run any planning query after the selection screen we have a timeout with the dump:

Category                 ABAP Programming Error

Runtime Errors        TIME_OUT

ABAP Program        CL_RSR_TIME_RELATION_HDB======CP

Application Component  BW-WHM-DBA

Thanks in advance,

Regards,

Jacob

[Former Member]

Dear Jacob,

As I see from dump:

SY-MSGID EU

SY-MSGNO 802

Would you please check if KBA

1981427 - Query fails with error "EU 802"

is relevant in this case?

Also please test Transaction RSRV->

All Elementary Tests->Master Data->Compare Number Range and Maximum SID, compare the character 0IOBJNM

if there is errors exists.

Best regards, Andras

[cornelia_lezoch]

Hi Jacob,

for planning questions it´s better to post here:

your error message looks to me like a system error, so I would search OSS or write a oss note.

regards

Cornelia

[Former Member]

Category               ABAP Programming Error

Runtime Errors         TIME_OUT

ABAP Program           CL_RSR_TIME_RELATION_HDB======CP

Application Component  BW-WHM-DBA

Date and Time          03.09.2015 16:39:55

Information on where terminated

     Termination occurred in the ABAP program "CL_RSR_TIME_RELATION_HDB======CP" -

      in "CREATE_DB_CONTENT".

     The main program was "WRITEQUERY ".

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

     of the (Include) program "CL_RSR_TIME_RELATION_HDB======CM00A".

Source Code Extract

Line  SourceCde

    14     l_t_time_periv type standard table of rsr_rel_time_fis.

    15   field-symbols:

    16     <s_time_periv> like line of l_t_time_periv.

    17

    18

    19   l_r_s_chas = create_data_chas( ).

    20   assign l_r_s_chas->* to <l_s_chas>.

    21   create data l_r_t_chas like standard table of <l_s_chas>.

    22   assign l_r_t_chas->* to <l_t_chas>.

    23

24   create(

25     importing

26       e_t_chas = <l_t_chas> ).

27

28   if n_with_periv = abap_false.

29     l_tabnm = n_c_tabnm_time.

30   else.

31     l_tabnm = n_c_tabnm_time_periv.

32     loop at <l_t_chas> assigning <l_s_chas>.

33       append initial line to l_t_time_periv assigning <s_time_periv>.

34       move-corresponding <l_s_chas> to <s_time_periv>.

35     endloop.

36     assign l_t_time_periv to <l_t_chas>.

37   endif.

38

39   " cleanup

40   delete from (l_tabnm).

41   " rebuild

42   insert (l_tabnm) from table <l_t_chas>.

43

>>> endmethod.

Contents of system fields

Name     Val.

SY-SUBRC 0

SY-INDEX 0

SY-TABIX 0

SY-DBCNT 2958464

SY-FDPOS 1

SY-LSIND 0

SY-PAGNO 0

SY-LINNO 1

SY-COLNO 1

SY-PFKEY GRID

SY-UCOMM

SY-TITLE BW: Test de salida

SY-MSGTY S

SY-MSGID EU

SY-MSGNO 802

SY-MSGV1 RSD_0INFOPROV_TXT_GET

[Former Member]

Hi Yiannis,

We have reviewed these notes, we have reactivated all the time characteristics from the bussiness content and we have the same problem.

Thanks,

DUMP:

Category               ABAP Programming Error

Runtime Errors         TIME_OUT

ABAP Program           CL_RSR_TIME_RELATION_HDB======CP

Application Component  BW-WHM-DBA

Date and Time          03.09.2015 16:39:55

Information on where terminated

     Termination occurred in the ABAP program "CL_RSR_TIME_RELATION_HDB======CP" -

      in "CREATE_DB_CONTENT".

     The main program was "WRITEQUERY ".

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

     of the (Include) program "CL_RSR_TIME_RELATION_HDB======CM00A".

Source Code Extract

Line  SourceCde

    14     l_t_time_periv type standard table of rsr_rel_time_fis.

    15   field-symbols:

    16     <s_time_periv> like line of l_t_time_periv.

    17

    18

    19   l_r_s_chas = create_data_chas( ).

    20   assign l_r_s_chas->* to <l_s_chas>.

    21   create data l_r_t_chas like standard table of <l_s_chas>.

    22   assign l_r_t_chas->* to <l_t_chas>.

    23

    24   create(

[former_member223480]

If you can please attach the full abap error (try to remove your system details)

tahnk you

Yiannis

[former_member223480]

Hi Jacob

I can see some issues on the sap knowledge base about this program (note 2162319, 2074801, 1927096). All of the messages from the knowledge base suggest to check calendar fields.

What steps you have followed until now?

A full abap dump is not so practical to have it in the message but we need more details from the error to understand a little bit more about your case. Read the message and try to remove the system info plus some static details and give us the points that might be evolved in the error.

Thank you

Yiannis