ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ Java / JMS » JMS Error while starting JDBC Connector

Post new topic  Reply to topic
 JMS Error while starting JDBC Connector « View previous topic :: View next topic » 
Author Message
shafi
PostPosted: Mon Apr 24, 2006 9:43 pm    Post subject: JMS Error while starting JDBC Connector Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi All,

I am getting the following JMS error while starting my JDBC Connector (with websphere mq5.3, WAS, Oracle). I think the error is due to classpath or path settings. can anybody guide me in that>?

[Time: 2006/04/25 10:57:27.535] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
58554542)] [Type: Info] [MsgID: 17007] [Mesg: Press q to quit connector.]
[Time: 2006/04/25 10:57:27.535] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1
270072494)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17006] [Mesg: No polling requested.] ]
[Time: 2006/04/25 10:57:36.929] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Error] [MsgID: 9064] [Mesg: Message received
is not of the type (Text, Object) expected for the current encryption settings. Message ID: ID:414d
5120574d5149422e51756575652ef5b14c4420000301]
[Time: 2006/04/25 10:57:36.939] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1268810926)] [Type: Error] [MsgID: 9064] [Mesg: Message received
is not of the type (Text, Object) expected for the current encryption settings. Message ID: ID:414d
5120574d5149422e51756575652ef5b14c4420000401]
[Time: 2006/04/25 10:57:36.969] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Trace] [Mesg: :Sending fault message:
JMS Message class: jms_bytes
JMSType: null
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d5120574d5149422e51756575652ef5b14c4420000301
JMSTimestamp: 1145879186430
JMSCorrelationID:null
JMSDestination: null
JMSReplyTo: null
JMSRedelivered: true
status:-1
resubmitTo:null
description:JMS Message was not of the type (Text, Object) expected. Writing it to the fault queu
e.
keys:null
Integer encoding: 2, Floating point encoding 512
3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e0d0a
3c51313a454d50502020786d6c6e733a51313d22687474703a2f2f7777772e69626d2e636f6d2f77
65627370686572652f63726f7373776f726c64732f323030322f424f536368656d612f454d505022
2076657273696f6e3d22332e302e302220766572623d2243726561746522206c6f63616c653d2265
6e222064656c74613d2266616c7365223e0d0a203c51313a454d505f49443e61733132333c2f5131
3a454d505f49443e0d0a203c51313a454d505f4e414d453e437849676e6f72653c2f51313a454d50
5f4e414d453e0d0a203c51313a454d505f434954593e437849676e6f72653c2f51313a454d505f43
4954593e0d0a203c51313a454d505f53543e437849676e6f72653c2f51313a454d505f53543e0d0a
203c51313a4f626a6563744576656e7449643e4a4442435f313134353837363334363033395f313c
2f51313a4f626a6563744576656e7449643e0d0a3c2f51313a454d50503e
]
[Time: 2006/04/25 10:57:37.039] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.th
read1 (#1270842542)] [Type: Error] [MsgID: 84017] [Mesg: Unable to deliver the message to the Queue.
Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage]
[Time: 2006/04/25 10:57:37.049] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Trace] [Mesg: :Fatal error! The fault queue
is not available or valid.]
[Time: 2006/04/25 10:57:37.059] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Trace] [Mesg: :javax.jms.JMSException: java.
lang.ClassCastException: com.ibm.jms.JMSBytesMessage
at CxCommon.Messaging.jms.SecurityProxy.SendProxy.send(SendProxy.java:104)
at CxCommon.Messaging.jms.Receiver.processFaultMsg(Receiver.java:1583)
at CxCommon.Messaging.jms.Receiver.access$700(Receiver.java:66)
at CxCommon.Messaging.jms.Receiver$ThreadCallBackImp.callback(Receiver.java:223)
at CxCommon.ThreadingServices.ThreadPoolThread.run(ThreadPoolThread.java:175)
]
[Time: 2006/04/25 10:57:37.089] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Error] [MsgID: 9061] [Mesg: Caught JMS error
. Reason: javax.jms.JMSException: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage.]
[Time: 2006/04/25 10:57:37.099] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.th
read1 (#1270842542)] [Mesg: [Type: Fatal Error] [MsgID: 17056] [Mesg: Failed to establish connection
to messaging system.] ]
[Time: 2006/04/25 10:57:37.109] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1268810926)] [Type: Trace] [Mesg: :Sending fault message:
JMS Message class: jms_bytes
JMSType: null
JMSDeliveryMode: 1
JMSExpiration: 0
Press any key to continue . . .

Thanks & Regards,
Shafi
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Tue Apr 25, 2006 2:56 am    Post subject: Re: JMS Error while starting JDBC Connector Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

shafi wrote:
Hi All,

I am getting the following JMS error while starting my JDBC Connector (with websphere mq5.3, WAS, Oracle). I think the error is due to classpath or path settings. can anybody guide me in that>?


[Time: 2006/04/25 10:57:36.929] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Error] [MsgID: 9064] [Mesg: Message received
is not of the type (Text, Object) expected for the current encryption settings. Message ID: ID:414d
5120574d5149422e51756575652ef5b14c4420000301]

