Hi Robert,
We do not have PAW available at the client where we upgraded to 2.0.8. So I don't know if PAW is also affected in this particular case but I would guess so.
I think the scenario is different from Jonel and your link did not help. We have many websheets but only one websheet had the issue after upgrading. After extensive testing we found out the following.
The error appears if the websheet includes:
1. Active form
2. Chart (does not necessarily need to be build based on active form, can have a slice as data source)
3. Merged cells
with the combination that you delete all active form rows except the first one before saving to keep the websheet size small.
I could reproduce the error in Planning Sample. If you are interested to understand the issue you can do the following in Planning Sample:
1. Open report "Actual v Budget.xlsx"
2. Merge any cells (e.g. E14 and F14)
3. Delete rows 20, 21, 22 -> sheet looks like in the screenshot I uploaded
4. Save and open in TM1Web -> Error should occur
5. Go back to file and unmerge cells
6. Open in TM1Web -> no error (chart might stop working because of the graphdata named ranges but it does not matter, if you would merge the cells again, the error occurs again.
BR
Mario
------------------------------
Mario Hasler
------------------------------
Original Message:
Sent: Thu August 15, 2019 06:26 AM
From: Robert VAUTOUR
Subject: Planning Analytics Workspace Books
Hi Mario,
Are you saying that this is only happening with TM1Web?
I'm trying to understand if the scenario is the same as Jonel had at the beginning of this thread where it was intermittent and to resolve he would do something like go to another sheet then back.
A bit surprised it's happening with 2.0.8, but wondering if you could retest with this jvm option in place?
https://www-01.ibm.com/support/docview.wss?uid=swg22014031
Thanks in advance,
------------------------------
Robert VAUTOUR
Original Message:
Sent: Wed August 14, 2019 08:50 AM
From: Mario Hasler
Subject: Planning Analytics Workspace Books
Hi
We are experiencing the issue after upgrading to 2.0.8 in TM1Web.
Is there any update on this?
BR
Mario
------------------------------
Mario Hasler
Original Message:
Sent: Tue June 11, 2019 07:10 AM
From: Pieter-Jan Beckers
Subject: Planning Analytics Workspace Books
Hi,
Is there any update on this, we are experiencing the same.
Kr,
------------------------------
Pieter-Jan Beckerselement61 Belgium
Senior Performance Management Architect
pieter-jan.beckers@element61.be
Original Message:
Sent: Wed December 12, 2018 01:37 AM
From: Jonel Unidad
Subject: Planning Analytics Workspace Books
Hi
Good Day To All,'
We are currently receiving this error on Planning Analytics Workspace when opening a book the error says "Failed to open the target workbook. Make sure that the file has not been renamed or deleted." But there are times the books open and when switching to another tab the error goes back again. We are using Planning Analytics Workspace Local Version 2.0.36. Does someone experience this before and how to resolve this.
Ill appreciate any help or suggestion that you can give me thanks... Please see image below for the screenshot error
Thanks,
Jonel
------------------------------
Jonel Unidad
------------------------------
#PlanningAnalyticswithWatson