Skip to Content
author's profile photo Former Member
Former Member

problem when executing query on infoset

hi all

we have our query on infoset which has a cube,dso and infoobject. since we had a new field to be added to dso i have deleted the dso from infoset and added it again once i have the new field added to dso. I have deleted and added it again because the new field was not showing up when i clicked on adjust infoset . now i have problem with the query we had on the infoset . all the f-125,f-126 so on.... number got changed when i deleted and added the dso.. now i have entered all the key fields and data fields of that dso again to the same query deleting the previous entries from the same dso which show up with error message ( objects not found in infoprovider). Once i again added all the key fields and data fields belonging to that dso to that query again when i check it doesnot show any errors but when i execute the query it is showing following errors.

error : illegal selection of infoobject from outer join table

error : error while reading data navigation is possible

error : Error while reading data; navigation is possible

>> Row: 11 Inc: RAISE_READ_ERROR Prog: CL_RSDRV_VPROV_BASE

please help

thanks & regards

Krishna

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2011 at 04:48 AM

    Hi,

    Check the note 1500161.

    Reason and Prerequisites

    This is NOT a program error. Excluding conditions in a LEFT-OUTER field of InfoSet queries do not make sense. The desired termination for such a situation (delivered with Note 1435772) prevents incorrect or undefined query statuses.

    Solution

    You can deactivate the termination after implementing these correction instructions. To do so, set the RSADMIN parameter EXCL_FOR_OUTER_JOIN to X using the report SAP_RSADMIN_MAINTAIN.

    Regards,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2011 at 06:32 AM

    thanks anil..

    actually there were some wrong variable selections given in char restrictions.I have made the changes it worked.

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.