TimeTrex not starting up

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
rjandreski
Posts: 23
Joined: Fri Oct 03, 2014 10:52 am

TimeTrex not starting up

Post by rjandreski » Mon Dec 03, 2018 7:06 am

When any user attempts to start up TimeTrex this morning, it redirects to http://timeclock:8085/html5/DownForMain ... on=DBError

I restarted the server and same result. Everything was working fine on Friday.

I did notice that the server was extremely low on hard drive storage so I freed up some space.

Need help resolving this. Any recommendations would be greatly appreciated.

I also do have our backup that was created with Acronis Backup that we use from Saturday morning that I can use to restore from. Thank you.

rjandreski
Posts: 23
Joined: Fri Oct 03, 2014 10:52 am

Re: TimeTrex not starting up

Post by rjandreski » Mon Dec 03, 2018 7:32 am

The closest resolution that I found that had the "DownForMaintenance.php?exception=DBError" was from 2008 which is now 10 years old so I'm not confident that this resolution will help me. viewtopic.php?f=2&t=729&p=3445&hilit=Do ... rror#p3445

Please let me know what I need to do to resolve this.

Our most recent database files in the C:\TimeTrex folder are as follows:

timetrex_database_20181202.sql - 1 KB

timetrex_database_20181201.sql - 4,590 KB

timetrex_database_20181130.sql - 4,583 KB

rjandreski
Posts: 23
Joined: Fri Oct 03, 2014 10:52 am

Re: TimeTrex not starting up

Post by rjandreski » Mon Dec 03, 2018 7:54 am

I attempted to restore_database and got the following:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\system32>cd\timetrex

C:\TimeTrex>restore_database.bat timetrex_database_20181201.sql

Attempting to restore SQL dump file: timetrex_database_20181201.sql...


-----WARNING-----WARNING-----WARNING-----WARNING-----

RESTORING THIS FILE WILL COMPLETELY OVERWRITE ALL EXISTING DATA...

ARE YOU SURE YOU WANT TO DO THIS?

-----WARNING-----WARNING-----WARNING-----WARNING-----

Press any key to continue . . .

NO REALLY, ALL EXISTING DATA WILL BE DELETED.

ARE YOU REALLY SURE YOU WANT TO DO THIS?

Press any key to continue . . .
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7; 2615 2200 SCHEMA public post
gres
pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" alr
eady exists
Command was: CREATE SCHEMA public;



WARNING: errors ignored on restore: 1
Done.


Still gives me the same error. Please help.

mikeb
Posts: 442
Joined: Thu Jul 27, 2006 11:58 am

Re: TimeTrex not starting up

Post by mikeb » Mon Dec 03, 2018 9:02 am

Please attach a copy of TimeTrex log file (c:\timetrex\timetrex\log) here from, it should contain the exact error message.

rjandreski
Posts: 23
Joined: Fri Oct 03, 2014 10:52 am

Re: TimeTrex not starting up

Post by rjandreski » Mon Dec 03, 2018 9:04 am

I've restore from Acronis backup before the issue began. Everything is working fine at this time.

Post Reply