Skip to Content
0
May 14, 2013 at 06:58 PM

ORA-12154 error when using Crystal Reports for Enterprise

1235 Views

Hello Guru's,

I am having hard time figuring what's wrong with Crystal Reports for Enterprise. I have created a unx universe using Information Design Tool and publiched it to the repository. When I try to create a report using Crystal Reports for Enterprise, I am getting the following error

Error:
[] <com.businessobjects.dsl.commons.exception.NestedException: ORA-12154: TNS:could not resolve the connect identifier specified
>

Cause of Error
ORA-12154: TNS:could not resolve the connect identifier specified

I tested the connection in IDT and it is working fine. I was able to create a Webi report on the universe and it is working fine. I am not able to figure why it is giving an error when I try to create a report by using Crystal Reports for Enterprise. I checked for TNS names on my machine and on the server. They are all correct.

The following is the deployment information.

Server: Windows Server 2008 R2 (64 bit, 8GB ram)

BOBJ Version: 4.0 SP6

Database: Oracle 11g (64 bit)

Thank you,

Sri