Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Exporting Reports from Windows to Linux Environment
Exporting Reports from Windows to Linux Environment [message #1589122] Wed, 28 January 2015 08:47 Go to next message
Thomas Tolksdorf is currently offline Thomas TolksdorfFriend
Messages: 3
Registered: January 2015
Junior Member
Hello,

I've got 3 different BIRT Reports, created with the Birt-Report-Designer 4.4.1.
Everything works fine on my Machine with Windows 7 installed an running on an Apache Tomcat 8.0.15 and jdk 1.7.0.67.
Database is Oracle 11g.

Now I need to change the Environment and export these 3 Reports to a Linux-Server.

Linux with Apache Tomcat 8.0.15 and jdk 1.7.0.67:


  • Report 1 - doesn't work, throws: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
  • Report 2 - works fine
  • Report 3 - exactly the same error as Report 1


Linux with Weblogic and jdk 1.7.0.67:


  • Report 1 - works fine
  • Report 2 - doesn't work, throws:
    org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details: Failed to prepare the query execution for the data set: test Cannot get the result set metadata. org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1:ORA-12704: character set mismatch ; java.sql.SQLException: ORA-12704: character set mismatch
  • Report 3 - doesn't work, throws:
    Multiple exceptions occurred.
    (basically ORA-12704: character set mismatch aswell)


Can someone help me with this? Maybe some Ideas on what to look at in my Reports / App Servers / Database?

I was able to trace the ORA-12704: character set mismatch in Weblogic to one Dataset (used in Report 2 and 3), which means: as soon as I added that Dataset to e.g. a table-binding I got that error.


That dataset has the following SQL query:

WITH papp AS
(
	SELECT ? AS appsession from dual
)
,pstart AS
(
	SELECT ? AS startdate from dual
)
,pgroup AS
(
	SELECT ? AS groupin from dual
)
,pend AS
(
	SELECT ? AS enddate from dual
)
,ptype AS
(
	SELECT ? AS stype from dual
)
,pdt AS
(
	SELECT ? AS datatype from dual
)
,pdt1 AS
(
	SELECT ? AS datatype1 from dual
)
,pdt2 AS
(
	SELECT ? AS datatype2 from dual
)
,pdt3 AS
(
	SELECT ? AS datatype3 from dual
)
,pdt4 AS
(
	SELECT ? AS datatype4 from dual
)
,pdt5 AS
(
	SELECT ? AS datatype5 from dual
)
,pdt6 AS
(
	SELECT ? AS datatype6 from dual
)
select
    trunc(v.TIME_STAMP, pgroup.groupin) "Datum"
	,case UPPER(m.display_type)
	  when 'AVG' then (
		case md.metric_id 
			when 1 then dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2),nvl(pdt1.datatype1,4))
			when 2 then dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2),nvl(pdt2.datatype2,4))
			when 3 then dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2),nvl(pdt3.datatype3,4))
			when 4 then dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2),nvl(pdt4.datatype4,4))
			when 5 then dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2),nvl(pdt5.datatype5,4))
			when 6 then dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2),nvl(pdt6.datatype6,4))
	  end
	  )
	  when 'MAX' then (
		case md.metric_id 
			when 1 then dbareport.dbareport_pkg.zData(round(max(v.metric_curr_value), 2),nvl(pdt1.datatype1,4))
			when 2 then dbareport.dbareport_pkg.zData(round(max(v.metric_curr_value), 2),nvl(pdt2.datatype2,4))
			when 3 then dbareport.dbareport_pkg.zData(round(max(v.metric_curr_value), 2),nvl(pdt3.datatype3,4))
			when 4 then dbareport.dbareport_pkg.zData(round(max(v.metric_curr_value), 2),nvl(pdt4.datatype4,4))
			when 5 then dbareport.dbareport_pkg.zData(round(max(v.metric_curr_value), 2),nvl(pdt5.datatype5,4))
			when 6 then dbareport.dbareport_pkg.zData(round(max(v.metric_curr_value), 2),nvl(pdt6.datatype6,4))
	  end
	  )
	  when 'MIN' then (
		case md.metric_id 
			when 1 then dbareport.dbareport_pkg.zData(round(min(v.metric_curr_value), 2),nvl(pdt1.datatype1,4))
			when 2 then dbareport.dbareport_pkg.zData(round(min(v.metric_curr_value), 2),nvl(pdt2.datatype2,4))
			when 3 then dbareport.dbareport_pkg.zData(round(min(v.metric_curr_value), 2),nvl(pdt3.datatype3,4))
			when 4 then dbareport.dbareport_pkg.zData(round(min(v.metric_curr_value), 2),nvl(pdt4.datatype4,4))
			when 5 then dbareport.dbareport_pkg.zData(round(min(v.metric_curr_value), 2),nvl(pdt5.datatype5,4))
			when 6 then dbareport.dbareport_pkg.zData(round(min(v.metric_curr_value), 2),nvl(pdt6.datatype6,4))
	  end
	  )
	  else dbareport.dbareport_pkg.zData(round(avg(v.metric_curr_value), 2), 0)
	end metric_curr_value
	
	,case UPPER(m.display_type) 
	  when 'AVG' then round(avg(v.metric_value),2)
	  when 'MAX' then round(max(v.metric_value),2)
	  when 'MIN' then round(min(v.metric_value),2)
	  else avg(v.metric_value)
	end metric_value
	, md.metric_id
	,case ptype.stype
		when 'C' then 
			case md.metric_id
			  when 1 then dbareport.dbareport_pkg.zDatatype(nvl(pdt1.datatype1,4))
			  when 2 then dbareport.dbareport_pkg.zDatatype(nvl(pdt2.datatype2,4))
			  when 3 then dbareport.dbareport_pkg.zDatatype(nvl(pdt3.datatype3,4))
			  when 4 then dbareport.dbareport_pkg.zDatatype(nvl(pdt4.datatype4,4))
			  when 5 then dbareport.dbareport_pkg.zDatatype(nvl(pdt5.datatype5,4))
			  when 6 then dbareport.dbareport_pkg.zDatatype(nvl(pdt6.datatype6,4))
			end
		else dbareport.dbareport_pkg.zDatatype(pdt.datatype)
	end datatype
    , c.customer_name || ' - ' || tt.target_type_desc || ' - ' ||
		t.target_name || ' - ' || m.metric_desc || ' - ' || md.metric_detail_desc description
