Data Mart tables are not getting updated.

Chemical and Biological registration users might sometimes be interested in setting up the Data Mart so that they can more easily view the data in a database using standard relational database tools. A GEMS data mart creates a set of tables, and views on those tables, which resemble a traditional database schema and users can use generic database SQL tools to inspect and query these tables.

Update of the data mart tables is handled by a scheduled job that periodically runs the GEMS Data Mart Update Wrapper protocol. This will create or re-create the data mart tables as appropriate if the metadata has changed, i.e., update the data mart tables to reflect any entities which have been created, updated or retired since the last time the protocol was run.

This protocol will run at the expected time interval, but sometimes it will fail to update the data mart tables and this failure can happen silently without any error or warning. Only a direct inspection of the data mart tables will show the missing new/edited data. If this happens, the first thing the users can check is the scheduled job server value in EMS_PARAMETER table. Please make sure that it is correct and also does not have any domain information; it should simply appear as :. Users can also check this by logging into the GEMS Metadata Editor > Admin > Parameters, Select the proper Registration data source, and look at the Scheduled Job Server parameter value.

Users can also check the 'SSL Security Level' in PP Admin portal > Setup > Server Configuration> SSL/TLS Security Level. They can try changing it to Intermediate (lower level) if it is set to a different value, save the change, restart PP services, and then check the running of this scheduled task.

If both these settings are correct in their ChemReg or BioReg environment, but the problem persists, users are advised to contact BIOVIA Support for further troubleshooting and suggestions to resolve this problem.