Extended Error Handling Facility › About the Extended Error Handling Facility › Input Phase Errors › Storage Violation Error

Storage Violation Error

CA Culprit returns a storage violation message when it attempts to store rows of a table for which row-level security is enforced. To store rows of a table, the OUTPUT parameter for the report must specify the name of the table (TABLE=) and one of the following keywords expressions:

• TYPE=CREATE
• TYPE=ADD
• TYPE=REPLACE

CA Culprit checks the row-level criteria established for the specified user. For each row that does not meet the criteria, CA Culprit prints this message followed by the first 100 bytes of the record:

C760001 THE FOLLOWING ROWS WERE NOT STORED DUE TO STORAGE VIOLATIONS

CA Culprit prints the following information in the record layout:

• OUTPUT RECORD NUMBER specifies the number of the output record to be stored in the table. For example, the seventh record to be stored is OUTPUT RECORD NUMBER 7.
• ERROR CODE specifies one of two error codes:
  • RLS—Identifies a row-level security violation on a STORE operation. This code occurs if you do not have authority to store rows that have a particular key value or values.
  • 1205—Identifies a CA IDMS/DB error-status code. This code indicates that the row to be stored contains a duplicate key. This code occurs when CA Culprit attempts to store a row in a table for which duplicate keys are not allowed.

Storage Violations

The following report shows an example of the message and the record layout, when storage violations occur:

mm/dd/yy                 RUN TIME MESSAGES       volser Vnn.n  PAGE     1


   C760001 THE FOLLOWING ROWS WERE NOT STORED DUE TO STORAGE VIOLATIONS:

    OUTPUT                 R E C O R D    L A Y O U T
    RECORD   ERROR
    NUMBER   CODE

          1  1205      CHAR      BOSTON
                       ZONE   000CDEEDD44444444444  ◄--------- CA Culprit does not store this row
                       DIGIT  01C26236500000000000             because it contains a duplicate key.
                             01...5...10....5...20

          2  1205      CHAR      CHICAGO
                       ZONE   000CCCCCCD4444444444
                       DIGIT  02C38931760000000000
                             01...5...10....5...20


       DATA TABLE UPDATE STATISTICS
                                                                                ROWS       STORAGE
       REPORT     FUNCTION         LR-NAME                                     STORED      VIOLATIONS
       ------     --------         -------                                     ------      ----------
         01        ADD        TEST1205                                             2              2