The majority of tables in the K2 database have both a Server and ServerLog schema version. Where people have put together views these tend to use the synonyms which in the vast majority of cases are for the ServerLog tables. The APIs from what I can see tend to use the Server tables or first write to Server then to ServerLog.
Although there are tables such as ProcInst in both schemas the columns in each table are not the same, there are common fields but also distinct fields in both sides.
Is there ever a reason to use Server tables directly?
Is there a chance that if the API uses Server and views use ServerLog the results will be inconsistent?
We certainly have different number of rows in Server.ProcInst and ServerLog.ProcInst although they are similar, is this expected.