Unable to Load Data from ODS to ODS.

[Former Member]

Hi,

I tried to Load Data from X Ods to Y Ods, but it is giving dumb at the statement given below at ST22,

<b>INSERT /BIC/AYRM_O0500 FROM TABLE l_t_insert_req.</b>

I thought of due to Duplicate records in the Table, so i deleted the records by right click on the ODS and selected the Delete Data. I checked in the Active data, New Data and Change Log tables, records count is 0.

Even though it is giving the same dump with the above statement only.

Need your support in this regard.

Thanks in Advance.

Regards,

srinivas.

[Former Member · Accepted solution]

Hi,

Might be a lack of tablespace. Check with your basis guy.

Best regards,

Eugene

[Former Member · Accepted solution]

Looks like issue with..

1. Table space (or)

2. Target ODS ( Looks like u r target ODS Name is 'YRM_O05'.

Regards,

hari

[Former Member]

Hi Srinivas,

Instead of

INSERT /BIC/AYRM_O0500 FROM TABLE l_t_insert_req.

Try

Modify /BIC/AYRM_O0500 FROM TABLE l_t_insert_req.

Regadrs

Nimesh

[Former Member]

Srinivas,

have written any code in the update rules. did you written that state ment in the UR. then change it to Modify. if you are loading for first time, then make sure that update rules is correct. if you write the code in UR, change it to Modify. check the Short dump for further information.

if you loaded data before this, it could be problem with table space and Insert Statement(change it to Modify).

All the best.

Regards,

Nagesh Ganisetti.

[Former Member]

Hi All,

Thanks for your Help.

This is due to TAble space problem only.

Regards,

srinivas

[Former Member]

Hi,

Hi,

check for any short dump with detail analysis(Check in ST22). or activate transfer rules.

In X ODS how any records ?

-Shreya

[Former Member]

Hi Srinivas,

Try "Activate data in ODS" in the first ODS and then load to the second ODS.

For this, just right click the ODS and select "Activate ods data"

(You may assign points if this is helpful...)

Hope this helps.

Thanks,

Raj

Message was edited by: Raj