Bind Variable does not Exist

Hi,

I have a few reports that comes up with this error. I have checked my reports as much as I can and I don't have an answer. I also checked other websites, forums etc.

Could you please provide me a direction as to what might be causing this error to occur? If there is no solution for this, Can I raise this as a BUG?

I understand the error message from a SQL sense but then I would like to know How and when BIRT creates this error. That's the tricky part.

Thanks
Nurani Sivakumar

Find more posts tagged with

Comments

nuraniuscc

Hi,

I would appreciate if someone can shed some light on this? I understand this error and dissected the SQL. No Luck.

Then What I did I " Stripped" of the SQL on clause at a time and Now I am at the bare minimum SQL. It's a Join with no WHERE Clause.

I am exploring all avenues possible. I have my doubts on the JOIN itself.

Your Input is appreciated. If you want I can send the report to you (Your email id).

Thanks
Nurani Sivakumar

mwilliams

Hi Nurani,

If you hard code the entire SQL statement into the dataSet rather than using the script to make it, do you get the same error?

nuraniuscc

Hi Mike,

No Luck. Same error.

Here is the SQL after it was hardcoded in the Dataset. The script is commented out.

select DATACENTER, CYCLE_RUN_MONTH || '/' || CYCLE_CODE || '/' || CYCLE_RUN_YEAR as CYCLE, NVL(TO_DATE(UPDATEDATE, 'DD-MON-YY') - TO_DATE(CREATEDATE, 'DD-MON-YY'),0) as ResDate, CYCLE_CODE from TBLRMSOLUTIONS A, TBLRMREJECTLIST B where A.ERRORNO = B.EXPERTKEY and DATACENTER in ('M02') and CYCLE_RUN_MONTH in (6) and CYCLE_CODE in (4) and CYCLE_RUN_YEAR in (2008) group by DATACENTER, CYCLE_RUN_MONTH || '/' || CYCLE_CODE || '/' || CYCLE_RUN_YEAR, NVL(TO_DATE(UPDATEDATE, 'DD-MON-YY') - TO_DATE(CREATEDATE, 'DD-MON-YY'),0), CYCLE_CODE order by DATACENTER, CYCLE_RUN_MONTH || '/' || CYCLE_CODE || '/' || CYCLE_RUN_YEAR

mwilliams

Nurani,

I think I've said this in another thread, but it still sounds like this would be an error with the binding to your table or something like that. Try clicking on the "Table" tab in the bottom left corner of your table to select the table. Then, go to the binding tab of the property editor and choose the refresh button to make sure you have the most current bindings from the dataSet. Then, choose every single element in the table and make sure that they're not bound individually to the dataSet. If it still gives this error after you do this, please email me your report design again, so I can take a look. Thanks.

nuraniuscc

Hi Mike,

Please refer to my email which has my .rptdesign as attachment. Yes, I made the changes as you suggested in your response. Still the same error.

Thanks
Nurani Sivakumar

mwilliams

Nurani,

I'm gonna send the report back to you by email. Run what I send you and tell me if it works.

nuraniuscc

Hi Mike,

Got you email and "Previewed" your version of the report and It still is the same error. Just for your Information Here it is...

I am not sure What to say or Where to go from Here. By the way, What was the "change" that you made.

Thanks
Nurani Sivakumar

Table (id=22)
- An exception occurred during processing. Please see the following message for details:
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01006: bind variable does not exist

detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:Cannot get the result set metadata.SQL statement does not return a ResultSet object.SQL error #1: ORA-01006: bind variable does not exist at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1107) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1071) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:88) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:928) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:876) at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:123) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:89) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:159) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:111) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:225) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:269) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

mwilliams

Nurani,

I reselected the dataSet for the table binding so that all the bindings would be cleared, then recreated your custom data binding you had for the date. I had noticed that there was a binding that didn't match in the table. I then deleted all the data elements in the table and replaced them with new ones after updating the table binding.