Database Tasks are available to SEND Explorer Plus and Warehouse users with permission level of administrator. They are a collection of various database procedures that can be executed from the interface and cover a range of administrative tasks including study archiving, load queue management, study deletion, refreshing audit and override tables and more. Custom database tasks can also be created to support specific customer needs.
Access Database Tasks by clicking on the Admin link next to the user name in the top right corner of SEND Explorer and then selecting the Database Tasks button. Database tasks should be run only after consultation with Certara support staff on their purpose and impact.
The list of the common available tasks is displayed in the table below. From the interface, click on the arrow in front of each task name to execute it or to see more information about the task, including input parameters and format.
Task Name | Description | Input Parameters |
Archive by Date | Archives SEND 3.x XPT studies with a last uploaded date <= to the specified date
DS_STUDY and DS_TRIAL_SUMMARY records are not archived so study metadata remains available in the Dashboard
The load status for these studies is 'Archived' in the Dashboard
Primary key and foreign key IDs are retained
Studies are archived one at a time. A record is added to the Load History Detail for each study. | i_user - John.Q.Public@company.com Auto-filled based on login
i_date - DD-MON-YY Studies with last uploaded date <= will be archived
i_exclude_study - INDS02|INDS03|INDS04 Pipe-delimited list of studies not to archive based on the specified date |
Archive by Study | Moves specified SEND 3.x XPT study to the archive
DS_STUDY and DS_TRIAL_SUMMARY records are not archived so study metadata remains available in the Dashboard
The load status for these studies is 'Archived' in the Dashboard
Primary key and foreign key IDs are retained
Studies are archived one at a time. A record is added to the Load History Detail for each study. | i_user - John.Q.Public@company.com Auto-filled based on login
i_studyid - INDS1234 |
Unarchive by Study | Moves specified SEND 3.X XPT study from the archive to the Data Store. The Mart Workflow must be run to complete the process. | i_user - John.Q.Public@company.com Auto-filled based on login
i_studyid - INDS1234 |
Clear Load Queue | Removes all studies from the Load Queue, resetting the load indicator flags to N in WH_STUDY_SUMMARY and WH_STUDY_DETAIL | i_user - John.Q.Public@company.com Auto-filled based on login |
Clear Load Status | Changes the Load Status to "Status Cleared" for a load that has stopped running
This should only be run if the most recent Load has failed to complete properly and the Clear Load Status button is not visible on the Load Schedule page
If another Load is started and the current Load is still running, the data may be corrupted | i_user - John.Q.Public@company.com Auto-filled based on login |
Delete PRS Study | Deletes an orphaned study from the persistent stage (PRS) tables
Studies can be orphaned if there is a problem during the upload or loading process
This should only be run if the study cannot be deleted via the dashboard | i_study - INDS1234 |
Delete SEND Study | Deletes an orphaned study from the SEND tables
Studies can be orphaned if there is a problem during the upload or loading process
This should only be run if the study cannot be deleted via the dashboard | i_study - INDS1234 |
Drop Back-up Tables | Drops back-ups of objects modified during database version updates
This procedure should be run only after a successful update | i_user - John.Q.Public@company.com Auto-filled based on login |
Load MRT | Allows complete refresh of MRT_FINDING table or refresh of specific studies
During a normal load cycle the refresh type is CDC | i_user - John.Q.Public@company.com Auto-filled based on login
i_license - WH or GOLD
i_refresh_type - CDC, COMPLETE, or STUDY
i_fetch_size - number of studies to process at one time for COMPLETE refresh. Set to 0 for CDC or STUDY
i_study_list - INDS02|INDS03|INDS04 Pipe-delimited list of studies to refresh. Set to NULL for CDC or COMPLETE |
Refresh Override Tables | Refresh tables used for overrides. Must be run prior to overrides for timepoint or finding records
Refreshes DS_TIMEPOINT_OVRD and DS_FINDING_OVRD in that order due to dependencies | i_user - John.Q.Public@company.com Auto-filled based on login |
Truncate Mart Tables | Truncates all tables with the MRT prefix | i_user - John.Q.Public@company.com Auto-filled based on login |
Clear Archive Status | Truncates the WH_ARCHIVE_STATUS table in the event of a timeout
This should only be run if all archive processes fail with "There is already an archive process running" error
If another archive process is started and the current one is still running, the data may be corrupted | i_user - John.Q.Public@company.com Auto-filled based on login |
Archive History Tables | Archives History table records with a creation date <= to the specified date
Records from the WH_LOAD_HISTORY, WH_LOAD_HISTORY_DETAIL, WH_LOAD_QUEUE_HISTORY, and WH_LOAD_STUDY_HISTORY tables will be archived | i_user - Auto-filled based on login
i_date - DD-MON-YY Records with created date <= will be archived |
Refresh Audit Tables | Refreshes Data Store Audit tables | i_user - Auto-filled based on login |