SAP Knowledge Base Article - Public

1912241 - @variable('PREFERRED_VIEWING_LOCALE') used in ConnectInit is not properly interpreted

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;

  1. Connect to Information Design Tool
  2. Create a relational connection to oracle database
  3. Add this sql statement in the connection parameter ‘ConnectInit’: BEGIN scheme.INSERTTABLE ('@VARIABLE('PREFERRED_VIEWING_LOCALE')');Commit; END;
  4. When testing the connection in IDT, an error message is displayed:

Untitled.png

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

Product

SAP BusinessObjects Dashboards 4.0