How to Reset Data in TM1 Application???

[7Zark7]

Hi All,

I am in the process of releasing our budget model and require an easy way to clear all test data contained within TM1 Application.

I have been able to release ownership across all nodes for a particular application via process: }tp_reset_state, however
getting rid of the all the old data ( highlighted in blue ) cannot be deleted.....

I have had a look at all the processes but cannot find which one to use. I cannot seem to find the process I'm after using these
hidden TI processes.

Is there a way to get around this? I can obviously select the top node within each deployed app and choose to "reset data" within
each app, but this would be too time consuming. Please help!

Sceenshot of the "reset data":



Cheers

Zark

[7Zark7]

Hi All,

I can finally see what the issue is, the data is being sandboxed in the cube that the data is being sent to. The question now is
how do I use the function: ServerSandboxesDelete function????

I have tried running this:
ServerSandboxesDelete( 'client|=|CAMID("AD::u::ebc010a33015e047ac55c8df80d80498")# name|=|DaveTest' , '|', '#' );

There must be a syntax error or I have missing something. I simply want to delete "DaveTest" sandbox but cannot.
Is there a way or deleting all sandboxes? I cannot find a way to do it. Any help would be greatly appreciated.

Cheers

Zark

[7Zark7]

Hi All,

I have had some success and found ti process < }tp_delete_sandboxes > to delete sandboxes within TM1 Applications ( contributor ) however I get this message when the process is run:

Sandbox '[Default]_[PracticeGroup].[6400]_e6013e66-13ad-4335-9d44-7ef72e15a4fb' matches criteria, but is currently in-use. It will be skipped.

Per the documentation it mentions this:
--------------------------------------------------
In-Use Sandboxes
When a sandbox meets the criteria for deletion, but is currently in use, that sandbox will not be deleted. An entry will appear in the debug log info-level report indicating the occurrence.

The question is: "What does in use mean?" And how do you NOT skip a sandbox that is in use and clear it???

Cheers

Zark

[7Zark7]

Hi All,

Appears to be a bug: http://www-01.ibm.com/support/docview.w ... wg1PM92058 and surprise surprise it will require an upgrade to version 10.2.
So the Local fix is to delete sandboxes manually. Are the sandboxes stored anywhere on the server? I am happy to go into
the back end and delete the lot of em but cannot locate them. If they do exist in the backend where do they reside??????

Cheers

Zark

###########################################################################
PM92058: RESETTING APPLICATION DOES NOT SEEM TO DELETE THE SANDBOXES

APAR status

Closed as unreproducible.

Error description
There is a functionality to reset the state of an application.
As a part of running this process users can select if sandboxes
are to be deleted or not.?However if they do it does not seem to
delete all those sandboxes. ?Ttm1server.log in the background of
this process triggers "}tp_delete_sandboxes" TI?However, the
process does not delete sandboxes ?as indicated by the
following INFO?"Sandbox 'test1admin_[Country and
Region].[Americas]_{ca086b02-c95a-46f8-a9d2-999fc2df4ce6}'
matches criteria, but is currently in-use. It will be
skipped.?No sandboxes were affected."?However the sandboxes are
not in use.

Local fix
delete sandboxes manually

Problem summary
****************************************************************
* USERS AFFECTED: *
* All Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See error description. *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to IBM Cognos TM1 10.2 *
****************************************************************

[7Zark7]

Hi All,

I have found a solution although not a great one.... to delete all sandboxes contained within a contributor app under TM1 version 10.1.1 you will need to do the following:
1) shut down the service and delete the following files ( not sure on this step, you may be able to delete while its still up )
2) navigate to the tm1 data directory and for each user :\Data\AD\User\}sandboxes
3) delete all files contained within the directory ( you may need to be careful what you delete )
4) reboot the server. Sandboxed data will now be removed as well as the views

I believe this has been fixed in version 10.2? Can anyone confirm that this is the case?

Cheers

Zark

[BrianL]

I believe this is also fixed in 10.1 RP1 FP2 if that's less painful than a 10.2 upgrade.