BI 4.2 / Web Intelligence / ORA-12557

[jean-philippe_maquestiaux]

Hello,

Since I have restarted the SIA service, I have an issue in the web base web intelligence I received the above error.

When I try to refresh one of my reports through the web base (BI Launch Pad...) it does not work

The following database error occurred: ORA-12557: TNS:protocol adapter not loadable
. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

But on the server and desktop: I can TNSPING / SQLPLUS the database, the rich client works as expected?

I have restarted the server without success. I have controlled the path to the Oracle Client (despite that it work with the rich client...)

Any idea?

------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

----

SAP BusinessObjects BI Platform 4.2 Support Pack 4

Version: 14.2.4.2410

[mhmohammed · Accepted solution]

Hi Jean,

I hope this might be the issue, BO Server Tools are a 64bit application, where as IDT or UDT are 32bit applications. So, you'll have to install Oracle 32bit Run time, and paste the tns entries in the tnsnames.ora file the 32bit folder as well. Try that and let us know.

Thanks,
Mahboob Mohammed

[jean-philippe_maquestiaux · Accepted solution]

Both client are already installed.

Finally, I have

1. updated to the latest SP (06)
2. changed the order in the Path environment variable (first 32b then 64b)
3. controlled that the tnsnames where the same (there were)
4. restarted the server
5. restarted again tomcat, the server intelligence agent and the www publishing Service. (through CCM)

And it works again...

Thank you, Have a nice day

[jean-philippe_maquestiaux]

After removing the ORACLE_HOME and restarted the server I have...

"The following database error occurred: (CS) "DBDriver failed to load : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib64\dbd_oci.dll (%1 is not a valid Win32 application.
)" . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

"

[former_member185603]

Is the issues happening with only one report or with multiple reports as well? If it is only one report, check the connection details of the report.

Check this KB for your reference.

2070772 - Error: “ORA-12557: TNS: protocol adapter not loadable”

[jean-philippe_maquestiaux]

Hello,

It is happening with all my reports.

I have already tried the ORACLE_BASE trick.

Thank you.