Symptom
- Derived table does not support optional prompt, althouth it is possible to define Derived table with optional prompt in Information Design Tool (IDT)
- Error occurs when running query with any object from this derived table in IDT
=>Error message : "Error executing query. Failed to execute runnable (java.lang.NullPointerException)" - Error occurs when running a Web Intelligence document off this universe any object from this derived table
=>Error message if database is access:
Database error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '<filter expression>'.。(IES 10901) (WIS 10901)
=>Error message if database is Oracle:
Database error: ORA-00936: missing expression. (IES 10901) (WIS 10901)
Read more...
Environment
- SAP BusinessObjects Business Intelligence Platform 4.0 (BI 4.0) Support Pack 6
- SAP BusinessObjects Business Intelligence Platform 4.0 (BI 4.0) Support Pack 7
- Information Design Tool (IDT)
- Web Intelligence (WebI)
Product
SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3
Keywords
BI4, BI4.0, 4.0, IDT, support, derived table, optional, prompt, expression, IES, WIS, 10901, missing operator, missing expression, Database error, Error executing query, ADAPT01699435, 01699435, 1699435 , KBA , @prompt , optional prompt , BI-BIP-IDT , Information design tool , BI-BIP-SL , Semantic Layer , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.