Skip to main content
Waters

The NuGenesis LMS template configuration report contains no Excel or Smart Builder configuration details - WKB61237

Article number: 61237

SYMPTOMS

  • When running the Template Configuration report for an LMS document template, one or more of the Excel and Smart Builder settings are selected for inclusion in the report, but the HTML and/or XML output files do not include the Excel and Smart Builder details
  • The Template Configuration report does display full details for other LMS document templates
  • The following error message appears in the LMS client's product.log file each time the template configuration report is generated:
    • ERROR CMN [(null)] - User: username, Class: OfficeUtils, Method: xlWorksheetIsEmpty, Message: Out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW)), Date: Exception occurred.

ENVIRONMENT

  • NuGenesis 9 LMS
  • NuGenesis 8 LMS

CAUSE

One or more of the Excel sections in the template includes an excessive amount of cells with formatting and/or cell values. Excel records the used range as extending to the boundaries of the worksheet, and when LMS accesses the used range, the range size is too large for the configuration report.

FIX or WORKAROUND

Follow the instructions in article 50873 to reduce the size of each Excel section in the LMS document template.

ADDITIONAL INFORMATION

 

id61237, NGLMS, NGLMSLIC, NGLMSOPT, SUPNG

Not able to find a solution? Click here to request help.