<p>Hi,</p>
<p> </p>
<p>I'm trying to populate classic dataset data to scripted dataset. But i am getting 17070 error message.</p>
<p> </p>
<p>in open :-</p>
<p> </p>
<div>importPackage(Packages.java.lang);</div>
<div>importPackage(Packages.org.eclipse.birt.report.data.adapter.api);</div>
<div>importPackage(Packages.org.eclipse.birt.report.model.api);</div>
<div>importPackage(Packages.org.eclipse.birt.data.engine.api.querydefn);</div>
<div> </div>
<div> </div>
<div>var config = reportContext.getReportRunnable().getReportEngine().getConfig();</div>
<div>var dataSource = reportContext.getDesignHandle().findDataSource("Classic_DS");</div>
<div>var dataSet = reportContext.getDesignHandle().findDataSet("C_DS");</div>
<div> </div>
<div>mySession = DataRequestSession.newSession(config, new DataSessionContext(DataSessionContext.MODE_DIRECT_PRESENTATION));</div>
<div>mySession.defineDataSource(mySession.getModelAdaptor().adaptDataSource(dataSource));</div>
<div>mySession.defineDataSet(mySession.getModelAdaptor().adaptDataSet(dataSet));</div>
<div> </div>
<div>queryDefinition = new QueryDefinition();</div>
<div>queryDefinition.setDataSetName(dataSet.name);</div>
<div>queryDefinition.setAutoBinding(true);</div>
<div> </div>
<div>var pq = mySession.prepare(queryDefinition);</div>
<div>query = pq.execute(null);</div>
<div>recordsIterator = query.getResultIterator();</div>
<div> </div>
<div>fetch :-</div>
<div> </div>
<div>
<div>if (recordsIterator.next()) {</div>
<div>row["CUSTOMERNAME"] = recordsIterator.getValue("CUSTOMERNAME");</div>
<div>row["CITY"] = recordsIterator.getValue("CITY");</div>
<div>return true;</div>
<div>}else {</div>
<div>return false;</div>
<div>}</div>
<div> </div>
<div> </div>
<div>What was wrong in my code? Please ping .rptdesign file in the attachments.</div>
<div> </div>
<div>How to debug or log console?</div>
<div> </div>
<div>Thanks,</div>
<div>Srinivas</div>
</div>
