[OFBIZ-12325] pricatdemo/control/pricatUpload fails to load the demo file

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Trunk, Upcoming Branch
• Component/s: pricat
• Assignee: Unassigned
• Reporter: Jacques Le Roux
• Created: 21/Sep/21 11:16
• Updated: 11/Jan/22 08:48

Description

When upoading the The SamplePricatTemplate_V1.1.xlsx demo file you get an error:

2021-09-21 12:08:07,361 |jsse-nio-8443-exec-9 |FreeMarkerWorker              |E| null
freemarker.core._TemplateModelException: Java method "org.apache.ofbiz.pricat.PricatParseExcelHtmlReport.prepareDisplayReport(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, String, String)" threw an except
ion when invoked on org.apache.ofbiz.pricat.PricatParseExcelHtmlReport object "org.apache.ofbiz.pricat.PricatParseExcelHtmlReport@51dffc31"; see cause exception in the Java stack trace.

----
FTL stack trace ("~" means nesting-related):
        - Failed at: ${report.prepareDisplayReport(request...  [in template "component://pricat/template/pricatdemo/parsePricatExcel.ftl" at line 20, column 5]
----
        at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:292) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:255) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:78) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.MethodCall._eval(MethodCall.java:62) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.Expression.eval(Expression.java:101) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.DollarVariable.calculateInterpolatedStringOrMarkup(DollarVariable.java:100) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.DollarVariable.accept(DollarVariable.java:63) ~[freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.Environment.visit(Environment.java:347) [freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.Environment.visit(Environment.java:353) [freemarker-2.3.31.jar:2.3.31]
        at freemarker.core.Environment.process(Environment.java:326) [freemarker-2.3.31.jar:2.3.31]
        at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:242) [main/:?]