Answered On : Feb 23rd, 2006
open workflow manager and configure/assign the Server. Then Start the IRS.
Answered On : Mar 31st, 2006
My name s priya,i am facing the same problem i hav installed Informatica 7.1 on my pc yesterday,but I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.
Please, if you hav got the solution to this problem reply my immediately
i am lagging behind in my class i want to finish up with my exercises as soon as i can ....please help...
Answered On : Apr 4th, 2006
i think while installing you have not installed properly.. i recomend you to install the software once again and check the setting in repository services..
I hope this will give the solution..
Answered On : May 14th, 2006
i think first u open the workflowmanager,configure properties of repository then conn to repository server
Answered On : May 20th, 2006
i am also facing the same problem..
i have installed informatica 7.1 on windows-xp system.
but i couldnt connect to the repository server..
i think i couldnt have done the configuration properly.
so, if u get the solution, plz mail me the detailed steps of configuring informatica server, repository server and all required steps.
one request.. plz be clear while providing me the steps..plz provide them sequentially..
onething.. i have installed informatica in my system with out the database(oracle).. if that is the problem, plz let me know that..
thanks in advance..
Answered On : May 22nd, 2006
Even i have the same problem of starting Informatica Repository Service. Tried the above solution and have even reinstalled Informatica 7.1 twice.
Pls help.. need to start practise.
Answered On : Jun 2nd, 2006
server setup problem.
first check computer ip address or compuer names are defined properly.after that start up the reposory using admin console.then go to workflow and configure server and run the service.
Answered On : Jun 18th, 2006
Hi, I too is unable to start Informatica server service...if I start...it stops immediately...I'm running Informatica 6.1 on Windows 2000 server. I also tried re installing the Informatica server. Any Idea how to resolve this problem.Thanks- Patza
Answered On : Jun 25th, 2006
While installing Informatica server it propmted me to put Platform Key, Oracle Key etc. I think we need atleast three keys to install
1. Platform key
2. Oracle Key
3. ODBC key
I do not have these keys. Can somebody share ? you can reach me at firstname.lastname@example.org
PLEASE HELP !!!
Answered On : Jun 30th, 2006
After installing the Tool,
Go to start-->all programs-->repository server-->repository server setup
cofigure there the port number and admin password..clik ok.
Then go to service .. right clik on Informatica repository service.. clik properties.
Then click on the log On tab.. and click the log to local computer radio button there. Click ok.
then start the service...
lemme kno if any probs further..
and about license keys for some body... if u already got it.. ignore..
else scrap the powercenter version.. will try to give u.
Answered On : Aug 18th, 2006
This problem is with the Windows XP Home.Thats the reason why everytime u start the services it gets disconnected. You need to have a Windows XP Professional. The XP Home version doesnt support one functionality compared to XP Professional. That function is IIS(Internet ... Services).I am not sure about the correct abbreviation but you will find it in XP Professional.
Answered On : Aug 30th, 2006
hi priya its better once you uninstall the software and restart the system and then reinstall software then u will be get working well. even though if u get the same problem plz change ur operating system Generally win XP professional service pack2 is very gud for testing.
Answered On : Oct 3rd, 2006
You need to change the Operating System that is the solution for your problem.
Windows XP Professional or Windows 2000 Advanced Server or WINDOWS NT will be ideal.
Answered On : Nov 9th, 2006
I think this link will help you while installing informatcia.
If still your problem is not sloved then here is the solution.
I also faced same problem during my installation of Informatica 7.1.1 recently.
If the Informatica repository server is not starting the go to the Repository server setup change the the port no that min value writen on the below field ,at least more that the minimum value.and put your passward that is must.
If your Informatica Server is not starting then workflow manager and configure the server there.
Thanks & Regads,
Answered On : Dec 8th, 2006
I too faced the same problem. But I resolved it. I guess there is some default firewall runnning which is stopping the services to start. Disable your firewall and then try to start the services. It should work. Its the way worked for me.
Answered On : Feb 5th, 2007
This is for Informatica 7.1.3 installation1) Click launch.exe ( I mean setup file of informatica)2) Select powercenter for windows3) Give product key of license.txt file from new license key folder4) Configuring repository servera) Provide a name for your repository server.b) Provide password for administering repositoryc) Provide license keys.d) After this restart windows. Because we must restart windows before running informatica repository server.e) Start repository server(pmrepserver) in Control panel --> Administrative tools --> Servicesf) Check whether it is running or not Control panel --> Administrative tools -->Event Log Viewer--> pmrepserver properties5) Creating repositoryGo to repository server administrator console.a) register new repository server with hostname and port number.b) when configuring repository we have to provide connection stringThat is native connection string to connect to the database.When we install oracle it will create a connection string whose name is same as Service name(SID). We have to provide that name for connection string while configuring repository.c) create a database user by the following command in SQL plus. Create user
Answered On : Mar 6th, 2007
Check the exact error message in the even viewer log for the pmserver entry(navigate using settings--> control pannel-->Admin tools-->eventviewer.
Probably this is relating to the port number. Change the port number to the one between max and min port number.
Check the Administrator password.
If you can't do let me know again.
Answered On : Mar 20th, 2007
your tip worked for me...
changed the port no. and now the service is up and running...
guys n gals,
please install xp-sp2 and then oracle 10g, then continue the informatice steps. you won't get that type of problems.
once i also got the same problem, then i reinstalled and got rid of the problem
Answered On : Apr 3rd, 2007
Try to re-install software once again and check the configuration weather you have given proper information or not.
Answered On : Apr 16th, 2007
I think, the problem is like you have installed and configured both server and repository manager,
then you are trying to start the informatica and repository manger sevices,at that timesevices get started and stopped immediatelybygiving message like no work is assinged toserver
If that is the problem, you may haveconfigured the informatica server with diffenrentrepository name,user and passwordand in repository admin console you are tryingto configure the repository for otherusername,
If that is not the problem, there may beproblemwithhost name (may not matching) (Localhost/comp.name/ip address)
Answered On : Apr 25th, 2007
First its better to remove the informatica software which u earlier installed it and then install it again and give all the settings properly. This are the some steps which you need to keep track
Steps for Installing Informatica 6.2
Note: Default means Don't Change
1. Login as Administrator with the Administrators rights User Id & Password.
2. Install all Informatica clients, repository servers and work flow mangers.
3. Install Oracle 8i/9i. While installing give Global database a name and SID as ORCL.
4. Create a user at the Oracle.
5. Select * from all_users
Create user Infodev identified by Infodev default table space users temporary table space temp. Grant connect, resource, select any table, insert any table, update any table, delete any table to Infodev.
Configuring Repository Server:
6. Note down your Computer name or IP address
7. Open Repository management console. Then, right click on Informatica repository server, then add New server registration as your computer name.
8. Right click repository => add repository (Infodev)
9. Repository Configuration:
Database type: Oracle
Code page: default (Don't change)
Repository Name: Infodev
Connect String: ORCL
DB User:Infodev (Created User at the Oracle Backend)
DB password: Infodev
The rest of the network & configuration Tabs maintain as default.
10. Repository Server:
Server Port number: 5001
Administrator Password: Give Administrator Password
Minimum Port: 5002
11. Once you have given all this information, it will start creating Repository (OPB) tables at the Oracle user you have created.
12. Once the repository is created, it will create a local repository and an option will be provided by Informatica to convert the local repository to a Global repository.
13. Convert the local repository to Global repository.
14. Now go to services. There you will find Informatica Repository server service. Start that service by giving the Administrator User ID & password.
Informatica Server Configuration:
15. Go to Informatica Server set up. Install the Informatica Server and login as Administrator. Use Administrator's rights User Id & Password and Domain as your computer name.
16. In Server set up, enter all the License keys for platform key, Oracle key ODBC key in Key tab.
17. In the server tab, you will need to enter server name once the sever is created at workflow manger. However, leave that blank for the time being.
18. Enter the TCP/IP address or computer name in this place, the rest leave set as the default.
19. In repository Tab
Repository Name: Infodev
Repository User: Infodev
Repository password: Infodev
Repository host name: Computer name
Repository port number: 5001
20. Compatibility & Database TAB: default values
21. Configuration TAB: default values
22. Open Server Manager, click the Add folders to Repository Server Manager.
Steps for registering Server in Workflow manager:
23. In the workflow manger, connect to the repository.
24. Choose connection server.
25. Add register to new server.
26. Give the name as temp_server.
27. Now server dialog box appears.
28. Enter the following Info:
Host Name: Your Computer name/IP address (IP address is better)
Port Number: 4001(default)
Code page: default
27. Server Variables:
$PMRootDir: C:Program Filesinformaticainformatica PowerCenter 6.2-Server - all others should be set to the default values
28. Now go back to the Informatica configuration. There in Server tab enter the name of server as temp_server. Click OK & apply.
29. Go to services, start Informatica Service. Login as Administrator with the UserID
30. In workflow manager, right click the server and select monitor.
31. Now the server will run.
32. Go to Workflow monitor, right click server and select online.
33. It should respond that the server is running, otherwise you might have missed some steps.
Dear Nagesh and Priya, I got the complete solution for your queries. I too had the same problem for the last one week, one of my friend provided me the step by step process on configuring the things correctly in informatica. Now the issue is fixed. All the credit goes to my friend.I got the word document (54 pages)with screen shots and step by step instruction, but I don't find any option to attach the file in this forum. Please let me know how to attach the file at the earliest. Probably this document will be a key solution for the all those who come with the same problem.The document contains the configuration procedure and a sample excercise.RegardsG.R
Answered On : May 8th, 2007
I am seeing most of the people are facing the same problem.
In Informatica server setup check these things :
1. Check your user id & password, connecting string & hostname etc...
somewhere you may missed in repository.
2. Check your default IP in your system, in server you have to give the same
ex :127.0.0.1 under TCP/IP host address.
(to check IP in your system start -> run -> cmd enter -> ipconfig you will get
your system IP address)
3 Add your licenses correctly.
In workflow manager
1. Server which you created name should match with server name given in
2. Make sure you are getting your system IP in server, if not click resolve IP
3. Disconnect your internet connection if connected .
4. Assign your server to the desired folders and start now
Answered On : May 10th, 2007
Informatica 7.1 only supports Windows 2000 not does not support Windows XP. so you first uninstall XP and with Windows 2000 You can start the services OLAP agent, TNS and Client and Informatica repository agent and finally Informatica.
Answered On : May 27th, 2007
I would suggest you to install Server2000 with service pack 4...& I ams ure you will not have these problems again...& one more thing don't go for 10g better go for 9i for windows platform & select 'Data warehousing' instead of selecting general purpose application..it works well...all the best
Answered On : Jul 26th, 2007
This problem occurs when the server is not configured or it has not worked to process so just go to Informatica work-flow manger and is server tab, click on configure and follow the steps.
Answered On : Aug 1st, 2007
These are my suggestions:
1. Make sure Firewall is OFF and internet is ON.
2. Get your computer's full name and ip address after restarting the computer
3. Go to Start-Programs-Informatica Power Center- Workflow manager - Server (from the menu) - Server configuration - Check whether you have your server name there or not. If yes, edit - go to row where it says "computer or host name" , you will have a web addresss, delete that and enter your ip address and then hit the button resolve address, it should be same as you entered. but it will change the ip address to your computer name.
if xyz is your computer name then
it should look like this (before)
Computer name : xyz.xyz.com ipaddress : 127.0.0.1
enter your ip address at the web address spot and hit resolve ipaddress button
it should change to (after)
Computer name : xyz ipaddress ###.###.#.#
Now close the workflow monitor, go to workflow manager, enter your admin password - right click the server - and click run monitor - it should say connected .. boom ...
Do not change any port settings or Operating systems etc.
it should work everywhere.
Thanks. hope this helps.
Answered On : Aug 2nd, 2007
Install Win XP Professional or Win2k Server. It will work properly
Answered On : Aug 2nd, 2007
Please do not waste time in XP prof or any other editions.
Should work with XP Home. 100% positive.
Spend some time in configuration which will be useful for you. or else follow the steps I have given before. SHOULD WORK.
Answered On : Aug 5th, 2007
Pls goto the event viewer and check the Problem. If you cant clear the problem. Un install the Informatica clear the registry and install it.
I had the same problem during installation. I could be because ur antivirus is blocking the running of repository server Try to stop the antivirus and run again . In my case I had to uninstall it.
Answered On : Aug 6th, 2007
Just give host name as your computer name while configure informatica server.
Answered On : Aug 17th, 2007
Check if you have installed some anti-virus/anti-spam softwares in your pc. Some of this softwares does not allow the repository server from starting. Uninstalled the softwares and try starting the repository server service.
Answered On : Sep 6th, 2007
Change operating system. Informatica does not support any home edition operating system.
Answered On : Sep 6th, 2007
You need database installed in your PC to connect it to repository. Without database you cannot start repository.
Answered On : Sep 17th, 2007
Here is 3 tips
You need to select suitable OS, Win2000, XP Profession
You need to createa folder for bad file and alocate saficiant shared memory
Main problem is OS, Windows 2000 is good for Informatica
Answered On : Sep 17th, 2007
I understand from your blogs that you people are experiencing an issue with Informatica Repository Service not running permanently when you start it. For this, I suggest you to first configure Informatica Repository Server correctly. This mistake can occur when you not properly given the 'server name' and 'TCP/Host name'.
If this still occurs, this issue can occur if the repository service is not registered in registry. So, I suggest you to try unregister and register repository server service file.
If still persists, uninstall ONLY Repository server.
Answered On : Oct 2nd, 2007
I also got same problem, I tried like this first stop repository manager and again start the repository manager and repository.
Answered On : Oct 29th, 2007
first choose windows nt server ,sp4,internet exp 6 then start installation
it will create repository.
before this install oracle9i and create user with ur name password with ur name.
then start services.they start.
if you got problem mail me
Informatica repository name placed in 2 different places.
1) Server-->Informatica server setup.
2) Client-->Informatica Repository console(Here we generally create repository name and start the repository)
Both the places Repository name should be same other wise when you try to start Repository service it will be stoped automatically.
some times i faced this type of problem due to automatic change of IP address in server config ....
priya go to workflow manager-->server confign--> check ur IP address if it is changed then click on RESOLVE button.
and start informatica in windows service.
if u ve installed oracle forms & reports then uninstall it.again reinstall informatica.give the port no.correct
first u answer me about
whether u r facing problems from informatica server or informatica repository server
if it is from informatica server the solution is 1st u have to start the informatica repository server and then informatica server other wise i mean if u do in reverse server could not be started it will be stopped
if u r not starting repository server u have to configure it again
ok if u have any doubts mail me at email@example.com
I faced same problem while installing the inforamtica powercenter 7.1.1 for the first time but my friend showed me and then took screenshots.
See now first thing you need to install inforamatica, config inforamtica server then repository server.
then give perticular port number you can give hostname as your name if it is training and port number 9999 as it will be easy to identify then you need create repository but first dont forget to start the repository server .
Ok now you have to go to repository manager create the repository and start the repository for this your db means oracle should be started already.
then in the workflow manager create the connection for the relation source in connections tab if it is relational otherwise other.
then create repository server and give it perticular hostname resolve the server , give the path to perticular session logs etc.
At the end you need to assign the server and select the required or all workflows for the perticular server.
start the informatica server then test it is working correct or not because till the server will not be configured correctly informatica server services will not start though repository server service started.
if any issue firstname.lastname@example.org
I had the same problem plazz tell what you did to the probel.
After installing Informatica 7.1 ,
Goto Start>>Programs>>Administrative Tools>>Services>>Informatica Repository Service>>Right Click and Start.
If ,this doesn't start then,
Goto Start>>Programs>>Administrative Tools>>Event Viewer>>Application Log>>Right Click on Error and then Select Properties.
Here , you will know, what's the problem.
Please send us the problem to resolve this issue
First check you install informatica properly or not, once again reinstall the Informatica software, then goto the services in that right click the Informatica Repository Server in that refresh option is there, click that one, if the started service is stopped means, you didn't install Informatica properly, and also check you install any Java or Dot Net or Apache server or any server means you disable the services, then it works try it.
Even I too got the same problem but it was solved...can you people try once...go to
Apply and click Ok
Now You can start your services....it will be connected....
Answered On : Nov 2nd, 2011
I am also facing the same problem. Can you please tel me how to change the port number and all.
Answered On : Nov 11th, 2011
In order to up your IRS, please follow up the guidelines:-
1) Create a database, if u have already DB exist, then u can go with the same.
2) Create two db users, give admin privilege to those users.
3) The go with the normal Informatica installation steps, and please do configure your IRS with the respective db users.
4) Start the informatica Integration service, and then try with IRS. It must work out if u followed up the steps mentioned.
Any issue/questions, kindly post me back.
Answered On : Dec 6th, 2011
Software could be corrupted or has attacked with Virus,
Re-install and if the problem persist then you change the OS and try Informatica, it may work.