#656
  • Created on
    2013-06-11 17:05
  • Reported by
    egouge
  • Status
    Fixed (Completed)
  • Priority
    Normal (3)
  • Assigned to
    darrinc
  • Milestone
    SMART 1.1.1
  • Plan Level
    -
  • Estimate
    1.0
  • Due Date
    -

Attachments

Related Tickets

Add new subtask or bug

Issue with queries in reports in French Version

Using the French version of SMART, within in the reports: when you import the queries for the report data sets - it no longer retains the name of the query, names them jeu de donnees, jeu de donnees 1.
In the English version, it would name the data set the name of the query.
This would be good to be done in the french version too.



ALSO THEN GET THIS error message for all queries....

Table (id = 49):
+ Une exception sest produite au cours du traitement. Pour plus de détails, consultez le message suivant :
Failed to prepare the query execution for the data set: Effort de patrouille en fonction de PatrolID
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date. (Element ID:49)
exception.error ( 1 fois )
détails :org.eclipse.birt.report.engine.api.EngineException: Une exception sest produite au cours du traitement. Pour plus de détails, consultez le message suivant :
Failed to prepare the query execution for the data set: Effort de patrouille en fonction de PatrolID
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date. (Element ID:49)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
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:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.wcs.smart.report.internal.ui.viewer.ReportView$1.run(ReportView.java:98)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Une exception sest produite au cours du traitement. Pour plus de détails, consultez le message suivant :
Failed to prepare the query execution for the data set: Effort de patrouille en fonction de PatrolID
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 11 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: Effort de patrouille en fonction de PatrolID
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:345)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
... 15 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.data.engine.executor.DataSourceQuery.convertToValue(DataSourceQuery.java:1263)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.getParameterInputValue(DataSourceQuery.java:606)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParametersToQuerySpec(DataSourceQuery.java:531)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.populateQuerySpecification(DataSourceQuery.java:465)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:279)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
... 20 more
Caused by: org.eclipse.birt.core.exception.CoreException: Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.core.data.DataTypeUtil.toSqlDate(DataTypeUtil.java:712)
at org.eclipse.birt.core.data.DataTypeUtil.convert(DataTypeUtil.java:166)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.convertToValue(DataSourceQuery.java:1259)
... 26 more



Table (id = 91):
+ Une exception sest produite au cours du traitement. Pour plus de détails, consultez le message suivant :
Failed to prepare the query execution for the data set: Jeu de données
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date. (Element ID:91)
exception.error ( 1 fois )
détails :org.eclipse.birt.report.engine.api.EngineException: Une exception sest produite au cours du traitement. Pour plus de détails, consultez le message suivant :
Failed to prepare the query execution for the data set: Jeu de données
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date. (Element ID:91)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
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:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.wcs.smart.report.internal.ui.viewer.ReportView$1.run(ReportView.java:98)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Une exception sest produite au cours du traitement. Pour plus de détails, consultez le message suivant :
Failed to prepare the query execution for the data set: Jeu de données
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 11 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: Jeu de données
Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:345)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
... 15 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Impossible de convertir la valeur de paramètre A FAIRE : Lier aux paramètres du rapport au type class java.sql.Date.
Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.data.engine.executor.DataSourceQuery.convertToValue(DataSourceQuery.java:1263)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.getParameterInputValue(DataSourceQuery.java:606)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParametersToQuerySpec(DataSourceQuery.java:531)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.populateQuerySpecification(DataSourceQuery.java:465)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:279)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
... 20 more
Caused by: org.eclipse.birt.core.exception.CoreException: Impossible de convertir la valeur de A FAIRE : Lier aux paramètres du rapport au type java.sql.Date.
at org.eclipse.birt.core.data.DataTypeUtil.toSqlDate(DataTypeUtil.java:712)
at org.eclipse.birt.core.data.DataTypeUtil.convert(DataTypeUtil.java:166)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.convertToValue(DataSourceQuery.java:1259)
... 26 more
User picture
  on 2013-06-12 00:12 *
By egouge
Assigned to set to egouge
Status changed from New to Accepted
The dataset name issue is a i18n. The software was looking for the words "Data Set" then renaming it. Since these are not the words used in the French version it would not get renamed to the query/table name. This will be an issue for all languages other than English.

I have resolved the problem, so it will be fixed in future builds.
User picture
  on 2013-06-12 01:33 *
By egouge
Regarding the stack trace - this is because the data set parameters are not linked correctly to the report parameters. This is also an i18n issue but the fix to get your report to run is to 'right click' on your dataset in the 'Outline' view, select 'Edit' then in the 'Parameters' page. For each of the parameter listed here pick select the 'Edit' button then the correct parameter in the 'Linked to Report Parameter' drop down.

Every query dataset requires dates to be provided in order for the query to run. Each report has a set of parameters associated with it (report parameters). The report parameters are the parameters the user is prompted for when running a report. Then, via the query parameter / report parameter link the values the user entered for the report parameters are passed along to the query so the query knows which dates to use.
User picture
  on 2013-06-12 01:33 *
By egouge
Attachment parameters.png added
bnVokY0U8r4PVdacwqjQYw
User picture
  on 2013-06-12 09:14 *
By RuthStarkey
Ok thanks, this works.
User picture
  on 2013-06-19 23:11 *
By egouge
Status changed from Accepted to Test
User picture
  on 2013-07-09 19:15 *
By egouge
Assigned to changed from egouge to darrinc
User picture
  on 2013-07-23 20:39 *
By darrinc
Status changed from Test to Fixed (Completed)