Repairing corrupted references

A computer system for repairing corrupt database references, the computer system comprising:

• one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage medium, and program instructions stored on at least one of the one or more tangible storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising:
• identifying, by a computer, one or more corrupt references within a database based on a diagnostic test, wherein the one or more corrupt references includes a reference with a broken connection between two or more data objects within the database, and wherein the one or more corrupt references have an associated reference corruption type that is determined based on a structure of a plurality of coding language used to build the database, and wherein the diagnostic test generates queries in structured query language (SQL) to detect tables within the database that store reference objects;
• determining, by the computer, a repair procedure using a backtracking algorithm, wherein the backtracking algorithm determines the repair procedure based on a user preconfigured priority list of repair procedures;
• and
• executing, by the computer, the repair procedure, wherein a list of preceding repairs to corrupt references is analyzed to ensure execution of the repair procedure does not affect any preceding repair of a corrupt reference, and wherein the execution of the repair procedure comprises generating SQL code to repair each detected corrupt reference in a text file.

A computer program product for repairing corrupt database references, the computer program product comprising:

• one or more computer-readable non-transitory tangible storage media and program instructions stored on at least one of the one or more non-transitory tangible storage media, the program instructions executable by a processor capable of performing a method, the method comprising:
• identifying, by a computer, one or more corrupt references within a database based on a diagnostic test, wherein the one or more corrupt references includes a reference with a broken connection between two or more data objects within the database, and wherein the one or more corrupt references have an associated reference corruption type that is determined based on a structure of a plurality of coding language used to build the database, and wherein the diagnostic test generates queries in structured query language (SQL) to detect tables within the database that store reference objects;
• determining, by the computer, a repair procedure using a backtracking algorithm, wherein the backtracking algorithm determines the repair procedure based on a user preconfigured priority list of repair procedures;
• and
• executing, by the computer, the repair procedure, wherein a list of preceding repairs to corrupt references is analyzed to ensure execution of the repair procedure does not affect any preceding repair of a corrupt reference, and wherein the execution of the repair procedure comprises generating SQL code to repair each detected corrupt reference in a text file.