[M_Terk]

I am try to create a simple table dashboard and some of the time when I open it I get an error that says

Invalid data set name.

If I hit refresh in the table, the error goes away and the data shows up. The trace in the iServer log file does not shine any light on what data set name it finds invalid and how that problem gets fixed if I hit refresh??

Anyone came across this? This is from iServer 11. Here is the partial error stack:
-----------------------------------------------
Task type: Report viewing
Task state: Finished
Task startup time: Mon Aug 15 17:49:07 CDT 2011
User name: administrator
Request type:
Request ID:
Volume name: VirBIRT
authid:cfMOutp7qK/gM5Qn76hbeydBSvE/zgzYtn+ncP17GV0mAWZLLDlpTHakNYYz1XXDX/W64LbGOSshsuMkKzsMfkmS//oyTLiMmfNUIwM52BH8sjlB4XjEzTJcBusupm7+
serverURI:http://virbirt:11100
MaxDuration:0com.actuate.reportapi.enginemanager.JREMException: Cannot view report. Cause: There are errors in the document: Invalid data set name.
Invalid data set name.
Invalid data set name.
.
at com.actuate.birt.report.engine.internal.dashboard.DashboardRenderTask.render(DashboardRenderTask.java:93)
at com.actuate.reportapi.engine.birt.ViewReportTask.renderReport(Unknown Source)
at com.actuate.reportapi.engine.birt.ViewReportTask.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.engine.api.EngineException: There are errors in the document: Invalid data set name.
Invalid data set name.
Invalid data set name.
.
... 6 more
[Thread 15, 3439] 2011-08-15 17:49:08 UTC-0500 com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run()
WARNING: [Ljava.lang.StackTraceElement;@72d14026
[Thread 40] 2011-08-15 17:49:10 UTC-0500 com.actuate.server.config.ServerConfig.readAcServerConfig()
WARNING: Reading acserverconfig.xml file from C:\Actuate11\iServer\data\config/acserverconfig.xml
[Thread 40] 2011-08-15 17:49:10 UTC-0500 com.actuate.server.config.AcServerConfigReader.createAcServerConfigData()
WARNING: Read acserverconfig file successfully
[Thread 40] 2011-08-15 17:49:10 UTC-0500 com.actuate.javaserver.Server.updateServerConfig()
WARNING: Synchronous report generation timeout has been changed to 300 seconds
[Thread 12] 2011-08-15 17:49:16 UTC-0500 com.actuate.javaserver.OnlineVolumeMonitor.run()
WARNING: null
[Thread 12] 2011-08-15 17:50:16 UTC-0500 com.actuate.javaserver.OnlineVolumeMonitor.run()
WARNING: null
[Thread 12] 2011-08-15 17:51:16 UTC-0500 com.actuate.javaserver.OnlineVolumeMonitor.run()
WARNING: null
[Thread 12] 2011-08-15 17:52:16 UTC-0500 com.actuate.javaserver.OnlineVolumeMonitor.run()
WARNING: null
[Thread 12] 2011-08-15 17:53:16 UTC-0500 com.actuate.javaserver.OnlineVolumeMonitor.run()
WARNING: null
[Thread 16, 3481] 2011-08-15 17:53:53 UTC-0500 org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare()
SEVERE: Invalid data set name.org.eclipse.birt.data.engine.core.DataException: Invalid data set name.
at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:80)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:207)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:298)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:239)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:147)
at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:548)
at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:275)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
[Thread 16, 3481] 2011-08-15 17:53:53 UTC-0500 org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare()
SEVERE: Invalid data set name.org.eclipse.birt.data.engine.core.DataException: Invalid data set name.
at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:80)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:207)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:298)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:239)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:147)
at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:548)
at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:275)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
[Thread 16, 3481] 2011-08-15 17:53:53 UTC-0500 org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare()
SEVERE: Invalid data set name.org.eclipse.birt.data.engine.core.DataException: Invalid data set name.
at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:80)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:207)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:298)
at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:239)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:147)
at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:548)
at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:275)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
[Thread 16, 3481] 2011-08-15 17:53:53 UTC-0500 com.actuate.reportapi.engine.birt.BirtUtil.logBirtEngineError()

[averma]

Hi M_Terk,
Can you describe the gadget that you are using and the data source that causes this issue? I am suspecting that the data source definition is being changed behind the scene. If thats not the case can you tell what browser and operating system you are using? And what version of BIRT iServer is it?

Ashwini

[M_Terk]

averma, on 16 August 2011 - 09:52 AM, said:

Hi M_Terk,
Can you describe the gadget that you are using and the data source that causes this issue? I am suspecting that the data source definition is being changed behind the scene. If thats not the case can you tell what browser and operating system you are using? And what version of BIRT iServer is it?

Ashwini

I am using a table gadget and the data source is a simple select query to an informix database. I am running in IE 9 on windows 7. The Birt iServer is version 11.

WHat is weird that half of the time the dashboard works and the rest of the time it give this error.

MT

[Frostscar]

M_Terk, on 16 August 2011 - 07:02 PM, said:

I am using a table gadget and the data source is a simple select query to an informix database. I am running in IE 9 on windows 7. The Birt iServer is version 11.

WHat is weird that half of the time the dashboard works and the rest of the time it give this error.

MT

M_Terk,

From the error log it looks as if you are using a .datadesign as data source of gadget. In execution BIRT will first try to materialize that .datadesign to a .data file and then execute based on the .data file.

An immediately workaround for your problem might be use a .data file rather than .datadesign in your gadget. Though this is not a fix to the problem.

I am not quite sure why sometimes we cannot find the data set in .datadesign, maybe you can attach you datadesign so that we can take a further look.

Thanks.
Lin

[M_Terk]

Thanks,

I decided to pull this apart and start from scratch. I realy need it to update from a datadesign, since i can not easily schedule the report to genereate every 5 minutes.

MT

Frostscar, on 17 August 2011 - 11:18 AM, said:

M_Terk,

From the error log it looks as if you are using a .datadesign as data source of gadget. In execution BIRT will first try to materialize that .datadesign to a .data file and then execute based on the .data file.

An immediately workaround for your problem might be use a .data file rather than .datadesign in your gadget. Though this is not a fix to the problem.

I am not quite sure why sometimes we cannot find the data set in .datadesign, maybe you can attach you datadesign so that we can take a further look.

Thanks.
Lin