Solved

Does Informatica PowerExchange client need start Listener?

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

710 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