Fixes are available
Rational Asset Analyzer 6.1
Rational Asset Analyzer for System z 6.1
Rational Asset Analyzer Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer for System z Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer for System z Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer for System z Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1
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
Document Information
Modified date:
28 October 2021