Created by Salim Frontin, last modified by Alex Thottunkel on Jan 22, 2024

 

*Purpose

This page will help you solve problems related to the feature Remove Locks (Troubleshooting)

To access the option: 

  1. Select the database/schema you want to work with, then right-click
  2. Select Troubleshooting> Remove Locks from the contextual menu.

This feature enables you to:

  • Remove locks on a CAST schema.

For more information, refer to:

*Observed in CAST AIP
Release
Yes/No
8.3(tick)
*Observed on RDBMS
RDBMS
Yes/No
CSS (tick)
Action Plan

  1. When a user analyzes an application, a lock is set on the Local Base. In some circumstances, for example if the analysis is brutally aborted, then the lock can remain, preventing any action on the Local Base. In general, it is better to check with the other user whether their analysis is finished and that the lock is an accident, before using this feature. Else their analysis will be cancelled.

    When the Local Base is locked, you generally find the below error message in the CAST-MS.log, occurring during the Synchronization Step.

    CAST-MS.log.txt
    RR: 2018-10-25 13:44:58: Could not save Application "MY APP" in Analysis Service "l834_14541_dti"
 com.castsoftware.java.ExternalException:Could not save Application "MYAPP 13200" in Analysis Service "l834_14541_dti"
 com.castsoftware.pmc.actions.application.UpdateLocalDatabase.updateUserProject(UpdateLocalDatabase.java:286)
 com.castsoftware.pmc.actions.application.UpdateLocalDatabase.executeAtomic(UpdateLocalDatabase.java:141)
 com.castsoftware.pmc.actions.localservice.Synchronize.synchronizeUserProjects(Synchronize.java:318)
 com.castsoftware.pmc.actions.localservice.Synchronize.synchronizeDatabase(Synchronize.java:127)
 com.castsoftware.pmc.features.AutoSynchronizeServices.synchronizeDatabases(AutoSynchronizeServices.java:201)
 com.castsoftware.pmc.features.AutoSynchronizeServices.autoSynchronize(AutoSynchronizeServices.java:142)
 com.castsoftware.pmc.features.AutoSynchronizeServices.documentExecute(AutoSynchronizeServices.java:84)
 com.castsoftware.mda.impl.MemoryTask.execute(MemoryTask.java:86)
 com.castsoftware.java.treatment.Task.run(Task.java:377)
 com.castsoftware.java.treatment.Task.runChildren(Task.java:582)
 com.castsoftware.mda.impl.MemoryAction.execute(MemoryAction.java:272)
 com.castsoftware.pmc.actions.application.RunAnalysis.execute(RunAnalysis.java:492)
 com.castsoftware.mda.impl.MemoryAction.topExecute(MemoryAction.java:265)
 com.castsoftware.mda.impl.MemoryAction$MemoryActionTask.documentExecute(MemoryAction.java:383)
 com.castsoftware.mda.impl.MemoryTask.execute(MemoryTask.java:86)
 com.castsoftware.java.treatment.Task.run(Task.java:377)
 com.castsoftware.java.treatment.execution.TaskExecutor$TaskMainThread.run(TaskExecutor.java:103)
 java.lang.Thread.run(Unknown Source)
 UserProject NMYAPP 13200 already locked by DTI
 com.castsoftware.java.ExternalException:UserProject MY APP already locked by DTI

    First call the user that owns the lock (in this example it is DTI), and ask if DTI is using the Local Base for an analysis. If so, this is an Expected Behavior, and the lock will be removed once DTI's analysis is finished.

  2. If user DTI is not using the Local Base, then the lock is not expected and should be removed in order to unlock the schema for further use. Open Server Manager, right-click on the schema, select Troubleshooting → Remove locks. Then close Server Manager, open Cast-MS and retry to launch your analysis.
  3. If your second analysis failed and if you still have the same error message, then it means the lock was not removed. There is a known issue in Cast AIP 8.3.6 and Cast AIP 8.3.7. It will be fixed in 8.3.8. If you are using 8.3.6 or 8.3.7, then download Cast AIP 8.3.5 and use Server Manager 8.3.5 to remove the lock like described in the previous step.
  4. If you do not find the information you are looking for or solution for your problem, in this page, contact CAST Technical Support with below Relevant input.'

Relevant input

Notes/comments


Related Pages