IBM Support

TM1 web error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted." occurs to all websheets

Troubleshooting


Problem

Open any websheet from TM1 web gets error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted." TM1web.log shows following error 2017-11-23 15:02:37,340 [Default Executor-thread-27730] ERROR () com.ibm.cognos.tm1.web.services.WorkbookService - [] Exception Error: null Stack Trace: java.lang.reflect.InvocationTargetException ... Caused by: java.lang.NoSuchMethodError: com/aspose/cells/Workbook.getDataConnections()Lcom/aspose/cells/ExternalConnectionCollection; ....

Symptom

Open any websheet from TM1 web gets error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted."

Cause

Multiple aspose*.jar files in location <PA installation>\webapps\tm1web\WEB-INF\lib

Diagnosing The Problem

Open any websheet from TM1 web gets error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted."

TM1web.log shows following error
2017-11-23 15:02:37,340 [Default Executor-thread-27730] ERROR () com.ibm.cognos.tm1.web.services.WorkbookService - [] Exception Error: null
Stack Trace: java.lang.reflect.InvocationTargetException
...
Caused by: java.lang.NoSuchMethodError: com/aspose/cells/Workbook.getDataConnections()Lcom/aspose/cells/ExternalConnectionCollection;
....

Resolving The Problem

Issue caused by multiple aspose*.jar files in location <PA installation>\webapps\tm1web\WEB-INF\lib

In this particular client site, they have two files – aspose-cells.jar & aspose-cells-7.5.3.5.jar. After remove aspose-cells-7.5.3.5.jar, error was gone.

[{"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22011086

Page Feedback