Can't administer stations in Datacap after upgrade

The sta_LoginTime and sta_LogoutTime may have NULL values and date fields of undisclosed format.  This can cause TMweb to hang, when adding a station.  It may be due to incorrect/improper/corrupt date entries in the columns sta_loginTime and sta_logoutTime of the Station table in the Admin database.

Try adding a current date with a date format similar to this one, to all the stations in columns sta_loginTime and sta_logoutTime: 2015-01-01 01:00:00.000   If your DBA would prefer, in order to populate the sta_loginTime and sta_logoutTime columns, perhaps he/she can try running a script similar to this one: UPDATE station SET sta_loginTime = '2015-01-01 01:00:00.000' WHERE sta_loginTime < '2005-01-01'; UPDATE station SET sta_logoutTime = '2015-01-01 01:00:00.000' WHERE sta_logoutTime < '2005-01-01';   In either case, the point is to make columns sta_loginTime and sta_logoutTime have a proper and current date format, whether you do that manually or via SQL script.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk