Database Server and Application Server Related Issues


The following table lists possible issues related to the database server and the Application Server, along with their causes and possible solutions.


Issue

Cause/Solution

I cannot start the Application Server from the Server Tray.

To start the Application Server, the Server Tray application must be started under an administrator account.

There are too many records in the database.

Use the automatic or manual database cleanup feature to remove old records from the database.

I have defined a new database. What happened to the old one?

The old database remains in place and is not changed.

I need to create a non-default SQL database user whose account will be used by the Ekran System Application Server to work with the database.

Make sure the “dbcreator” and “public” roles are granted to the SQL Server user whose account will be used by the Ekran System Application Server to work with the database. The “User must change password at next login” checkbox must be cleared.

I need to transfer the data from the existing database to a new one.

For the new database, you need to restore the database from a backup copy (i.e. from the existing database).

I want to change the type of the database without losing any data.

Unfortunately, data cannot be transferred from one database type to another.

I want to transfer the SQL database to another computer.

Unfortunately, it is not possible to relocate the SQL database to another computer, although you can move it to another location on the same machine where the SQL Server is running.

I have installed a new version of the Application Server, but I want to use the old database.

If you have updated the Application Server, your existing database will remain in place. If you reinstall the Application Server, you need to make sure that you select the option to use your old database when prompted, while reinstalling.

I have accidentally removed the database from the MS SQL Server.

You need to restore the database from a backup copy. If you do not have a backup, you will need to define a new database while reinstalling the Application Server.

I cannot shrink the database transaction log: the Shrink Transaction Log button is absent in the Management Tool (on the Configuration page, on the Database Management tab).

Shrinking is only possible for the MS SQL Server database; this function is not supported by the PostgreSQL Server database.

NOTE: Shrinking cannot be performed while a cleanup operation is in progress.

My anti-virus blocks uninstallation/update of the Application Server.

Due to the specifics of the uninstaller, some anti-viruses might detect it as a false positive during a virus scan. It is therefore recommended that you disable your anti-virus during uninstallation/update of the Application Server.