The Database
- Emma Paton (Unlicensed)
Remote Sampler uses another CSols product called Labcache to store all application data, static data and configuration data. Labcache is a SQL Server database and is accessed by all CSols services and the Remote Sampler Hub application.
For the most part, the tables in the database will be of little interest to you as a support user but there are some exceptions that are described in the table below.
Table Name | Contents |
LcFailover | Holds entries that define which application server is currently live. Changes will need to be made to this table whenever the Remote Sampler system is failed over from one application server to another. |
LcMediatorConfiguration | Holds configuration information for each of the mediator services that are installed across all application servers. |
LcPdas | Holds configuration information for each of the handheld devices that are connected to the system. |
LcRsAdaptorConfiguration | Contains configuration information for each of the Adaptor services that are installed across all application servers. |
LcRsCommsService | Contains configuration information for each of the RsComms service instances that are installed across all application servers. |
LcRsRunSynchronization | Contains a list of all the collection runs that have been successfully extracted from LIMS. |
Warning