Difference between revisions of "Maintenance"

From PresenceWiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
Firstly, be sure to upgrade to the latest version of Presence. Please [mailto:support@international-presence.com contact us] to obtain the URL for the current version.
 
Firstly, be sure to upgrade to the latest version of Presence. Please [mailto:support@international-presence.com contact us] to obtain the URL for the current version.
  
http://www.international-presence.com/images/bestuse/download.png  
+
[[file:download.png]]
  
 
It's always a good idea to have the latest version for the latest improvements (such as improved logging and load balancing) as well as making support simpler.
 
It's always a good idea to have the latest version for the latest improvements (such as improved logging and load balancing) as well as making support simpler.
Line 7: Line 7:
 
The changes.txt file located in the Presence directory will let you know what has changed between versions:-
 
The changes.txt file located in the Presence directory will let you know what has changed between versions:-
  
http://www.international-presence.com/images/bestuse/changes.png
+
[[file:changes.png]]
  
In the Presence Bin directory on the machine where the database server is located you will find the sqltool.exe and databasecompactor.exe applications.
+
In the Presence Bin directory on the machine where the database server is located you will find the sqltool.exe and databasecompactor.exe applications. The databasecompactor.exe is only valid for Presence Version 3.x
  
 
These can be used to manage and compact the database respectively.
 
These can be used to manage and compact the database respectively.
  
http://www.international-presence.com/images/bestuse/bindirectory.png
+
[[file:bindirectory.png]]
  
 
To free up space in the database, run the sqltool.exe and perform a  
 
To free up space in the database, run the sqltool.exe and perform a  
Line 23: Line 23:
 
'Truncate Table app.activityarchivehistory'
 
'Truncate Table app.activityarchivehistory'
  
http://www.international-presence.com/images/bestuse/truncate.png
+
[[file:truncate.png]]
  
 
These tables store information about which Tasks and Task elements ran successfully or failed.
 
These tables store information about which Tasks and Task elements ran successfully or failed.
Line 31: Line 31:
 
Over time the database will expand as it is used. The database compactor enables you to straight forwardly, backup, unload and reload the database (thus compacting it).
 
Over time the database will expand as it is used. The database compactor enables you to straight forwardly, backup, unload and reload the database (thus compacting it).
  
http://www.international-presence.com/images/bestuse/databasecompactor.png
+
[[file:databasecompactor.png]]

Latest revision as of 10:37, 21 August 2015

Firstly, be sure to upgrade to the latest version of Presence. Please contact us to obtain the URL for the current version.

Download.png

It's always a good idea to have the latest version for the latest improvements (such as improved logging and load balancing) as well as making support simpler.

The changes.txt file located in the Presence directory will let you know what has changed between versions:-

Changes.png

In the Presence Bin directory on the machine where the database server is located you will find the sqltool.exe and databasecompactor.exe applications. The databasecompactor.exe is only valid for Presence Version 3.x

These can be used to manage and compact the database respectively.

Bindirectory.png

To free up space in the database, run the sqltool.exe and perform a

'Truncate Table app.activityarchive'

as well as a

'Truncate Table app.activityarchivehistory'

Truncate.png

These tables store information about which Tasks and Task elements ran successfully or failed.

Regular database compaction using the databasecompactor.exe tool.

Over time the database will expand as it is used. The database compactor enables you to straight forwardly, backup, unload and reload the database (thus compacting it).

Databasecompactor.png