cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

Former Member
0 Kudos

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 ๐Ÿ˜ƒ

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

Thx for your response.

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

0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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.

Answers (0)