Solved

Does Informatica PowerExchange client need start Listener?

Posted on 2011-02-28
2
2,195 Views
Last Modified: 2012-05-11
I am new to Informatica Power Exchange,

1. the Power Exchange listener can not start,  it shows:

"The PowerExchange_Listener server on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example,the performance Logs and Alerts service"

2. PING PowerExchange Listener, it shows:
This does a PowerExchange "ping" to the node "node1"

C:\Informatica\PowerExchange9.0.1>dtlrexe loc=node1 prog=ping
PWX-00750 DTLREXE Input LOC=node1, PROG=PING, PARMS=<null>, UID=<>.
PWX-00752 DTLREXE Startup Error <Failed Client Connect RCs=1217/5/10060>.
PWX-00652  : TCP/IP CONNECT Error, rc=10060, reason <Connection timed out.>

3. in PowerCenter Designer, source analizer  "import from PowerExchange"
Cannot extract necessary data from the PowerExchange Listener.
[Informatica][SCLI PWX Driver] PWX-00271 DBAPI Error. DB_READ failed for file (database name)
[Informatica][SCLI PWX Driver] PWX-01266 DBNTC Receive READ header for file (database name) failed, rcs 33301/33301/0.
[Informatica][SCLI PWX Driver] PWX-33301 192.168.17.133:1506 : operation timeout is 180 seconds and operation did not complete within that period - ending processing

question:

does the the PowerExchange Listener need start?
how to fix this issue ?

thanks



0
Comment
Question by:SayYou_SayMe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 35030567
Please make sure that the PowerExchange listener is up and running by executing a ping command in order to ping the listener.

1 - Open a command line window on the powercenter server box
2 - Issue the following command

Dtlrexe prog=ping, loc=your_node_name

3 - Make sure that the PowerExchange installation directory is in your PATH environment variable

Hope this helps.

0
 

Author Comment

by:SayYou_SayMe
ID: 35032882
thanks lcohan


3 -in my machine: it seems correct
Environment Variable
path c:\Informatica\PowerExchange9.0.1

2 - what is the "your_node_name"
is it [the NAME] here in dbmover.cfg at my machine( PowerExchange client)?
NODE=([NAME],TCPIP,[IP ADDRESS],[PORT])

question:

1. there is no "node1" in the dbmove.cfg, why the error message shows
dtlrexe loc=node1 prog=ping?

there  are only these :
/*NODE=(node1,TCP,xxxxxxxxxxxxxxxx)
/*SVCNODE=(node1,xxxx)
/*CMDNODE=(pwxccl_node1,CONDENSE,XXXXX)

2. does it need to start PowerExchange_Listener at my machine (PowerExchange client)
  because it is in my "Service", but can not start it


 
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question