Delta load failures

[Former Member]

Hi Gurus,

While i am doing a delta update from ODS to cube i get an error mesage saying that "Error 1 in update".

and the system response is A caller 01, 02 or equal to or greater than 20 contains an error meesage.

I tried doing the repeat delta but it failed once again.

Could any one of you help me on this it is very urgent

point will be assigned.

Thanks

Subha

[Former Member]

Please check at Trnasfer structure .......newstatus of changed records,full update..options .

please selct one amongst and reload the data.

this may helps.

[Former Member]

Hi,

Since it is a delta load i cannot load to PSA as the other options are greyed out.

Could anyone of you please help me on this issue as this is very very critical.

Regards,

Subha

[Former Member]

Hi Subhasini,

Do you have the setting on the ODS to load data to Cube automatically??

Error 1 comes when data is being loaded from a flat file and the flat file is open ..

Regards.

[Former Member]

Hi

Create a New info package for same info source then psa option enabled then you can load to psa then you can simulate to data target.

Thanks

[Former Member]

hi

are you doing flat file extraction

revert back

[Former Member]

If you see the error in load monitor you can see the explanation message of the error please post this.....

Regards

Message was edited by:

Oscar Díaz

[Former Member]

Hi,

The error message says

Error 1 in the update

Message no. RSAR119

Diagnosis

The update delivered the error code 1.

Procedure

You can find further information on this error in the error message of the update.

but other than this information i get no other information from the monitor screen...

Thanks,

[Former Member]

Hi,

Could any one please help me.This is very critical.

Regards,

Subha

[Former Member]

Check at which infoobject this error ocurs..it might be usually with conversion routine.. like ALPHA is not enabled..for specific infobject..

moreover you are loading thru flat file....so you might not have leading zeros for say material ..for example... for any other infoobject which has conversion or fiscal year period , fiscal year variant are not properly converted to internal format you may get this error..check the infoobjects which has got conversion routine enabled and check the data..is it in the expected format

[Former Member]

Hi Subhashini,

You create new info package with processing type as only psa, once you load delta to psa do simulate update to data target then you can find out where the error exactly coming in some records showing error, just correct those things and then load into cube.

Sarath

[Former Member]

Please post the error meesage that is shown in the monitor

Regards

[Former Member]

Hi,

The error message is

"Error 1 in the update".

I am loading the data from a flat file to ODS and then a delta load to my cube.

The laod to ODS was successful but my delta load fails,no clue on why it has failed.

Checked the short dump no dumps ,checked SLG1 no clue...

could anyone help me out ....

regards,

Subha

[Former Member]

Is the delta job failing during loading or activation step ??

When you did the full load, did you mark the request as FULL REPAIR ? Else the activation of delta request would fail.

You can use the program RSSM_SET_REPAIR_FULL_FLAG to do this as well.

Good luck!

[Former Member]

Also since we are talking abt flat files, please make sure that the file is not open during loading (this error message usually pops up when you keep the file open during loading).

Good luck!

[Former Member]

Hi,

My load to the ODS is sucessful and the activated but when i do my delta load to the cube from ODS i get an error message as "Error 1 in update".

In case if i had my flat file open then i would get this message while loading the data to ODS itself...

can anyone help me...

regards

[Former Member]

go to infopackage..do a preview of your data.. check if you get any error message..

check if your file is closed.. if it client workstation..where you are uploading the file..

[Former Member]

Check for short dumps in ST22.

In the monitor screen of request, go to DETAILS tab and look for any extra information. Please paste it here and someone would be able to help.