Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DAC client fails to connect to Informatica Repository Server

CGladwin-OracleMar 11 2008 — edited Mar 11 2008
BI Apps 7.9.4
Oracle DB 10g release 2
All installed on single machine - Windows XP 2002 SP2

All informatica services are running, as is the DAC server and the database and I have been through all the required set up steps (I think!) to import repositories, configure workflow manager etc.

All is working fine apart from when I try to connect from the DAC client in the Setup/Informatica Servers tab. It is OK for the informatica server (Oracle_BI_DW_Server) but it fails on the informatica repository server with the message below.

ANOMALY INFO::: Error while connecting to informatica repository server
MESSAGE:::
pmrep Connect Error

=====================================
STD OUTPUT
=====================================

=====================================
ERROR OUTPUT
=====================================

EXCEPTION CLASS::: com.siebel.analytics.etl.infa.interaction.PmrepConnectException

com.siebel.analytics.etl.infa.interaction.PmrepInvoker.pmrep(PmrepInvoker.java:93)
com.siebel.etl.gui.data.StaticDatabaseCalls.testRepositoryServer(StaticDatabaseCalls.java:946)
com.siebel.etl.gui.data.StaticDatabaseCalls.testInformaticaServer(StaticDatabaseCalls.java:881)
com.siebel.etl.net.ExecutionPlan.getInformaticaStatus(ExecutionPlan.java:261)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.mBeanRequestInformaticaStatus(ClientMessageDispatcher.java:403)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.consoleMessage(ClientMessageDispatcher.java:220)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.run(ClientMessageDispatcher.java:140)


From other posts, I thought it might be a path error, so I have checked the path to make sure that it only has one reference to a JDK. The current path setting in Environment Variables is:

D:\Informatica\Server\bin;D:\Informatica\RepositoryServer;C:\Program Files\Java\jdk1.5.0_13\bin;D:\OracleDB102\bin;D:\OracleXE\app\oracle\product\10.2.0\server\bin;D:\Oracle10g\bin;D:\Oracle10g\jlib;D:\OracleBI\server\Bin;D:\OracleBI\web\bin;D:\OracleBI\web\catalogmanager;D:\OracleBI\SQLAnywhere;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Symantec\pcAnywhere\;C:\Program Files\Common Files\Adobe\AGL;C:\Program Files\QuickTime\QTSystem\

The only other error I've had during installation was that I had spaces in the java path so I have copied my JDK to a new path (d:\jdk1.5.0_13) and updated the config.bat for the DAC client. I'm not sure if this causing this error? I have tried changing the path to point to this installation of JDK instead but its made no difference.

I'm not experienced in java, so can anyone point me to the solution for this error?

Thanks Caroline
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2008
Added on Mar 11 2008
6 comments
1,825 views