Rerunning a failed Transaction

note this feature requires litmus production record database v 1 4 0 0 or higher use cases litmus production record database is processing incoming data for tags, production events and digital twin through asynchronous processing if such a process fails, this transaction is stored in the table prorec at servicebroker failed transaction they will be kept there for the same amount of time as log data (by default = 24hours) in the case a transaction failed, users can investigate the transaction using log tables like the tables prorec error log , prorec misc log , prorec prorec log and prorec tag log once the root cause has been identified, users can fix the issue and rerun the transaction method execute stored procedure prorec misc rerun at transactions input variables variable name datatype description example @action integer a numeric representation of a specific action which can be performed possible values 1 = show all entries in the table prorec at servicebroker failed transaction 2 = show the entry for a specific entry id from the table prorec at servicebroker failed transaction 3 = breakdown of the xml object of an entry in the table prorec at servicebroker failed transaction this provides a tabled representation of the xml data 4 = fix / update a value for any of the keys "arrived at","device id","register id","tag name","datatype","value","success" in the xml object for a specific record uuid 5 = rerun a specific transaction mandatory! can not be null or empty 1 @id bigint the entry id of a row in table prorec at servicebroker failed transaction can not be null for the actions 2,3,4 or 5 null @recorduuid char(36) the record uuid of a specific entry of the xml object can not be null for action 4 null @columntochange varchar(50) the xml key to change allowed are "arrived at" "device id" "register id" "tag name" "datatype" "value" "success" can not be null for action 4 null @newvalue varchar(max) the new value for the xml key defined by columntochange can not be null for action 4 null how to use to investigate, fix and/or rerun a failed transaction logged in the table prorec at servicebroker failed transaction , call the stored procedure prorec misc rerun at transactions using the t sql exec or execute keyword and provide the input variables below is an example using t sql in sql server management studio read out all entries from the table prorec at servicebroker failed transaction execute \[le productionrecord] \[dbo] \[prorec misc rerun at transactions] @action = 1; result view a specific entry from the table prorec at servicebroker failed transaction execute \[le productionrecord] \[dbo] \[prorec misc rerun at transactions] @action = 2, @id = 12; result view a break down of the xml object for the entry execute \[le productionrecord] \[dbo] \[prorec misc rerun at transactions] @action = 3, @id = 12; result modify a value for an item in the xml object execute \[le productionrecord] \[dbo] \[prorec misc rerun at transactions] @action = 4, @id = 12, @recorduuid = 'e26cccac 513b 4e85 9990 26650f273bda', @columntochange = 'value', @newvalue = '18 3704'; result rerun a specific entry execute \[le productionrecord] \[dbo] \[prorec misc rerun at transactions] @action = 5, @identifier = 12; result