MQSeries.net :: View topic

harish6185 · Posted: Wed Mar 19, 2008 1:16 am Post subject:

Hi All,

i have a problem with passing a huge message.
here are the details.

1) The XAUDIT database name is mentioned in the file .odbc.ini is as follows.

[ODBC Data Sources]
XROUTE=IBM DB2 ODBC Driver
XAUDIT=IBM DB2 ODBC Driver
DHUB01BR=IBM DB2 ODBC Driver
XREF=DataDirect 5.0 Oracle
GLPS=DataDirect 5.0 Oracle
GFIELD=DataDirect 5.0 Oracle
YMS=DataDirect 5.0 Oracle

2) The error which we are getting is Database Insert failed - XAUDIT/TBMSGIDX and the error description is

The most likely cause of this problem is a problem accessing the audit log database, for example, the ODBC connection is not set up correctly, or the database is full. Check that the database is available and that the correct ODBC connection has been set up. Check that the database is not full (if it is, then it is likely that the audit log needs purging).

I have checked whether the ODBC connection is set properly or not by passing small message. It went through with out throwing any error and can confirm that the database is not full.

I am getting this error only when I try to pass a huge file which is about 5-10 MB.

In the point number 2, XAUDIT is the database name and TBMSGIDX is the table name.

the message is failed to reach the database and went to system dead letter queue of the hub with the following exception.

<DatabaseException>
<File>/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp</File>
<Line>227</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Catalog>BIPv600</Catalog>
<Severity>3</Severity>
<Number>2321</Number>
<Text>Root SQL exception</Text>
<Insert><Type>2</Type><Text>-1</Text></Insert>
<DatabaseException>

can anyone please help me in resolving this problem.

thank you very much in advance.