SID is Missing --- Error how to solve it?

[Former Member]

Hello All

When this "SID is missing error" will come and how to handle this error?

Whether this error will come while laoding Master or Transaction data?

Many Thanks

[Former Member · Accepted solution]

Hi balaji,

this error mostly occurs when

- you are trying to activate uploaded data in ODS released for BEx reporting or cubes

- uploaded data contain infoobjects with attributes

- there is no characteristic value in master data for such uploaded IO's.

The last condition is splitted into two particular situations:

1. There is an option in the infopackage that doesn't allow to create master data for new

characteristic values;

2. The option allows to create master data but the key value of IO is not acceptable for the

system. For example, lowercase letters or non permitted characters.

There is no remedy for the last situation. What you have to do is to check you incoming

data, find erroneous ones, correct them and upload again.

If the situation with invalid characters is repeated, then it's better to write routine(s)

in transfer rules to correct dataflow.

Regards,

jess

please award points if helpful..

[Former Member · Accepted solution]

hi Mathew

Thanks for your info given

when this invalid characters error will come either loading Master or Transaction data or both?and from which source syatem either r/3 or flatfile?

Pl let me know that?

Many Thanks

[edwin_harpino]

hi Balaji,

it can happened when loading master and transaction.

you try rsrv or program RSDMD_CHECKPRG_ALL.

[Former Member]

hi AHP

in rsrv how do v analyse this?

and how does this program RSDMD_CHECKPRG_ALL will help us?can u please elaborate this?

Many Thanks

[Former Member]

Hi Balaji,

It will come when you are loading transactional data.

It indicates that some master data is missing in the info object , that system is trying to load in the transactional data table.

This can be solved in 2 ways .

1. Update master data first and then transactional data.

2. There is one option in the update tab of infopackage

in that check the option

"Always update transactional data even if no master data exists."

Regards

Nimesh

Awarding points is the only way to say thanks.

[Former Member]

hi Nimesh

thanks for your info given

Many Thanks

[Former Member]

Hi dear,

take a look to OSS Notes by searching with "RSDMD_CHECKPRG_ALL" as key word: you will find a lot of info about this pgm that in a few words helps to assure (and repair) consistency of P,X,Q,Y tables for master data (look at RSRV transaction, this pgm is embedded there

Bye,

Roberto

[Former Member]

Hi Balaji,

You would primarily get this error when you load thetransaction data before loading the master data. You can also get this error when you forget to activate the master data after loading it.

You would get this error when the transaction data depends on the master data i.e your infopackage would have settings as " Do not update if no master data exists".

You would find lots of posts on this topic in these forums.

Bye

Dinesh

[Former Member]

hi Dinesh

Thanks!

according to ur st.,"You can also get this error when you forget to activate the master data after loading it",u mean to say like if the master data is changed and did'nt activated then this error might come?

Is there any chance of one particular characteristics is missing in your master data and when u r trying to load Transaction data this error will come for that particular characterictics? is this scenario is correct?

Many Thanks

[Former Member]

Hi Balaji,

SID missing error comes when the system is trying to load either the master or transaction data. If it is at the time of loading master data, problem could be the inactivated infoobjects, however if this issue is coming at the time of loading Trans data, it finds for the relevant master data for this trans data and tries to connect with the help of SIDs but as we don't have master data, it comes up with this error.

Hope it helps you!!!!

Regards,

Amit