ReportServer Forum

AChater

Member

Registered: 2021-03-23

execution error

Welcome everyone,

I wanted to execute a report under the name on ReportServer 3.0.2 but I get the following error:

org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
    at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:325)
    at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:287)
    at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:98)
    at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:88)
    at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:372)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Connection Loss Rate - Cause List
Cannot convert the parameter value  to type class java.lang.Integer.
Can not convert the value of  to Integer type.
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:672)
    at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:359)
    at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:316)
    ... 5 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: Connection Loss Rate - Cause List
Cannot convert the parameter value  to type class java.lang.Integer.
Can not convert the value of  to Integer type.
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:355)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:464)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:652)
    ... 7 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Cannot convert the parameter value  to type class java.lang.Integer.
Can not convert the value of  to Integer type.
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.convertToValue(DataSourceQuery.java:1335)
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.getParameterInputValue(DataSourceQuery.java:644)
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParametersToQuerySpec(DataSourceQuery.java:568)
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.populateQuerySpecification(DataSourceQuery.java:502)
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:285)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:621)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:351)
    ... 12 more
Caused by: org.eclipse.birt.core.exception.CoreException: Can not convert the value of  to Integer type.
    at org.eclipse.birt.core.data.DataTypeUtil.toInteger(DataTypeUtil.java:276)
    at org.eclipse.birt.core.data.DataTypeUtil.convert(DataTypeUtil.java:158)
    at org.eclipse.birt.data.engine.executor.DataSourceQuery.convertToValue(DataSourceQuery.java:1331)
    ... 18 more

Do you have any idea please about the possible cause of the problem ?

Thank you in advance.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: execution error

Hi AChater,

could you pls test with the newest ReportServer version 3.6.0 if report works in this case?

Regards,
Eduardo