MQSeries.net :: View topic

missing_link · Posted: Fri Nov 23, 2007 2:09 am Post subject: Broker internal software error

Hi Guys

Running Broker v5 CSD9 on Solaris.

I have a message flow which is doing a join across my input message and oracle database to detect differences in a daily data feed. This was working OK, but I've had to make a small change (ie an additional join) which then caused the broker to fail at runtime when the message is passed into the compute node ie. it doesnt fail when its trying to execute the changed piece of code. I've tried adding different clauses in the join and it throws the error in virtually every case!!

Heres the code....

SET OutputLocalEnvironment.Variables.MarkitChanges[] =
(SELECT markitIndex.red AS IndexRED,
markitIndex.indexname AS IndexName ,
C.refentity.name AS RefentityName,
C.refentity.red AS RefentityRED,
I2.INSTR_NAME AS FromName,
C.bond.name AS ToName,
I2.UNDERLYING_BOND_ISIN AS FromISIN,
C.bond.isin AS ToISIN,
C.bond.originalisin AS OriginalISIN,
I2.MATR_DATE AS MaturityDate
FROM
Database.INSTR AS I2,
InputRoot.MRM.index as M,
InputRoot.MRM.index.component[] as C
WHERE
I2.INDEX_RED = M.red AND
I2.INSTR_TYPE_CODE = 'CDS' AND
-- ** This is the additional line ****
'hello' = C.refentity.red AND
I2.UNDERLYING_BOND_ISIN <> C.bond.isin
);

Obviously the addition line there is just a test....what i need to do is compare compare two mutually exclusive values in my message against the db. I know how to do this (which is when i first started to get the error)....i put the above in just to see if something like that would still work or have the same effect.

The errors that I get are:
--------------------------------------------------
** to show that it fails as the message enters the compute node **
2007-11-21 16:59:23.191480 27 UserTrace BIP4005I: Message propagated to 'false' terminal of filter node 'Markit_CDSI.Check if New In
dex'.
2007-11-21 16:59:23.192712 27 UserTrace BIP4081I: Message propagated to catch terminal from try-catch node 'Markit_CDSI.TryCatch'.
The try-catch node 'Markit_CDSI.TryCatch' has caught an exception which occurred in a node connected to
its try terminal. The message has been augmented with an exception list and is propagating it to any nodes connected to its catch terminal fo
r further processing. See the following messages for details of the exception list.
No user action required.

2007-11-21 16:59:23.192746 27 RecoverableException BIP2230E: Error detected whilst processing a message in node 'Markit_CDSI.Check Ma
rkit Data'.
The message broker detected an error whilst processing a message in node 'Markit_CDSI.Check Markit Data
'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2007-11-21 16:59:23.192760 27 RecoverableException BIP2488E: (.Markit_CDSI_Check_Data.Main, 46.4) Error detected whilst executing th
e SQL statement 'PROPAGATE;'.
The message broker detected an error whilst executing the given statement. An exception has been thrown
to cut short the SQL program.
See the following messages for details of the error.

and then...

2007-11-21 16:59:23.192790 27 RecoverableException BIP2110E: Message broker internal program error.
An internal software error has occurred in the message broker. Further messages will indicate the effe
ct of this error on the broker's transactions. There is no diagnostic information associated with this message
Shutdown and restart the message broker. If the problem continues to occur, then restart the system.
If the problem still continues to occur contact your IBM support center.

------------------------------------

Has anybody experienced any issues similar to this/ideas as to whats actually causing this to fall over? Next step is to log a PMR with IBM but thought I'd sound out the forum first.

cheers

ash.