Issue while loading data in BW Zextractor

[amine_lamkaissi]

Hi experts,

I ve enhanced a Zdatasource with a user exit, in that user exit i am creating new data regarding some conditions that business gived me.

FYI, this datasource is exctracting data from ECC table CATSDB, the key field is counter. So if CATSDB containes 1000 values, in my extractor i am generating more lines for example 1030 (30 is the new created data at my user exit level)

The created data is good, i increased the counter to 1030, but in BW my request is still yellow at PSA level.

Can someone tells me what's wrong?

RSA3 in ECC

PSA request BW

When i delete the code of data creation in my exit, everything is working fine.

I don't see wha'ts wrong.

Thanks for your help.

Amine

[RamanKorrapati · Accepted solution]

Hi Amine,

Please check the job log details at SM37 ecc side.

At info package montior screen, menu --> Environment --> job overview --> source system --> it will prompt for ID n PWD -enter and check the status.

select the job and click on job log details and check in detailed.

Thanks

[amine_lamkaissi · Accepted solution]

Hi Raman,

Congratulations for the platinium level

I was trough the job log as you showed to me, but i can't have the root cause (Job finished and request still yellow in BW)

Thanks.

Amine

[RamanKorrapati · Accepted solution]

Hi Amine,

Thank you for ur wishes.

As i guess Idocs not reached to bw from ecc which are carrying(finished message) completed info.

check at WE05 you may know.

its just idocs issue. noting to worry. check the idoc related t codes like SM59/BD87/WE20/WE21

Thanks

[amine_lamkaissi · Accepted solution]

Thanks Raman for your input,

What bother me, when i remove the code when i create new entries in my CMOD user exit. Everything is working fine.

Amine

[RamanKorrapati · Accepted solution]

Hi Amine,

As my guess this is not related to Code. its idocs are not reaching to target in time.

Mean while do the fine tune on code and try to load again.

is any authorizations are changed recently to background user ids?

is this happen to this load only or any other loads also?

Thanks

[Former Member · Accepted solution]

Hi Amine,

goto bd87 and check status of iDoc's.. this seems to be issue here.

Regards,

Ganesh

[amine_lamkaissi · Accepted solution]

Hi Raman,

Only for this load.

Thanks.

Amine

[amine_lamkaissi · Accepted solution]

Hi Ganesh,

On BW everything seems to be ok.

Amine

[RamanKorrapati · Accepted solution]

Hi,

if this is test load and full load. just delete(if possible) psa request and try to load again.

before that check SM58/SMQ1/SMQ2.

once you trigger the info pack load, keep on eye at SM37 ecc side and SM58. check it.

Thanks

[amine_lamkaissi · Accepted solution]

Hi Raman,

I had a short dump as following:

Runtime Errors         DBIF_RSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

Database error text........: "ORA-01438: value larger than specified precision

I think it's because of the counters that i am creating in user exit.

Amine

[RamanKorrapati · Accepted solution]

Hi Amine,

At Database level you need increares certain parameters.

please lookthe below links might be useful.

http://scn.sap.com/message/13753866

Also look at Note  1773797 - Dump RMCSS024 UPDATE_FROM_INT.

Thanks

[former_member182516 · Accepted solution]

Hi Amine,

Can you give a try by reducing the data packet size once while loading. here are the steps to reduce the data packet and no of idocs per data packet

- Double click on Info pacakge

- menu "Scheduler" --> Data Settings for sending data" --> down you will find a secntion "Reduce settings for data transfer from the source system" --> here enter data packet size

maximum size of data packet size --> 6000

Number of Idocs per data packet - 6

By default this will be arount 20000 and 10.Change the settings for FULL load option if you are performing a full if not change for delta or init respectively. and check

--> Comming to short dump: DBIF_RSQL_SQL_ERROR

Looks like PSA temp space issue,Check with BASIS on this short dump.

Why you are using the Custom data source for CATSDB table , SAP has provided a standard Business content data source 0CA_TS_IS_1 data source.

Check the below link

http://help.sap.com/saphelp_tm80/helpdata/en/c7/565f3ce4dd3370e10000000a114084/frameset.htm

Can you post the Custom code that you are using for this Z extractor?

Counter was not provided as part of Standard content but when we had same requirement to get the counter as key in CATS data source we had contacted SAP. SAp solution for this ... we can Add the counter feild to the standard FM of this data source.

CATS_BIW_GET_DATA2

--------------------------in the standard FM we had appended the counter feild so that we can extract it directly from Data source---------------

    call function 'CATS_BIW_CREATE_RANGES'

      exporting

        i_t_select = i_t_select[]

      importing

        range_tab  = g_t_select.

* add CATSDB fields for selection

  append 'COUNTER' to g_t_fields.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[amine_lamkaissi · Accepted solution]

Hi Prashanth,

Thank you for your clear explanations.

Datasource 0CA_TS_IS_1 was my firstproposal to business, we used it, but it wasn't convenient to them, this is why i created a custom one on CATSDB table.

Here's my custom user exit, please tell me if you see something wrong:

I didn't put any comments yet since i am on tests, tell me if there is something that you didn't understand.

WHEN 'YCO_NON_PROD_HRS'.
     DATA: s_data_cats TYPE zoxd780009.
     DATA: s_data_cats2 TYPE zoxd780009.
     DATA: s_ctshrs TYPE zoxd780009.
     data: it_data TYPE STANDARD TABLE OF zoxd780009.
     data: count type CATSCOUNTE.
     sort c_t_data.
     select max( counter ) into count from catsdb.
     LOOP AT c_t_data INTO s_data_cats.
 *Get WBS Element POSID.
       SELECT SINGLE posid INTO s_data_cats-posid FROM prps
         WHERE pspnr = s_data_cats-rproj.
       IF s_data_cats-refcounter IS NOT INITIAL.
         SELECT SINGLE * FROM catsdb INTO s_ctshrs WHERE counter = s_data_cats-refcounter.
         IF sy-subrc = 0.
           if s_data_cats-RPROJ eq s_ctshrs-RPROJ.
             s_data_cats-catshours = s_data_cats-catshours - s_ctshrs-catshours.
           else.
             add 1 to count.
             shift count right.
             overlay count with '000000000000'.
             s_data_cats2 = s_ctshrs.
             s_data_cats2-counter = count.
             s_data_cats2-apdat =  s_data_cats-apdat.
             s_data_cats2-status = '30'.
             s_data_cats2-catshours = s_ctshrs-catshours * -1.
             append s_data_cats2 to c_t_data.
           ENDIF.
         ENDIF.
       endif.
       modify c_t_data from s_data_cats.
       CLEAR s_data_cats.
       CLEAR s_data_cats2.
       clear s_ctshrs.
     ENDLOOP.

Thanks.

Amine

[amine_lamkaissi · Accepted solution]

In order to complete my previous message, here are the settings of my zdatasource:

Thanks.

Amine