Problem with BO Data Services

[Former Member]

Hello

I have a problem when I launch al_designer.exe ( BusinessObjects Data Services Repository Login )

A message appear

BODI-1111340:ERROR: OCI call <OCIEnvCreate> for connection < BASE_SI.world> failed: <cptmap>

we have log in the file

C:\Program Files\Business Objects\BusinessObjects Data Services\Log\errorlog.txt

(12.0) 10-23-14 10:10:58 (E) (7792:4972) CON-120404: OCI call <OCIEnvCreate> for connection <BASE_SI.world> failed: <cptmap>.

Thank you for help me

[Former Member]

Hi Marc,

Kindly check your TNS  entry for oracle 10g R2 product with having current TNS ID .

with C:\orant\BIN\PLUS80.exe with BODS repository .

Try this

Regards

Asish

[former_member208363]

Did you check by logging into repository database with the same credentials used in created repository ?

Are you able to login without any issue?

[Former Member]

Thank you for answer

with C:\orant\BIN\PLUS80.exe, I am able to connect

C:\orant\BIN\PLUS80.exe --> I' am able to connect to the repository

SQL*Plus: Release 8.0.6.0.0 - Production on Thu Oct 23 14:02:05 2014

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

SQL> connect atos/atos@SIPD.world

Connected.

SQL>

With D:\oracle\product\10.2.0\client_2\BIN , I cab't connect

D:\oracle\product\10.2.0\client_2\BIN>sqlplus atos/atos@SIPD.world

SP2-1503: Unable to initialize Oracle call interface

SP2-0152: ORACLE may not be functioning properly

[former_member208363]

Check if  TNS entries for BASE_SI.world.

You are connecting to SIPD.world which is fine.

I doubt this is because of BASE_SI.world. Double check it.

[Former Member]

The base is SIPD and not BASE_SI

In the first message

I replace SIPD by BASE_SI

BODI-1111340:ERROR: OCI call <OCIEnvCreate> for connection < BASE_SI.world> failed: <cptmap>

Then the log is

CON-120404: OCI call <OCIEnvCreate> for connection <SIPD.world> failed: <atos>.

[former_member208363]

Try this on TOAD.

Connect BASE_SI.world DB with the specified credentials.

Did anybody changed the credentials recently?

[Former Member]

The patch

https://technet.microsoft.com/en-us/library/security/ms14-oct.aspx

has been inbstalled

we havent TOAD

but the connection is OK with sqldevelopper ( similar to TOAD ) and C:\orant\BIN\PLUS80.exe

The connection is KO with

D:\oracle\product\10.2.0\client_2\BIN

[former_member208363]

1.Try to create one more local repository by using Repository manager for testing purpose if it is DEV.

2. Disable all anti-virus scanning.