JR51699: DATAINTEGRITYVIOLATIONEXCEPTIONS ARE OCCASIONALLY THROWN

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

爱旅游的汽水 · 世界上美食最多的十个国家，第一名让所有人心服口服！· 2 月前 ·

坚强的猴子 · Journal of Open ...· 3 月前 ·

寂寞的芹菜 · window.print()打印时根据页面高 ...· 4 月前 ·

大力的拐杖 · 空调外机怕不怕淋雨？要不要遮一下？原来大多数 ...· 4 月前 ·

乐观的蚂蚁 · 冰岛商务论坛2008年新年招待会· 5 月前 ·

To return expected results, you can:

Reduce the number of search terms. Each term you use focuses the search further.

Check your spelling. A single misspelled or incorrectly typed term can change your result.

Try substituting synonyms for your original terms. For example, instead of searching for "java classes", try "java training"

Did you search for an IBM acquired or sold product ? If so, follow the appropriate link below to find the content you need.

8.5.0.1-WS-BPM-IFJR51699
8.5.5.0-WS-BPM-IFJR51699
Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products

In rare situations, for example after you migrate your system,
you might see
org.springframework.dao.DataIntegrityViolationException and
exceptions that are similar to the following exception stack in
the SystemOut.log file:
org.springframework.dao.DataIntegrityViolationException:
StatementCallback; SQL [
                insert into LSW_USR_GRP_MEM_XREF(USER_ID,
GROUP_ID)
                SELECT LSW_USR_XREF.USER_ID, 5417
                from LSW_USR_XREF where
USER_ID IN (
                select DISTINCT LSW_USR_XREF.USER_ID
                from LSW_USR_GRP_MEM_XREF, LSW_USR_GRP_XREF,
LSW_USR_XREF
                where
                    LSW_USR_GRP_MEM_XREF.GROUP_ID =
LSW_USR_GRP_XREF.GROUP_ID
                    AND LSW_USR_XREF.USER_ID =
LSW_USR_GRP_MEM_XREF.USER_ID
                    AND LSW_USR_GRP_XREF.GROUP_NAME =
'wab_lic_produktieteam'
USER_ID IN (
                select DISTINCT LSW_USR_XREF.USER_ID
                from LSW_USR_GRP_MEM_XREF, LSW_USR_GRP_XREF,
LSW_USR_XREF
                where
                    LSW_USR_GRP_MEM_XREF.GROUP_ID =
LSW_USR_GRP_XREF.GROUP_ID
                    AND LSW_USR_XREF.USER_ID =
LSW_USR_GRP_MEM_XREF.USER_ID
                    AND LSW_USR_GRP_XREF.GROUP_NAME =
'wab_lic_produktieteam_S_f86a73f7-b540-47ca-af3c-36c969e51395.42
28ad52-4
a8b-431a-a85b-8990cffa00d5'
 AND USER_ID IN (
                select DISTINCT LSW_USR_XREF.USER_ID
                from LSW_USR_ATTR, LSW_USR_XREF
                where
                    LSW_USR_XREF.USER_ID = LSW_USR_ATTR.USER_ID
                    AND USER_ATTR_DEF_ID =
'e673bd96-ab12-4c45-b3fa-655a8d499be5' and ATTR_VALUE = 'true'
 AND USER_ID IN (
                select DISTINCT LSW_USR_XREF.USER_ID
                from LSW_USR_ATTR, LSW_USR_XREF
                where
                    LSW_USR_XREF.USER_ID = LSW_USR_ATTR.USER_ID
                    AND USER_ATTR_DEF_ID =
'2d05f0e4-e0c3-4234-bebd-46e4a4d28986' and ATTR_VALUE = 'true'
]; DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
SQLERRMC=2;VIRTUSER.LSW_USR_GRP_MEM_XREF, DRIVER=4.11.69; nested
exception is com.ibm.websphere.ce.cm.DuplicateKeyException:
DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
SQLERRMC=2;VIRTUSER.LSW_USR_GRP_MEM_XREF, DRIVER=4.11.69
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransla
tor.tran
slate(SQLErrorCodeSQLExceptionTranslator.java:292)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
java:407
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.j
ava:522)
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(S
impleJdb
cTemplate.java:237)
com.lombardisoftware.server.core.DynamicGroupHelper.assignUsersR
ecursive
ly(DynamicGroupHelper.java:215)
com.lombardisoftware.server.core.DynamicGroupHelper.refreshMembe
rship(Dy
namicGroupHelper.java:117)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.resolveParticipantIfNecessary(BPDActivityWorker.java:
2210)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.resolveParticipantAddress(BPDActivityWorker.java:2169
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.resolveParticipantAddress(BPDActivityWorker.java:2156
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.resolveSendToCustom(BPDActivityWorker.java:1991)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.resolveTaskSendToList(BPDActivityWorker.java:1891)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.resolveSendTo(BPDActivityWorker.java:1054)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.createTask(BPDActivityWorker.java:703)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.executeImplementation(BPDActivityWorker.java:490)
com.lombardisoftware.bpd.component.flowcomponent.activity.worker
.BPDActi
vityWorker.doWork(BPDActivityWorker.java:270)
com.lombardisoftware.bpd.runtime.engine.FlowObjectExecutionTreeN
ode.doWo
rk(FlowObjectExecutionTreeNode.java:371)
com.lombardisoftware.bpd.runtime.engine.BPDEngine.executeTreeNod
e(BPDEng
ine.java:337)
com.lombardisoftware.bpd.runtime.engine.BPDEngine.resume(BPDEngi
ne.java:
The stalled BPD instances are in state running, but no active
Task for these BPD instances exists.
Local fix
Problem summary
When IBM BPM refreshes dynamic group membership, it deletes all
records in LSW_USR_GRP_MEM_XREF that belong to this group and
inserts the records in LSW_USR_GRP_MEM_XREF that make up this
group. This refresh happens whenever an activity in a business
process definition (BPD) that uses a dynamic group is activated
and the associated task is created.
If two threads refresh the same group concurrently, the delete
operation usually creates a lock that blocks the second thread
until the first thread has committed its transaction. However,
if no record for this group exists in LSW_USR_GRP_MEM_XREF, the
second thread is not blocked and the delete operation has no
effect and both threads attempt to insert the same records into
LSW_USR_GRP_MEM_XREF, which causes a
DataIntegrityViolationException or DuplicateKeyException.
Problem conclusion
A fix is/will be available that catches and ignores the
DataIntegrityViolationException because it does no harm.
This exception simply means that the records that the actual
thread attempted to insert have already been inserted by another
thread.
On Fix Central (http://www.ibm.com/support/fixcentral), search
for JR51699:
1. Select IBM Business Process Manager with your edition from
  the product selector, the installed version to the fix pack
  level, and your platform, and then click Continue.
2. Select APAR or SPR, enter JR51699, and click Continue.
When you download fix packages, ensure that you also download
the readme file for each fix. Review each readme file for
additional installation instructions and information about the
Temporary fix
Not applicable
Comments
APAR Information
APAR number
JR51699
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
850
Status
CLOSED  PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-11-03
Closed date
2015-01-12
Last modified date
2015-01-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM STANDARD
Fixed component ID
5725C9500
Applicable component levels
R850  PSY
   UP
R855  PSY
   UP