ODS Activation terminated

[Former Member]

Hi Experts,

In my ODS there are 580000 records loaded successfully. ODS processing - PSA and then data target.

But activation terminated with the following errors.

Value 'FR # ' (hex. '46522023 ') of characteristic 0PYMT_METH contains invalid characters.

Error when assigning SID

Activation of data records from ODS object 0FIAR_O03 terminated

Error getting SID for ODS object 0FIAR_O03

Because i am loading from PSA, i should get the invalid characteristic error before Activation itself.

I reward full points for appropriate answers.

Thanks & Regards,

VSN

[Former Member · Accepted solution]

Because i am loading from PSA, i should get the invalid characteristic error before Activation itself.

No, invalid char errors are shown during the activation.

try passing ALL_CAPITALS in RSKC

[Former Member]

Hi vsn,

no, for ODS it works as follows.

1. Your data is first loaded to the NEW table. Posting data to the NEW table is nothing else than writing the data to the flat table. At this stage, this data as no meaning for the data warehouse because it has not been checked in terms of master data and SIDs.

2. Your data is activated; passed to the active table.

Here it depends on some settings:

- if your ODS is flagged for reporting (adding the meaning of the data) the system needs to link the fields values with the corresponding master data IDs of the IObjs and their surrogate IDs (SIDs).

If master data exists, fine the record will be activated.

If not, two options again:

- if your IPack has the option " Always update data, even if master data don't exists"; a SID will be generated and a master data entry as well if the IObj has master data (P, Q table of an IObj)

- if not, the activation will fail.

In addition, only a set of characters is allowed for master data IDs; in your case the sharp # is not allowed by default. You can extend the allowed characters in tx RSKC.

It is also possible to check this prior the posting into the ODS during the transfer rules. If the IObj has master data, enable the referential integrity check in the communication structure of your ISource for this IObj. The load will then fail if no master data exists for this IObj.

Another option is to check characters in a transfer routine...

hope this helps,

Olivier.

[Former Member]

Hi

If invalid characteristics found,it fails at the time of activation only..try to rectify it in psa and send it again and then activate it or add these new characteristics into RSKC and execute it.then load and activate it.

Hope it helps

Thanks

Teja