I am having an issue exporting a report to XLSX in Sage CRM 2018R3. The message on screen is the typical message, An error occurred while running the report. Error generating report.
Exporting to CSV and Excel CSV work fine, no issues. All other tomcat related features(dashboard, exchange integration, etc) all are working fine. Exporting to XLSX works fine for some reports but not all.
The error in the logs I get is below. The data being returned in one of the reports with error is nothing out of the ordinary, it contains currency type fields in the report, but no nulls, either 0.0000 for a greater value. The error message below refers to an empty String.
Has anyone encountered this before? Any thoughts?
Jan 27 2019 18:09:32.393 3704 6944 5 START - doEndpointGet URL: localhost/.../spreadsheetTask
Jan 27 2019 18:09:32.544 3704 6944 5 FINISHED - doEndpointGet finished URL: localhost/.../spreadsheetTask
Jan 27 2019 18:09:32.547 3704 6944 1 ERROR generating excel file. HTTP status:500 Message: <diagnoses><errorMessages><errorMessage><info>com.sage.crm.core.exception.SageAsyncProcessException: Report generation failed
Exception in thread "main" com.sage.crm.core.exception.SageReportGeneratingException: java.lang.NumberFormatException: empty String
at com.sage.crm.core.util.reportgenerator.ReportGeneratorBase.generate(ReportGeneratorBase.java:70)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorManager.generate(ReportGeneratorManager.java:59)
at com.sage.crm.core.util.reportgenerator.ReportProcess.generateReport(ReportProcess.java:113)
at com.sage.crm.core.util.reportgenerator.ReportProcess.main(ReportProcess.java:83)
Caused by: java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1842)
at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
at java.lang.Double.parseDouble(Double.java:538)
at java.lang.Double.<init>(Double.java:608)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorSpreadsheet.currencyStringToDouble(ReportGeneratorSpreadsheet.java:260)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorSpreadsheet.processSummaryBand(ReportGeneratorSpreadsheet.java:632)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorBase.buildReport(ReportGeneratorBase.java:224)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorSpreadsheet.buildReport(ReportGeneratorSpreadsheet.java:787)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorBase.generate(ReportGeneratorBase.java:127)
at com.sage.crm.core.util.reportgenerator.ReportGeneratorBase.generate(ReportGeneratorBase.java:68)
... 3 more
at com.sage.crm.core.async.task.SpreadsheetTask.execute(SpreadsheetTask.java:103)
at com.sage.crm.core.async.TaskProcessor.process(TaskProcessor.java:82)
at sun.reflect.GeneratedMethodAccessor692.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.expression.spel.support.ReflectiveMethodExecutor.execute(ReflectiveMethodExecutor.java:113)
at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:102)
at org.springframework.expression.spel.ast.MethodReference.access$000(MethodReference.java:49)
at org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:347)
at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:88)
at org.springframework.expression.spel.ast.SpelNodeImpl.getTypedValue(SpelNodeImpl.java:131)
at org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:330)
at org.springframework.integration.util.AbstractExpressionEvaluator.evaluateExpression(AbstractExpressionEvaluator.java:169)
at org.springframework.integration.util.MessagingMethodInvokerHelper.processInternal(MessagingMethodInvokerHelper.java:317)
at org.springframework.integration.util.MessagingMethodInvokerHelper.process(MessagingMethodInvokerHelper.java:155)
at org.springframework.integration.handler.MethodInvokingMessageProcessor.processMessage(MethodInvokingMessageProcessor.java:93)
at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:89)
at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:102)
at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:127)
at org.springframework.integration.endpoint.PollingConsumer.handleMessage(PollingConsumer.java:129)
at org.springframework.integration.endpoint.AbstractPollingEndpoint.doPoll(AbstractPollingEndpoint.java:272)
at org.springframework.integration.endpoint.AbstractPollingEndpoint.access$000(AbstractPollingEndpoint.java:58)
at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:190)
at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:186)
at org.springframework.integration.endpoint.AbstractPollingEndpoint$Poller$1.run(AbstractPollingEndpoint.java:353)
at org.springframework.integration.util.ErrorHandlingTaskExecutor$1.run(ErrorHandlingTaskExecutor.java:55)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.sage.crm.core.exception.SageEndpointException: org.apache.commons.exec.ExecuteException: Process exited with an error: 1 (Exit value: 1)
at com.sage.crm.core.util.RunProcessHelper.run(RunProcessHelper.java:291)
at com.sage.crm.core.async.task.SpreadsheetTask.execute(SpreadsheetTask.java:93)
... 28 more
Caused by: org.apache.commons.exec.ExecuteException: Process exited with an error: 1 (Exit value: 1)
at org.apache.commons.exec.DefaultExecutor.executeInternal(DefaultExecutor.java:377)
at org.apache.commons.exec.DefaultExecutor.execute(DefaultExecutor.java:160)
at org.apache.commons.exec.DefaultExecutor.execute(DefaultExecutor.java:147)
at com.sage.crm.core.util.RunProcessHelper.run(RunProcessHelper.java:288)
... 29 more
</info></errorMessage></errorMessages></diagnoses>
Jan 27 2019 18:09:32.547 3704 6944 1 ERROR generating excel file. Message - Error generating report. .
Jan 27 2019 18:09:32.558 3704 6944 4 EndUserAction,User,Action,Time 210 1411 6266
