Error when inserting the data record for data package

[Former Member]

Dear BW experts,

I'm trying to activate data in an ODS.

I get the following error:

Error when inserting the data record for data package

I've looked through previous posts and found some suggestions:

. Check Master data is loaded before transaction data and that Attribute/Hierarchy change run carried out - done

. Deselect option of SID generation and then activate ODS - done

. Check Master Data that is loaded before DSO load, then activate master data...- done

. Check the primary index on Active data table to see wether it is missing - done

(I went db02 "Missing Tables and indexes" shows all green. )

. RSKC- Allow special characters can use ALL_CAPITAL - done

None of the above worked...

. Se38: execute "RSDMD_CHECKPRG_ALL" to check the characteristics Infoobject consistency.

It shows the following red warnings:

- Characteristic 0HIER_VERS: Errors found during this test (no log)

- Characteristic 0HIER_VERS: 1 values from table /BI0/SHIER_VERS do not exist in table /BI0/SHIER_VERS (no log)

- Characteristic 0HIER_VERS: following versions are incorrect (display max 50.)

--> For this one there is a log : Hierarchy version SID

0 0

- Characteristic 0VENDOR: missing initial entry in table /BI0/Pvendor

- Characteristic 0VENDOR: Errors found during this test (no log)

- Characteristic 0VENDOR: 3 values from table /BI0/SVENDOR do not exist in table /BI0/SVENDOR(no log)

- Characteristic 0VENDOR: following versions are incorrect (display max 50.)

--> For this one there is a log : VENDOR SID

<blank> 0

20000004 0

TEST_PUR 0

etc, etc...

Can anyone help me decypher the above mentionned?

Looking forward to reading you.

Alice

Edited by: alice r. on Apr 15, 2010 10:53 AM

[Former Member]

Few entries for 0HIER_VERS and 0VENDOR got deleted from the master data tables.

You are trying to load transaction data for those deleted entries.

Update your master data or check to ensure those log entries are present there and active. Reupload ODS again.

This issue will not be there.

[Former Member]

Hi

Try performing RSRV tests for the info objects and the dso and correct error if any and if this is a dev system you can try adjusting the tables in question and then reload

Thanks

Puneet

[Former Member]

I have executed the tests for ODS (foreign key and check status test) and PSA (duplicate record check) but they came back green.

ODS is loaded with nothing since the loading has always failed.

The PSA is only loaded with one init request.

[Former Member]

@ Ganesh,

How to fill the Master Data for those objects?

Can I give any value?

[Former Member]

Hi guys,

I'm sorry I feel I should rephrase my previous posts...

Got a bit carried away.

I have rtested the PSA tables using RSRV -> PSA duplicate record check: it throws a short dump message type x.

I do not know what to make out of it. (It throws the error every time.)

And when I go to the PSA maintenance and check the records ... with status "erroneous", nothing is displayed.

So I feel the master data fixing is the way to go.

But I'm confused because I just did a reload of all master data...

Anyway I have basically 2 char which are giving problems:

0hier_vers and 0vendor.

How should I maintain the master data for these 2?

For instance 0vendor log shows:

SID V Vendor blank SID SID SID SID SID SID

0 A blank blank 0 0 0 0 0 0

6 A 2000004 blank 0 0 0 0 0 0

7 A TEST_PUR blank 0 0 0 0 0 0

What does that mean? And how to fix it?

Regards to all,

ALice

Edited by: alice r. on Apr 15, 2010 12:11 PM

[Former Member]

Thank you both for your answers...

The forum is not allowing me to give points at this moment

Anyway I went in the master data maintenance and fixed 0vendor.

for 0hier_vers it was a bit tricky...

One of the messages displayed after running pgm RSDMD_CHECKPRG_ALL was that:

values from table /BI0/PHIER_VERS do not exist in table /BI0/SHIER_VERS

So I tried the repair...

Then I check sdn again and it was suggested to run pgm: RSDMD_SID_P_Q_REPAIR, which I did for 0hier_vers...

And also RSD1 to repair infoobjects...

It seems to be ok now.

RSDMD_CHECKPRG_ALL gives me all green.

I'm trying to reload and reactivate now:-)