Introduction
-
SQL Server Audit for Surveys
This option enables SQL Server auditing at the survey database level. Refer to the Forsta Administrator documentation for details on how to turn it on. When ...
-
SQL Query for Monitoring Errors from Web Services
The following query may be used to report on the amount of errors recently generated from XML Web Services:select count(id) as countfrom [confirmlog]..[webse...
-
SQL Query for Monitoring REST API Server Errors
The REST API servers are the backbone of a lot of the services in Forsta Plus. The logs are IIS based, meaning that all errors in the 500 range are server er...
-
SQL Query for Monitoring Errors from Reportal
The following query may be used to report on the number of errors recently generated from Reportal:select count(id) as countfrom [confirmlog]..[reportalmonit...
-
SQL Query for Monitoring Failing Launch Survey Tasks
If users are unable to launch new or updated surveys, the production status of the system is pretty much at a standstill. The query below will return the num...
-
SQL Query for Monitoring Delays in Task Queue Execution
The following SQL statement returns the number of tasks in queue that are delayed by more than ten minutes:Select count(id) as QueuedTasksfrom [confirm].dbo....
-
SQL Query for Monitoring Errors from Authoring
Similar to monitoring errors from surveys, the following query may be used to report on the number of errors recently generated by Authoring:select count (id...
-
SQL Query for Monitoring the Number of Attached Survey Databases
Forsta Plus installations with many active surveys should utilize the automatic survey database detachment/attachment feature. It is also recommended to moni...
-
Using BitStream Performance Counters
The Forsta BitStream service contains several performance counters which can be utilized to troubleshoot BitStream issues. The following performance counters...
-
Database System Redundancy
To ensure the system is robust, redundancy should be built in. The sub-topics linked below describe an example of the setup.
-
Searching and Indexing History Cleanup
Figure 1 - The Searching and Indexing History Cleanup overlayThe ...history cleanup task removes old entries in the ConfirmitSearch database. The Days to exp...
-
NodeStore Cleanup Task
The NodeStorecleanup task will remove all data for the configured “resource collection names”, that is older than the “expiry days” setting configured in the...
-
Cleanup
Hub CleaningHub Cleanup can be performed periodically to permanently remove deleted hubs, sources and related objects from SmartHub. When a hub is deleted fr...
-
DocumentStore Cleanup Task
The DocumentStore cleanup task will delete all document versions that are marked as expired. Version expiration is set based on the system configuration sett...
-
Deleting Survey Test Databases
Administrators may also notice that survey test databases expand over time, and after a while can take up quite a lot of space on the server. To keep the num...
-
Clearing Contents of Log Tables
The databases [confirm] and [confirmlog] contain task history and survey response history tables respectively. On a busy system, these databases will quickly...
-
Automatic Detachment of Inactive Hub Databases
In the System Configuration > Hub section, there is a setting called MinutesIdleTimeBeforeDetachingHubDatabase that is used by the Hub Cleanup task to determ...
-
Software Deployment Infrastructure
This is a connectivity diagram of the Octopus Server infrastructure.Figure 1 - Diagram of Octopus infrastructure and required external connectionsThe Forsta ...
-
Security in Octopus Deploy
In Octopus Deploy, as is the case with Forsta Plus, an application security review by an independent party is performed regularly, at a minimum on major rele...
-
New Application Structure
Forsta Plus will be made available via NuGet feeds, containing versioned NuGet packages, rather in one large MSI installer. The Octopus Server will have the ...
-
Introduction
This documentation is intended as guide for preparing, installing and maintaining a Forsta Plus server environment. The content of the document is written fr...