Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Limit Exceeded error

    Posted Tue November 26, 2019 12:35 PM

    Hi all

    I am getting the limits exceeded error when I try to publish a excel sheet in workspace,
    I have made it public and also the sheet was created with exploration  then converted to customer report.
    Attaching the picture of error message for reference.

    Let me know if any one know what it means, Thank you in advance.



    ------------------------------
    Dhwani Talsania
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Limit Exceeded error

    Posted Fri November 29, 2019 08:13 AM
    Hi Dhwani,

    is it possible that this is a large view and it may be too large? Depending on the MaximumViewSize setting in the tm1s.cfg file, you could get this message if this has reached this size. The administrator can also view the server log files for additional information.

    https://www.ibm.com/support/pages/tm1-error-maximum-memory-action-exceeded-view-may-be-too-large

    Kind Regards,

    ------------------------------
    Robert VAUTOUR
    ------------------------------

    Original Message


  • 3.  RE: Limit Exceeded error

    Posted Tue December 03, 2019 12:59 PM
    Hi Robert,

    Thank you, that is a good point I did check after reading your response it is not a large view, Thank you again for your response.
    I will keep looking at other options.
    Dhwani

    ------------------------------
    Dhwani Talsania
    ------------------------------

    Original Message


  • 4.  RE: Limit Exceeded error
    Best Answer

    Posted Mon December 02, 2019 09:10 AM
    Hi Dhwani

    Points to note:
    New PA has added a parameter for the number of data points (excel cells) that are published in TM1 web;
    tm1web_config.xml
    WorkbookMaxCellCount

    1. RE-publish the Excel Template - ensuring the used area of the spreadsheet is minimised (Crtl+End) will take you to the most South Easterly point of the spreadsheet that will be published. If an Active form has refreshed this used area can cover a large area of the sheet, this is not required - DELETE UNUSED CELLS/SPACE TO THE RIGHT OF THE REPORT and BELOW the REPORT, Save the report and UPDATE/RE-PUBLISH the Websheet in the applications folder - DO NOT REFRESH THE ACTIVE FORM BEFORE re-publishing.

    2. IF you still get an error - update the tm1web_config parameter
    3. if you are still getting an error - reduce the size of the template/report (remove sheets and publish them separately)

    ------------------------------
    Richard Morley
    ------------------------------

    Original Message


  • 5.  RE: Limit Exceeded error

    Posted Wed December 04, 2019 12:18 PM
    Hi Richard,

    ​Thanks a lot the first suggestion of yours helped and I was able to resolve the issue. I truly appreciate you taking time and giving me solutions, Thank you again.

    Dhwani

    ------------------------------
    Dhwani Talsania
    ------------------------------

    Original Message


Related Content