The following database error occurred: ORA-00936: missing expression . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF WIS 10901)

tcpatil121 · November 11, 2020, 10:06am

Hi Experts,

We are upgrading BO SP 03 to BO SP-08 IDT and Webi.

SP-03 webi reporting working fine and stable but new SP-08 all webi report showing below error while refreshing and some prompt values does not show any value.

Can you please help how to resolve this

The following database error occurred: ORA-00936: missing expression
.For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF WIS 10901)

jemstar · November 12, 2020, 12:03am

Can you compare the SQL generated in WEBI from BO SP 03 to BO SP-08 ?

Can you copy the SQL into an native Oracle query tool?

I would re-validate the prompts in IDT and perhaps isolate them in a smaller query to see if they are causing the issue

tcpatil121 · November 22, 2020, 8:42am

Hi
That issue causing because the content not get completely synchronized from SP-03 to SP-08
after synchronization of SP-03 to SP-08 all reports and Universe and connection.
issue ORA-00936: missing expression gone.

Thank you for your inputs.