Category Archives: Berry van den Heuvel
NULL value in choice list
Problem: NULL value appears in choice list
Screenshot:
Solution:
- open the rpd in the BI Administration Tool
- select the physical column in de physical model
- double click to edit the physical column
- uncheck the Nullable option
Note; because of cache, it will take a while before the NULL value disappears in the LOV. To let the NULL value disappear directly, restart the presentation services in Enterprise Manager.
- open Enterprise Manager
- click Business Intelligence – coreapplication
- click Availability
- click Processes
- select BI Presentation Services
- click Restart
- click OK
- wait until the message Done appears
- go to the choice list
The NULL value is not displayed anymore.
Het bericht NULL value in choice list verscheen eerst op OBIEE 24/7.
NULL value in choice list
Problem: NULL value appears in choice list
Screenshot:
Solution:
- open the rpd in the BI Administration Tool
- select the physical column in de physical model
- double click to edit the physical column
- uncheck the Nullable option
Note; because of cache, it will take a while before the NULL value disappears in the LOV. To let the NULL value disappear directly, restart the presentation services in Enterprise Manager.
- open Enterprise Manager
- click Business Intelligence – coreapplication
- click Availability
- click Processes
- select BI Presentation Services
- click Restart
- click OK
- wait until the message Done appears
- go to the choice list
The NULL value is not displayed anymore.
Het bericht NULL value in choice list verscheen eerst op OBIEE 24/7.
Display charts as images without using Flash
To display charts as images without using Flash, change the default image type to non-flash. Follow these steps;
- go to the directory of instanceconfig.xml
cd $ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1
- make a copy of instanceconfig.xml
-
cp instanceconfig.xml instanceconfig.xml[_orig]
- edit instanceconfig.xml
vi instanceconfig.xml
- between </Table> and </Views> insert the tag
<Charts> <DefaultWebImageType>png</DefaultWebImageType> </Charts>
- be sure that png is lowercase, because when it is not, the presentation server will not start after restart!
- a part of the instanceconfig.xml must look like this now;
</Table> <Charts> <DefaultWebImageType>png</DefaultWebImageType> </Charts> </Views>
- save and quit
:wq
Note; some reports may have a hardcoded rendering type flash. To be sure every report is working with the rendering type specified within the instanceconfig, change the “renderFormat” within the XML of the reports, by following these steps;
- open Catalog Manager
- open the online catalog
- go to the directory or report
- select the XML Search and Replace
- change renderFormat=”flash” to renderFormat=”default”
- log in to Enterprise Manager
- click Business Intelligence - coreapplication
- click Availability
- click Processes
- click Restart All
- wait untill the Done message appears
Het bericht Display charts as images without using Flash verscheen eerst op OBIEE 24/7.
Not a valid month at OCI call OCIStmtExecute
Problem: Error in report
Screenshot:
Screenshot text:
State: HY000. Code: 10058. [NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1843, message: ORA-01843: not a valid month at OCI call OCIStmtExecute: select [STATEMENT] [nQSError: 17011] SQL statement execution failed. (HY000)
Possible cause:
One of the causes can be that the repository variable that is used, is not of the type Date.
Possible solution:
- edit the variable block
- change the type of the error causing repository variable.
for example, if the definition is
to_char(to_date(max(day_number),'yyyymmdd'),'dd-mm-yyyy') as var_date
then change it to
to_date(max(day_number),'yyyymmdd') as var_date
- go back to the report
- refresh
Het bericht Not a valid month at OCI call OCIStmtExecute verscheen eerst op OBIEE 24/7.
Looping chain of synonyms at OCI call OCIStmtExecute
Problem: Error in report
Screenshot:
Screenshot text:
State: HY000. Code: 10058. [NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1775, message: ORA-01775: looping chain of synonyms at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preperation failed. (HY000)
Possible cause:
The table that is queried is deleted, but the synonym on the table still exists.
Possible solution:
- open SQL plus or SQL developer
- log in to the database and schema that has to contain the table
- check if the table exists
- if it doesn’t exist, create the table (again)
- go back to the report
- refresh the result
The error message is not displayed anymore.
Het bericht Looping chain of synonyms at OCI call OCIStmtExecute verscheen eerst op OBIEE 24/7.
