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

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
    292 Posts
    ACCEPTED ANSWER

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

    ‏2012-12-12T16:09:24Z  in response to EberhardRamm
    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
    292 Posts
    ACCEPTED ANSWER

    Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

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

      Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

      ‏2012-12-12T16:30:40Z  in response to jcdelmo
      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
        292 Posts
        ACCEPTED ANSWER

        Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

        ‏2012-12-16T22:57:33Z  in response to EberhardRamm
        I opened RAA work item 38257 to track this issue.
        • SystemAdmin
          SystemAdmin
          849 Posts
          ACCEPTED ANSWER

          Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

          ‏2013-01-05T02:19:51Z  in response to jcdelmo
          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
        292 Posts
        ACCEPTED ANSWER

        Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

        ‏2013-02-13T23:18:44Z  in response to EberhardRamm
        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
          ACCEPTED ANSWER

          Re: RAAz V6.0.0.11 - DMH_CU_DATA_USE insert failed

          ‏2013-02-18T11:33:09Z  in response to jcdelmo
          I have opened PMR 14522,021,724 for this problem.