What K2 SQL table is "Process Instance ID" stored in?

  • 3 January 2019
  • 1 reply
  • 54 views

15324i95CB25BE8718B64A.png

Hi all,

 

Within SQL Server, I'm trying to find out which schema and table K2 Studio refers to to grab the auto-incrementing Process Instance ID.

 

Background:

 

I need to find this because there have been occasions where I needed rollback the K2 database to the previous day's backup (due to unexplained DB corruption). Upon the rollback, the Process Instance ID value is also rolled back. This causes issues in our operations because old Process Instance ID values - which are already used in our other, non-corrupted database - reused in new records. Thus, we have multiple smartforms with the same Process Instance ID.

 

 


1 reply

Userlevel 5
Badge +16

Hi mitch,


 


Check the following tables


 


Server.ProcInst


ServerLog.ProcInst


 


The ID column is the Process Instance ID

Reply