cancel
Showing results for 
Search instead for 
Did you mean: 

problem when executing query on infoset

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

thanks anil..

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

thanks

Former Member
0 Kudos

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