top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Working with Informatica

0 votes
140 views

I am setting up a dev environment for a project, with informatica 9.1 and SQL Server 2012 on a Windows Server 2008 R2 machine.

Installation etc has finished fine and no issues reported so far.

When we are trying to run our first mapping/workflow, the SQL Server database connectivity is becoming a bottleneck.

I tried creating a native connection to SQL Server, and also odbc, both don't seem to work, the session in question just fails to initialize. The error message finally is

failed to prepare session

Am I missing something here? Any experiences?

Disclaimer: This is my first ever attempt to host Infa repository at SQL Server, and also, using source and target as SQL Server.

posted Aug 19, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The cause of the "failed to prepare session" error was that one or more objects used by the workflow were checked out. Once everything referenced by the workflow was checked in again, the error went away and the workflow completed successfully.

answer Aug 21, 2014 by Shweta Singh
Similar Questions
0 votes

I have a package and I have to execute a function from package whose parameter is session date and return value is a reference cursor. When I connect to database and execute the function, I am getting proper output. When I am executing the same in informatica, it's going wrong at date part. 1) Firstly what can be an approach to execute the function and obtain the data in informatica 2) is this possible by source qualifier transformation or SQL transformation? 2) if there is feasibility how can I pass the date to Oracle

0 votes

I have found the mapping sdk code samples, however without any documentation whatsoever.

Currently working with 9.0, I am looking for more info.

For one of the current issues, when I try to save the mapping to repository, (with pcconfig.properties lying in the same folder where the xml file is being generated), I am getting the following error:

Written the file..

Caught an exception in run() method

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

com.informatica.powercenter.sdk.mapfwk.exception.MapFwkOutputException: Error saving to repository :  Failed to connect to repository

    at com.informatica.powercenter.sdk.mapfwk.xml.XMLWriter.save(Unknown Source)

    at com.informatica.powercenter.sdk.mapfwk.repository.Repository.save(Unknown Source)

    at TestRaghavExample.generateOutput(TestRaghavExample.java:259)

    at TestRaghavExample.create(TestRaghavExample.java:64)

    at TestRaghavExample.main(TestRaghavExample.java:272)

Caught an exception in run() method
This is my initial example.. trying to find my way through the API..

0 votes

I am trying to merge multiple targets with same name and I am getting errror.
Please guide me on how to proceed.

+3 votes

What is CDC in Informatica, What is the purpose of using it? Please explain with an example?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...