Handling data errors
View Patent ↗An approach is disclosed that corrects database replication errors. The approach runs a replication tool that replicates a source database of a source database type to a target database of a target database type. When a replication error is encountered that cannot be resolved by the replication tool, the approach matches the replication error to a business logic recovery rule that is selected from a set of business logic recovery rules that are external to the replication tool. The matching business logic recovery rule is applied to the replication error to correct the replication error.
1 . A method comprising:
running a replication tool that replicates a source database of a source database type to a target database of a target database type; and
in response to encountering a replication error that cannot be resolved by the replication tool:
matching the replication error to a business logic recovery rule selected from a plurality of business logic recovery rules, wherein the plurality of business logic recovery rules are stored in a business logic recovery rules data store that is external to the replication tool; and
applying the business logic recovery rule to the replication error, wherein the applying of the business logic recovery rule corrects the replication error.
2 . The method of claim 1 , wherein the running of the replication tool is halted when the replication error is encountered, the method further comprising:
resuming the running of the replication tool at a point in the replication where the replication error was encountered.
3 . The method of claim 1 , further comprising:
in response to failing to match the replication error to one of the plurality of business logic recovery rules:
receiving the business logic recovery rule from a user of the replication tool; and
writing the business logic recovery rule to the plurality of business logic recovery rules.
4 . The method of claim 1 , further comprising:
determining one or more data points in the replication of the source database to the target database where replication may fail; and
writing one or more of the plurality of business logic recovery rules.
5 . The method of claim 1 , wherein the plurality of business logic recovery rules are written in a human-readable data-serialization language.
6 . The method of claim 5 , wherein the plurality of business logic recovery rules include a rule name, an error identifier, an applicable range, an error type, and a resolution policy.
7 . The method of claim 1 , further comprising:
injecting the plurality of business logic recovery rules into a set of native replication tool recovery resolutions.
8 . An information handling system comprising:
a processor set;
one or more computer readable storage media; and
program instructions stored on the one or more computer readable storage media to cause the processor set to perform operations comprising:
running a replication tool that replicates a source database of a source database type to a target database of a target database type; and
in response to encountering a replication error that cannot be resolved by the replication tool:
matching the replication error to a business logic recovery rule selected from a plurality of business logic recovery rules, wherein the plurality of business logic recovery rules are stored in a business logic recovery rules data store that is external to the replication tool; and
applying the business logic recovery rule to the replication error, wherein the applying of the business logic recovery rule corrects the replication error.
9 . The information handling system of claim 8 , wherein the running of the replication tool is halted when the replication error is encountered comprises:
resuming the running of the replication tool at a point in the replication where the replication error was encountered.
10 . The information handling system of claim 8 , wherein the operations further comprise:
in response to failing to match the replication error to one of the plurality of business logic recovery rules:
receiving the business logic recovery rule from a user of the replication tool; and
writing the business logic recovery rule to the plurality of business logic recovery rules.
11 . The information handling system of claim 8 , wherein the operations further comprise:
determining one or more data points in the replication of the source database to the target database where replication may fail; and
writing one or more of the plurality of business logic recovery rules.
12 . The information handling system of claim 8 , wherein the plurality of business logic recovery rules are written in a human-readable data-serialization language.
13 . The information handling system of claim 12 , wherein the plurality of business logic recovery rules include a rule name, an error identifier, an applicable range, an error type, and a resolution policy.
14 . The information handling system of claim 8 , wherein the operations further comprise:
injecting the plurality of business logic recovery rules into a set of native replication tool recovery resolutions.
15 . A computer program product comprising:
one or more computer readable storage media; and
program instructions stored on the one or more computer readable storage media to perform operations comprising:
running a replication tool that replicates a source database of a source database type to a target database of a target database type; and
in response to encountering a replication error that cannot be resolved by the replication tool:
matching the replication error to a business logic recovery rule selected from a plurality of business logic recovery rules, wherein the plurality of business logic recovery rules are stored in a business logic recovery rules data store that is external to the replication tool; and
applying the business logic recovery rule to the replication error, wherein the applying of the business logic recovery rule corrects the replication error.
16 . The computer program product of claim 15 , wherein the running of the replication tool is halted when the replication error is encountered comprises:
resuming the running of the replication tool at a point in the replication where the replication error was encountered.
17 . The computer program product of claim 15 , wherein the operations further comprise:
in response to failing to match the replication error to one of the plurality of business logic recovery rules:
receiving the business logic recovery rule from a user of the replication tool; and
writing the business logic recovery rule to the plurality of business logic recovery rules.
18 . The computer program product of claim 15 , wherein the operations further comprise:
determining one or more data points in the replication of the source database to the target database where replication may fail; and
writing one or more of the plurality of business logic recovery rules.
19 . The computer program product of claim 15 , wherein the plurality of business logic recovery rules are written in a human-readable data-serialization language.
20 . The computer program product of claim 19 , wherein the plurality of business logic recovery rules include a rule name, an error identifier, an applicable range, an error type, and a resolution policy.