Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Null parameter(How to pass null parameter)
Null parameter [message #1062237] Thu, 06 June 2013 12:16 Go to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Hi Experts,

As per my requirement one parameter is optional, If there is no value in the parameter iam getting error. how to pass null parameter in report at run time.

Thanks
RED


Thanks,
JP
Re: Null parameter [message #1062555 is a reply to message #1062237] Sat, 08 June 2013 20:33 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

In the parameter editor, did you uncheck the "is required" check box?

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Null parameter [message #1063637 is a reply to message #1062555] Thu, 13 June 2013 10:54 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Yes uncheck the check box, but it is throughing the error. I have changed the scenario and written script on dataSet also getting error. Attached is the report and below is the error. Please suggest me.

Thanks,
The following items have errors:
Script on Dataset

Table (id = 6):
+ There are errors evaluating script "queryText = "Select employeenumber,";
queryText = queryText + "lastname,";
queryText = queryText + "firstname,";
queryText = queryText + "extension,";
queryText = queryText + "email,";
queryText = queryText + "officecode,";
queryText = queryText + "reportsto,";
queryText = queryText + "jobtitle";
queryText = queryText + " from employees";
if (params["P_employeenumber"] && params["P_employeenumber"].value.length > 0) {
queryText = queryText + "where employeenumber >= " + params["P_employeenumber"].value;
}
else {
queryText = "Select employeenumber,";
queryText = queryText + "lastname,";
queryText = queryText + "firstname,";
queryText = queryText + "extension,";
queryText = queryText + "email,";
queryText = queryText + "officecode,";
queryText = queryText + "reportsto,";
queryText = queryText + "jobtitle";
queryText = queryText + " from employees";
}".


Thanks,
JP
Re: Null parameter [message #1064171 is a reply to message #1063637] Tue, 18 June 2013 01:08 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Any Suggestions..................


Thanks,
JP
Re: Null parameter [message #1064394 is a reply to message #1064171] Wed, 19 June 2013 01:21 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

Sorry. I was out of town at the end of last week. Can you expand the error by clicking on the '+' and post the entire stack in here? Thanks!

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Null parameter [message #1064480 is a reply to message #1064394] Wed, 19 June 2013 09:07 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Thanks Williams,
There is nothing in the + sign. below is the message after clicking on the +.

Table (id = 6):
- There are errors evaluating script "queryText = "Select employeenumber,";
queryText = queryText + "lastname,";
queryText = queryText + "firstname,";
queryText = queryText + "extension,";
queryText = queryText + "email,";
queryText = queryText + "officecode,";
queryText = queryText + "reportsto,";
queryText = queryText + "jobtitle";
queryText = queryText + " from employees";
if (params["P_employeenumber"] && params["P_employeenumber"].value.length > 0) {
queryText = queryText + "where employeenumber >= " + params["P_employeenumber"].value;
}
else {
queryText = "Select employeenumber,";
queryText = queryText + "lastname,";
queryText = queryText + "firstname,";
queryText = queryText + "extension,";
queryText = queryText + "email,";
queryText = queryText + "officecode,";
queryText = queryText + "reportsto,";
queryText = queryText + "jobtitle";
queryText = queryText + " from employees";
}".


Thanks,
JP
Re: Null parameter [message #1064533 is a reply to message #1064480] Wed, 19 June 2013 14:03 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

If you change your beforeOpen script to simply have this, it should work:

if (params["P_EMPLOYEENUMBER"].value != null && params["P_EMPLOYEENUMBER"].value != "") {
 this.queryText = this.queryText + " where employeenumber >= " + params["P_EMPLOYEENUMBER"].value;
}


The issues in your script above was that the parameter is all uppercase and there is no space before "where". It probably also wouldn't have worked as you wanted with your conditions.

Hope this helps.


Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Null parameter [message #1064915 is a reply to message #1064533] Fri, 21 June 2013 11:51 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Williams,

Thanks for your suggestions and it's worked fine with sample report. When i implemented the same in my report it is throughing exceptions as follows.

if (params["P_SALESREP_ID"].value != null && params["P_SALESREP_ID"].value != "") {
this.queryText = this.queryText + " AND f.name = '" + params["P_SALESREP_ID"].value + "'";
}

Please don't hesitate to suggest me.





Table (id = 12):
- Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00933: SQL command not properly ended


odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the result set metadata.SQL statement does not return a ResultSet object.SQL error #1: ORA-00933: SQL command not properly ended at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:379) at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:339) at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.declareCustomColumn(PreparedStatement.java:1079) at org.eclipse.birt.data.engine.executor.DataSourceQuery.addCustomFields(DataSourceQuery.java:388) at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:256) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344) at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:212) at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:397) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:147) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:135) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:127) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:114) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:208) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1640) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:62) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:74) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:35) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layoutChildren(HTMLPageLM.java:123) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:81) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:80) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:194) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source) at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:662)Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.SQL error #1: ORA-00933: SQL command not properly ended ;


Thanks,
JP
Re: Null parameter [message #1065317 is a reply to message #1064915] Tue, 25 June 2013 06:12 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Williams,
Any suggestions?


Thanks,
JP
Re: Null parameter [message #1065669 is a reply to message #1065317] Thu, 27 June 2013 01:44 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

Sorry for the delay. What does your query look like inside the dataSet editor? If you were to put a static value in place of the parameter in the above script, are you able to get the results?

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Null parameter [message #1065831 is a reply to message #1062237] Thu, 27 June 2013 12:25 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

My DataSet query as

SELECT DISTINCT b.segment1 Brand,b.segment2 Type,
( SUM (NVL(msi.list_price_per_unit,0))) cog,
( SUM (d.quantity_invoiced)) net_units,
( SUM (NVL(d.unit_selling_price,0))) tot_unit_price,
( SUM (NVL(c.exchange_rate,1))) totExc,
( SUM (d.quantity_invoiced)) tot_sold_qty,
( sum (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1))) NetSales,
( SUM (DECODE(e.TYPE, 'CM', (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1)), 0))) Returns,
( SUM (DECODE(e.TYPE, 'INV', (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1)), 'DM', (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1)),0))) gross_amount,
DECODE(b.segment1,
'M', DECODE(b.segment2, 'F', 'Modo Frames',
'C', 'Modo Clips',
'S', 'Modo Sun',
'H', 'Modo Cases',
'X', 'Modo Spareparts', 'Modo'),
'S', DECODE(b.segment2, 'F', 'Saki Frames',
'C', 'Saki Clips',
'S', 'Saki Sun',
'H', 'Saki Lens',
'X', 'Saki Others', 'Saki'),
'K', DECODE(b.segment2, 'F', 'Keo Frames',
'C', 'Keo Clips',
'S', 'Keo Sun',
'H', 'Keo Lens',
'X', 'Keo Others', 'Keo'),
'P', DECODE(b.segment2, 'F', 'M+ Frames',
'C', 'M+ Clips',
'K', 'M+ Frame & Clip',
'S', 'M+ Sun',
'H', 'M+ Lens',
'X', 'M+ Others', 'M+'),
'B', DECODE(b.segment2, 'F', 'Babyphat Frames',
'C', 'Babyphat Clips',
'S', 'Babyphat Sun', 'Babyphat'),
'H', DECODE(b.segment2, 'F', 'Phatfarm Frames',
'C', 'Phatfarm Clips',
'S', 'Phatfarm Sun', 'Modo'),
'D', DECODE(b.segment2, 'F', 'Dvf Frames',
'C', 'Dvf Clips',
'S', 'Dvf Sun', 'Dvf'),
'U', DECODE(b.segment2, 'F', 'Puma Frames',
'C', 'Puma Clips',
'S', 'Puma Sun', 'Puma'),
'TE', DECODE(b.segment2, 'F', 'Teko Frames',
'C', 'Teko Clips',
'S', 'Teko Sun', 'Teko'),
'C', DECODE(b.segment2, 'F', 'Kirkland Frames',
'S', 'Kirkland Sun', 'Kirkland'),
'E', DECODE(b.segment2, 'F', 'Etro Frames',
'S', 'Etro Sun', 'Etro'),
'F', DECODE(b.segment2, 'F', 'Fendi Frames',
'S', 'Fendi Sun', 'Fendi'),
'PL', DECODE(b.segment2, 'F', 'PHILLIP LIM FRAMES',
'S', 'PHILLIP LIM SUN', 'PHILLIP LIM'),
'ID', DECODE(b.segment2, 'F', 'ID Frames',
'S', 'ID Sun', 'ID'),
'SP', 'SPARES', 'Others') description
FROM mtl_item_categories a,
mtl_system_items_b msi,
mtl_categories b,
ra_customer_trx c,
ra_customers ar,
ra_customer_trx_lines d,
ra_cust_trx_types_all e,
ra_salesreps f
WHERE d.inventory_item_id = a.inventory_item_id(+)
AND msi.inventory_item_id = a.inventory_item_id
AND msi.organization_id = a.organization_id
AND a.category_id = b.category_id(+)
AND ar.customer_id = c.bill_to_customer_id
and c.customer_trx_id = d.customer_trx_id
AND msi.inventory_item_id = d.inventory_item_id
AND c.cust_trx_type_id = e.cust_trx_type_id
AND f.salesrep_id(+) = c.primary_salesrep_id
AND ar.primary_salesrep_id = c.primary_salesrep_id
AND d.line_type = 'LINE'
AND b.structure_id = 101
AND TRUNC(c.trx_date) >= ?
AND TRUNC(c.trx_date) <= ?
AND a.organization_id = ?
GROUP BY b.category_id, b.segment1, b.segment2
ORDER BY b.segment1


and i have written script on DataSet at beforeOpen

if (params["P_CUSTOMER_NUMBER"].value != null && params["P_CUSTOMER_NUMBER"].value != "")
{ this.queryText = this.queryText + " AND ar.customer_number = '" + params["P_CUSTOMER_NUMBER"].value + "'";}

It is failed...

Hence i have changed the script as

queryText = " SELECT DISTINCT b.segment1 Brand,b.segment2 Type,";
queryText = queryText + " ( SUM (NVL(msi.list_price_per_unit,0))) cog,";
queryText = queryText + " ( SUM (d.quantity_invoiced)) net_units,";
queryText = queryText + " ( SUM (NVL(d.unit_selling_price,0))) tot_unit_price,";
queryText = queryText + " ( SUM (NVL(c.exchange_rate,1))) totExc,";
queryText = queryText + " ( SUM (d.quantity_invoiced)) tot_sold_qty,";
queryText = queryText + " ( sum (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1))) NetSales,";
queryText = queryText + " ( SUM (DECODE(e.TYPE, 'CM', (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1)), 0))) Returns,";
queryText = queryText + " ( SUM (DECODE(e.TYPE, 'INV', (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1)), 'DM', (nvl(d.extended_amount,0) * nvl(c.exchange_rate,1)),0))) gross_amount,";
queryText = queryText + " DECODE(b.segment1,";
queryText = queryText + " 'M', DECODE(b.segment2, 'F', 'Modo Frames',";
queryText = queryText + " 'C', 'Modo Clips',";
queryText = queryText + " 'S', 'Modo Sun',";
queryText = queryText + " 'H', 'Modo Cases',";
queryText = queryText + " 'X', 'Modo Spareparts', 'Modo'),";
queryText = queryText + " 'S', DECODE(b.segment2, 'F', 'Saki Frames',";
queryText = queryText + " 'C', 'Saki Clips',";
queryText = queryText + " 'S', 'Saki Sun',";
queryText = queryText + " 'H', 'Saki Lens',";
queryText = queryText + " 'X', 'Saki Others', 'Saki'),";
queryText = queryText + " 'K', DECODE(b.segment2, 'F', 'Keo Frames',";
queryText = queryText + " 'C', 'Keo Clips',";
queryText = queryText + " 'S', 'Keo Sun',";
queryText = queryText + " 'H', 'Keo Lens',";
queryText = queryText + " 'X', 'Keo Others', 'Keo'),";
queryText = queryText + " 'P', DECODE(b.segment2, 'F', 'M+ Frames',";
queryText = queryText + " 'C', 'M+ Clips',";
queryText = queryText + " 'K', 'M+ Frame & Clip',";
queryText = queryText + " 'S', 'M+ Sun',";
queryText = queryText + " 'H', 'M+ Lens',";
queryText = queryText + " 'X', 'M+ Others', 'M+'),";
queryText = queryText + " 'B', DECODE(b.segment2, 'F', 'Babyphat Frames',";
queryText = queryText + " 'C', 'Babyphat Clips',";
queryText = queryText + " 'S', 'Babyphat Sun', 'Babyphat'),";
queryText = queryText + " 'H', DECODE(b.segment2, 'F', 'Phatfarm Frames',";
queryText = queryText + " 'C', 'Phatfarm Clips',";
queryText = queryText + " 'S', 'Phatfarm Sun', 'Modo'),";
queryText = queryText + " 'D', DECODE(b.segment2, 'F', 'Dvf Frames',";
queryText = queryText + " 'C', 'Dvf Clips',";
queryText = queryText + " 'S', 'Dvf Sun', 'Dvf'),";
queryText = queryText + " 'U', DECODE(b.segment2, 'F', 'Puma Frames',";
queryText = queryText + " 'C', 'Puma Clips',";
queryText = queryText + " 'S', 'Puma Sun', 'Puma'),";
queryText = queryText + " 'TE', DECODE(b.segment2, 'F', 'Teko Frames',";
queryText = queryText + " 'C', 'Teko Clips',";
queryText = queryText + " 'S', 'Teko Sun', 'Teko'),";
queryText = queryText + " 'C', DECODE(b.segment2, 'F', 'Kirkland Frames',";
queryText = queryText + " 'S', 'Kirkland Sun', 'Kirkland'),";
queryText = queryText + " 'E', DECODE(b.segment2, 'F', 'Etro Frames',";
queryText = queryText + " 'S', 'Etro Sun', 'Etro'),";
queryText = queryText + " 'F', DECODE(b.segment2, 'F', 'Fendi Frames',";
queryText = queryText + " 'S', 'Fendi Sun', 'Fendi'),";
queryText = queryText + " 'PL', DECODE(b.segment2, 'F', 'PHILLIP LIM FRAMES',";
queryText = queryText + " 'S', 'PHILLIP LIM SUN', 'PHILLIP LIM'),";
queryText = queryText + " 'ID', DECODE(b.segment2, 'F', 'ID Frames',";
queryText = queryText + " 'S', 'ID Sun', 'ID'),";
queryText = queryText + " 'SP', 'SPARES', 'Others') description ";
queryText = queryText + " FROM mtl_item_categories a,";
queryText = queryText + " mtl_system_items_b msi,";
queryText = queryText + " mtl_categories b,";
queryText = queryText + " ra_customer_trx c,";
queryText = queryText + " ra_customers ar,";
queryText = queryText + " ra_customer_trx_lines d,";
queryText = queryText + " ra_cust_trx_types_all e,";
queryText = queryText + " ra_salesreps f";
queryText = queryText + " WHERE d.inventory_item_id = a.inventory_item_id(+)";
queryText = queryText + " AND msi.inventory_item_id = a.inventory_item_id";
queryText = queryText + " AND msi.organization_id = a.organization_id";
queryText = queryText + " AND a.category_id = b.category_id(+)";
queryText = queryText + " AND ar.customer_id = c.bill_to_customer_id";
queryText = queryText + " and c.customer_trx_id = d.customer_trx_id";
queryText = queryText + " AND msi.inventory_item_id = d.inventory_item_id";
queryText = queryText + " AND c.cust_trx_type_id = e.cust_trx_type_id";
queryText = queryText + " AND f.salesrep_id(+) = c.primary_salesrep_id";
queryText = queryText + " AND ar.primary_salesrep_id = c.primary_salesrep_id";
queryText = queryText + " AND d.line_type = 'LINE'";
queryText = queryText + " AND b.structure_id = 101";
queryText = queryText + " AND TRUNC(c.trx_date) >= ?";
queryText = queryText + " AND TRUNC(c.trx_date) <= ?";
queryText = queryText + " AND a.organization_id = ?";

if (params["P_CUSTOMER_NUMBER"].value != null && params["P_CUSTOMER_NUMBER"].value != "")
{ this.queryText = this.queryText + " AND ar.customer_number = '" + params["P_CUSTOMER_NUMBER"].value + "'";}
queryText = queryText + "GROUP BY b.category_id, b.segment1, b.segment2";
queryText = queryText + "ORDER BY b.segment1";

java.lang.System.out.println(queryText);

It is also failing and getting the message as

Table (id = 12):
- Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00933: SQL command not properly ended


odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the result set metadata.SQL statement does not return a ResultSet object.SQL error #1: ORA-00933: SQL command not properly ended at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:379) at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:339) at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.declareCustomColumn(PreparedStatement.java:1079) at org.eclipse.birt.data.engine.executor.DataSourceQuery.addCustomFields(DataSourceQuery.java:388)




Thanks,
JP
Re: Null parameter [message #1066177 is a reply to message #1065831] Mon, 01 July 2013 08:27 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

When i pass static values to the DataSet it is giving error message as
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.1.1.v20060922-1058
Error Code:data.engine.BirtException
Error Message:A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: TypeError: Cannot read property "length" from undefined (DataSet[Sales].__bm_beforeOpen#87)
Script source: DataSet[Sales].__bm_beforeOpen, line: 1, text:
__bm_beforeOpen(). See next exception for more information.
Error evaluating Javascript expression. Script engine error: TypeError: Cannot read property "length" from undefined (DataSet[Sales].__bm_beforeOpen#87)
Script source: DataSet[Sales].__bm_beforeOpen, line: 1, text:
__bm_beforeOpen()



Thanks,
JP
Re: Null parameter [message #1066437 is a reply to message #1066177] Tue, 02 July 2013 12:06 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Please advice

Thanks,
JP
Re: Null parameter [message #1066850 is a reply to message #1066437] Thu, 04 July 2013 14:43 Go to previous messageGo to next message
Zain Abedin is currently offline Zain Abedin
Messages: 5
Registered: July 2013
Junior Member
If I can install Birt 4.2.2 on CentOS 6.4 which download package do I install (I assume Linux package).

NEEDED:

Link to the package (if anyone can provide me with the link/path)
Pre-Install document(Pre-Conditions)
Installation guide

This is the system stack I would like to install Birt 4.2.2 on:

NAME Version
CentOS 6.4
Apache 2.4.4
Tomcat 7.0.41
My SQL 5.6.12
BIRT 4.2.2
KETTLE 4.4.0
JDK 7u25
HTML 5
Re: Null parameter [message #1067059 is a reply to message #1066850] Fri, 05 July 2013 11:45 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

Sorry for the delay. I was tied up with things for the BIRT Exchange upgrade.

The error you're getting with the script might be because you're not putting a space in the beginning of what you're adding to the queryText. Try changing:

queryText = queryText + "GROUP BY b.category_id, b.segment1, b.segment2";
queryText = queryText + "ORDER BY b.segment1";

to

queryText = queryText + " GROUP BY b.category_id, b.segment1, b.segment2";
queryText = queryText + " ORDER BY b.segment1";


Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Null parameter [message #1070593 is a reply to message #1067059] Thu, 18 July 2013 05:25 Go to previous messageGo to next message
JP Redro is currently offline JP Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Thanks Williams,

I worked it out with your correction. thanks once again.


Thanks,
JP
Re: Null parameter [message #1071393 is a reply to message #1070593] Fri, 19 July 2013 21:34 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

No problem! Great to hear!

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Previous Topic:text align vertical
Next Topic:StackOverFlow Exception While running Birt Report
Goto Forum:
  


Current Time: Fri Apr 25 02:50:14 EDT 2014

Powered by FUDForum. Page generated in 0.04739 seconds