cancel
Showing results for 
Search instead for 
Did you mean: 

Error while executing report from Query Designer

Former Member
0 Kudos

Hi,

While executing the report from query designer we are getting following error.

Error while readind data, navigation is possible.

Error reading the data from infoprovider.

ORA-01722.Invalid Number.

Could anyone help us.

Thanks in advance..

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If there is a routine in the model which has code in it, check to see if the data definitions have been given properly.

Former Member
0 Kudos

Hi,

Thanks for Your Response.

We are not using any routines in this DSO.

Answers (2)

Answers (2)

Former Member
0 Kudos

Were you able to solve this problem? Please let me know the solution. I am facing similar problem.

Thanks!

~ Arun KK

Former Member
0 Kudos

Check whether the Infoprovider (DSO) from which the query is designed is active.

Former Member
0 Kudos

Yes. it's active. I dont get the msg when i do 'listcube'. error comes only when executing the query.

Former Member
0 Kudos

Try re-generating the Query from RSRT and then run the Query in RSRT. If it still gives an error, try making some changes to the Query definition.

former_member666940
Participant
0 Kudos

Hi,

Look at the settings of the DSO.

Make BEx reporting check.

Best Wishes,

SRS

Former Member
0 Kudos

Hi,

I have checked the settings, everything is checked.