PI42324: EXCEPTION INSERTING INTO DMH_MAP_FILE WITH SQLCODE=-803 WHEN POSTPROCESSING

RAAz-6.1.0.8-Install-IMRepository
RAAz-6.1.0.8-Install
RAA-6.1.0.8-Install-IMRepository
RAA-6.1.0.8-Install
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

APAR status

• Closed as program error.

Error description

• Message similar to the following may occur during
  postprocessing when using a 6.1.0.7 update driver built before
  June, 2015:
  
  Exception on prepared statement [INSERT INTO
  $(SCHEMA).DMH_MAP_FILE (map_id, file_id) VALUES (?, ?)
  (params=[-1,17929])]
   Caused by: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=2;DMH.DMH_MAP_FILE, DRIVER=3.65.110
   Caused by: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=2;DMH.DMH_MAP_FILE, DRIVER=3.65.110
  com.ibm.dmh.db.SQLRuntimeException: Exception on prepared
  statement [INSERT INTO $(SCHEMA).DMH_MAP_FILE (map_id, file_id)
  VALUES (?, ?) (params=[-1,17929])]
   Caused by: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=2;DMH.DMH_MAP_FILE, DRIVER=3.65.110
   Caused by: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=2;DMH.DMH_MAP_FILE, DRIVER=3.65.110
   at
  sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
  Method)
   at
  sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons
  tructorAccessorImpl.java:56)
   at
  sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega
  tingConstructorAccessorImpl.java:39)
   at
  java.lang.reflect.Constructor.newInstance(Constructor.java:527)
   at
  com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionH
  elper(GenericDataStoreHelper.java:617)
   at
  com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(
  GenericDataStoreHelper.java:676)
   at
  com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2
  265)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.jav
  a:1187)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(
  WSJdbcPreparedStatement.java:813)
   at
  com.ibm.dmh.db.DbPreparedStatement.update(DbPreparedStatement.ja
  va:246)
   at com.ibm.dmh.db.DbAdmin.update(DbAdmin.java:1105)
  
  and analysis queue status goes to Not running, but leaving
  items on the queue.
  

Local fix

• none known.
  

Problem summary

• SQLCODE=-803 on INSERT into DMH_MAP_FILE during postprocessing
  queue type 18, caused by incorrect map id being returned.
  

Problem conclusion

• Corrected the code that inserts DMH_MAP rows so that it returns
  the correct map id to be used later with the DMH_MAP_FILE table
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• aqp
  

Fix information

• Fixed component name

  RATL ASSET ANAL

• Fixed component ID

  5724V2700

Applicable component levels

• R610 PSY

     UP