from 	papp, pstart, pgroup, pend, ptype, pdt, pdt1,pdt2,pdt3,pdt4,pdt5,pdt6
	, dbareport.dbac_values v
    inner join dbareport.dbac_selection s
      on s.customer_id = v.customer_id
        and	s.target_id = v.target_id
        and s.metric_detail_id = v.metric_detail_id
    inner join dbareport.dbac_metric_detail md
      on md.metric_detail_id = s.metric_detail_id
    inner join dbareport.dbac_metric m
      on m.metric_id = md.metric_id
    inner join dbareport.dbac_target t
      on t.target_id = s.target_id
    inner join dbareport.dbac_target_type tt
      on t.target_type_id = tt.target_type_id
    inner join dbareport.dbac_customer c
      on s.customer_id = c.customer_id
where 
    s.SESSION_ID = papp.appsession and
    v.time_stamp between to_date(pstart.startdate, 'dd.mm.yyyy hh24:mi')
      and to_date(pend.enddate, 'dd.mm.yyyy hh24:mi')
group by
    trunc(v.TIME_STAMP, pgroup.groupin)
	, m.display_type
	, md.metric_id
	, ptype.stype
	, pdt.datatype
	, pdt1.datatype1
	, pdt2.datatype2
	, pdt3.datatype3
	, pdt4.datatype4
	, pdt5.datatype5
	, pdt6.datatype6
    , c.customer_name || ' - ' || tt.target_type_desc || ' - ' ||
		t.target_name || ' - ' || m.metric_desc || ' - ' || md.metric_detail_desc
order by 
    c.customer_name || ' - ' || tt.target_type_desc || ' - ' ||
		t.target_name || ' - ' || m.metric_desc || ' - ' || md.metric_detail_desc
    , trunc(v.TIME_STAMP, pgroup.groupin)



Complete errors:
Apache Tomcat 8.0.15, Report 1 and 3:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
   at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1114)
   at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1561)
   at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
   at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:237)
   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.GeneratedMethodAccessor65.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   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.GeneratedMethodAccessor64.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   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:644)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
   at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Thread.java:745)
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
   at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2380)
   at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:325)
   at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1555)
