Error when query is executed?

[Former Member]

When I exeucte the query I am getting below error.

not sure to about this error.

System error in program SAPLRRK0 and form RSRDR;CHECK_NAV_INIT_BACK (see long text)

Removed_by_moderator. Offering or asking for points is against the forum rules.

Thanks,

Vasu

Edited by: Pravender on Sep 9, 2010 8:23 PM

[Former Member · Accepted solution]

do you get error in RSRT ?

check below notes if they helps you!

Note 578948 - X299 Brain in SAPLRRK0: Form check_NAV_INIT_BACK-03-

Note 928584 - X299 Brain in SAPLRRK0; RSRDR;CHECK_NAV_INIT_BACK form

Note 928584 - X299 Brain in SAPLRRK0; RSRDR;CHECK_NAV_INIT_BACK form

[Former Member · Accepted solution]

Thanks and I am getting same error when i execute thorugh the RSRT.One intersting thing is this is happeing for only one key figure and when i tried with other keyfigures query is working fine.I also verified properties of this key figure and other ky figure and I did not find any differenc.

[Former Member · Accepted solution]

Can you check identification of keyfigure in MP and check properties of keyfigure in backend

[Former Member · Accepted solution]

I chcked the assignement in mullti provider and also checked the ky figure properties and I did not find any difference from other ky figures?

[Former Member · Accepted solution]

How many targets were included in MP ? from which target it has been marked ? if it's being marked from only one cube..

Please check the cube contents and restrict / and choose objects as per query definition and execute .. Also repeat the same at MP level .. it might gives some idea

[Former Member · Accepted solution]

I am getting that key figure from two ods and in assignemnt check mark both the ods have selected.

[Former Member · Accepted solution]

Display data at MP level by giving same selections/restrictions as they are in query definition

[Former Member · Accepted solution]

Yes data is appearing in MP.

[former_member186696]

Hello,

Go to RSRV and check if your query has any inconsistence, and then, try to fix it.

Also, this note could be helpful 421635.

regards,

Edward

[Former Member]

No actually the proble is with one of the restriction for Company code.I started adding each and every info objects and did not face any problem but when I add company code and had three restriction for that two are hiearchies and another one is company code-9008(exclude onption).When I add that one I am getting this problem.Also I tried with removing the company exclude 9008 and they query execuction works fine.But the results are getting multiplied by 3.I dont know wht could be the reason for this?

[Former Member]

1- At query level, where are you excluding Company Code '9XXXX' ?? In global filters? Default values? or Inside each single row or column ?

I suggest you to try at row or column level.

2- Are you using authorization relevant objects or customer exits there? If it is, go to Tcode SE38 ==> Display program ZXRSRU01, place a User breakpoint at the beginning of the loop. Then execute your query with the same user you putted the breakpoint and debug the variables in order to analize which values are being retrieved.

3- Create a copy of your query removing the company code exclusion. Go to web application designer, create a simple web template with two analisys items, two data providers (one with your original query and the other one with your new query), and two infofields. Assign one-to-one both Dataproviders (Analisys object 1 to Dataprovider 1, Analysis 2 to dataprovider 2, Infofield 1 to DP1, infofield 2 to DP2).

Execute the web template, see what the differences are.

Hope that helps, regards.