Clarity

 View Only
  • 1.  Excel Export query

    Posted Sep 03, 2018 08:58 AM

    Hi.

    We are on version 15.2.0.213 04 6

     

    How do I adjust the setting for numbers of rows allowed to export to Excel? We need to change it to 30000 rows.

    Thanks!



  • 2.  Re: Excel Export query
    Best Answer

    Broadcom Employee
    Posted Sep 03, 2018 09:24 AM

    All the governor settings are now put in one file Governor Limits in CA PPM - CA Knowledge 

     

    Regards

    Suman Pramanik 



  • 3.  Re: Excel Export query

    Posted Sep 03, 2018 09:59 AM

    Thank you Suman. Do I need to change both values in bold below? Also - is a service restart required for the changes to take effect?

     

    #Maximum Document upload Size
    DMS_DOCUMENT_MAX_SIZE=20
    #Maximum rows for Export to Excel
    E2E_MAX_ROWS=25000
    #Maximum row limit for Objects and NSQL Portlets
    MAX_FETCH_LIMIT=50000
    #Maximum GEL rows allowed
    MAX_SQL_GEL_ROWS=100000
    #Maximum tasks allowed in a timesheet
    MAX_TIMESHEET_TASKS=250
    #Maximum allowed XML nodes in a XOG read
    MAX_XML_NODES=150000
    #Maximum attributes allowed in a PFM Portfolio
    PFM_LIMITS_MAX_INV_ATTRS=700
    #Maximum roles allowed
    PFM_LIMITS_MAX_ROLES=75
    #Maximum rows for Export to Excel, application level setting
    E2E_MAX_ROWS_APP=25000
    #Timer for Export to Excel.
    E2E_TIMER=600
    #Maximum todos allowed per task
    MAX_TODOS_PER_TASK=25



  • 4.  Re: Excel Export query

    Broadcom Employee
    Posted Sep 03, 2018 11:06 AM

    Thats correct Colin 



  • 5.  Re: Excel Export query

    Posted Mar 11, 2019 07:51 AM

    This helped! I did not need a service restart though.



  • 6.  Re: Excel Export query

    Broadcom Employee
    Posted Mar 11, 2019 11:38 AM

    Thanks all, yes this is asynchronous