SecurityRefresh cause restrart TI process

[ioscat]

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?

[asutcliffe]

Hi,

I'm afraid I don't really understand what you mean by this:

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?

Maybe you can elaborate or post your code?

[rmackenzie]

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?

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]

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' );

1) recreate dimesion
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.

[Andy Key]

Do the server logs show any messages about Rolling Back?

[ioscat]

Upping old post.

What does "Roll Back" log look like? Have anybody ever met it?