What is the table "tw_sli_detail_bypass" for? We had an error report from Ticketing with a duplicate key value (on the SPID). Closing Tessitura and reopening it fixed the issue. The one record in that table also was deleted when Tessitura closed.
I'm just looking for some context on this.
Tables prefixed 'TW_' are temporary work tables used to store data which is then moved to a permanent table later in the Order (or Contribution) process.
Sometimes, when web or imported orders are created, a spid_no/order_no combination is written to the TW_SLI_DETAIL_BYPASS table to let the system know that the process will be creating the sli_detail rows. Typically, those combinations are deleted when the order creation is complete.
Okay. Thanks!
So her instance of Tessitura didn't shut down cleanly or something. _shrug_