IBM Support

"Error getting active sandbox - no ad-hoc sandbox capability has been granted" error on TI execution

Troubleshooting


Problem

TI run by Non- Admin users fail with error
"Error getting active sandbox - no ad-hoc sandbox capability has been granted"
Same TI works for Admin users.

Cause

TI had the below code
cCurrentSandbox = ServerActiveSandboxGet();
If (cCurrentSandbox @<> '');
ServerSandboxMerge(cCurrentSandbox, '');
ServerSandboxDiscardAllChanges(cCurrentSandbox);
SetUseActiveSandboxProperty(0);
Endif;

Resolving The Problem

Login to Architect
Right Click on the TM1 server
Select Capabilities Assignment
For the Capability called Sandbox apply Grant status for all groups
Click ok

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 March 2019

UID

ibm10875458