Topic
  • 7 replies
  • Latest Post - ‏2013-02-18T11:33:09Z by EberhardRamm
EberhardRamm
EberhardRamm
78 Posts

Pinned topic RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

‏2012-12-12T13:14:26Z |
I have some messages in Job RDPRINT section and in the error message section of Program details like
DMH2131W DMH_CU_DATA_USE insert failed: REF 1313 690 16 F 0 2 D 180
DMH2131W DMH_CU_DATA_USE insert failed: REF 1067 348 16 F 0 2 D 113

What is the reason of this message and which information or data is lost ?
Updated on 2013-02-18T11:33:09Z at 2013-02-18T11:33:09Z by EberhardRamm
  • jcdelmo
    jcdelmo
    343 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2012-12-12T16:09:24Z  
    These messages indicate the data element references at line 690 column 16 and line 348 column, respectively, have not been recorded in the statement reference table (DMH_CU_DATA_USE). This message is a warning because it is not fatal to many of the RAA functions. However, it should not be occurring.

    The references could not be inserted as the DB2 KEY generated already existed in the data base.

    This could only occur if 1) the data base table is corrupted (unlikely) -- 2) the triggers for deleting the prior meta-data before loading the new results did not fire (unlikely) -- 3) there are two data element references on exactly the same line and column (unlikely) -- 4) RAA has a bug of some unknown nature

    In order to diagnose this rare warning message, I would need to debug one of offending programs -- source and copy books (as both of these are from PROCEDURE DIVISION copybooks -- the 1313 and 1067 are expanded source line numbers)

    Can you, from the RDPRINT, tell what source was being scanned at the time of the messages?
  • jcdelmo
    jcdelmo
    343 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2012-12-12T16:10:20Z  
    One more thing: what scanner were you using (WPS or CBS)?
  • EberhardRamm
    EberhardRamm
    78 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2012-12-12T16:30:40Z  
    • jcdelmo
    • ‏2012-12-12T16:10:20Z
    One more thing: what scanner were you using (WPS or CBS)?
    I was scanning PL/I sources with CBS Compiler with enhanced INCLUDE support:

    DMH1201I Container=TG29.TRAA.PLI File=COMP2
    DMH1929W DMHSVPPM analyzer return code: 0
    DMH1929W PLI analyzer return code: 12
    DMH1929W DMHSSCAN analyzer return code: 0
    DMH1929W DMHSVPPM analyzer return code: 0
    DMH1929W PLI analyzer return code: 4
    DMH1929W DMHSSCAN analyzer return code: 4
    DMH2110I File information being stored in database: COMP2
    DMH2131W DMH_CU_DATA_USE insert failed: REF 1067 348 16 F 0 2 D 113

    I have two programs with this problem and I will look for a small PL/I source with only few includes. It will send it tomorrow via direct email.
  • jcdelmo
    jcdelmo
    343 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2012-12-16T22:57:33Z  
    I was scanning PL/I sources with CBS Compiler with enhanced INCLUDE support:

    DMH1201I Container=TG29.TRAA.PLI File=COMP2
    DMH1929W DMHSVPPM analyzer return code: 0
    DMH1929W PLI analyzer return code: 12
    DMH1929W DMHSSCAN analyzer return code: 0
    DMH1929W DMHSVPPM analyzer return code: 0
    DMH1929W PLI analyzer return code: 4
    DMH1929W DMHSSCAN analyzer return code: 4
    DMH2110I File information being stored in database: COMP2
    DMH2131W DMH_CU_DATA_USE insert failed: REF 1067 348 16 F 0 2 D 113

    I have two programs with this problem and I will look for a small PL/I source with only few includes. It will send it tomorrow via direct email.
    I opened RAA work item 38257 to track this issue.
  • SystemAdmin
    SystemAdmin
    849 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2013-01-05T02:19:51Z  
    • jcdelmo
    • ‏2012-12-16T22:57:33Z
    I opened RAA work item 38257 to track this issue.
    Had this problem once. The database trigger to cascade the delete of the table had gone inactive when we exported, dropped and restored the table (in a different tablespace). It might be worth rerunning the trigger DDL; that's what fixed it for us.

    Thanks,
    Paul
  • jcdelmo
    jcdelmo
    343 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2013-02-13T23:18:44Z  
    I was scanning PL/I sources with CBS Compiler with enhanced INCLUDE support:

    DMH1201I Container=TG29.TRAA.PLI File=COMP2
    DMH1929W DMHSVPPM analyzer return code: 0
    DMH1929W PLI analyzer return code: 12
    DMH1929W DMHSSCAN analyzer return code: 0
    DMH1929W DMHSVPPM analyzer return code: 0
    DMH1929W PLI analyzer return code: 4
    DMH1929W DMHSSCAN analyzer return code: 4
    DMH2110I File information being stored in database: COMP2
    DMH2131W DMH_CU_DATA_USE insert failed: REF 1067 348 16 F 0 2 D 113

    I have two programs with this problem and I will look for a small PL/I source with only few includes. It will send it tomorrow via direct email.
    I have not been able to reproduce this in the lab. Could you pick any program that causes it and rescan (in debugMode) capturing the import file (it will be one of the temp file with STMT and REF records in it) to send to me?
  • EberhardRamm
    EberhardRamm
    78 Posts

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2013-02-18T11:33:09Z  
    • jcdelmo
    • ‏2013-02-13T23:18:44Z
    I have not been able to reproduce this in the lab. Could you pick any program that causes it and rescan (in debugMode) capturing the import file (it will be one of the temp file with STMT and REF records in it) to send to me?
    I have opened PMR 14522,021,724 for this problem.