| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Using WTX Plugin within WMB 6.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| jonnl0715 |
 Posted: Tue Oct 28, 2008 8:41 am Post subject: Using WTX Plugin within WMB 6.1 |
 |
|
Newbie
Joined: 18 Apr 2002
Posts: 4
Location: Atlanta, GA
|
I am trying to create a very simple broker flow which uses FileInput Node connected to the DTXPlugin Node which connects to a FileOutput Node. I am running in a LINUX environment. I have copied my compiled WTX maps to the broker server.
My problem is that is get the below error when I create the input file:
Oct 28 16:21:40 msgbroker1atl WebSphere Broker v6102[23660]: (OMHMBP1.EG_Billing)[8]BIP2628E: Exception condition detected on input node 'OMHBillingFlow.OMH_AUDIT'. : OMHMBP1.fd6a93e8-1c01-0000-0080-9109a410b3a4: /build/S610_P/src/DataFlowEngine/TemplateNodes/ImbCallableTemplateNode.cpp: 1511: ImbCallableTemplateNode::processMessage: ComIbmFileInputNode: OMHBillingFlow#FCMComposite_1_1
Oct 28 16:21:40 msgbroker1atl WebSphere Broker v6102[23660]: (OMHMBP1.EG_Billing)[8]BIP2230E: Error detected whilst processing a message in node 'OMHBillingFlow.DTXPlugIn'. : OMHMBP1.fd6a93e8-1c01-0000-0080-9109a410b3a4: /build/S610_P/src/DataFlowEngine/PluginInterface/ImbCniNode.cpp: 1769: ImbCniNode::evaluate: ComIbmCniNode: OMHBillingFlow#FCMComposite_1_2
Oct 28 16:21:40 msgbroker1atl WebSphere Broker v6102[23660]: (OMHMBP1.EG_Billing)[8]BIP0000I: Map failed: OMHMBP1.fd6a93e8-1c01-0000-0080-9109a410b3a4: : 0: _RunMercator: :
Oct 28 16:21:40 msgbroker1atl WebSphere Broker v6102[23660]: (OMHMBP1.EG_Billing)[8]BIP2628E: Exception condition detected on input node 'OMHBillingFlow.OMH_AUDIT'. : OMHMBP1.fd6a93e8-1c01-0000-0080-9109a410b3a4: /build/S610_P/src/DataFlowEngine/TemplateNodes/ImbCallableTemplateNode.cpp: 985: ImbCallableTemplateNode::processMessage: ComIbmFileInputNode: OMHBillingFlow#FCMComposite_1_1
Oct 28 16:21:40 msgbroker1atl WebSphere Broker v6102[23660]: (OMHMBP1.EG_Billing)[8]BIP3910I: Input node 'OMH_AUDIT' has retried a message the maximum number of times. The message is now propagated to the failure terminal. : OMHMBP1.fd6a93e8-1c01-0000-0080-9109a410b3a4: /build/S610_P/src/DataFlowEngine/TemplateNodes/ImbCallableTemplateNode.cpp: 1222: ImbCallableTemplateNode::processMessage: :
One observation is that maybe the problem is in how I have the WTX map "Get Source" definition. At present is is set to file, however, I think it sould be something different but I cannot work out what I should actually set this to when working in a broker environment.
Any ideas? |
|
| Back to top |
|
 |
| joebuckeye |
| Posted: Tue Oct 28, 2008 11:47 am Post subject: |
|
|
Partisan
Joined: 24 Aug 2007
Posts: 365
Location: Columbus, OH
|
| Quote: |
| Oct 28 16:21:40 msgbroker1atl WebSphere Broker v6102[23660]: (OMHMBP1.EG_Billing)[8]BIP0000I: Map failed: OMHMBP1.fd6a93e8-1c01-0000-0080-9109a410b3a4: : 0: _RunMercator: : |
This is as detailed a message as you will get through the broker logs for WTX.
You will need to have the map's trace and/or audit logs turned on to see what the map is complaining about. |
|
| Back to top |
|
|
| jonnl0715 |
| Posted: Tue Nov 11, 2008 7:29 am Post subject: |
|
|
Newbie
Joined: 18 Apr 2002
Posts: 4
Location: Atlanta, GA
|
Here is what is being output to the .dbl log
<31320-2774846384>: Validating the adapter command...
<31320-2774846384>: Database type is Oracle
<31320-2624306096>: Connecting...
<31320-2624306096>: Host string:
<31320-2624306096>: UserID : wmbadmin
<31320-2624306096>: Password : *****
<31320-2624306096>: Context: Input Card, Transaction scope: Map
<31320-2624306096>: On Failure: Rollback, On Success: Keep
<31320-2624306096>: TRACE command specified, file: /home/wmbadmin/WTXMaps/BILLING.dbl
<31320-2624306096>: Error returned by OCIServerAttach, errcode=12162
ORA-12162: TNS:net service name is incorrectly specified
<31320-2624306096>: Oracle connect failed.
<31320-2624306096>: Returned status: (-1005) Failed_to_connect_to_the_database
SQLplus works just fins using the userid and password to connect to the Oracle server, so I do not think there is an actual problem with the TNS definition.
There are a couple places to configure the access to the DB, in DID oron the input card definition within MapDesigner. Which should be used? I defined the userid/password and DB name within DID and only used -t on the input card in Map Designer, is this all that is needed or do I need more config details ion the input card?
Many thanks for any help. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Nov 11, 2008 8:51 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Quote: |
<31320-2624306096>: Error returned by OCIServerAttach, errcode=12162
ORA-12162: TNS:net service name is incorrectly specified
|
So did you check including case that the definition in TNS ora matches the setup(reality) and matches what you have in ODBC? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
