Unable to delete large studies from Clinical cache in Connector for Medidata Rave

Problem:

User is uanble to delete large studies from Clinical cache in Connector for Medidata Rave.

Consider the following scenario:

1. In Spotfire Analyst go to Tool > Connector for Medidata Rave > Clinical Cache Manager.

2. Select a study and click Delete.

3. Deletion of study does not occur even after waiting for a long time.

Resolution:

The current implementation of Connector for Medidata Rave cannot delete very large studies from Clinical cache using GUI method. Follow the instructions below to delete such a study.

**The instruction below will fill up the transaction logs quickly. Please consider changing the Microsoft SQL Server recovery model to simple beforehand.

1. Start Microsoft SQL Server Management Studio and login using Clinical cache user (e.g. Analytics)

2. From the left pane, right click on Clinical cache database name > New Query

3. Run the following SQL. Examine the result to find out the value of Id of the study to be deleted.

select Id, URL, Name from dbo.DatabaseStudy;

4. Run the following SQL in order presented below.

delete StudyLock where StudyID in ('<Id of the study>');
delete DatabaseStudy where ID in ('<Id of the study>');
delete DatabasePage where StudyID in ('<Id of the study>');
delete AuditRecords where StudyID in ('<Id of the study>');