Data Loading Error in Production from ODS to InfoCube

[Former Member]

Hai

Im trying to load 6 lakhs records from ODS to Infocube in PRW. But im getting the following eror

<b>Error message from the source system

Diagnosis

An error occurred in the source system.

System response

Caller 09 contains an error message.

Further analysis:

The error occurred in Service API .

Refer to the error message.

Procedure

How you remove the error depends on the error message.

Note

If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.</b>

Please tell me wt i have to do for this one

rizwan

[Former Member]

HAI

Yes (the red request) is loaded in seperate Request . Now can i load that red request into InfoCube .

rizwan

[Former Member]

Hi

in the JOb log u will find

ARFCSTATE- sysfail... check it out..and at st22 also check it out

its better u load like this ...

1) Delete the request in the Info cube

2) delte the datamart status int he ODS

3) create a IP at the *8 tech neame .. generated Infosource of the ODS

4) check the Processign option as the PSA and datatargets subsequently

5) execute the IP

6) before executing DELETE THE INDEX

7) After Loading CREATE INDEX..

hope it helps

regards

AK

points=thanks

[Former Member]

Hai Edwin

These no shortdump .....

Pls suggest for this one

rizwan

[Former Member]

Hai Edwin

Thanks for your reply.

I loaded the 1 lakh records into InfoCube from ODS. Can i delete the index from the infocube now ...

Pls tell me . I will delete the index nw

rizwan

[edwin_harpino]

hi Rizwan,

it's loaded in separate request right ?

you can delete the index and load the next request.

hope this helps.

[Former Member]

Hi

Delete the index from infocube this is also one of the improve the performance and load the data.u can load from cube to ods that time before the laod the data u can delete indexes.

i hope this is helpful info

bye

Suresh Goud Burra

[edwin_harpino]

hi Rizwan,

check if any shortdump and message ST22 and SM21

most time delete first infocube index will speed up the loading.

infocube->manage->performance->delete index.

create index after loading.

hope this helps.