PH35312: A CERTAIN CALL STATEMENT GIVES COBOL BUILD ERROR [1075] : FAILED TO INSERT INTO REPOSITORY DATA FOR THE CURRENT PROGRAM

APAR status

• Closed as program error.

Error description

• A DAL CALL statement in the customer code gives COBOL build
  "Error [1075] : Failed to insert into repository data for the
  current program."
  CALL  'EDBM0000'  USING  BTRN-P01
                           BTRN-P02
                           BTRN-P03
                           BTRN-P04.
  When this is commented, the error doesn't occur. This coding
  itself is no problem as similar coding appears repeatedly in the
  same program.
  The error seems related to "Violation of UNIQUE KEY constraint
  'UniqueConstraintResources'. Cannot insert duplicate key in
  object 'dbo.Resources'. The duplicate key value is (195, )."
  

Local fix

• N/A
  

Problem summary

• Build Client - Failed to insert into repository, data for the
  current program, due to "Violation of UNIQUE KEY constraint
  'UniqueConstraintResources'" -     'Resources' database table.
  

Problem conclusion

• It happens because some parameters(as in the case of a DAL call)
   cannot be resolved to a valid value and in this case they are
  assigned either with an empty string("") or with 4 spaces("
  "). Sql Server considers these two values to be equal, thus the
  "Violation of UNIQUE KEY constraint..". Fixed with code change,
  assigning only empty string value ("") to parameters that cannot
   be resolved.
  

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:

Fix information

• Fixed component name

  APPL DISCOVERY

• Fixed component ID

  5737B1600

Applicable component levels