| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBI JDBC Adapter and headers |
« View previous topic :: View next topic » |
| Author |
Message
|
| 4integration |
 Posted: Thu Mar 15, 2007 1:00 pm Post subject: WBI JDBC Adapter and headers |
 |
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hi,
I am trying to get the WBI JDBC adapter to work but the message are not inserted into database.
I get an strange error message in the log:
| Quote: |
| [Time: 2007/03/15 21:40:22.056] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: WBIA.JDBC_PLWMS2.REQUESTQUEUEJmsThreadPool.thread6 (#642548188)] [Type: Error] [MsgID: 9085] [Mesg: REQUESTQUEUE can not be used to process Admin message. This Admin message is ignored. Message ID: ID:414d5120454f57594e5f4233202020209b37eb45203b1376] |
The trace file says:
| Quote: |
[Time: 2007/03/15 21:40:22.056] [System: ConnectorAgent] [SS: JDBC_WMSConnector] [Thread: WBIA.JDBC_PLWMS2.REQUESTQUEUEJmsThreadPool.thread6 (#642548188)] [Type: Trace] [Mesg: :Receiver.processMsg(msg) received message:
JMS Message class: jms_text
JMSType: null
JMSDeliveryMode: 2
JMSExpiration: 0
JMSPriority: 4
JMSMessageID: ID:414d5120454f57594e5f4233202020209b37eb45203b1376
JMSTimestamp: 1173991221990
JMSCorrelationID:ID:502057203030373033313532313430323230303631303032
JMSDestination: null
JMSReplyTo: queue://EOWYN_B3/WMQI.Reply_Log_Queue?targetClient=1
JMSRedelivered: false
JMSXDeliveryCount:1
JMS_IBM_Report_COD:2048
JMS_IBM_MsgType:1
JMSXAppID:EOWYN_B3
JMS_IBM_Format:MQSTR
JMS_IBM_PutApplType:26
JMS_IBM_Report_Pass_Correl_ID:64
JMSXUserID:WBIMB
JMS_IBM_Report_Exception:16777216
JMS_IBM_PutTime:20402199
JMS_IBM_PutDate:20070315
<NS1:INTERFACE_ORDER_HEADER xmlns:NS1="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/INTERF
Another 24,521 character(s) omitted] |
The message's MQRFH2 headers looks like:
| Code: |
(0x01000000):MQRFH2 = (
(0x03000000):Version = 2
(0x03000000):Format = ''
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 1208
(0x03000000):Flags = 0
(0x03000000):NameValueCCSID = 1208
(0x01000000):mcd = (
(0x01000000):Msd = (
(0x02000000): = 'mrm'
)
(0x01000000):Set = (
(0x02000000): = 'D25SI38002001'
)
(0x01000000):Type = (
(0x02000000): = 'INTERFACE_ORDER_HEADER'
)
(0x01000000):Fmt = (
(0x02000000): = 'CwXML'
)
)
(0x01000000):jms = (
(0x01000000):Dst = (
(0x02000000): = 'queue:///WBIA.SAP_DM_DES.DELIVERYQUEUE'
)
(0x01000000):Tms = (
(0x02000000): = '1164986831634'
)
(0x01000000):Dlv = (
(0x02000000): = '2'
)
)
(0x01000000):usr = (
(0x01000000):WSDLBinding = (
(0x02000000): = 'sap4_delvry05AgentDeliveryBinding'
)
(0x01000000):WSDLOperation = (
(0x02000000): = 'sap4_delvry05Create'
)
(0x01000000):PrivacyLevel = (
(0x02000000): = 'None'
)
(0x01000000):MessageType = (
(0x02000000): = 'sap4_delvry05'
)
)
(0x01000000):psc = (
(0x01000000):Topic = (
(0x02000000): = 'VolvoParts/VPIO/FromDM/VOLVO/GBG'
)
(0x01000000):mcd = (
(0x01000000):Set = (
(0x02000000): = 'F89SVNO002001'
)
(0x01000000):Type = (
(0x02000000): = 'sap4_delvry05'
)
(0x01000000):Fmt = (
(0x02000000): = 'CwXML'
)
)
(0x01000000):Command = (
(0x02000000): = 'Publish'
)
)
) |
Do you have any idea what's wrong?
_________________
Best regards
4 Integration |
|
| Back to top |
|
 |
| vk |
| Posted: Thu Mar 15, 2007 9:50 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Is the message going to the Fault Queue? The RFH header of the fault message will have the reason why the message failed.
The RFH header which you attached looks fine. Is the XML body also as expected? Do you have a BO by name INTERFACE_ORDER_HEADER in the adapter repository? Make sure that the XML has all the elements corresponding to the columns in the table and namespace settings are proper.
Regards,
VK. |
|
| Back to top |
|
|
| 4integration |
| Posted: Thu Mar 15, 2007 11:32 pm Post subject: |
|
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
No, it's not going to fault queue....it disappears. Do I have to define the Rto queue, e.g as below
| Code: |
(0x01000000):MQRFH2 = (
(0x01000000):jms = (
(0x01000000):Rto = (
(0x02000000): = 'queue:///WBIA.JDBC_PLWMS2.FAULTQUEUE'
)
)
.....
|
The XML body seems fine and the BO is in the repository.
_________________
Best regards
4 Integration |
|
| 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
|
|
|
|
