can't print work order

[DCIM_Support]

After upgrade to DCO 8.0.4 we are unable to print work orders.

This is what is in the application log:

2017-03-28 09:58:03,606 ERROR [com.apc.isxc.reports.views.ReportView] (main) Error generating report org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred. See next exception for more information. Can not convert the value of NOT_STARTED to Integer type. (Element ID:5768) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86) at com.apc.isxc.reports.views.ReportView$4.run(ReportView.java:392) at java.lang.Thread.run(Thread.java:745) Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information. Can not convert the value of NOT_STARTED to Integer type. at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123) at org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil.convert(ResultObjectUtil.java:367) at org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil.writeData(ResultObjectUtil.java:305) at org.eclipse.birt.data.engine.executor.dscache.CacheUtilFactory$DiskSaveUtil.saveObject(CacheUtilFactory.java:194) at org.eclipse.birt.data.engine.executor.dscache.DataSetToCache.saveDataSetResult(DataSetToCache.java:185) at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.cacheDataSet(ResultSetPopulator.java:205) at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:142) at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:160) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1134) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:177) at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:115) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:176) at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) ... 29 more Caused by: org.eclipse.birt.core.exception.CoreException: Can not convert the value of NOT_STARTED to Integer type. at org.eclipse.birt.core.data.DataTypeUtil.toInteger(DataTypeUtil.java:285) at org.eclipse.birt.core.data.DataTypeUtil.convert(DataTypeUtil.java:104) at org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil.convert(ResultObjectUtil.java:363) ... 45 more 2017-03-28 10:25:36,167 ERROR [com.apc.isxc.reports.views.ReportView] (main) Unable to open view org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The type of parameter "selectedWorkOrder" is expected as "string", not "java.lang.Integer". (Element ID:5692) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateParameterValueType(EngineTask.java:904) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:845) at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:772) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:702) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1498) at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:688) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:207) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86) at com.apc.isxc.reports.views.ReportView$4.run(ReportView.java:392) at java.lang.Thread.run(Thread.java:745) 2017-03-28 10:26:13,169 ERROR [com.apc.isxc.reports.views.ReportView] (main) org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The type of parameter "selectedWorkOrder" is expected as "string", not "java.lang.Integer". (Element ID:5692) 2017-03-28 10:26:13,170 ERROR [com.apc.isxc.reports.views.ReportView] (main) Error generating report org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The type of parameter "selectedWorkOrder" is expected as "string", not "java.lang.Integer". (Element ID:5692) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateParameterValueType(EngineTask.java:904) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:845) at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:772) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:702) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1498) at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:688) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:207) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86) at com.apc.isxc.reports.views.ReportView$4.run(ReportView.java:392) at java.lang.Thread.run(Thread.java:745)

We have also tried "Restore Default Designs" from Analytics/Reports and it did not fix the issue.

Also happens when we try to print from either the "Work Orders" tab and when using "Analytics/Reports" - Work Order Details.

(CID:115837094)

[DCIM_Support · Accepted solution]

Hi Dieter,

I've been able to reproduce this on DCO 8.0.4 moment ago. It seems this has been resolved in 8.1, which is going to be released very soon.

Thanks

Kind regards

(CID:116361722)

[DCIM_Support]

Hi Dieter (Dieter Kuchta)

DCO 8.1 is now released, the download link can be obtained from your local tech support (please be aware that they will ask for a valid support contact), thanks.

Kind regards

(CID:116362273)

[DCIM_Support]

Hi Jef,

I upgrade from 8.02 to 8.1.0 today and can confirm that I can print work orders from Reports–> Work Order Details.

However I still get an error when I try to print a work order from the Work Order View tab.  I've included the error from the application log

2017-03-31 12:45:16,103 ERROR [com.apc.isxc.reports.views.ReportView] (main) Unable to open view org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The type of parameter "selectedWorkOrder" is expected as "string", not "java.lang.Integer". (Element ID:5692) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateParameterValueType(EngineTask.java:904) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:845) at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:772) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:702) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1498) at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:688) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:207) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86) at com.apc.isxc.reports.views.ReportView$4.run(ReportView.java:392) at java.lang.Thread.run(Thread.java:745) 2017-03-31 12:45:17,535 ERROR [com.apc.isxc.reports.views.ReportView] (main) org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The type of parameter "selectedWorkOrder" is expected as "string", not "java.lang.Integer". (Element ID:5692) 2017-03-31 12:45:17,535 ERROR [com.apc.isxc.reports.views.ReportView] (main) Error generating report org.eclipse.birt.report.engine.api.impl.ParameterValidationException: The type of parameter "selectedWorkOrder" is expected as "string", not "java.lang.Integer". (Element ID:5692) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateParameterValueType(EngineTask.java:904) at org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:845) at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:772) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:702) at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1498) at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:688) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:207) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86) at com.apc.isxc.reports.views.ReportView$4.run(ReportView.java:392) at java.lang.Thread.run(Thread.java:745)

(CID:116362491)

[DCIM_Support]

Hi Andrew,

I have seen this before and had captured an enhancement case, apparently the report template seems to be originated from previous version of DCO. The type parameter that is being communicated between the "right click -> Print Work Order" feature (in Work Orders view tab) seems not be in expected type.

Current work around: restoring the default report template designs should resolve the issue, but please notice that would overwrite the templates. (note: take a fresh backup, before going for Restore Default Designs)

Or as you've mentioned, you might want to print directly from "Analytics Reports" -> "Work Order Details". Or might be printed from "Analytics Changes > Work Order Tasks".

Hope this helps,

Kind regards

(CID:116362760)

[DCIM_Support]

Thanks Jef,

I thought I restored the default template last time and it still didn't work.  I tried again today and its working as expected.  I don't know if restarting my client or the server itself helped, but its now resolved.  

(CID:116363103)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.