![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2011\/06\/opalis_purge01.jpg\" "\\"opalis_purge01\\"")
<\/a><\/p>\nThe purge feature will purge data from following three tables in the Opalis database<\/p>\n
- \n
- Policyinstances<\/li>\n
- Objectinstances<\/li>\n
- Objectinstancedata<\/li>\n<\/ul>\n
When working with the Opalis Integration Server Client you can review historical data in a couple of places<\/p>\n
- \n
- The log tab, show you running policy instances<\/li>\n
- The log history tab, will show you information on policy instances that have completed<\/li>\n
- The Audit History tab will show changes made to a policy grouped by each time you click \u00e2\u20ac\u0153check\u00e2\u20ac\u201din\u00e2\u20ac\u009d<\/li>\n
- The Events tab will show you events from Opalis, for example if you use the Send Platform Event activity within a policy<\/li>\n<\/ul>\n
Both the Log tab and the Log History tab show you data from these three tables.<\/p>\n
![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2011\/06\/opalis_purge02-300x251.jpg\" "\\"opalis_purge02\\"")
<\/a><\/p>\nBoth views, Log and Log History, show selected data from the POLCIINSTANCES table. When you click on a log entry, data for the objects in that policy instance are shown from the OBJECTINSTANCES table. When selecting an object, data for that object is read from the OBJECTINSTANCEDATA table.<\/p>\n
![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2011\/06\/opalis_purge03-300x89.jpg\" "\\"opalis_purge03\\"")
<\/a><\/p>\n![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2011\/06\/opalis_purge04-300x222.jpg\" "\\"opalis_purge04\\"")
<\/a><\/p>\n![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2011\/06\/opalis_purge05-300x221.jpg\" "\\"opalis_purge05\\"")
<\/a><\/p>\nThe following query can be used to list Policy ID, Policy Name, SeqNumber, Action Server and Number of Instances. The Number of Instances is the indicator how often the Action Server executed the policy since the last log purge. This query is very helpful to see what policy is filling up your tables with historical data.
\nSELECT
\n[p].[UniqueID] AS [Policy ID],
\n[p].[Name] AS [Policy Name],
\n[prq].[SeqNumber],
\n[a].[Computer] AS [Action Server],
\nCOUNT([pi].[UniqueID]) AS [Number Of Instances]
\nFROM [POLICY_REQUEST_HISTORY] AS prq
\nINNER JOIN [POLICIES] AS p ON [prq].[PolicyID] = [p].[UniqueID]
\nINNER JOIN [POLICYINSTANCES] AS [pi] ON [prq].[SeqNumber] = [pi].[SeqNumber]
\nINNER JOIN [ACTIONSERVERS] AS a ON [pi].[ActionServer] = [a].[UniqueID]
\nWHERE
\n[prq].[Active] = 1 AND
\n[pi].[TimeEnded] IS NOT NULL
\nGROUP BY
\n[p].[UniqueID],
\n[p].[Name],
\n[prq].[SeqNumber],
\n[a].[Computer]
\nORDER BY
\n[Number Of Instances] DESC<\/code><\/p>\n![\"\"](\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2011\/06\/opalis_purge06-300x226.jpg\" "\\"opalis_purge06\\"")
<\/a><\/p>\nRegarding backup of the Opalis database I have seen a couple of different solutions. The first solution is to export all policies and global settings. This will give you a simple way to restore, re-import the export files. You can do a quick re-install of the Opalis environment and import the files in case of a disaster. You can include the export part in your change management process; before you import a new policy into Opalis you also make a backup copy.<\/p>\n
The second solution is to do a backup of the database; an advantage with this solution is that you keep all the historical data. But if you restore the database from a backup when there were policies running, you can run into some problem with state data. But you could execute the sp_StopAllRequests stored procedure to clear out any active requests and instances that aren\u00e2\u20ac\u2122t desired. The restore process gets a little bit more complicated with the second solution.<\/p>\n
With the first backup solution I recommend you, and that is a general recommendation, to keep state data\/historical data in an external data store. For example we could use Service Manager to track what is happening. Opalis executes and Service Manager remembers. As soon as Opalis is done, it will drop everything, it only keeps it in memory during execution (and maybe some logs). Working with Service Manager will give us a great way to track everything. It could of course be any system that we can integrate with, for example an extra SQL database.<\/p>\n
Thanks to my colleague Robert Riedmaier for sharing his deep knowledge around Opalis log purge, backup and database maintenance. Thanks Robert!<\/p>\n","protected":false},"excerpt":{"rendered":"
If your Opalis database is filled up with log entries the console performance will be affected. Navigating between folders in the console, viewing workflows or console \u00e2\u20ac\u0153hangs\u00e2\u20ac\u009d in general can be a result of to much log data in the database.By default the log purging feature is not enable in Opalis. The result of that … Continue reading