| Author |
Message
|
| brokerics |
 Posted: Thu Dec 15, 2005 1:25 am Post subject: |
 |
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
ok...
i had to change the object inthe trigger, now its okay.
but but
the event_status in the eventtable shows 0. but its not picked up by the queue.
and in the error log
(#678282633)] [Type: Info] [MsgID: 17007] [Mesg: Press q to quit connector.]
[Time: 2005/12/15 14:53:36.054] [System: ConnectorAgent] [SS: JDBC_X] [Thread: appPolling (#676119945)] [Type: Error] [MsgID: 35030] [Mesg: Cannot find the business object ADAPTEST in the database with the key values received.]
[Time: 2005/12/15 14:53:36.054] [System: ConnectorAgent] [SS: JDBC_X] [Thread: appPolling (#676119945)] [Type: Error] [MsgID: 10556] [Mesg: Exception Detail: com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException
[Type: Error] [MsgID: 35030] [Mesg: Cannot find the business object JDBC_ADAPTEST in the database with the key values received.] ]
[Time: 2005/12/15 14:53:36.054] [System: ConnectorAgent] [SS: JDBC_X] [Thread: appPolling (#676119945)] [Type: Fatal Error] [MsgID: 35030] [Mesg: Cannot find the business object JDBC_ADAPTEST in the database with the key values received.]
the manuals say i can safely ignore this message.
but the BO is not picked up!
can someone help?? |
|
| Back to top |
|
 |
| sdng |
| Posted: Thu Dec 15, 2005 2:50 am Post subject: |
|
|
Acolyte
Joined: 23 Nov 2005
Posts: 53
|
imho, you are wrong in set object key in events table (see trigger)
_________________
Are you gangsters? No, we are Russians! |
|
| Back to top |
|
|
| brokerics |
| Posted: Fri Dec 16, 2005 12:55 am Post subject: Elements of a message on delivery queue |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
ok...done thanks.
now i tried to use the message(given below) on the delivery queue in a message flow.
specifically, i wanted to pick out the attribute 'EID' from the message(in compute node)
DLH
JDBC_X/DELIVERYQUEUE TRIB
<Q1:EMPL
xmlns:Q1="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPL" version="3.0.0" verb="Create" locale="en_US" delta="false">
<Q1:NAME>Joey mike</Q1:NAME>
<Q1:EID>108</Q1:EID>
<Q1:PAY>25000</Q1:PAY>
<Q1:ObjectEventId>JDBC_X_117xworlds_events20051216125736.043001</Q1:ObjectEventId>
</Q1:EMPL>
how do i do that in ESQL? Is it InputBody.EID ? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Dec 16, 2005 4:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think you have to know how to use Broker and how to write ESQL to do that.
I'd strongly suggest looking here.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brokerics |
| Posted: Fri Dec 16, 2005 5:29 am Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
uhh actually... i included this
DECLARE Q1 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPL';
Set OutputRoot.MRM.PERSO.NAME =InputBody.Q1:EMPL.Q1:NAME;
and thote it wud work....but doesnt |
|
| Back to top |
|
|
| recallsunny |
| Posted: Fri Dec 16, 2005 10:47 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
Try using this:
| Code: |
| Set OutputRoot.MRM.PERSO.NAME =InputRoot.MRM.*:EMPL.*:NAME; |
|
|
| Back to top |
|
|
| brokerics |
| Posted: Sun Dec 18, 2005 11:22 pm Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
i tried that too
the compilation shows no errors..but its not able to recognise...when
i check in the Flow Debug message.
watdo i do ? |
|
| Back to top |
|
|
| brokerics |
| Posted: Sun Dec 18, 2005 11:33 pm Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
this is the trace file content
Date is: 12/19/2005
Time is: 12:58
Exception List is:
Date is: 12/19/2005
Time is: 13:1
Root is:
(
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = 'EMPL'
(0x03000000):MessageFormat = 'CwXML'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = TRUE
(0x03000000):CreationTime = GMTTIMESTAMP '2005-12-19 07:31:52.370'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 4
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'JDBC_X/DELIVERYQUEUE'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = 'MQHRF2 '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 4
(0x03000000):Persistence = 1
(0x03000000):MsgId = X'414d51205452494220202020202020202347a64320002601'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'TRIB '
(0x03000000):UserIdentifier = 'EAIUSER '
(0x03000000):AccountingToken = X'160105150000003b18d57638520b60a69fb24a0504000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = 'ters\AdapterJRE\bin\java.exe'
(0x03000000):PutDate = DATE '2005-12-19'
(0x03000000):PutTime = GMTTIME '07:31:52.370'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000000):MQRFH2 = (
(0x03000000):Version = 2
(0x03000000):Format = 'MQSTR '
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Flags = 0
(0x03000000):NameValueCCSID = 1208
(0x01000000):mcd = (
(0x01000000):Msd = (
(0x02000000): = 'xml'
)
(0x01000000):Type = (
(0x02000000): = 'EMPL'
)
(0x01000000):Fmt = (
(0x02000000): = 'CwXML'
)
)
(0x01000000):jms = (
(0x01000000):Dst = (
(0x02000000): = 'queue:///JDBC_X/DELIVERYQUEUE'
)
(0x01000000):Tms = (
(0x02000000): = '1134977512371'
)
(0x01000000):Dlv = (
(0x02000000): = '2'
)
)
(0x01000000):usr = (
(0x01000000):WSDLBinding = (
(0x02000000): = 'EMPLAgentDeliveryBinding'
)
(0x01000000):WSDLOperation = (
(0x02000000): = 'EMPLCreate'
)
(0x01000000):PrivacyLevel = (
(0x02000000): = 'None'
)
(0x01000000):MessageType = (
(0x02000000): = 'EMPL'
)
)
)
(0x01000010):XML = (
(0x05000018):XML = (
(0x06000011): = '1.0'
(0x06000012): = 'UTF-8'
)
(0x06000002): = '
'
(0x01000000):Q1:EMPL = (
(0x03000000):xmlns:Q1 = 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPL'
(0x03000000):version = '3.0.0'
(0x03000000):verb = 'Create'
(0x03000000):locale = 'en_US'
(0x03000000):delta = 'false'
(0x02000000): = '
'
(0x01000000):Q1:NAME = (
(0x02000000): = 'Joey mike'
)
(0x02000000): = '
'
(0x01000000):Q1:EID = (
(0x02000000): = '108'
)
(0x02000000): = '
'
(0x01000000):Q1:PAY = (
(0x02000000): = '25000'
)
(0x02000000): = '
'
(0x01000000):Q1:ObjectEventId = (
(0x02000000): = 'JDBC_X_117xworlds_events20051219130146.635001'
)
(0x02000000): = '
'
)
(0x06000002): = '
'
)
) |
|
| Back to top |
|
|
| brokerics |
| Posted: Mon Dec 19, 2005 7:48 pm Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
o god
i guess quotes are required whn including namespaces,huh....
Code:
Set OutputRoot.MRM.PERSO.NAME =InputRoot.MRM."Q1:EMPL"."Q1:NAME"; |
|
| Back to top |
|
|
|
|