[Time: 2006/04/25 10:57:36.969] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Trace] [Mesg: :Sending fault message:
JMS Message class: jms_bytes
JMSType: null
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d5120574d5149422e51756575652ef5b14c4420000301
JMSTimestamp: 1145879186430
JMSCorrelationID:null
JMSDestination: null
JMSReplyTo: null
JMSRedelivered: true
status:-1
resubmitTo:null
description:JMS Message was not of the type (Text, Object) expected. Writing it to the fault queue.
keys:null .........

[Time: 2006/04/25 10:57:37.039] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.th
read1 (#1270842542)] [Type: Error] [MsgID: 84017] [Mesg: Unable to deliver the message to the Queue.
Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage]

[Time: 2006/04/25 10:57:37.049] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1270842542)] [Type: Trace] [Mesg: :Fatal error! The fault queue
is not available or valid.]

Thanks & Regards,
Shafi


Seems like you have some programing errors and some setup errors.
a) the message is received but not recognized of valid type
b) an attempt is made to create a DLQ message to put on the fault queue but the cast to BytesMessage failed
c) Finally the fault queue is not recognized/defined ?

Enjoy
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
shafi
PostPosted: Wed Apr 26, 2006 12:50 am    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi fjb_saper,

I am doing the following steps :

1. start the connector (successful)

[[Time: 2006/04/26 11:58:28.032] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: ClientPacketSy
ncDrvFormatterJDBCConnector (#1256084657)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state
is active.]
[Time: 2006/04/26 11:58:28.203] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
50874545)] [Type: Info] [MsgID: 17007] [Mesg: Press q to quit connector.]
[Time: 2006/04/26 11:58:28.203] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1
245254833)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17006] [Mesg: No polling requested.] ]]

2. start VTC. (connect WAS, add BO & send BO - successful)

[Connecting to WAS... Wednesday, April 26, 2006 11:59:00 AM IST
JDBC Ready Wednesday, April 26, 2006 11:59:07 AM IST
Sent Business Object EMPP Verb Create Wednesday, April 26, 2006 11:59:25 AM IST]

3. open RFHUtil (Successful)

Main Tab:

QueueManager name: WMQIB.Queue.Manager
QueueName : JDBCCONNECTOR/DELIVERYQUEUE
SetUser/App id : ticked
Data Tab:

Data format : xml

MQMD Tab:

MQ Message Format :MQHRF2
UserID : Administrato
codepage :819


RFH Tab:

version 2: ticked
mcd, jms, usr : ticked
mesage domain:xml
Data format: MQSTR
CODE PAGE:1208

Then, when I clicked StartBrowse in the Main Tab, I got the XML data in the Data Tab.which i copied & saved as a XML file.

[12.04.02 First message read from JDBCCONNECTOR/DELIVERYQUEUE length=758]

[<?xml version="1.0" encoding="UTF-8"?>
<Q1:EMPP xmlns:Q1="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPP" version="3.0.0" verb="Create" locale="en" delta="false">
<Q1:EMP_ID>CxIgnore</Q1:EMP_ID>
<Q1:EMP_NAME>CxIgnore</Q1:EMP_NAME>
<Q1:EMP_CITY>CxIgnore</Q1:EMP_CITY>
<Q1:EMP_ST>CxIgnore</Q1:EMP_ST>
<Q1:ObjectEventId>JDBC_1145876346039_1</Q1:ObjectEventId>
</Q1:EMPP>]

4. close & open RFHUtil.

Main Tab:

QueueManager name: WMQIB.Queue.Manager
QueueName :JDBCCONNECTOR/REQUESTQUEUE
SetUser/App id : ticked
Data Tab:

Data format : xml

MQMD Tab:

MQ Message Format :MQHRF2
UserID : Administrato
codepage :819


RFH Tab:

version 2: ticked
mcd, jms, usr : ticked
mesage domain :xml
Data format: MQSTR
CODE PAGE :1208


Then clicked read file from the Main Tab to read the XML file, then clicked the Write Queue

[12.02.39 Message sent to JDBCCONNECTOR/REQUESTQUEUE length=393
12.02.38 393 bytes read from file C:\Documents and Settings\Administrator\Desktop\check.xml]


This is where I am getting that error. I don't understand where exactly the mistake is?

Thanks and Best Regards,
Shafi.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Wed Apr 26, 2006 2:48 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Have you tried setting the format to MQSTR and only then checking the HRF2 format (hint this resets the format to MQRFH2 but sets the format in the RFH2 to MQSTR as the format of the next part?

Somewhere you need to make sure that you are passing the right format for your payload (MQSTR).

Enjoy
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
shafi
PostPosted: Mon May 01, 2006 10:28 pm    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

fjb_saper,

thanks for all the guidance u gave. the issue was that I had used the RFHUtil in the reversed order; I mean instead of starting with "Read file", of Main Tab,I had been starting with RFH Tab......so, that was the problem.Now its working fine.

Thanks and Regards,
Shafi.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ Java / JMS » JMS Error while starting JDBC Connector
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.