BTM Exception caused by SQL error: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002

Troubleshooting

Problem

A large number of transactions fail due to BTM Exception when doing batch updates in InfoSphere MDM Server.

Symptom

After closer inspection of the WebSphere logs the following details are seen.
[6/27/14 8:25:21:746 EDT] 00000915 SystemErr R

***** Out of Package Error Occurred (2014-06-27 08:25:21.743) *****
Exception stack trace:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002,
SQLERRMC=MDMPROD.NULLID.SYSLN203.5359534C564C3031;DISTSERV;04, DRIVER=3.64.106
com.ibm.db2.jcc.am.bd.a(bd.java:682)
com.ibm.db2.jcc.am.bd.a(bd.java:60)

[{"Product":{"code":"SSPVUA","label":"IBM InfoSphere Master Data Management Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere Master Data Management Server

Software version:
10.1

Operating system(s):
AIX, Linux

Document number:
516971

Modified date:
16 June 2018

UID

swg21679179

IBM Support

Tips