Wednesday, April 13, 2016

OBIEE 11.1.1.7 - Export to Excel 2007+ Error Shell format error

OBIEE 11.1.1.7 - Export to Excel 2007+ Error Shell format error

To Resove excel 2007 export and header fixed issues please follow the below two steps.

1) Applying OBIEE bundled patch 11.1.1.7.140415
2) Enable below parameter as TRUE in xdo.cfg Configuration file.

"xlsx-keep-values-in-same-column" set to true  in xdo.cfg configuration file.
 
It will be available in below instance config BIJava Host components directory.


/obiee/Middleware/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1/
xdo.cfg 


<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">
<properties>
<property name="xlsx-keep-values-in-same-column">true</property>
</properties>
</config>


ODI XML File Parallel exeuction errors.

PARALLEL EXECUTION OF XML DRIVER COMMANDS FAIL


If you are running XML Files files parallel you will get xml error on technology

Use below two parameters in JDBC URL:  &dod=true&re=true

OR

update below patch no


 Patch 18238917: PARALLEL EXECUTION OF XML DRIVER COMMANDS FAIL

Configuring ODI Master and Work repositories in RAC Database using JDBC URL Format.



Configuring ODI Master and Work repositories in RAC Database using below JDBC URL Format.


jdbc:oracle:thin:(DESCRIPTION = (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = tcp)
(HOST = 192.168.1.10)(PORT = 1521)) (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.1.11)
(PORT = 1522)) (CONNECT_DATA = (SERVER=dedicated)

(SERVICE_NAME=PROD_EDW)))