Actuate throws TNS error

[Anon Anon]

Hi All,

I've recently moved our Actuate 8.1 server to a new VM we got in our UAT environment.

I was able to install the server and made it start without issues.

I've installed the Reports I have in the server, using the e.Report Designer 7.0. Running the reports from within the tool it works fine.

Now, when I run the reports from Clarity interface I am getting the following error in the Actuate server log files:
***0000014704*reJobMgr.cpp*01206*08000*2010NOV22*11:25:28
Job execution failed: Status No: 1 :
Basic Error: 1011
Module: afc\db.bas
Line: 193

Database Error
3: Database login failed.
12560: ORA-12560: TNS:protocol adapter error


Job Type = Sync Transient
WriteLockHandle = 1
****0000014192*soapOpsJob.cpp*05520*08000*2010NOV22*11:25:28
RunSyncJob() failed: Status No: 1 :
Basic Error: 1011
Module: afc\db.bas
Line: 193

Database Error
3: Database login failed.
12560: ORA-12560: TNS:protocol adapter error

If I go to the Actuate server machine and do a "tnsping <tns name>" it works fine.

I am not sure why is this happening considering that the report I run on my machine using the Designer tool is using the same tns name I have configured in the Actuate server machine.

I would appreciate any suggestions.

Thanks,

Fabricio

[Anon Anon]

Hi all, don't need to worry about this anymore.

I figure out the issue.

The original developers have developed a Library with 2 different connections. I was using the incorrect one with the reports that were throwing this error.

Regards,

Fabricio

[System]

Thank you for letting everyone know this one is resolved Fabricio.

Chris

[Anon Anon]

Hi!

How do i know which library I'm using? I'm having the same error and I'm clueless..

Thanks.
:*)

fabricio.de.marchi wrote:

Hi all, don't need to worry about this anymore.

I figure out the issue.

The original developers have developed a Library with 2 different connections. I was using the incorrect one with the reports that were throwing this error.

Regards,

Fabricio

[Deactivated User]

You need to open the design file (.rod) with eRDpro and and see there.

The details of the connection are stored in the report design and the y must match the tsnnames.ora.


Martti K.