Wait:IXCur on user login during TI data load

Post Reply
4rtem
Posts: 12
Joined: Wed Nov 20, 2013 5:05 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

Wait:IXCur on user login during TI data load

Post 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.
“The way to get started is to quit talking and begin doing.” - Walt Disney
pandinus
Posts: 78
Joined: Tue Mar 18, 2014 8:02 am
OLAP Product: TM1, Cognos Express
Version: 10.2.2
Excel Version: 2013

Re: Wait:IXCur on user login during TI data load

Post by pandinus »

4rtem wrote:Can CubeSetLogChanges(vCube,0) drive such behavior?
Yes.
And also metadata updates may be blocking.
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Wait:IXCur on user login during TI data load

Post 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?
4rtem
Posts: 12
Joined: Wed Nov 20, 2013 5:05 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

Re: Wait:IXCur on user login during TI data load

Post 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.
“The way to get started is to quit talking and begin doing.” - Walt Disney
dhims
Posts: 22
Joined: Sun Oct 23, 2011 12:14 pm
OLAP Product: TM1
Version: 951 952 101 10101
Excel Version: 2003 2007 2010

Re: Wait:IXCur on user login during TI data load

Post 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
4rtem
Posts: 12
Joined: Wed Nov 20, 2013 5:05 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

Re: Wait:IXCur on user login during TI data load

Post 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.
“The way to get started is to quit talking and begin doing.” - Walt Disney
ambrus
Posts: 10
Joined: Thu Nov 19, 2009 1:13 pm
OLAP Product: Manny's TM1
Version: 10.2.2
Excel Version: 2010
Contact:

Re: Wait:IXCur on user login during TI data load

Post by ambrus »

That is only the old wisdom, isn't it? AFAIK this was sorted somewhere around 10.2.2 FP4+
Rest API addict, creator of http://cubeac.com || Blog http://cubeac.com/blog/
Post Reply