RSRV Check on Infoc - SID table /BI0/SREQUID does not contain a zero record

[Former Member]

Hi,

I performed a RSRV consistency check with my infocube and got this error - SID table /BI0/SREQUID does not contain a zero record.. Even if i tried to repair this error, it persists.

Previously i tried to click 'display data' of my infocube and also tried to execute query in BEx Analyzer i got - Error inconsistent input parameter(parameter: i_sid, value 0) in both SAP BW and BEx Analyzer.

Any suggestions on this? Help will be greatly appreciated. Thanks 😃

[Former Member · Accepted solution]

Hi,

you should be careful with this table! it contains all request IDs with their corresponding SIDs; never manipluate it yourself or with any program!

It is better to contact SAP regarding your error....

In any case, in all my systems I have a record with

REQUID = <empty>

SID = 0

CHKFL = X

DATAFL = X

INCFL = X.

in this table.

Depending on if you are in a sandbox or DEV or PROD... contact SAP and see if you can insert such a record in the table....

hope this helps...

Olivier.

[Former Member · Accepted solution]

Thx for your response.

Is there anyone who encountered this problem before and are there any solutions to overcome this.

[former_member219936 · Accepted solution]

Dear Lin,

The same issue I am facing now , it is CRM 5.2 System, I am planning to ask my basis person to give me the access so that I can create an entry .

I think you are on support pack 15 for BI System

Thanks,

krishna

Edited by: Sri Krishna Charan Viswanatha on Jan 8, 2008 6:50 AM

[Former Member · Accepted solution]

Hi Krishna,

Thanks for your reply. I know i have to insert the entry by executing an ABAP program which consists of SQL statements.

However, due to the fact that the entry is SID 0 and i read somewhere that the REQUID have to be <empty>.

Any sample code which i can refer to?

[Former Member · Accepted solution]

Hi,

I would open an CSS message to SAP.

Otherwise the code would be quite simple:

DATA: ls_requid LIKE /BI0/SREQUID.

ls-SID = 0.

ls-CHCKFL = 'X'.

ls-DATAFL = 'X'.

ls-INCFL = 'X'.

INSERT /BI0/SREQUID FROM ls_requid.

COMMIT WORK.

hope this helps...

Olivier.

[Former Member · Accepted solution]

Hi thanks for the code.

I have an error record with the code

Field "LS-SID" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement. "DATA" statement. "DATA" statement.

Edited by: Lin Zi Hui on Jan 9, 2008 10:25 AM

Edited by: Lin Zi Hui on Jan 9, 2008 10:28 AM

[Former Member · Accepted solution]

sorry, the full code should be

REPORT NAME_OF_YOUR_ABAP.

DATA: ls_requid LIKE /BI0/SREQUID.

ls_requid-SID = 0.

ls_requid-CHCKFL = 'X'.

ls_requid-DATAFL = 'X'.

ls_requid-INCFL = 'X'.

INSERT /BI0/SREQUID FROM ls_requid.

COMMIT WORK.