BI7 Upgrade Issue

[Former Member]

hi,

We are in the process of upgrading from BI 3.1 to BI 7.

During testing one of the queries through BEX ( Analyzer 7 ), we are getting the following error message whenever we try to refresh the query or change the variables :

"A table name is missing

An exception with the type CX_SY_DYNAMIC_OSQL_SYNTAX occured, but was neither handled...

Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION"

Also, please note that we have upgraded the query while opening it.

Have checked OSS and SDN for similar problem faced but have not come across any solution / note.

It would be great if anyone could help us on this issue.

regards,

Anirudha

[Former Member]

Hi,

Could you please try to run the report RSDG_ODSO_ACTIVATE for DSO and activate it again.

Regards,

Rafael

[Former Member]

hi Rafael,

We had activated the ODS ; we are getting the error even then. Please note that another query based on the same ODS is working fine.

regards,

Anirudha