... 54 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.eclipse.birt.chart.device.svg.SVGRendererImpl
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:190)
   at org.eclipse.birt.core.framework.jar.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:46)
   at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:35)
   at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1252)
   at org.eclipse.birt.chart.util.PluginSettings.getDevice(PluginSettings.java:632)
   at org.eclipse.birt.chart.api.ChartEngine.getRenderer(ChartEngine.java:119)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.prepareDeviceRenderer(ChartReportItemPresentationBase.java:1222)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.generateRenderObject(ChartReportItemPresentationBase.java:971)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:904)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
   at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1074)
   at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:591)
   at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:176)
   at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
   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.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.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)
   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.HTMLListLM.layoutChildren(HTMLListLM.java:72)
   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.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:717)
   at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:321)


Weblogic - Report 2:

org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: test
Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:ORA-12704: character set mismatch

;
java.sql.SQLException: ORA-12704: character set mismatch

   at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1245)
   at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1224)
   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
   at org.eclipse.birt.report.engine.executor.ListItemExecutor.execute(ListItemExecutor.java:66)
   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.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:269)
   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)
   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
   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:118)
   at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:103)
   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:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   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.GeneratedMethodAccessor155.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   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:751)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
   at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
   at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
   at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
   at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:341)
   at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
   at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
   at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
   at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3367)
   at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3333)
   at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
   at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
   at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
   at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2220)
   at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2146)
   at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2124)
   at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1564)
   at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
   at weblogic.work.ExecuteThread.execute(ExecuteThread.java:295)
   at weblogic.work.ExecuteThread.run(ExecuteThread.java:254)
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: test
Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:ORA-12704: character set mismatch

;
java.sql.SQLException: ORA-12704: character set mismatch

   at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:657)
   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
   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:275)
   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)
   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 65 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: test
Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:ORA-12704: character set mismatch

;
java.sql.SQLException: ORA-12704: character set mismatch

   at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:350)
   at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)
   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:178)
   at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:637)
... 70 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:ORA-12704: character set mismatch

;
java.sql.SQLException: ORA-12704: character set mismatch

   at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
   at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
   at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)
   at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:414)
   at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:377)
   at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.declareCustomColumn(PreparedStatement.java:1223)
   at org.eclipse.birt.data.engine.executor.DataSourceQuery.addCustomFields(DataSourceQuery.java:684)
   at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepareColumns(DataSourceQuery.java:407)
   at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:345)
   at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:517)
   at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:346)
... 75 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:ORA-12704: character set mismatch

;
java.sql.SQLException: ORA-12704: character set mismatch

   at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:481)
   at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingPolicy1(Statement.java:420)
   at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:316)
   at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(BidiStatement.java:56)
   at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:423)
   at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)
   at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)
... 82 more
Caused by: java.sql.SQLException: ORA-12704: character set mismatch

   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
   at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
   at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3594)
   at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3638)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
   at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:477)
... 88 more 
Re: Exporting Reports from Windows to Linux Environment [message #1589655 is a reply to message #1589122] Wed, 28 January 2015 15:21 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

In Tomcat, it seems to be having problems with the SVG renderer. Could you try changing the charts in those reports (I'm assuming those reports have charts) from SVG to PNG to see if that solves the issue?

Michael

Developer Evangelist, Silanis
Re: Exporting Reports from Windows to Linux Environment [message #1591049 is a reply to message #1589655] Thu, 29 January 2015 09:38 Go to previous messageGo to next message
Thomas Tolksdorf is currently offline Thomas TolksdorfFriend
Messages: 3
Registered: January 2015
Junior Member
Hi Michael,

Thanks for your response.
You were right that there are Charts in those 2 Reports.
I tried your suggestion (First with PNG, then with JPG) and the Error-Msg changed.
Now it's
Caused by: java.lang.NoClassDefFoundError: org.eclipse.birt.chart.device.swing.SwingRendererImpl


instead of the previous SVGRenderer.
Basically means the Chart-rendering is my Problem here (atleast with the Tomcat Server), right?
Any Idea what I could do from here on?

Full "new" Error-MSG:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
   at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1114)
   at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1561)
   at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
   at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:237)
   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.GeneratedMethodAccessor65.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   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.GeneratedMethodAccessor64.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   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:644)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
   at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Thread.java:745)
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
   at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2380)
   at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:325)
   at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1555)
