You are not logged in.
Pages: 1
Topic closed
Hi,
I created Knime birt report in eclipse knime. Knime birt report has the extension .rptdesign. Whenever I am trying to publish knime birt report in to report server I didn't get any data. How can I resolve this problem. Please help me any one is there any solution for this one.
Thanks
Offline
Hi,
try to export the report as HTML. The pdf-preview does not always show relevant error messages. If that doesn't help, check the logfiles for related error messages.
Cheers,
Thorsten
Hi,
Can we publish knime birt report in report server. I tried to export as html. But it is not working. I got the following error message while export as html.
The following items have errors:
Table (id = 25):
+ An exception occurred during processing. Please see the following message for details:
Cannot find or process the com.knime.oda.data.source driver's data source extension configuration.
Cannot find the ODA dataSource extension (com.knime.oda.data.source).
Check the workspace log file for any problems with loading the extension bundle and its dependencies.
I checked in log. I got the following error.
12:28:19,293 WARN StatefulPersistenceContext:722 - HHH000179: Narrowing proxy t
o class net.datenwerke.rs.core.service.reportmanager.entities.ReportFolder - thi
s operation breaks ==
Sep 04, 2014 12:28:27 PM org.eclipse.birt.data.engine.odaconsumer.Driver doGetDr
iverManifest
SEVERE: Cannot find or process the ODA data source extension configuration.
java.lang.IllegalArgumentException: Cannot find the ODA dataSource extension (co
m.knime.oda.data.source).
Check the workspace log file for any problems with loading the extension bundle
and its dependencies.
at org.eclipse.datatools.connectivity.oda.util.manifest.ManifestExplorer
.getExtensionManifest(ManifestExplorer.java:200)
at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(D
river.java:152)
at org.eclipse.birt.data.engine.odaconsumer.Driver.findDataSourceExtensi
onConfig(Driver.java:128)
at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverExtensionCon
fig(Driver.java:79)
at org.eclipse.birt.data.engine.odaconsumer.Driver.getExtensionConfig(Dr
iver.java:61)
at org.eclipse.birt.data.engine.odaconsumer.Driver.createNewDriverHelper
(Driver.java:99)
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelpe
r(DriverManager.java:115)
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getNewDriverHe
lper(DriverManager.java:101)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnec
tion(ConnectionManager.java:150)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSo
urce.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java
:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource
(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryE
xecutor.java:435)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(Quer
yExecutor.java:322)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQue
ry.java:463)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQuer
yResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Pre
paredDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(Prepared
OdaDSQuery.java:178)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.exec
ute(DataRequestSessionImpl.java:637)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(
DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Ab
stractDataEngine.java:275)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery
(ExecutionContext.java:1947)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuer
y(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(Tab
leItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicat
eItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportIt
emExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReport
ItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPage
LM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.lay
out(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAnd
RenderTask.java:181)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRe
nderTask.java:77)
at net.datenwerke.rs.birt.service.reportengine.output.generator.BirtPDFO
utputGenerator.exportReport(BirtPDFOutputGenerator.java:33)
at net.datenwerke.rs.birt.service.reportengine.sandbox.BirtEngineEnviron
ment.call(BirtEngineEnvironment.java:89)
at net.datenwerke.rs.birt.service.reportengine.BirtReportEngine.executeR
eport(BirtReportEngine.java:104)
at net.datenwerke.rs.birt.service.reportengine.BirtReportEngine.doExecut
e(BirtReportEngine.java:70)
at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.exec
ute(ReportEngine.java:127)
at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImp
l.execute(ReportExecutorServiceImpl.java:186)
at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImp
l.execute(ReportExecutorServiceImpl.java:119)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeuct
eReport(ReportExportServlet.java:467)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.export
Report(ReportExportServlet.java:358)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.export
ReportViaSession(ReportExportServlet.java:293)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(
ReportExportServlet.java:155)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$Enhan
cerByGuice$$5499ea5c.CGLIB$doGet$1(<generated>)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$Enhan
cerByGuice$$5499ea5c$$FastClassByGuice$$20dc2f8a.invoke(<generated>)
at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(Metho
dProxy.java:228)
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethod
Invocation.proceed(InterceptorStackCallback.java:72)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalT
xnInterceptor.java:66)
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethod
Invocation.proceed(InterceptorStackCallback.java:72)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor
.invoke(SecurityCheckInterceptor.java:110)
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethod
Invocation.proceed(InterceptorStackCallback.java:72)
at com.google.inject.internal.InterceptorStackCallback.intercept(Interce
ptorStackCallback.java:52)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$Enhan
cerByGuice$$5499ea5c.doGet(<generated>)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$Enhan
cerByGuice$$5499ea5c.CGLIB$service$14(<generated>)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$Enhan
cerByGuice$$5499ea5c$$FastClassByGuice$$20dc2f8a.invoke(<generated>)
at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(Metho
dProxy.java:228)
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethod
Invocation.proceed(InterceptorStackCallback.java:72)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor
.invoke(SecurityCheckInterceptor.java:110)
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethod
Invocation.proceed(InterceptorStackCallback.java:72)
at com.google.inject.internal.InterceptorStackCallback.intercept(Interce
ptorStackCallback.java:52)
at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$Enhan
cerByGuice$$5499ea5c.service(<generated>)
at com.google.inject.servlet.ServletDefinition.doService(ServletDefiniti
on.java:263)
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition
.java:178)
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServl
etPipeline.java:91)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainI
nvocation.java:62)
at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:8
9)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.
java:163)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainI
nvocation.java:58)
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilte
rPipeline.java:118)
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1023)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
at java.lang.Thread.run(Thread.java:745)
Please help me.
Last edited by kusuma.kolasani (2014-09-04 12:35:31)
Thanks
Offline
Hi All,
Can anybody help me for the problem? I did not get solution till now. It is very urgent work.
Thanks
Offline
Hi Kusuma,
unfortunately no one here has any experience with knime so it's hard to offer good advice.
But from the quick glance I took, I'd say what you are trying to do won't work. If I understand this correctly knime extends birt with a custom datasource that feeds your workflow data directly into the report engine. If you try to execute the report outside of knime there is no way to retrieve the data.
An alternative might be to have your knime workflow write its results to a database and use regular (as in not knime specific) birt reports that access this database. You can than add these reports to ReportServer.
If you use knimes batch mode you can update your database automatically at a given interval or using ReportServer scripts build something that refreshes your data, whenever a report is executed.
Hope that helps,
Thorsten
Hi,
Thank you giving a good way to do. I will try this one.
Thanks
Offline
Pages: 1
Topic closed