PM54135: DUPLICATEKEYEXCEPTION ON INSERT INTO DMH.DMH_RUN

Fixes are available

APAR status

Closed as program error.

Error description

While scanning assets, customer observes
hundreds of the same exception message "DuplicateKeyException on
INSERT INTO DMH.DMH_RUN_UNIT"


Here additional lines from the exception:

Problem description [2011/08/14 07:34:42:084] WARNING: Executing
update INSERT INTO DMH.DMH_RUN_UNIT (run_unit_id, ep_symbol_id,
analysis_status_cd, site_id, create_tool_id, create_timestamp)
VALUES (?, ?, 'I', ?, ?, CURRENT TIMESTAMP)
com.ibm.websphere.ce.cm.DuplicateKeyException: DB2 SQL Error:
SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DMH.DMH_RUN_UNIT,
DRIVER=3.61.75 at
sun.reflect.GeneratedConstructorAccessor4.newInstance(Unknown
Source) at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega
tingConstructorAccessorImpl.java:27) at
java.lang.reflect.Constructor.newInstance(Constructor.java:516)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionH
elper(GenericDataStoreHelper.java:605) at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(
GenericDataStoreHelper.java:667) at
com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2
111) at
com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.jav
a:1034) at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.ExecuteUpdate(
WSJdbcPreparedStatement.java:826) at
com.ibm.dmh.model.DmhDatabase.executeUpdate(DmhDatabase.java:369
) at
com.ibm.dmh.model.DmhDatabase.executeUpdateInternal(DmhDatabase.
java:323) at
com.ibm.dmh.model.DmhDatabase.executeReusableUpdate(DmhDatabase.
java:293) at
com.ibm.dmh.model.DmhMetaComponentRunUnit.insertRow(DmhMetaCompo
nentRunUnit.java:301) at
com.ibm.dmh.model.DmhMetaComponentRunUnit.insert(DmhMetaComponen
tRunUnit.java:321) at
com.ibm.dmh.aqp.AnalysisQueueProcessorWork.addRunUnitsForPrimary
EntryPoints(AnalysisQueueProcessorWork.java:211) at
com.ibm.dmh.aqp.AnalysisQueueProcessorWork.startQTypeProcessing(
AnalysisQueueProcessorWork.java:390) at
com.ibm.dmh.aqp.AnalysisQueueProcessorWork.startQProcessing(Anal
ysisQueueProcessorWork.java:355) at
com.ibm.dmh.aqp.AnalysisQueueProcessorWork.run(AnalysisQueueProc
essorWork.java:294) at
com.ibm.dmh.qp.AsynchBeanWorkManager$ABWorkWrapper.run(Unknown
Source) at
com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782) at
com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithE
xecutionContextImpl.java:222) at
com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:15
9) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1563

Local fix

Problem summary

When detecting a duplicate key upon inserting run unit meta-data
into the data base, a duplicate key (SQL -803) error was
reported.  The insert continues correctly resolving the
duplicate key issue.

Problem conclusion

Duplicate key detection is a normal part of the insert run unit
meta-data process, and should not have been reported.  The
message is now suppressed.

Temporary fix

```
Appy RAA 6.0.0.6 fixpak
```

Comments

APAR Information

APAR number
PM54135
Reported component name
RATL ASSET ANAL
Reported component ID
5724V2700
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-12-12
Closed date
2012-01-25
Last modified date
2012-01-25

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
RATL ASSET ANAL
Fixed component ID
5724V2700

Applicable component levels

R600 PSY
UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
28 October 2021

Tips

PM54135: DUPLICATEKEYEXCEPTION ON INSERT INTO DMH.DMH_RUN_UNIT

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

R600 PSY

Document Information

Share your feedback

Need support?