Gradience Pro / Enterprise - Database Maintenance

Database Maintenance

Resolve minor errors/performance issues and clear out possible database corruption that can adversely affect software performance.

Note:  This can only be run while physically at the computer where the database resides. You may encounter difficulty trying to run this through a remote tool like RDP. You may however, be successful if you remote directly into the console. Also,  if your HRWARE.INI path= is pointing to the IP address of the server you will need to temporarily change it to localhost as shown below. The HRWARE.INI file can be found in C:\Windows in Windows XP/Windows Server 2003 or C:\programdata\gradience in Windows 7/Windows Server 2008

 pic1.JPG

When should it be run? 

Run it any time that the program performs oddly.   If you perform a routine task but get unusual results you may have database corruption.

Why should it be run?

Run this utility to remove database corruption.  A database can become corrupt a number of ways.

One way the database can become corrupt is through an electrical interruption.  We recommend that any workstation running the software be connected to a UPS. (Uninterrupted Power Supply)   An inexpensive UPS will give you enough time to close programs and shut down the computer properly after a power failure.

Another cause of database corruption is when someone who is running a Gradience program or Gradience TimeStation that has been minimized, turns off the computer without first closing the program or the TimeStation.

How is it run?

Running the Database Maintenance Utility

Do this from the desktop of the computer/server where the database resides.

1. Have all users at client workstations, close Gradience (not minimize)

2. Click Start

 

3.Click the Start button that appears on the Database Maintenance popup.

4. Click File > Exit when done. Ignore any Runtime error you may get.

Is there a way to automatically run the DB Maintenance?

Yes, if you add a parameter to the shortcut and then write a script or batch file that calls the shortcut for DBMaint.exe. You would add the parameter (AUTO) to the end of the Target line (Create a shortcut for DBMaint.exe, then right click the shortcut and go to Properties. Add "AUTO" to the end of the Target line, such as:

TARGET: C:\Program Files\Gradience\Utilities\DBMaint.exe "AUTO"

 

Now, when you run the Database Maintenance from the shortcut, it will automatically start the maintenance process.

Note: Adding AUTO-d will purge deleted employees and will permanently delete employees from the database.

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.