| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Broker 6 (AIX) Database insertion Flow Error (SQL Server) |
« View previous topic :: View next topic » |
| Author |
Message
|
| diegoH |
 Posted: Wed Mar 07, 2007 4:35 pm Post subject: Broker 6 (AIX) Database insertion Flow Error (SQL Server) |
 |
|
Newbie
Joined: 01 Dec 2006
Posts: 4
Location: Argentina
|
Hi guys,
we are getting some strange error that results in a rollback of the insert we are trying to do in an SQLServer Database. WMB 6.0.0.1 is running on an AIX box.
We use the Merant ODBC Driver and the stanza in .odbc.ini is defined as follows:
| Code: |
[MYDATABASE]
Driver=/usr/IBM/mqsi/6.0/merant/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=DATABASE_HOST,1433
Database=MYDATABASE_NAME
AnsiNPW=Yes
QuotedId=No |
When we put a message that has to be processed by the Database insertion flow we got this in WMB Logs:
| Code: |
Mar 7 19:11:22 arp005fuc2ap user:err|error WebSphere Broker v6002[262150]: (AUTBK.valor por omisión)[5912]BIP2628E: Exceptio
n condition detected on input node 'InsertCFU.MQInput'. : AUTBK.310f7738-0f01-0000-0080-9536c184ddb1: /build/S600_P/src/DataF
lowEngine/ImbCommonInputNode.cpp: 1070: ImbCommonInputNode::run: ComIbmMQInputNode: InsertCFU#FCMComposite_1_1
Mar 7 19:11:22 arp005fuc2ap user:err|error WebSphere Broker v6002[262150]: (AUTBK.valor por omisión)[5912]BIP2230E: Error de
tected whilst processing a message in node 'InsertCFU.Database'. : AUTBK.310f7738-0f01-0000-0080-9536c184ddb1: /build/S600_P/
src/DataFlowEngine/ImbDatabaseNode.cpp: 295: ImbDatabaseNode::evaluate: ComIbmDatabaseNode: InsertCFU#FCMComposite_1_3
Mar 7 19:11:22 arp005fuc2ap user:err|error WebSphere Broker v6002[262150]: (AUTBK.valor por omisión)[5912]BIP2488E: (.Inser
tCFU_Database.Main, 13.3) Error detected whilst executing the SQL statement 'INSERT INTO Database.TempCFU ( Comprobante, Sucu
rsal, Estacion, Servicio, Cuenta, Moneda, Importe, Msgid, nombre_lu, banco, netacheq, sucbnl ) VALUES (s_MsgDep.nro_comproba
nte, s_MsgDep.nro_sucursal, s_MsgDep.nro_estacion, t_MsgDep.cod_sistema_credito, NULLIF(TRIMBOTH(BOTH FROM t_MsgDep.nro_cuent
a_credito_deposito), ''), t_MsgDep.tipo_moneda_credito, t_MsgDep.importe_credito, s_MQMD.MsgId, s_MsgDep.nombre_lu, t_MsgDep.
cod_banco, NULLIF(TRIMBOTH(BOTH FROM t_MsgDep.netacheq), ''), NULLIF(TRIMBOTH(BOTH FROM t_MsgDep.sucbnl), '') ) '. : AUTBK.31
0f7738-0f01-0000-0080-9536c184ddb1: /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 573: SqlStatementGroup:
:execute: ComIbmDatabaseNode: InsertCFU#FCMComposite_1_3
Mar 7 19:11:22 arp005fuc2ap user:err|error WebSphere Broker v6002[262150]: (AUTBK.valor por omisión)[5912]BIP2321E: Database
error: ODBC return code '-1'. : AUTBK.310f7738-0f01-0000-0080-9536c184ddb1: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 22
7: ImbOdbcHandle::checkRcInner: :
Mar 7 19:11:22 arp005fuc2ap user:err|error WebSphere Broker v6002[262150]: (AUTBK.valor por omisión)[5912]BIP2322E: Database
error: SQL State '^Z'; Native Error Code '0'; Error Text '[DataDirect][ODBC SQL Serv'. : AUTBK.310f7738-0f01-0000-0080-9536c
184ddb1: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
|
Any suggestions/Ideas?
_________________
Saludos / Regards,
Diego. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 08, 2007 5:53 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I guess I'd recommend updating broker runtime to 6.0.0.3 and see if that fixes the problem.
Also make sure that you don't have "throw exceptions on database warnings" checked, and confirm that the SQLServer is not throwing errors somewhere.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jbenke |
| Posted: Tue Jul 10, 2007 1:21 am Post subject: |
|
|
Newbie
Joined: 07 Sep 2006
Posts: 6
|
I have also the same problem with fixpack 4. I there an solution or the update of the driver.
2007-07-10 08:49:37.598804 ppid=696424:pid=549002:1f20 EXIT SQLExecute with return code -1 (SQL_ERROR)
2007-07-10 08:49:37.598804 ppid=696424:pid=549002:1f20 HSTMT 0x45c32748
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 ENTER SQLError
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 HENV 0x00000000
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 HDBC 0x00000000
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 HSTMT 0x45c32748
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 UCHAR * 0x44e1a530 (NYI)
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 SDWORD * 0x44e1a538
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 UCHAR * 0x45c360b8
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 SWORD 1024
2007-07-10 08:49:37.598860 ppid=696424:pid=549002:1f20 SWORD * 0x44e1a51c
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 EXIT SQLError with return code 0 (SQL_SUCCESS)
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 HENV 0x00000000
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 HDBC 0x00000000
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 HSTMT 0x45c32748
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 UCHAR * 0x44e1a530 [ 3] ""
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 SDWORD * 0x44e1a538 (0)
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 UCHAR * 0x45c360b8 [ 26] "[DataDirect][ODBC SQL Serv"
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 SWORD 1024
2007-07-10 08:49:37.599062 ppid=696424:pid=549002:1f20 SWORD * 0x44e1a51c (26)
_________________
Jochen Benke
WebSphere Business Integration Services
IBM Software Group Germany |
|
| 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
|
|
|
|
