Symptom
when using the oracle 11g client to connect to the Oracle 11g server, the creation of new WebIntelligence (WebI) reports fails with the following error message:
"an internal error occurred while calling ProcessDPCommands API (error: WIS 30270)"
Environment
- BusinessObjects Enterprise XIR2 Service Pack 5
- Solaris 10
- database Oracle 11g for CMS and reports
Reproducing the Issue
- install XIR2 SP5 on Solaris 10
- point the variables ORACLE_HOME and LD_LIBRARY_HOME to an Oracle 11g client
- in Designer, create a new connection and a new universe, using Oracle 11
- In Infoview, create a new WebI report using that new universe
- run query: "an internal error occurred while calling ProcessDPCommands API (error: WIS 30270)"
- if we use oracle 10 client to connect to the oracle 11 server, then the creation of new WebI reports works fine
Cause
This is a problem with the Oracle Client middleware install, a symbolic link is missing.
Resolution
From the oracle 11 client install directory, go to directory lib32 and type the following
ln -s libclntsh.so.11.1 libclntsh.so
Keywords
KBA , BI-RA-WBI , Web Intelligence , Problem
Product
Crystal Reports Server XI R2