MQSeries.net :: View topic - EG shutsdown on every database insert failure.

guest468

Hi all,
We are using a broker which uses JavaComputeNode (WBI6.0). And whenever the node(using java compute node) tries to insert a record into the database (oracle 10g) with unique constraint violation, the EG shutsdown.
Here is the syslog output covering the scenario...

Oct 19 13:43:55 da1at012 user:err|error WebSphere Broker v6001[467178]: (DVA12MBKR01.STAGING_TRANSFORM)[5912]BIP2121E: The thread bootstrap code caught an unhandled exception on thread '5912'. : DVA12MBKR01.e2e7fce9-0c01-0000-0080-c4e1
b5df3501: /build/S600_P/src/CommonServices/rios_aix_4/ImbOsThread.cpp: 252: ImbOsThread::threadBootStrap: :
Oct 19 13:43:55 da1at012 user:err|error WebSphere Broker v6001[467178]: (DVA12MBKR01.STAGING_TRANSFORM)[5912]BIP2488E: (, 1.1) Error detected whilst executing the SQL statement 'INSERT INTO Database.DTHDBA.DTH_MCI_INDIVIDUAL ( WMS_CLI
ENT_ID, HISTORY_SEQ_NBR, SOURCE_SYSTEM_TXT, FIRST_NM, LAST_NM, MIDDLE_NM, SUFFIX_NM, BIRTH_DT, SOCIAL_SEC_NBR, GENDER_CD_TXT, SWMS_CONVERSION_DT, CREATE_DT, CREATE_USR_ID, DELETE_IND ) VALUES ('SU74630T', 1, 'NYC', 'VICTOR', 'CRUZ', '
', '', CAST('1942-04-15' AS DATE), 0, 'M', CURRENT_DATE, CURRENT_DATE, 'OTDABROKER', 'N' ) '. : DVA12MBKR01.e2e7fce9-0c01-0000-0080-c4e1b5df3501: /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 573: SqlStatementGroup:
:execute: ComIbmJniNode: application_to_canonical/Staging_To_Canonical_NYC_Transformer#FCMComposite_1_4.common_services/Message_Transformer#FCMComposite_1_3
Oct 19 13:43:55 da1at012 user:err|error WebSphere Broker v6001[467178]: (DVA12MBKR01.STAGING_TRANSFORM)[5912]BIP2321E: Database error: ODBC return code '-1'. : DVA12MBKR01.e2e7fce9-0c01-0000-0080-c4e1b5df3501: /build/S600_P/src/DataFlo
wEngine/ImbOdbc.cpp: 227: ImbOdbcHandle::checkRcInner: :
Oct 19 13:43:55 da1at012 user:err|error WebSphere Broker v6001[467178]: (DVA12MBKR01.STAGING_TRANSFORM)[5912]BIP2322E: Database error: SQL State '23000'; Native Error Code '1'; Error Text '[DataDirect][ODBC Oracle driver][Oracle]ORA-00
001: unique constraint (DTHDBA.DTH_MCI_INDIVIDUAL_PK) violated '. : DVA12MBKR01.e2e7fce9-0c01-0000-0080-c4e1b5df3501: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
Oct 19 13:44:08 da1at012 user:info WebSphere Broker v6001[467178]: (DVA12MBKR01.STAGING_TRANSFORM)[1]BIP2204I: Execution group using process '467178' thread '1' stopped. : DVA12MBKR01.e2e7fce9-0c01-0000-0080-c4e1b5df3501: /build/S600_P
/src/DataFlowEngine/ImbMain.cpp: 886: main: :
Oct 19 13:44:08 da1at012 user:warn|warning WebSphere Broker v6001[688246]: (DVA12MBKR01)[2571]BIP2060W: The broker has detected that the Execution Group STAGING_TRANSFORM, process ID 467178, has shutdown. : DVA12MBKR01.agent: /build/S6
00_P/src/AdminAgent/ImbAdminAgent.cpp: 4070: ImbAdminAgent::startAndMonitorADataFlowEngine: :
Oct 19 13:44:08 da1at012 user:info WebSphere Broker v6001[868362]: (DVA12MBKR01.STAGING_TRANSFORM)[1]BIP2201I: Execution Group start

EG is restaring for every such database failure. Would appreciate if someone can help to resolve this...