Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2366
  • Last Modified:

Does Informatica PowerExchange client need start Listener?

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
SayYou_SayMe
Asked:
SayYou_SayMe
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
SayYou_SayMeAuthor Commented:
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now