Solved

Does Informatica PowerExchange client need start Listener?

Posted on 2011-02-28
2
2,077 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
2 Comments
 
LVL 39

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Originally published Entrepreneur.com Booming numbers of freelancing professionals are changing the face of work. In the United States alone last year, the number of workers freelancing grew from 700,000 to 54 million, according to a Freelancers’…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
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.

828 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