As part of my onboarding I have been investigating sandboxes.
I have been trying out the ServerSandboxesDelete TI function and I can get it to work... but maybe not when I would expect (at least not all of the time).
I created a new user / client called sandboxtester and used GO_New_Stores and Architect to create a sandbox in the Products Cube, All View - no problem. I can then use TI to do things like ServerActiveSandboxGet and SetUseActiveSandboxProperty (1) and CellPutN (1,'Product','Lanterns','Budget version 1','Unit sale price') - all works lovely. My default value of Unit Sale Price for Lanterns in Budget Version 1 changes from 29.12 to 1, but only in the sandbox.
I wanted to then delete that sandbox via TI, so used ServerSandboxesDelete ('client:=:sandboxtester') but most of the time I get an error in the tm1server.log saying the following:
TM1.Sandbox SandboxGlobalAdmin::RunOperation: 'Delete' Sandbox 'testsandbox' matches criteria, but is currently in-use. It will be skipped.
No sandboxes were affected.
This happens if I close the Cube Viewer where I created the sandbox, if I save the View and close the Cube Viewer or even if I commit the sandbox to the base, it always tells me that the sandbox is in use.
Now... if I log out of the TM1 Server and log back in - either as that sandboxtester user or as admin - I can run the process and straight away I get a successful outcome:
TM1.Sandbox SandboxGlobalAdmin::RunOperation: 'Delete' Sandbox 'testsandbox' of client 'Sandboxtester' with size '17408'.
But... I was wondering why the use of TI ServerSandboxesDelete is any different to me pressing the Sandbox Delete menu item in the Cube Viewer of Architect... whenever I press that menu item the sandbox is successfully deleted, it seems.
ServerSandboxesDelete only seems to work when I've logged-out and back in, but the Sandbox Delete button appears to work all the time. I dunno, but I would've thought the button might call ServerSandboxesDelete behind the scenes.
Is this a valid query for the forum?
ServerSandboxesDelete, special circumstances for it to succeed?
- Hippogriff
- Posts: 48
- Joined: Thu Nov 19, 2015 4:02 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2012
ServerSandboxesDelete, special circumstances for it to succeed?
--
Cheers, Hippo
Cheers, Hippo