SIDs Missing error

[usha_marudaipillai]

Dear BW experts,

                                  We are facing issues while executing query from portal/RSRT. XXX SIDs from characteristic XXX are missing(CL_RSDM_READ_MASTER_DATA_SIDVAL_DIRECT_READ2) is the error message received. Upon debugging the the given method, a select query is fetching the records from the SID table of the characterictic.While the query is executed, for the failed SIDs when I check the SID table entires are present in the database. What could be the reason for the select statement not to fetch the records when they actually exist in SID tables in database? Kindly help is anyone has faced issues like this. Thanks.

[usha_marudaipillai · Accepted solution]

Thanks all for your responses. The issue was solved by myself and it was due to buffering settings of SID tables in our system. As the SID tables were fully duffered, the new SIDs which are created in the table are not reflected in the buffer and hence the error. We have deactivated the buffer and it is working fine. SAP notes 912174 and 550784 explain about this issue. Thanks.

Regards,

Usha.

[Former Member]

use RSRV tcode

- all combined tests,

- select  master data.

  - give infoobject click on f8 r  correct error option in application tool bar

[former_member182970]

Hi Usha Marudaipillai

Try Repair your characteristic object, thanks.

-

Regards,

Mgande 

[S_Sriram]

Hi Usha.

Refer the SAP KBA  1989324 - SIDs from characteristic xxx are missing

Regards

SS

[sander_vanwilligen]

Hi,

I suggest to execute all master data checks using t/code RSRV for the affected Characteristic.

Best regards,

Sander