| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BIP2328E |
« View previous topic :: View next topic » |
| Author |
Message
|
| Jim Peterson |
 Posted: Thu Feb 27, 2003 6:28 am Post subject: BIP2328E |
 |
|
Newbie
Joined: 26 Feb 2003
Posts: 2
|
BIP2328E: A value of SQL datatype 'CHARACTER' encountered when datatype 'INTEGER' expected.
I'm getting this error when I try to publish a message from a publish node in WMQI. The problem is that it isn't specific in telling me what field it's having a problem with. I tinkered with the message set, but I don't think the problem is there, I suspect that there's something about the MQRFH2 header that it doesn't like. I have lots of examples, I'll list the output from two of them.
I appreciate any feedback.
Thanks,
Jim
I have a trace node just before the publish node, and it's showing me this:
2003-02-26 14:14:20.676450 7983 UserTrace BIP4060I: Data '(
(0x1000000)Properties = (
(0x3000000)MessageSet = NULL
(0x3000000)MessageType = NULL
(0x3000000)MessageFormat = NULL
(0x3000000)Encoding = '273'
(0x3000000)CodedCharSetId = '819'
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2003-02-26 22:13:54.570'
(0x3000000)ExpirationTime = GMTTIMESTAMP '2003-03-12 15:07:40.383083'
(0x3000000)Priority = 9
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'EI.SALESORDEREVENT.PUB'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQHRF2'
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = GMTTIMESTAMP '2003-03-12 15:07:40.383083'
(0x3000000)Feedback = 0
(0x3000000)Priority = 9
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'c3e2d840d4c3c1c44040404040404040b90aa6f9338b8081'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'MCAD '
(0x3000000)UserIdentifier = 'cicsuser '
(0x3000000)AccountingToken = X'160de4d5c9d5c5e34bc3c9c3e2c9c60aa6f91141070003000000000000000000'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 1
(0x3000000)PutApplName = 'CICSIF BCCP '
(0x3000000)PutDate = DATE '2003-02-26'
(0x3000000)PutTime = GMTTIME '22:13:54.570'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = 68
)
(0x1000000)MQRFH2 = (
(0x1000000)StrucId = (
(0x2000000) = 'RFH '
)
(0x1000000)Version = (
(0x2000000) = 2
)
(0x1000000)StrucLength = (
(0x2000000) = 36
)
(0x1000000)Encoding = (
(0x2000000) = 273
)
(0x1000000)CodedCharSetId = (
(0x2000000) = 819
)
(0x1000000)Format = (
(0x2000000) = 'MQSTR'
)
(0x1000000)Flags = (
(0x2000000) = 0
)
(0x1000000)NameValueCCSID = (
(0x2000000) = 1208
)
(0x1000000)NameValueLength = (
(0x2000000) = 36
)
(0x1000000)NameValueData = (
(0x2000000) = 'MQPSCommand Publish MQPSTopic test '
)
(0x1000000)mcd = (
(0x1000000)Msd = (
(0x2000000) = 'mrm'
)
)
)
(0x1000008)MRM = (
(0x3000001)QE8_Order_Number = '01-KT-635640'
(0x3000001)QE8_EDI_Master_Order = ''
(0x3000001)QE8_Record_Type = 'SALESORDER '
(0x3000001)QE8_Command = ' '
(0x3000001)QE8_Order_Line_Count = '0001'
(0x3000001)QE8_Message_Line_Count = '0003'
)
)
' from Trace node 'SalesOrderEvent_publish.Trace1_1'.
The Trace node 'SalesOrderEvent_publish.Trace1_1' has output the specified trace data.
This is an information message provided by the message flow designer. The user response will be determined by the local environment.
2003-02-26 14:14:20.677082 7983 UserTrace BIP4067I: Message propagated to Output terminal for Trace node 'SalesOrderEvent_publish.Trace1_1'.
The Trace node 'SalesOrderEvent_publish.Trace1_1' has received a message and is propagating it to any nodes connected to its Output terminal.
No user action required.
2003-02-26 14:14:20.678457 7983 UserTrace BIP7086I: Node 'SalesOrderEvent_publish.Publication1.PSService1': The Publication node with Subscription Point '' has received an error code 3008.
The Publication node with Subscription Point '' has received an error with code 3008. No response message has been sent as one was not requested.
No user action required.
2003-02-26 14:14:20.680130 8228 UserTrace BIP4067I: Message propagated to Output terminal for Trace node 'SalesOrderEvent_message.Database1'.
The Trace node 'SalesOrderEvent_message.Database1' has received a message and is propagating it to any nodes connected to its Output terminal.
No user action required.
2003-02-26 14:14:20.687168 7983 Error BIP2628E: Exception condition detected on input node 'SalesOrderEvent_publish.MQInput1'.
The input node 'SalesOrderEvent_publish.MQInput1' detected an error whilst processing a message. The message flow has been rolled-back and, if the message was being processed in a unit of work, it will remain on the input queue to be processed again. Following messages will indicate the cause of this exception.
Check the error messages which follow to determine why the exception was generated, and take action as described by those messages.
2003-02-26 14:14:20.687252 7983 RecoverableException BIP2230E: Error detected whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'.
The message broker detected an error whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2003-02-26 14:14:20.687311 7983 Exception BIP2230E: Error detected whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'.
The message broker detected an error whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2003-02-26 14:14:20.687364 7983 RecoverableException BIP2328E: A value of SQL datatype 'CHARACTER' encountered when datatype 'INTEGER' expected.
And this is another example, slightly different MQRFH2 header:
2003-02-25 14:20:58.522388 7983 UserTrace BIP4060I: Data '(
(0x1000000)Properties = (
(0x3000000)MessageSet = NULL
(0x3000000)MessageType = NULL
(0x3000000)MessageFormat = NULL
(0x3000000)Encoding = '273'
(0x3000000)CodedCharSetId = '819'
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = TRUE
(0x3000000)CreationTime = GMTTIMESTAMP '2003-02-25 22:20:32.920'
(0x3000000)ExpirationTime = GMTTIMESTAMP '2003-03-11 15:14:17.954696'
(0x3000000)Priority = 9
(0x3000000)Topic = 'test'
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'EI.SALESORDEREVENT.PUB'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQHRF2'
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = GMTTIMESTAMP '2003-03-11 15:14:17.954696'
(0x3000000)Feedback = 0
(0x3000000)Priority = 9
(0x3000000)Persistence = 1
(0x3000000)MsgId = X'c3e2d840d4c3c1c44040404040404040b9096697a3883701'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'MCAD '
(0x3000000)UserIdentifier = 'cicsuser '
(0x3000000)AccountingToken = X'160de4d5c9d5c5e34bc3c9c3e2c9c60966977ecc450003000000000000000000'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 1
(0x3000000)PutApplName = 'CICSIF BCCP '
(0x3000000)PutDate = DATE '2003-02-25'
(0x3000000)PutTime = GMTTIME '22:20:32.920'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = 68
)
(0x1000000)MQRFH2 = (
(0x1000000)StrucId = (
(0x2000000) = 'RFH '
)
(0x1000000)Version = (
(0x2000000) = 2
)
(0x1000000)StrucLength = (
(0x2000000) = 48
)
(0x1000000)Encoding = (
(0x2000000) = 273
)
(0x1000000)CodedCharSetId = (
(0x2000000) = 819
)
(0x1000000)Format = (
(0x2000000) = 'MQSTR'
)
(0x1000000)Flags = (
(0x2000000) = 0
)
(0x1000000)NameValueCCSID = (
(0x2000000) = 1208
)
(0x1000000)psc = (
(0x1000000)Command = (
(0x2000000) = 'Publish'
)
(0x1000000)Topic = (
(0x2000000) = 'test'
)
(0x1000000)QMgrName = (
(0x2000000) = 'UEID'
)
(0x1000000)QName = (
(0x2000000) = 'SYSTEM.BROKER.DEFAULT.STREAM'
)
)
(0x1000000)mcd = (
(0x1000000)Msd = (
(0x2000000) = 'mrm'
)
)
)
(0x1000008)MRM = (
(0x3000001)QE8_Order_Number = '01-KT-635634'
(0x3000001)QE8_EDI_Master_Order = ''
(0x3000001)QE8_Record_Type = 'SALESORDER '
(0x3000001)QE8_Command = ' '
(0x3000001)QE8_Order_Line_Count = '0001'
(0x3000001)QE8_Message_Line_Count = '0003'
)
)
' from Trace node 'SalesOrderEvent_publish.Trace1_1'.
The Trace node 'SalesOrderEvent_publish.Trace1_1' has output the specified trace data.
This is an information message provided by the message flow designer. The user response will be determined by the local environment.
2003-02-25 14:20:58.522937 7983 UserTrace BIP4067I: Message propagated to Output terminal for Trace node 'SalesOrderEvent_publish.Trace1_1'.
The Trace node 'SalesOrderEvent_publish.Trace1_1' has received a message and is propagating it to any nodes connected to its Output terminal.
No user action required.
2003-02-25 14:20:58.524307 7983 UserTrace BIP7086I: Node 'SalesOrderEvent_publish.Publication1.PSService1': The Publication node with Subscription Point '' has received an error code 3008.
The Publication node with Subscription Point '' has received an error with code 3008. No response message has been sent as one was not requested.
No user action required.
2003-02-25 14:20:58.531539 7983 Error BIP2628E: Exception condition detected on input node 'SalesOrderEvent_publish.MQInput1'.
The input node 'SalesOrderEvent_publish.MQInput1' detected an error whilst processing a message. The message flow has been rolled-back and, if the message was being processed in a unit of work, it will remain on the input queue to be processed again. Following messages will indicate the cause of this exception.
Check the error messages which follow to determine why the exception was generated, and take action as described by those messages.
2003-02-25 14:20:58.531620 7983 RecoverableException BIP2230E: Error detected whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'.
The message broker detected an error whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2003-02-25 14:20:58.531669 7983 Exception BIP2230E: Error detected whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'.
The message broker detected an error whilst processing a message in node 'SalesOrderEvent_publish.Publication1.PSService1'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2003-02-25 14:20:58.531715 7983 RecoverableException BIP2328E: A value of SQL datatype 'CHARACTER' encountered when datatype 'INTEGER' expected. |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Feb 27, 2003 10:23 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Is it possible to capture the ExceptionList in a trace node and post the contents here?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Jim Peterson |
| Posted: Fri Feb 28, 2003 6:09 am Post subject: |
|
|
Newbie
Joined: 26 Feb 2003
Posts: 2
|
| I'll have to do a little digging to figure out how to do that. I'll be back. |
|
| 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
|
|
|
|
