Page 1 of 1
Process does not update updateable cell
Posted: Fri Aug 04, 2017 12:26 pm
by TMinorK
I bump into the following issue occasionally in TM1 10.2.2. RTM: it happens that some processes, though terminating without any errors, do not update some target cells. The corresponding cells are updateable and in most of the cases they are actually updated when the process is executed.
A couple of days ago it happened even while using an AttrPutS command to assign an alias to a dimension element (i.e. in this case the cell in the related }ElementAttributes cube was not updated).
Do you have any idea?
Re: Process does not update updateable cell
Posted: Fri Aug 04, 2017 1:36 pm
by jim wood
I think we'll need more detail than that. I've some funnies over time when specifying the elements for every dimension in a source view but I'm not sure if these are related.
Re: Process does not update updateable cell
Posted: Fri Aug 04, 2017 1:43 pm
by Drg
turn on logging on this cube and run you process. check transaction log after.
or use textoutput(),LOGOUTPUT() function on your process to find your error.
Re: Process does not update updateable cell
Posted: Mon Aug 07, 2017 7:05 am
by TMinorK
The "main" problem is that the non-updating happens apparently randomly: usually the process updates the cell as desired, but then (after several successful executions) it does not. When (if) we notice the error and run the process again, it works. We've been facing this for about a year, previously it never happened.
We experienced the problem with several processes, and it effected both numeric and string cells. I have no idea about how to localize the "bewitched" processes or how to reproduce the phenomenon intentionally.
Re: Process does not update updateable cell
Posted: Mon Aug 07, 2017 9:23 am
by Drg
use textoutput() function on your process to create snapshot of action on the TI script.
Check rule on cell where you don't see you data(maybe on some action of users cell lock's CellIsUpdateable etc...).
Faced in same trouble wheen copy data from version to version.
We check al ldata flow and find rule on cube A who lock cell on Cube B if in cube C cell null.
then change load data sequence first load Cube C then Cube A then Cube B
As an option why it might be...
Re: Process does not update updateable cell
Posted: Mon Aug 07, 2017 9:45 am
by Edward Stuart
Is this a last values wins scenario?
If you know there are target cells that are not updating, then you can ASCIIOUTPUT/ TEXTOUTPUT for those cells only and check if they are being written/ overwritten/ being targeted as required
Has the code in the processes changed? Does the data source change? Have you upgraded? etc.. etc..