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.
Wait:IXCur on user login during TI data load
-
- 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
“The way to get started is to quit talking and begin doing.” - Walt Disney
-
- 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
Yes.4rtem wrote:Can CubeSetLogChanges(vCube,0) drive such behavior?
And also metadata updates may be blocking.
-
- 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
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?
-
- 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
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.
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
-
- 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
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
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
-
- 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
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.
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
-
- 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
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/