database connections timeout when left open for extended periods
Here are the log entries that lead up to the problem.
The root cause is that the webbrowser was left open during the weekend, causing automatic token refresh to keep alive the session for a weekend, causing a database connection to be left open for a weekend
[INFO] 3/2/17 19:02:13.443 [0m| L1CE listening at http://[::1]:8081
[INFO] 3/2/17 19:02:14.100 [0m| User Cms L1osw connected from ::ffff:10.176.138.52
[INFO] 4/2/17 09:30:43.129 [0m| User Cms L1osw disconnected from ::ffff:10.176.138.52
[INFO] 4/2/17 09:30:44.271 [0m| User Cms L1osw connected from ::ffff:10.176.138.52
[41m[37m [ERROR] 6/2/17 09:57:07.069 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-02396: exceeded maximum idle time, please connect again
[41m[37m [ERROR] 6/2/17 09:57:17.246 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-01012: not logged on
Process ID: 35276
Session ID: 2003 Serial number: 7663
[41m[37m [ERROR] 6/2/17 09:58:09.890 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-01012: not logged on
Process ID: 35276
Session ID: 2003 Serial number: 7663
[41m[37m [ERROR] 6/2/17 09:59:32.005 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-01012: not logged on
Process ID: 35276
Session ID: 2003 Serial number: 7663
[41m[37m [ERROR] 6/2/17 09:59:48.976 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-01012: not logged on
Process ID: 35276
Session ID: 2003 Serial number: 7663
[41m[37m [ERROR] 6/2/17 10:00:08.516 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-01012: not logged on
Process ID: 35276
Session ID: 2003 Serial number: 7663
[41m[37m [ERROR] 6/2/17 10:00:42.942 [39m[49m[41m[37m[0m| [39m[49mError while fetching table: Error while getting table owner: Error: ORA-01012: not logged on
Process ID: 35276
Session ID: 2003 Serial number: 7663
...