Planning Analytics

 View Only
  • 1.  The new TM1 Web / PASS fails to create new files in it's excelsheet-folder

    Posted Fri May 06, 2022 09:36 AM
    Recently we upgraded from the old TM1 Web to the new TM1 Web, to Planning Analytics Spreadsheet Services (PASS). Currently we are running PA 2.0.9.11 Windows and PASS 2.0.73 Windows. Before the upgrade our users had no problems with the old TM1 Web. Since the upgrade we have two distinct groups of TM1 Web users, the good ones and the bad ones. When working with the new TM1 Web / PASS the bad ones get error messages like

    Failed to open the target workbook. Make sure that the file has not been renamed or deleted.

    and the websheets do not render or render incompletely. When that happens, in the TM1 Web log file tm1web.log we find error messages like

    2022-05-06 07:46:17,262 [Default Executor-thread-45] ERROR ([]) com.ibm.cognos.tm1.common.FileUtility - [] [77a12069-d801-4c7e-b2a1-17c695bd92e9] Failed to create a new file in: D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\excelsheet\s_165181597640477_f\s_165181597640477_f_ie.css

    How to resolve this problem ?
    This does not seem to be a known problem. Or is it ?

    How to gather more information why the FileUtility of the new TM1 Web / PASS fails to write new files in it's excelsheet-folder ?

    ------------------------------
    Bernd Siebert
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: The new TM1 Web / PASS fails to create new files in it's excelsheet-folder

    Posted Fri May 06, 2022 12:36 PM

    Hi,

    Does the ID that is running the PASS service have full rights to the folder?  We had to switch from Local System to an AD service account with access to the folders.



    ------------------------------
    Scott Brown
    ------------------------------



  • 3.  RE: The new TM1 Web / PASS fails to create new files in it's excelsheet-folder

    Posted Mon May 09, 2022 08:47 AM
    Edited by System Fri January 20, 2023 04:44 PM
    Hello Scott,
    the AD service account running the PASS service (and the other TM1 services) has Full Control on the excelsheet-folder.
    Regards

    ------------------------------
    Bernd Siebert
    ------------------------------



  • 4.  RE: The new TM1 Web / PASS fails to create new files in it's excelsheet-folder

    Posted Fri May 20, 2022 02:49 AM
    We resolved the issue by upgrading PASS from 2.0.73 to 2.0.76

    PASS 2.0.76 addresses two product defects which throw the error message "Failed to open the target workbook":
    PH45317   Failed to open the target workbook' error in Planning Analytics Spreadsheet Services 2.0.74
    PH45443   Failed to open target workbook in TM1 Web version 2.0.73

    It seems we run into these product defects.

    ------------------------------
    Bernd Siebert
    ------------------------------