SAPJCO media error with Birt

Rama_Reddy · 2009-08-08T06:27:22+00:00

Hi Experts, please help me with this. i have created java class to fetch data from SAP system using SAP JCO connector. code import java.lang.reflect.Array; import java.util.Arrays; import org.eclipse.birt.report.engine.api.script.IScriptedDataSetMetaData; import…

Rama_Reddy

Hi Experts, 
please help me with this. i have created java class to fetch data from SAP system using SAP JCO connector.

code

import java.lang.reflect.Array; 
import java.util.Arrays; 
 
import org.eclipse.birt.report.engine.api.script.IScriptedDataSetMetaData; 
import org.eclipse.birt.report.engine.api.script.IUpdatableDataSetRow; 
import org.eclipse.birt.report.engine.api.script.eventadapter.ScriptedDataSetEventAdapter; 
import org.eclipse.birt.report.engine.api.script.instance.IDataSetInstance; 
import com.sap.mw.jco.*; 
public class MyScriptedDataSet extends ScriptedDataSetEventAdapter { 
public int recordCount = 0; 
public String[][] buffer; 
R3Table table; 
SapDataSource sds; 
 
@Override 
public boolean fetch(IDataSetInstance dataSet,IUpdatableDataSetRow row ) { 
try{ 
 
if(buffer.length<1) return false; 
for(int i=0;i<buffer.length;i++){ 
for(int j=0;j<buffer.length;j++) row.setColumnValue(buffer[0][j], buffer[j]); 
} 
return true; 
 
}catch( Exception e ){ 
e.printStackTrace(); 
sds.disconnect(); 
return false; 
} 
} 
@Override 
public void open( IDataSetInstance dataSet ) { 
String[] arr={"110","sysadm","basis56","EN","10.28.32.23","00","0","0","T002","",""}; 
sds=new SapDataSource(arr); 
table=sds.getTable(); 
} 
public void dataBuffer(){ 
 
String info; 
try{ 
MyScriptedDataSet msds=new MyScriptedDataSet(); 
 
for(int j=0;j<msds.table.getNumRows();j++){ 
 
for(int i=0; i<msds.table.getMetaData().getFieldCount();i++) 
{ 
if(j==0){ 
info=msds.table.getMetaData().getName(i); 
} 
else{ 
info=(String) msds.table.getValue(i); 
} 
buffer[j]=info; 
} 
} 
 
sds.disconnect(); 
}catch( Exception e ){ 
e.printStackTrace(); 
sds.disconnect(); 
 
} 
} 
public static void main(String[] args){ 
String[] arr={"110","sysadm","basis56","EN","10.28.32.23","00","0","0","T002","",""}; 
SapDataSource sds1=new SapDataSource(arr); 
R3Table table1=sds1.getTable(); 
for(int j=0;j<table1.getNumRows();j++){ 
for(int i=0; i<table1.getMetaData().getFieldCount();i++) 
{ 
System.out.print(table1.getMetaData().getName(i)+":"+table1.getValue(i)); 
 
} 
System.out.println(" "); 
} 
} 
}

when is execute it as Java Application in eclpise. its working fine but when i run this in the from the report i am getting following error..

Error

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) 
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) 
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) 
at org.mortbay.http.HttpServer.service(HttpServer.java:909) 
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) 
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) 
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) 
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) 
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) 
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report 
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:259) 
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90) 
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246) 
... 51 more 
Caused by: 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:sapjcosapjcorfc.dll already loaded in another classloader]. java.library.path [D:eclipse;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:/Program Files/Java/jdk1.6.0_02/bin/../jre/bin/client;C:/Program Files/Java/jdk1.6.0_02/bin/../jre/bin;d:share;c:sapjco;c:sapjcosapjco.jar;C:Program FilesJavajdk1.6.0_02bin;C:usrsitebin;C:usrbin;D:Program FilesMySQLMySQL Server 5.1bin;C:usrbin;C:Perlbin;D:oracleora92bin;c:program filessdbprogramsbin;c:program filessdbprogramspgm;;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program FilesIntelDMIX;C:Program FilesOpenOffice.org 3program;C:Program FilesOpenOffice.org 3Basisprogram;C:Program FilesOpenOffice.org 3Basisprogramclasses] 
at com.sap.mw.jco.JCO.(JCO.java:776) 
at SapDataSource.(SapDataSource.java:37) 
at MyScriptedDataSet.(MyScriptedDataSet.java:14) 
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) 
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) 
at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 
at java.lang.Class.newInstance0(Class.java:355) 
at java.lang.Class.newInstance(Class.java:308) 
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.getInstance(ScriptExecutor.java:129) 
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.initEventHandler(DataSetScriptExecutor.java:62) 
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.initEventHandler(ScriptDataSetScriptExecutor.java:56) 
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.(DataSetScriptExecutor.java:47) 
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.(ScriptDataSetScriptExecutor.java:47) 
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.newScriptDataSet(ModelDteApiAdapter.java:625) 
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.createDataSetDesign(ModelDteApiAdapter.java:220) 
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:288) 
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:247) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:140) 
at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:118) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) 
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:76) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) 
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:51) 
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:209) 
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237) 
... 53 more

What could be wrong here.. i have cheked the calss path. it looks fine to me. it points to the sapjco.jar and in path it points to sapjcorfc.dll. 
 
Thanks 
Ramakrishna

Find more posts tagged with

Comments

Rama_Reddy

Hi,
Now, I can preview results for Scripted Data Set from SAP system. but when i run the report in Eclipse Designer, I am gettng the Exception for evaluationg the script. can any one suggest whats wrong. Thanks...

org.eclipse.birt.report.engine.api.EngineException: Unhandled exception when executing script.
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:187)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:170)
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:139)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)
at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)
at org.eclipse.birt.data.engine.executor.cache.SmartCache.(SmartCache.java:74)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:156)
at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:92)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
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:45)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)
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.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
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.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:269)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: org.eclipse.birt.data.engine.core.DataException: data.engine.BadFetchScriptReturnType
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:129)
... 89 more