all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||||||||
|
|
|
Blue
|
|
|
Sorry, no photos available for this element of time.
|
|
|
|
Notes:
|
|
We got a number of calls that the data 0 server was having problems with invoices. We shut it down and so did Newtek. It was struggling for awhile and we finally found that it was a locked table that was dishing out duplicate primary keys. Basically, it seems like the database was part-way through a transaction and recorded a key auto increment id in one place but not in another. Then when it came back up, it was tripping on it self. This little hiccup was on the customer_history table. That table shutdown all quoting, all invoicing, all assignments for element of time, all add/edits of customer info, all add/edits for customer logs, and all add/edits for additional customer contacts. It effected ecommerce, reoccurring invoicing, etc. Pretty pivotal. We got everything all fixed and back up but it was pretty crazy and intense. As a side note, we may want to go in and wrap that section with its own try/catch stuff so that if an error occurs, it just softly floats over that section without causing an error. That could be good and bad. Anyways, just making a note. We ended up resetting the auto increment id number and then re-pushed up new code. We recorded notes and let our developer team know what was going on. |