Solutions
...
Litmus Production Record Datab...
Interacting with Litmus Produc...
Rerunning a failed Transaction
7 min
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 155,141,239,219,133,114 false true false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type 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