TM1 Forum

It is the exact same TI job on all TM1 services across all servers. The TI job has a single line of code in the Prolog tab as follows: EnableBulkLoadMode(); There is no data source and there is not a single other line of code in the TI job. I've also submitted this issue with IBM Support but haven't...

There is a function available in 9.4.1 FP3 to lock out all other threads while a chore is executing called 'EnableBulkLoadMode()'. Although this fuction is working as expected on a few of our TM1 instances it is not working on all TM1 instances. We are having behaviour where it appears that the TM1 ...

you can execute this from the cmd prompt and it will give you the PID: sc \\servername queryex tm1servicename so if your TM1 service is called 'planning' and it is running on a server called \\server1 the command would look like this: sc \\server1 queryex planning you can run this from your computer...

I haven't implemented this yet since we are only on FP2, but there is a new feture in 9.4.1 FP3 which I think will solve the chore roll back issue...here is the info from IBM support... There is a new parameter called Bulk Load Mode in 9.4.1 FP3. If you upgrade to 9.4.1fp3 this parameter would work ...

All indications are pointing to locking issues while the chore is running which causes it to "fail" and rollback and start the chore over again from the beginning. For example, if the chore is running and then a separate process or chore executes something which locks an object and then th...

I did some testing and if I pull the SAME exact data out of a cube which has all of the live revenue rules the data pull takes 6 seconds (which is exactly what i would expect). When I pull that same data out of a separate cube on a separate TM1 service on a separate server which is pasted values of ...

We have gone a day and a half without the blank error message so it sure looks like this was the solution!

thanks again...

Yes, I have rebuilt the chore. The same thing still happens. It does not happen every night.

Has anybody who has seen this found a way to fix it?

I am about 99% positive that I have confirmed your post!!! Our code to load the TM1 add-in was flawed and it was re-loading the TM1 add-in on every single excel report a user would open instead of just loading the add-in once on the first report they opened. I have fixed this flaw on a few of our re...

We are running TM1 9.4.1 FP2 on our servers and our clients have TM1 9.4.1. Since we have upgraded, users randomly get a vbCritical Error message while using our Excel based reports. The message box that appears has no words, number or any other information on it. It is a totally blank VBA message b...

I rebuilt the chore yesterday but we still received the same error messages. Is anybody else experiencing the same thing? In our chore we have a bunch of TI jobs that run then we have a TI job that executes the 'SaveDataAll' and then a bunch more TI jobs run all in the same chore.


thanks...

So has anybody noticed a performance improvement moving to 9.4.1 FP3? We just upgraded to 9.4.1 FP2 from 9.0 and out clients are experiencing major performance issues when connecting excel workbooks direclty to our cubes. I am interested if anybody has any comments...did you just upgrade your client...

We recently upgraded to TM1 9.4 FP2 and are getting the following error message when executing the 'SaveDataAll' function within a chore: Error: Prolog procedure line (27): SaveDataAll failed. See tm1server.log for more information The information in the tm1server.log shows the following: 912 WARN 2...

We have a chore that is scheduled to execute 1 time each night starting at 10:20pm. This chore has been running 1 time each night for over 5 years on version 8.2.12 through 9.0. Over this past weekend we upgraded to 9.4 FP2 and the chore ran 1 time each night starting at 10:20pm until last night. La...