Can not load the report query

mohanish

I have added mysql-connector-java-5.1.18-bin file to

C:\apache-tomcat-7.0.22\webapps\Birt-Viewer\WEB-INF\lib and

C:\apache-tomcat-7.0.22\lib and

C:\birt-runtime-3_7_1\WebViewerExample\WEB-INF\lib and

C:\birt-runtime-3_7_1\ReportEngine\lib


Please let me know where i have to add my mysql connector jar files.

My error is coming in this form


- Can not load the report query: 417. Errors occurred when generating the report document for the report element with ID 417.

Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 417. Errors occurred when generating the report document for the report element with ID 417.
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:160)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1876)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecu

LokeshP

Hello every one i got solution now.


U can add these lines top part of catlina.bat


SET java.io.tmpdir=C:\apps\apache-tomcat-5.5.20\tmpdir

SET org.eclipse.datatools_workspacepath=%java.io.tmpdir%\workspace_dtp

mkdir %java.io.tmpdir%

mkdir %org.eclipse.datatools_workspacepath%