Hi,<br />
<br />
Environment:- Actuate 10/11 BIRT Report Designer Professional, SAP JCo 2.1.8<br />
<br />
We are creating a Actuate BIRT report to pull data from SAP R/3 system using SAP JCo connector. We created some JAVA classes for this purpose. When we run these JAVA classes as Java Application, they work fine and they pull data from SAP R/3. We now created an BIRT Report Design which uses a scripted data source and wrote code in the open, fetch, and close method to get data from the SAP R/3 system. We are able to successfully preview data on the scripted data source. We placed the fields on report layout and are also able to run the report. But the problem is, the report runs successfully for two consecutive times and when we run it for third consecutive time, we are getting the following error (If we close the BRD Pro and open it, it is again the same behaviour, runs two times and gives error third time onwards):<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
java.lang.ExceptionInInitializerError: JCO.classInitialize(): Could not load middleware layer 'com.sap.mw.jco.rfc.MiddlewareRFC'
JCO.nativeInit(): Could not initialize dynamic link library sapjcorfc [Native Library C:\WINDOWS\system32\sapjcorfc.dll already loaded in another classloader]. java.library.path [C:\Program Files\Common Files\Actuate\11.0\JDK160\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\QuickTime\QTSystem\;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\Common Files\Microsoft Shared\Windows Live]
at com.sap.mw.jco.JCO.<clinit>(JCO.java:776)
at JcoConnectionPool.<init>(JcoConnectionPool.java:43)
at JcoConnectionPool.getInstance(JcoConnectionPool.java:55)
at JcoConnectionPool.getConnection(JcoConnectionPool.java:60)
at SimpleClass.gettingData(SimpleClass.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
at org.mozilla.javascript.gen.c7._c1(:2)
at org.mozilla.javascript.gen.c7.call()
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
at org.mozilla.javascript.gen.c8._c0(:0)
at org.mozilla.javascript.gen.c8.call()
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
at org.mozilla.javascript.gen.c8.call()
at org.mozilla.javascript.gen.c8.exec()
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:134)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:219)
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:88)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:80)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:245)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:221)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1045)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:172)
at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:74)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:59)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:333)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
</pre>
<br />
Did anyone face similar issue earlier? Please help us in resolving this issue. <br />
<br />
Any help would be highly appreciated.<br />
<br />
Thanks and Regards,<br />
<br />
Satish
