Error when Loading from ODS to Cube?

[Former Member]

Hi ,

I am loading data from ODS to cube.The load got failure .The data load from ODS to cube is FULL load.I checked in Error message tab(monitor) I could see three errors.

Error list:

1.Error 7 occurred when transferring an IDoc to the Business Information Warehouse.

2.SQL error in the database when accessing a table. 1

3.Errors in source system.

Please help me to resovle this.

[Former Member · Accepted solution]

Just exit from RSA1 and again go into tcode RSA1.

Reactivate DTP

Regards,

Mahendra

[Former Member · Accepted solution]

Thanks alot.

I did same thing and reloaded I am getting same error.

Can just help me to understand

Error list 1,2 and 3.

[Former Member · Accepted solution]

I got some thing related to this issue.

Here is documentation related to that one.Can any one explain it.

(taken from F1 help)

Definition

If the transfer structure to which this request was loaded has not been changed since the load, a green checkmark appears here, otherwise you will see a clock symbol.

The clock symbol means that the transfer structure with which the data is stored in IDoc/PSA is obsolete.

Dependencies

If the clock symbol appears it can no longer be ensured that the data will be able to be disassembled from the IDoc/PSA for the Info Source /Source System combination again. Then it is no longer possible to add this request to this InfoCube or to reconstruct the InfoCube with this request.

But for the request which I got an error that is having clock symbol.But for other success full requsts it is showing clock symbol.

[Former Member · Accepted solution]

Can nay help please?

[Former Member · Accepted solution]

The messages looks more like trouble from the R/3 side..

is the data in the DTP ok?

[Former Member · Accepted solution]

No I am loading data from ODS.Data in DTP is Ok.

[Former Member · Accepted solution]

Please any one can look into it?

[Former Member · Accepted solution]

Hi,

have you checked data in DSO, is it correct data available.

Also Check the Transformations between DSO and Cube.Is it in Active.

Let us know some inputs from you.......

Reg

Pra

[Former Member · Accepted solution]

Yes the DTP between DSO and Cube is in active status and the data in DSO is correct.But I could find the Clock symbol in the Reconstruction tab in the transfer structure status column there is tick mark for this present load which has gone wrong.But for all the other loads there is a clock symbol for which the data is correct in cube.Please let me know if u need any thing more.

[Former Member · Accepted solution]

>

> Yes the DTP between DSO and Cube is in active status and the data in DSO is correct.But I could find the Clock symbol in the Reconstruction tab in the transfer structure status column there is tick mark for this present load which has gone wrong.But for all the other loads there is a clock symbol for which the data is correct in cube.Please let me know if u need any thing more.

Hi Vasu,

1.Goto to the datatarget for which it was loaded (ur case infocube- - is it getting updated to multiple targets). Delete the bad request from cube then check with DSO - Manage screen. check for datamart status is Blank for the requests to be loaded- Refresh.

2.Try to activate the transformations for the DSO,Cube. Goto DSO- context menu- update datatarget- this will ensure the requests which are not updated from DSO are updated now.

3.now the cube contains the new requests which r loaded.

Regards,

Kp

[Former Member · Accepted solution]

Thanks a lot.

[Former Member]

Try to check data through RSA3.

regards,

Mahendra

[Former Member]

Hi Vasu.

Sometimes when there has beeen changes in the ODS, InfoCube, or transformation, the DTP needs to be refreshed or remade.

Remember to restart RSA1 also before you do this.

( If your in version 7).

[Former Member]

Thanks for the quick response.

Yes I am working on BI7 version.

Can you just tell what is this DTP Refreshing and Remade?

How to restart the RSA1?

Thanks in Advance.

Vasu