Page 1 of 1
Wait:IXCur on user login during TI data load
Posted: Mon Aug 22, 2016 2:25 pm
by 4rtem
I have a TI data load process that causes users to wait during integrated login. This situation is reflected in TM1Top in the following way:
USername: ???
State: Wait:IXCur (UserName) - (Client)
Function: SystemServerConnectIntegrate
Obj Lock Status: Client
This TI process does not create subsets, change view, does not touch control cubes and dimensions directly. It just operates with dimension elements and cube data. Can CubeSetLogChanges(vCube,0) drive such behavior?
We use 64x TM1 10.1.
Thanks.
Re: Wait:IXCur on user login during TI data load
Posted: Mon Aug 22, 2016 2:36 pm
by pandinus
4rtem wrote:Can CubeSetLogChanges(vCube,0) drive such behavior?
Yes.
And also metadata updates may be blocking.
Re: Wait:IXCur on user login during TI data load
Posted: Mon Aug 22, 2016 2:40 pm
by BrianL
It looks like the the TI process is touching the client objects. Are you doing anything with the TM1User() function or the }Clients dimension in the TI?
Re: Wait:IXCur on user login during TI data load
Posted: Mon Aug 22, 2016 3:04 pm
by 4rtem
No operations with TM1USer() and }Clients dimension and any of control cubes/dimensions.
Statistic cubes are active on the server, maybe it is the source of locks...
I will turn it off tomorrow and check if it helps.
Re: Wait:IXCur on user login during TI data load
Posted: Thu Oct 13, 2016 8:42 am
by dhims
Hi 4rtem,
Just thought of checking with you how you resolved this issue. I am facing exactly the same issue on (10.2.2 FP5). I disabled the command that plays on cube logging. There is no commands that play on control objects. But, I am still getting the same locking contention.
Any help will be highly appreciated.
Dhims
Re: Wait:IXCur on user login during TI data load
Posted: Thu Jan 19, 2017 11:56 am
by 4rtem
Do not use CubeSetLogChanges.
If you want to turn on/off logging in the cube set the LOGGING property on the
}CubeProperties cube directly.
That worked for me.
Re: Wait:IXCur on user login during TI data load
Posted: Thu Jan 19, 2017 12:01 pm
by ambrus
That is only the old wisdom, isn't it? AFAIK this was sorted somewhere around 10.2.2 FP4+