SYMPTOM:
When running a script via Strategy Command Manager to stop Strategy Intelligence Server, the users find that when re-starting Strategy Intelligence Server, the schema is locked by Strategy Command Manager.
Consider the following command from the command line:
cmdmgr -n "Strategy BI Developer Kit" -u Administrator -f c:\stop.scp -o c:\command.log
Stop.scp contains the following:
STOP SERVER "localhost";
The stop command is followed by the start command below:
cmdmgr -n "Strategy BI Developer Kit" -u Administrator -f c:\start.scp -o c:\command.log
Start.scp contains the following:
START SERVER "localhost";
Running these commands causes the schema to be locked by Strategy Command Manager.
ACTION:
To avoid this situation, add the following command to the script that starts Strategy Intelligence Server:
UNLOCK CONFIGURATION FORCE;