Solved

Does Informatica PowerExchange client need start Listener?

Posted on 2011-02-28
2
2,052 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

One of the biggest challenges facing freelancers is balancing multiple projects and deadlines. Organizational skills and time management are key to keeping up with projects and staying on track. Luckily, we’ve curated seven tools to help you focus o…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…

809 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