Symptom
- When used in the “ConnectInit” parameter from Information Design Tool, PREFERRED_VIEWING_LOCALE (or DOMINANT_PREFERRED_VIEWING_LOCALE) are not properly interpreted
- The error message displayed: Database error: ORA-06550: PLS-00103: Encountred the symbol "PREFERRED_VIEWING_LOCALE" when expecting one of the following...
Environment
- SAP BusinessObjects Business Intelligence Platform 4.0 SP05 Patch 04
- Oracle 11g
Reproducing the Issue
- Define an Oracle procedure to insert an input string into a table:
create or replace PROCEDURE INSERTTABLE ( VALUE IN VARCHAR2 ) AS
BEGIN
insert into scheme.table values (VALUE);
commit;
END INSERTTABLE;
-
Connect to Information Design Tool
-
Create a relational connection to oracle database
-
Add this sql statement in the connection parameter ‘ConnectInit’: BEGIN scheme.INSERTTABLE ('@VARIABLE('PREFERRED_VIEWING_LOCALE')');Commit; END;
- When testing the connection in IDT, an error message is displayed:
Note: if @VARIABLE('PREFERRED_VIEWING_LOCALE') is replaced by @VARIABLE(‘BOUSER’), the connection tests fine
Note: if @VARIABLE('PREFERRED_VIEWING_LOCALE') is used in the definition of a universe object it is working fine
Cause
This has been logged as product defect ADAPT01706059
Resolution
This issue is scheduled to be addressed in a future Fix Pack or Service Pack
Keywords
PREFERRED_VIEWING_LOCALE , connectinit, ADAPT01706059 , KBA , BI-BIP-SL , Semantic Layer , Bug Filed