Home » Archived » BIRT » v2.1.1 - Bug with Scripted Data Set
| v2.1.1 - Bug with Scripted Data Set [message #193438] |
Sat, 30 September 2006 16:48  |
Eclipse User |
|
|
|
I have a scripted query that works perfectly in v2.1.0, but in v2.1.1
the following addition to my query causes an "unterminated /* comment"
error.
queryText += "sum((sf.labor+sf.subLabor+sf.materials)/1000.0) AS
monthlySales "
What's going on????
Chart (id = 14):
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ERROR: unterminated /* comment at or near "/*000.0) AS
monthlySales FROM (SELECT DISTINCT sales, TimeDimension_id,
ProjectDimension_id, labor, subLabor, materials FROM pipeline.SalesFact
) AS sf, pipeline.TimeDimension td, pipeline.ProjectDimension pd,
pipeline.CategoryOrder co WHERE sf.TimeDimension_id=td.id AND
sf.ProjectDimension_id=pd.id AND co.category=pd.pipelineCategory AND
td.salesMonth >= date_trunc('month', now()) GROUP BY td.salesMonth,
pd.pipelineCategory, co.rank ORDER BY co.rank ASC, td.salesMonth ASC"
odaconsumer.CannotGetResultSetMetaData ( 2 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: ERROR: unterminated /* comment at or near "/*000.0) AS
monthlySales FROM (SELECT DISTINCT sales, TimeDimension_id,
ProjectDimension_id, labor, subLabor, materials FROM pipeline.SalesFact
) AS sf, pipeline.TimeDimension td, pipeline.ProjectDimension pd,
pipeline.CategoryOrder co WHERE sf.TimeDimension_id=td.id AND
sf.ProjectDimension_id=pd.id AND co.category=pd.pipelineCategory AND
td.salesMonth >= date_trunc('month', now()) GROUP BY td.salesMonth,
pd.pipelineCategory, co.rank ORDER BY co.rank ASC, td.salesMonth ASC" at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:379)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:259)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.ExtendedItemExecutor .execute(ExtendedItemExecutor.java:79)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known
Source) at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)Caused by:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
not return a ResultSet object.SQL error #1: ERROR: unterminated /*
comment at or near "/*000.0) AS monthlySales FROM (SELECT DISTINCT
sales, TimeDimension_id, ProjectDimension_id, labor, subLabor, materials
FROM pipeline.SalesFact ) AS sf, pipeline.TimeDimension td,
pipeline.ProjectDimension pd, pipeline.CategoryOrder co WHERE
sf.TimeDimension_id=td.id AND sf.ProjectDimension_id=pd.id AND
co.category=pd.pipelineCategory AND td.salesMonth >=
date_trunc('month', now()) GROUP BY td.salesMonth, pd.pipelineCategory,
co.rank ORDER BY co.rank ASC, td.salesMonth ASC" ;
java.sql.SQLException: ERROR: unterminated /* comment at or near
"/*000.0) AS monthlySales FROM (SELECT DISTINCT sales,
TimeDimension_id, ProjectDimension_id, labor, subLabor, materials FROM
pipeline.SalesFact ) AS sf, pipeline.TimeDimension td,
pipeline.ProjectDimension pd, pipeline.CategoryOrder co WHERE
sf.TimeDimension_id=td.id AND sf.ProjectDimension_id=pd.id AND
co.category=pd.pipelineCategory AND td.salesMonth >=
date_trunc('month', now()) GROUP BY td.salesMonth, pd.pipelineCategory,
co.rank ORDER BY co.rank ASC, td.salesMonth ASC" at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:344)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
.... 62 moreCaused by: java.sql.SQLException: ERROR: unterminated /*
comment at or near "/*000.0) AS monthlySales FROM (SELECT DISTINCT
sales, TimeDimension_id, ProjectDimension_id, labor, subLabor, materials
FROM pipeline.SalesFact ) AS sf, pipeline.TimeDimension td,
pipeline.ProjectDimension pd, pipeline.CategoryOrder co WHERE
sf.TimeDimension_id=td.id AND sf.ProjectDimension_id=pd.id AND
co.category=pd.pipelineCategory AND td.salesMonth >=
date_trunc('month', now()) GROUP BY td.salesMonth, pd.pipelineCategory,
co.rank ORDER BY co.rank ASC, td.salesMonth ASC" at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract Jdbc2Statement.java:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:330)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs tractJdbc2Statement.java:240)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:340)
.... 66 more
|
|
|
| Re: v2.1.1 - Bug with Scripted Data Set [message #193448 is a reply to message #193438] |
Sat, 30 September 2006 17:00  |
| Eclipse User |
|
|
|
Went on and logged this as a bug:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=159398
George Handin wrote:
> I have a scripted query that works perfectly in v2.1.0, but in v2.1.1
> the following addition to my query causes an "unterminated /* comment"
> error.
>
> queryText += "sum((sf.labor+sf.subLabor+sf.materials)/1000.0) AS
> monthlySales "
>
> What's going on????
>
>
>
> Chart (id = 14):
> + Cannot get the result set metadata.
> SQL statement does not return a ResultSet object.
> SQL error #1: ERROR: unterminated /* comment at or near "/*000.0) AS
> monthlySales FROM (SELECT DISTINCT sales, TimeDimension_id,
> ProjectDimension_id, labor, subLabor, materials FROM pipeline.SalesFact
> ) AS sf, pipeline.TimeDimension td, pipeline.ProjectDimension pd,
> pipeline.CategoryOrder co WHERE sf.TimeDimension_id=td.id AND
> sf.ProjectDimension_id=pd.id AND co.category=pd.pipelineCategory AND
> td.salesMonth >= date_trunc('month', now()) GROUP BY td.salesMonth,
> pd.pipelineCategory, co.rank ORDER BY co.rank ASC, td.salesMonth ASC"
>
> odaconsumer.CannotGetResultSetMetaData ( 2 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: ERROR: unterminated /* comment at or near "/*000.0) AS
> monthlySales FROM (SELECT DISTINCT sales, TimeDimension_id,
> ProjectDimension_id, labor, subLabor, materials FROM pipeline.SalesFact
> ) AS sf, pipeline.TimeDimension td, pipeline.ProjectDimension pd,
> pipeline.CategoryOrder co WHERE sf.TimeDimension_id=td.id AND
> sf.ProjectDimension_id=pd.id AND co.category=pd.pipelineCategory AND
> td.salesMonth >= date_trunc('month', now()) GROUP BY td.salesMonth,
> pd.pipelineCategory, co.rank ORDER BY co.rank ASC, td.salesMonth ASC" at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:379)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:259)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.ExtendedItemExecutor .execute(ExtendedItemExecutor.java:79)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
> at java.lang.Thread.run(Unknown Source)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
> not return a ResultSet object.SQL error #1: ERROR: unterminated /*
> comment at or near "/*000.0) AS monthlySales FROM (SELECT DISTINCT
> sales, TimeDimension_id, ProjectDimension_id, labor, subLabor, materials
> FROM pipeline.SalesFact ) AS sf, pipeline.TimeDimension td,
> pipeline.ProjectDimension pd, pipeline.CategoryOrder co WHERE
> sf.TimeDimension_id=td.id AND sf.ProjectDimension_id=pd.id AND
> co.category=pd.pipelineCategory AND td.salesMonth >=
> date_trunc('month', now()) GROUP BY td.salesMonth, pd.pipelineCategory,
> co.rank ORDER BY co.rank ASC, td.salesMonth ASC" ;
> java.sql.SQLException: ERROR: unterminated /* comment at or near
> "/*000.0) AS monthlySales FROM (SELECT DISTINCT sales,
> TimeDimension_id, ProjectDimension_id, labor, subLabor, materials FROM
> pipeline.SalesFact ) AS sf, pipeline.TimeDimension td,
> pipeline.ProjectDimension pd, pipeline.CategoryOrder co WHERE
> sf.TimeDimension_id=td.id AND sf.ProjectDimension_id=pd.id AND
> co.category=pd.pipelineCategory AND td.salesMonth >=
> date_trunc('month', now()) GROUP BY td.salesMonth, pd.pipelineCategory,
> co.rank ORDER BY co.rank ASC, td.salesMonth ASC" at
> org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:344)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
> ... 62 moreCaused by: java.sql.SQLException: ERROR: unterminated /*
> comment at or near "/*000.0) AS monthlySales FROM (SELECT DISTINCT
> sales, TimeDimension_id, ProjectDimension_id, labor, subLabor, materials
> FROM pipeline.SalesFact ) AS sf, pipeline.TimeDimension td,
> pipeline.ProjectDimension pd, pipeline.CategoryOrder co WHERE
> sf.TimeDimension_id=td.id AND sf.ProjectDimension_id=pd.id AND
> co.category=pd.pipelineCategory AND td.salesMonth >=
> date_trunc('month', now()) GROUP BY td.salesMonth, pd.pipelineCategory,
> co.rank ORDER BY co.rank ASC, td.salesMonth ASC" at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1471)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1256)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:175)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract Jdbc2Statement.java:389)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:330)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs tractJdbc2Statement.java:240)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:340)
> ... 66 more
>
|
|
|
Goto Forum:
Current Time: Tue Jul 22 14:47:45 EDT 2025
Powered by FUDForum. Page generated in 0.03258 seconds |
Home