... 54 more
Caused by: java.lang.NoClassDefFoundError: org.eclipse.birt.chart.device.swing.SwingRendererImpl
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:190)
   at org.eclipse.birt.core.framework.jar.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:46)
   at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:35)
   at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1252)
   at org.eclipse.birt.chart.util.PluginSettings.getDevice(PluginSettings.java:632)
   at org.eclipse.birt.chart.api.ChartEngine.getRenderer(ChartEngine.java:119)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.prepareDeviceRenderer(ChartReportItemPresentationBase.java:1222)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.generateRenderObject(ChartReportItemPresentationBase.java:971)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:904)
   at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
   at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1074)
   at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:591)
   at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:176)
   at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
   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.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.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)
   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.HTMLListLM.layoutChildren(HTMLListLM.java:72)
   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.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:717)
   at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:321)
... 55 more
Re: Exporting Reports from Windows to Linux Environment [message #1591686 is a reply to message #1591049] Thu, 29 January 2015 17:37 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Are you using the Oracle jdk or Open jdk? And you've got the jdk, not just the jre, correct?

Michael

Developer Evangelist, Silanis
Re: Exporting Reports from Windows to Linux Environment [message #1592944 is a reply to message #1591686] Fri, 30 January 2015 10:17 Go to previous messageGo to next message
Thomas Tolksdorf is currently offline Thomas TolksdorfFriend
Messages: 3
Registered: January 2015
Junior Member
I am using the Oracle JDK,
jdk1.7.0_67 in both the windows and the linux environment.

Saw that "solution" in another forum post aswell and therefore double-checked it.
Re: Exporting Reports from Windows to Linux Environment [message #1601338 is a reply to message #1592944] Wed, 04 February 2015 22:15 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

You might try using the OSGi runtime instead of the POJO runtime to see if that works.

Michael

Developer Evangelist, Silanis
Re: Exporting Reports from Windows to Linux Environment [message #1634853 is a reply to message #1601338] Wed, 25 February 2015 13:42 Go to previous messageGo to next message
Prathyush S is currently offline Prathyush SFriend
Messages: 10
Registered: February 2015
Junior Member
Can you please share how to deploy the '.rptdesing' file in linux.
Report working WINDOWS but not in the LINUX.
Whenever I run the report in tomcat from linux it throws a Exception.
org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver:
org.eclipse.birt.report.data.oda.jdbc.dbprofile.
org.eclipse.datatools.connectivity.oda.OdaException: Unable to find the connection profile referenced by the data source connection properties. ;
org.eclipse.datatools.connectivity.oda.OdaException: Unable to find or access the named profile (birtconnectionprofile) in profile store path (/home/pro/Liferay/BIRTReport/BirtReport/lib/birtconnectionprofile). ;
org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. (Element ID:95)
Hide Exception Stack Trace

Stack Trace:
org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
org.eclipse.datatools.connectivity.oda.OdaException: Unable to find the connection profile referenced by the data source connection properties. ;
org.eclipse.datatools.connectivity.oda.OdaException: Unable to find or access the named profile (birtconnectionprofile) in profile store path (/home/pro/Liferay/BIRTReport/BirtReport/lib/birtconnectionprofile). ;
org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. (Element ID:95)
       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).
Re: Exporting Reports from Windows to Linux Environment [message #1654966 is a reply to message #1634853] Fri, 06 March 2015 23:00 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Sorry for the delay. You'd set the default workspace in the web.xml. It should be the root directory of the viewer by default.

Michael

Developer Evangelist, Silanis
Re: Exporting Reports from Windows to Linux Environment [message #1689398 is a reply to message #1654966] Mon, 23 March 2015 13:47 Go to previous messageGo to next message
Prathyush S is currently offline Prathyush SFriend
Messages: 10
Registered: February 2015
Junior Member
Can you please share how to set the default workspace in the web.xml.
I am completely new to birt report.
Re: Exporting Reports from Windows to Linux Environment [message #1690063 is a reply to message #1689398] Tue, 24 March 2015 22:10 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Navigate to WEB-INF/web.xml, find the BIRT_VIEWER_WORKING_FOLDER parameter and set a value. You'll see above the parameter that the default value is BIRT home.

Michael

Developer Evangelist, Silanis
Previous Topic:Report Deployment
Next Topic:Cannot get any Library file to work
Goto Forum:
  


Current Time: Sun Jul 14 04:25:09 GMT 2024

Powered by FUDForum. Page generated in 0.03326 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top