can't load data to cube :Exception in Substep Write to Fact Table

[Former Member]

hi, expert

    i am try to load data from dso(just 70 records) to custom cube,  and i am get some errors:

Exception in Substep Write to Fact Table

Messages for 1 data records saved; request is red acc. to configuration

Processing terminated

my bw is 7.3 sp4. i have check the note 1657246  - Problems loading data in BW 7.3 SP4&5

i can't confirm is it a sap programe issue.  i have reactive cube, dtp, transformation, or try create a new cube,  still error.

how to sovle this issue?  thanks for help.

xwu.

[Former Member · Accepted solution]

dear all, this issue has been fixed by myself, one of the infobject lowercase letters settings is off, but the data contains ABcD. so just change to on, and reload it again.

[former_member221711]

Hi,

Please check if ur SID table for fiscal variant has proper entries.

Refere the screen shot.

Also check the table T009 for fiscal variant

[Former Member]

Hi ,

Try among below 3 options -->

1.You verify in transformation level, weather mapping is ok with source  field to target info object..

2.Before loading the data, in the DTP check the following settings ->Update Tab->Error handling-> Valid Records update, Reporting poss (Request Green).

Here all the valid records will get updated to target.

After that the data load, in the monitor screen of DTP-> Click on the error Stack , here you can view the erroneous record. Correct the record and create a error DTP and upload the same.

3.If there's no need to create report in dso level  , switching off the auto SID checkbox .

Regards,

B Devi

[Former Member]

yes, i have test SID for cube, there is no error.  when i reactive dso , occurs warnings:

InfoObject 0FISCVARNT needs to be in key for DataStore object z****

in my cube contains 0FISCVARNT, 0FISCER.

[former_member182470]

Is your DSO old one or created it freshly?

What are your key fields in it? Can you keep fiscvariant to key fields as per error message?

[former_member199691]

DSO gives that warning for 0FISCVARNT but if you believe you dont need it as part of the keys, it is ok.

[MGrob]

Hi

Is the cube restricted to a fix value on 0fiscvarnt? Are you supplying the 0fiscvarnt because you need it together with 0fiscper. Try to put 0fiscvarnt in you DSO key and see if it helps. SPS4 on 7.30 is not that high it could also be an issue related to a program error on SAP side.

hope that helps

Martin

[Former Member]

dear all, thanks for reply, there is no dump in st22, no routine in transformation, i have just test dso in rsrv,  it occurs error : The SID values are missing for 2 specifications for characteristic z***.

[RamanKorrapati]

Hi.

your DSO SID settings are off?

Try to test SID at RSRV for info object also

Thanks

[former_member182470]

If you got errors in RSRV, you can repair them by tapping Repair button in RSRV. After that, you can again try to load.

[former_member199691]

is it a short dump or error?

is there any routine in the transformation?

may be it is an data issue e.g. date being some wrong value, missing units or lowercase letters.

Please provide some more details about the issue.

[RamanKorrapati]

hi,

Assuming as your DSO data was activated. is it full or delta dtp.

please check whether any dump exist at ST22 for this.

have you tried to create new transformations?

Thanks