Hello, Community!
We got a trouble - we start TI process with SecurityRefresh command in the code, but when this string is executed all process starting from the first string. Has anybody met this issue ever?
SecurityRefresh cause restrart TI process
-
- Regular Participant
- Posts: 164
- Joined: Tue May 04, 2010 10:49 am
- OLAP Product: Cognos TM1
- Version: 9.4.1 - 10.1
- Excel Version: 2003 and 2007
Re: SecurityRefresh cause restrart TI process
Hi,
I'm afraid I don't really understand what you mean by this:
I'm afraid I don't really understand what you mean by this:
Maybe you can elaborate or post your code?ioscat wrote:Hello, Community!
We got a trouble - we start TI process with SecurityRefresh command in the code, but when this string is executed all process starting from the first string. Has anybody met this issue ever?
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: SecurityRefresh cause restrart TI process
AIUI SecurityRefresh applies locks on security objects whilst it is performing its function. It sounds like you are experiencing a rollback in this particular TI process due to some command in the process after the SecurityRefresh trying to update something related to security. Most people would run SecurityRefresh at the end of the process after having performed security updates - can you post the code?ioscat wrote:We got a trouble - we start TI process with SecurityRefresh command in the code, but when this string is executed all process starting from the first string. Has anybody met this issue ever?
Robin Mackenzie
- ioscat
- Regular Participant
- Posts: 209
- Joined: Tue Jul 10, 2012 8:26 am
- OLAP Product: Contributor
- Version: 9.5.2 10.1.1 10.2
- Excel Version: 07+10+13
- Contact:
Re: SecurityRefresh cause restrart TI process
Code: Select all
#executeprocess( 'Dim.Load.Техническое средство' );
#executeprocess( 'ElementSecurity_UpdateSecurity_Техническое средство' );
#SecurityRefresh;
CubeClearData( 'Budget_Income_po_TS' );
executeprocess( 'Cube.Load.Budget_Income_po_TS_Forec_Komm_2012' );
executeprocess( 'Cube.Load.Budget_Income_po_TS_Forec_Central_2012' );
executeprocess( 'Cube.Load.Budget_Income_po_TS_Actual_Komm_2012' );
executeprocess( 'Cube.Load.Budget_Income_po_TS_Actual_Central_2012' );
executeprocess( 'Cube.Load.Budget_Income_po_TS_Forec_Komm_2013' );
executeprocess( 'Cube.Load.Budget_Income_po_TS_Forec_Central_2013' );
2) we have cube "ElementSecurity_Техническое средство" (copy of "}Ele...") that has rules. String data is put from rule cube to security cube by this process.
3)
4)
5)-10) Data load.
this morning tried to run process without "#" and it become to cycle around first two strings.
-
- MVP
- Posts: 351
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: SecurityRefresh cause restrart TI process
Do the server logs show any messages about Rolling Back?
Andy Key
- ioscat
- Regular Participant
- Posts: 209
- Joined: Tue Jul 10, 2012 8:26 am
- OLAP Product: Contributor
- Version: 9.5.2 10.1.1 10.2
- Excel Version: 07+10+13
- Contact:
Re: SecurityRefresh cause restrart TI process
Upping old post.
What does "Roll Back" log look like? Have anybody ever met it?
What does "Roll Back" log look like? Have anybody ever met it?