User Entries and Web Sheets break with Server Reboot

[SherryC]

Hi Everyone,
I'm new here (first post), and I've been searching the forum a few different ways on this with no luck thus far.

My team is using TM1 10.2.2 FP2 (upgraded from 10.1.1 in July 2015). We're running this on a single Windows 2012R2 virtual server. Our IT team applies patches on a monthly basis that often require rebooting the server. Our small user base of < 10 finance department people access and make entries via TM1 Web (web sheets and cube views).

Over the past 3 - 4 weeks, the web sheets have become unavailable. They produce the STOP message that says "Failed to open the target workbook. Please make sure that the file has not been renamed or deleted." There have been zero changes to the web sheets. We have noticed a correlation between TM1 Server service restarts (our TM1 Server is called "Financial Model") and or server reboots and this web sheet issue occurring. This has happened in production 3 times. Each time our fix has been to delete the web sheets and reupload them (they haven't changed). However, the past 2 times the web sheet issue occurred, some data was lost.

In the first case, it was a value in a control cube that defines the current month. It was set to period 4 on 9/30 and had somehow reverted to period 3 in early October the second time the issue happened. Looking in the transaction log, I can see that it was set to period 4 on 9/30, but there's no transaction indicating it was set back to period 3 (and this value does not get modified via any TI process, and there are only about 3 people who could change it - none of them did). It was easy to reset the value to period 4 and move on. However, the second time there were a number of significant user entries lost - at least a day's worth of work, possibly more. We do have a Save Data All chore scheduled to run at 19:00 each weekday, so I would've thought that we were mostly safe from data loss (at least up to that 19:00 point each day). We do also have daily server images from which we can recover files, but in this case our users had adequate notes to redo the entries in a few hours).

We are actively working a PMR with IBM, but we're also trying to research independently, since patches are applied routinely and we're worried the issue will resurface at any time. We've sent a good bit of data to them, including our TM1 Server directory, and the results of our own testing, but we have yet to hear back from them.

We have been able to reproduce the issue and do some testing in our DEV environment. What we've found from that is:

1) Any scenario that involved either rebooting the server or restarting the service caused data loss
2) If we successfully shut down the (Financial Model) service prior to rebooting the server, the web sheets remained valid (but data was still lost).

So, my first question is has anyone seen this or something similar, and if so, do you have any advice?. My second question is how can I verify that user entries have successfully been saved to disk (in other words, that the save data all command actually did what it's supposed to do)?

Thanks.

[Alex]

We just experienced a very similar behaviour and figured out that it was due to Feeders!

After we had deleted the Feeders from the rules the system behaved "normally" again. And yes, we had to really delete the Feeders not just commenting out "Skipcheck".

Now we are trying to find out why this had happen.

Maybe that is of help.

[Xavier 13]

I have the same error. Only 1 workbook in my application gets this error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted."

One solution proposed by IBM precises that it applies if any websheet doesn't open. This didn't help me.
Issue caused by multiple aspose*.jar files in location <PA installation>\webapps\tm1web\WEB-INF\lib
https://render-prd-trops.events.ibm.com ... -websheets

I then deleted the rules as suggested by Alex above

I also reinstalled the web application
https://www.ibm.com/support/pages/unabl ... -same-name

nothing helped.

And finally I simply realised that I forgot to change the server name in hardcoded references of the hidden sheets of my workbook.

[MarenC]

Juts along the lines of Xavier,

Do you have multiple TM1 instances, other than the financial model?
Do you have action buttons on the websheets? If so have you checked that they all point to the financial model server.

I had an issue where one of the action buttons on the websheet, which simply recalculated the sheet, was actually pointing at a different TM1 instance

Maren