PI38664: RAA 6.1.0.7 EXCEPTION ON PREPARED STATEMENT WITH SQLCODE=-803 DURING 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

• A message similar to the following is logged and postprocessing
  stops when certain COBOL assets are being scanned:
  
  SEVERE: Exception on prepared statement [INSERT INTO $(SCHEMA).
  DMH_CU_DATA_USE (comp_unit_id, source_line_no, verb_column_no,
  file_line_no, token_column_no, member_id, related_id,
  cmpnt_type_id,
  modified_flag, expression_no, phrase_type_id) VALUES (?, ?, ?,
  ?, ?, ?,
  ?, ?, ?, ?, ?)
  (params=[122403285,98124,24,1157,26,122403285,58525,2,
  F,1,54])]
   Caused by: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=1;DMH.
  DMH_CU_DATA_USE, DRIVER=3.65.110
  

Local fix

• From a DB2 Command Prompt (Run as administrator), you can:
  
  .
  
  DB2 CONNECT TO DMHDB
  
  .
  
  DB2 ALTER TABLE DMH.DMH_CU_DATA_USE DROP PRIMARY KEY
  
  .
  
      DB2 ALTER TABLE DMH.DMH_CU_DATA_USE ADD PRIMARY KEY
  (comp_unit_id,
  source_line_no, verb_column_no, file_line_no, token_column_no,
  
  member_id)
  
  .
  
      DB2 CONNECT RESET
  
  .
  
  Then, rerun the postprocessor.
  

Problem summary

• Duplicate rows being generated in import file when parsing some
  statements with WHEN...OR... syntax.
  

Problem conclusion

• Import file generation logic was fixed to update these types of
  records to avoid duplicates.
  

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

• cbs
  

Fix information

• Fixed component name

  RATL ASSET ANAL

• Fixed component ID

  5724V2700

Applicable component levels

• R610 PSY

     UP