Error when creating a report from a data object

<p>Version used - Actuate BIRT Designer Professional </p><div>Version: 3.7.2</div><div>Build id: 20130129</div><div> </div><div>When I create a regular Birt report, create a data source, data set - go to preview - everything is fine, run the report no problems</div><div> </div><div>When I create a data object with the similar data source and data set and try and create a report off of this data object, nothing works. First I get an exception even doing a preview in data sets. Details of the exception follows</div><div> </div><div><div>org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</div><div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:299)</div><div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:261)</div><div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:72)</div><div>at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:68)</div><div>at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:338)</div><div>at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)</div><div>Caused by: java.lang.NullPointerException</div><div>at com.actuate.birt.data.adapter.DataMartUtil$DataMartDesign.getHidenParameterIterator(DataMartUtil.java:152)</div><div>at com.actuate.birt.data.interceptors.datamart.Utils.collectDataMartParams(Utils.java:52)</div><div>at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:111)</div><div>at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:216)</div><div>at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:294)</div><div>at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:235)</div><div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:327)</div><div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:290)</div><div> </div><div>

</div><div> </div><div>I get this exception everywhere. When I publish the data object to iHub and try to create a report from iHub, I get the same exception.</div><div> </div><div>Database info - Sybase ASA 11.</div><div> </div><div>One final note: I am very familiar with open source birt but not with actuate professional. I have just started to evaluate the product. There is a strong chance I might have done something incorrect as this looks like a user error.</div><div> </div><div>I will appreciate any info on this one as I am really stuck.</div><div> </div><div>Thanks,</div><div> Ravi</div></div><p> </p>

Find more posts tagged with

Comments

kclark

<p>Can you post your database URL that you are using? What driver class are you selecting when creating a new JDBC data source?</p>

rveeraraghav

<p>I have a local sybase ASA database server running. So, I use the following.</p><p> </p><p>Driver Class - com.sybase.jdbc3.jdbc.SybDriver (v6.0)</p><p>Database URL - jdbc:sybase:Tds:localhost:2638</p><p> </p><p>Also, when I do a Test Connection it comes back as a success, </p><p> </p><p>Before all this, as per documentation, I copied the driver (jconn3-6.05.jar) to <span style="font-size:9pt;font-family:courierstd;">$ACTUATE_HOMEiHubJarBIRTplatformplugins</span><span style="font-size:9pt;font-family:courierstd;">org.eclipse.birt.report.data.oda.jdbc_<VERSION>drivers</span></p><div> </div><p>One more thing, I get the same exception even when I create a report from Birt designer pro. As soon as I Open the Data set and go to Preview results, I get the same error. ( of course for designer, I added the jar file via manage drivers )</p><p> </p><p>Thanks,</p><p> Ravi</p>

dmelcher

<p>Ravi,</p><p> Just curious: Did you try using the Actuate-supplied JDBC driver for Sybase? In BRD Pro's JDBC Data Source component, there is a Driver Class dropdown where you can select com.actuate.jdbc.sybase.SybaseDriver (Actuate Sybase Driver).</p><p> </p><p>This may eliminate the need for you to deploy and maintain an extra driver.</p><p> </p><p>Hope this helps,</p><p>Dan</p>

rveeraraghav

<p>Hi Dan,</p><p></p><p> </p><p> and when I enter <strong>db=mydb</strong> or <strong>db_name=mydb</strong> for PROP=VALUE, I get errors. I couldn't find an example for this driver.</p><p> </p><p></p><p>Thanks in advance,</p><p> Ravi</p>

rveeraraghav

<p>in my previous post, it keeps stripping off sentences.</p><p>I am creating a new post as a result.</p><p>I tried using actuate supplied sybase driver</p><p>I am not sure what the values for PROP=VALUE needs to be for database url. If I use db=NAME or db_name=NAME I get exceptions</p><p>if I don't set any PROP=VALUE, I get null pointer exceptions.</p><p> </p><p>This explanation was part of the previous post which seems to have been posted in parts and pieces.</p><p>Thanks,</p><p> Ravi</p>