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!

BIA 7.9.6.1 Unable to connect to Informatica services from DAC

691014Nov 11 2009 — edited Sep 21 2010
Hi All,

As a learning exercise, I have installed the following on a single Windows XP machine (Am aware that Windows XP is not supported for Informatica Service install - but currently have access to only this machine)
- OBIA 7.9.6.1
- Informatica 8.6.1 client & services with hotfix 6
- DAC client & server

I have created the Repository and Integration services in Informatica PowerCenter and are running in normal mode

I have configured the DAC as per installation document. I am now trying to configure the DAC Integration Settings for informatica.

I am unable to register an Integration service or a repository service and get the following errors,

On testing the Integration Service registration
----------------------------------------------------------------

Failure connecting to "INFORMATICA_DW_SERVER"!

And in the log file I find

SEVERE Thu Nov 12 11:43:54 WST 2009
ANOMALY INFO::: Error while pinging informatica server using command pmcmd pingservice -sv int_service -d Domain_ASG596138
MESSAGE:::log\ping.log (The system cannot find the file specified)
EXCEPTION CLASS::: java.io.FileNotFoundException

java.io.FileInputStream.open(Native Method)
java.io.FileInputStream.<init>(FileInputStream.java:106)
java.io.FileInputStream.<init>(FileInputStream.java:66)
com.siebel.etl.functional.ReadFileToBuffer.readFileToBuffer(ReadFileToBuffer.java:39)
com.siebel.etl.gui.data.StaticDatabaseCalls.testServer(StaticDatabaseCalls.java:917)
com.siebel.etl.gui.data.StaticDatabaseCalls.testInformaticaServer(StaticDatabaseCalls.java:887)
com.siebel.etl.net.ExecutionPlan.getInformaticaStatus(ExecutionPlan.java:275)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.mBeanRequestInformaticaStatus(ClientMessageDispatcher.java:433)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.consoleMessage(ClientMessageDispatcher.java:224)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.run(ClientMessageDispatcher.java:144)


On testing the Repository Service registration
----------------------------------------------------------------
Failure connecting to "INFORMATICA_REP_SERVER"!

ANOMALY INFO::: Error while pinging informatica repository server
MESSAGE:::C:\orahome\10gR3_2\bifoundation\dac\log\pmrepConnect.log (The system cannot find the file specified)
EXCEPTION CLASS::: java.io.FileNotFoundException

java.io.FileInputStream.open(Native Method)
java.io.FileInputStream.<init>(FileInputStream.java:106)
java.io.FileInputStream.<init>(FileInputStream.java:66)
com.siebel.etl.functional.ReadFileToBuffer.readFileToBuffer(ReadFileToBuffer.java:39)
com.siebel.analytics.etl.infa.interaction.PmrepInvoker.pmrep(PmrepInvoker.java:100)
com.siebel.etl.gui.data.StaticDatabaseCalls.testRepositoryServer(StaticDatabaseCalls.java:959)
com.siebel.etl.gui.data.StaticDatabaseCalls.testInformaticaServer(StaticDatabaseCalls.java:890)
com.siebel.etl.net.ExecutionPlan.getInformaticaStatus(ExecutionPlan.java:275)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.mBeanRequestInformaticaStatus(ClientMessageDispatcher.java:433)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.consoleMessage(ClientMessageDispatcher.java:224)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.run(ClientMessageDispatcher.java:144)

Could anyone please suggest what could be the cause of these errors. Any pointers to how to debug this will also be great. Please note I am totally new to Informatica and OBIA.

Many Thanks,
Kiran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2010
Added on Nov 11 2009
5 comments
6,884 views