Friday, February 3, 2012

Problem with viewing CLOB type data in ODI 10g model

I had faced a problem in viewing the CLOB type data in a model.
On right clicking the table and view data, it throws an error if the table contains CLOB (rawXML) content.

To resolve the above issue,

In odiparamas.bat file set the below parameter

set ODI_ADDITIONAL_JAVA_OPTIONS=%ODI_ADDITIONAL_JAVA_OPTIONS% " -Doracledatabasemetadata.get_lob_precision=false"

next to,

set ODI_ADDITIONAL_JAVA_OPTIONS="-Djava.security.policy=server.policy"


Restart the ODI and now able to see the data..!! :)

No comments:

Post a Comment