Problem when I refresh a web-I report

[Former Member]

Hi EvErYbOdY,

I have a small problem with BO.

I have created a report in Deski and export it in Webi. This report find the information on the SQL Server database and I have no problem when I want to update it on Deski.

On Webi, i have this error :

http://img402.imageshack.us/img402/5602/webierrorym5.png

translation : Connection or SQL sentenc error: (DA0005): Exception: DBD, ORA-12154: TNS:could no resolve service name State: N/A. The following data provider have not been successfully refreshed

Do you know how I can solve this problem ?

ThAnK yOu

[amrsalem1983 · Accepted solution]

yes, coz when you export it to the infoview, its using the server tns configuration file.

i didnt understand wat was wirtten there, but i took the ORA error, its wide known, you have some error with your TNS names files on your Oracle Client, that has been used for a connection for this universe.

good luck

Amr

[Former Member]

I'm still having th same problem. Has anybody been abled to resolve this issue?

[Former Member]

Hi Pascolo,

Is the machine where the Deski report resides the same with the machine where the Infoview resides?

laurence resubal

Edited by: Laurence Resubal on Oct 27, 2008 12:55 PM

[amrsalem1983]

do you built this report based on an universe or an external data source?

[Former Member]

Hi Pascolo,
Is the machine where the Deski report resides the same with the machine where the Infoview resides?
laurence resubal

Hi Laurence,

I'm not sure about the architecture but i think that Infoview is on the server and I access it with my computer & Desktop Intelligence is on my computer.

Mario

[former_member207003]

Pascolo,

Sounds like your workstation is configured properly but the BO Server that is trying to connect to your Oracle DB Server is not. Easiest thing to do is to make sure the tnsname.ora works properly on the BO Server and has the same settings as your work station tnsname.ora.

An easy check, if the BO Server is Windows, open Designer and run a Integrity Check or open the Deski Client on the BO Server and run a report that utilizes the Oracle connection.

If those don't work, trying just testing the Oracle connection itself by using SQLPlus. Once you have confirmed the connectivity between servers, then try the Webi Report again.

Hope this helps.

[Former Member]

Hi,

The "integrity check" in the Designer works fine and I can access to Oracle SQLPLUS without problem on my computer.

Webi and Oracle DB are installed on the server side and Desktop Intelligence and Oracle Client is on my computer.

Can this be the cause of my problem ?

Do someone has an idea about how I can fix it ?

Thank you.

Mario

[former_member207003]

Mario,

You need to run these tests from the BO Server, not your workstation. You have confirmed that everything works on your workstation, now you need to confirm if it works from the BO Server.

So please run the same tests, but from the BO Server. If these tests fail from the BO Server, then you need to fix your connectivity from the BO Server to the Oracle DB Server.

Cheers,

Stephen

[Former Member]

Thank you for your answer.

The refresh of the report works fine when I open it in Desktop Intelligence.

Do you mean that I have to reconfigure a connection on WebI ? How could I do that ?

[amrsalem1983]

let me ask something first please.

do you really connecto to oracle?

do you know what it is a TNS names file?

are you the one who design the universes?

good luck

Amr

[Former Member]

Hi Pascolo,

Following solutions might help you to resolve the issue.

This issue occurs:

1. If the file "dbd_oci10.dllu201D under the following location

C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\dbd_oci10.dll

is deleted or corrupted.

2. If Oracle middleware is not properly installed

3. If the OS user doesn't have permissions on the folder.

Resolution1:

Please do the following at your end to resolve the issue.

1. Re-install the oracle middleware again and try the issue.

or

2. Check the privileges for the Connection server folder and give all the permissions on the folder to

the OS user.

Resolution2:

Add Read & Execute Rights to the Oracle Home.

Resolution4:

This issue might be related to OS rights on the Oracle middleware folders.

You need to apply Modify rights to the Authenticated users group at every folder level

from the root down to the TNSNAMES.ora file; this can help you to resolve the issue.

Resolution5:

-Also please check Path Environment Variable is setup correctly; Use the Oracle Home Selector

Tool to ensure that the Path Environment Variable is setup correctly.

Regards,

Sarbhjeet kaur

[Former Member]

let me ask something first please.
do you really connecto to oracle?
do you know what it is a TNS names file?
are you the one who design the universes?
good luck
Amr

Yes, I connect my universe to Oracle when I design the universe.

The connection works fine in the universe.

Here is my tnsname.ora :

BOXI.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (COMMUNITY = TCP.world)(PROTOCOL = TCP)(Host = HAMAMELIS)(Port = 1521))

)

(CONNECT_DATA = (SID = BOXI)(GLOBAL_NAME = BOXI.world))

)