Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0039491
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Retail Analyticsmajoralways2018-10-19 13:252018-10-26 08:47
ReporterngarciaView Statuspublic 
Assigned Tocaristu 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision3d8df53c0968
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Regression levelQA functional test
Regression date2018-06-07
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/b521576871b021e6a286c1553b773c17f6073129 [^]
Triggers an Emergency PackNo
Summary

0039491: Forward Update Analytics Fact Tables process finishes with OBRetailAnalyticsFactSessionUpdater: Error in Process Log field

DescriptionForward Update Analytics Fact Tables process finishes with OBRetailAnalyticsFactSessionUpdater: Error in Process Log field
Steps To ReproduceIn https://livebuilds.openbravo.com/retail_modules_pgsql_pi: [^]

As System Admin role:
   Go to Process Request window and schedule 'Update Time Dimension Refs + Tree Closure Table' process to be run immediately

As group admin role:
   Go to Process Request window and schedule 'Forward Update Analytics Fact Tables' process to be run immediately
   Check although it finishes with Success status the process log shows:
     OBRetailAnalyticsFactSessionUpdater: Error

   In openbravo.log you can find:
      [DefaultQuartzScheduler_Worker-8] ERROR org.openbravo.client.analytics.fact.OBAnalyticsFactUpdater - java.lang.String cannot be cast to org.openbravo.base.structure.BaseOBObject
java.lang.ClassCastException: java.lang.String cannot be cast to org.openbravo.base.structure.BaseOBObject
 at org.openbravo.dal.core.DalPropertyAccess$GetterMethod.get(DalPropertyAccess.java:130)
 at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:224)
 at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:4927)
 at org.hibernate.persister.entity.AbstractEntityPersister.isTransient(AbstractEntityPersister.java:4627)
 at org.hibernate.engine.internal.ForeignKeys.isTransient(ForeignKeys.java:226)
 at org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:276)
 at org.hibernate.type.EntityType.getIdentifier(EntityType.java:495)
 at org.hibernate.type.EntityType.nullSafeSet(EntityType.java:288)
 at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:53)
 at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:645)
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2000)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1914)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892)
 at org.hibernate.loader.Loader.doQuery(Loader.java:937)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)
 at org.hibernate.loader.Loader.doList(Loader.java:2689)
 at org.hibernate.loader.Loader.doList(Loader.java:2672)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)
 at org.hibernate.loader.Loader.list(Loader.java:2501)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
 at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)
 at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)
 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)
 at org.openbravo.retail.analytics.OBRetailAnalyticsFactSessionUpdater.doSave(OBRetailAnalyticsFactSessionUpdater.java:148)
 at org.openbravo.retail.analytics.OBRetailAnalyticsFactSessionUpdater.doSave(OBRetailAnalyticsFactSessionUpdater.java:38)
 at org.openbravo.client.analytics.fact.OBAnalyticsFactUpdater.executeUpdate(OBAnalyticsFactUpdater.java:126)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by defect 00384463.0PR18Q3 closedjarmendariz Openbravo ERP Do not use positional query parameters with Query (Modules) 

-  Notes
(0107474)
hgbot (developer)
2018-10-22 12:50

 Repository: erp/pmods/org.openbravo.retail.analytics
Changeset: 3d8df53c09683aeb7c6cdc666d35dacdb00db1af
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Oct 22 12:40:42 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/3d8df53c09683aeb7c6cdc666d35dacdb00db1af [^]

fixes issue 39491: fix query to use the positional parameters properly

---
M src/org/openbravo/retail/analytics/OBRetailAnalyticsFactSessionUpdater.java
---
(0107505)
caristu (manager)
2018-10-22 18:07
edited on: 2018-10-22 18:07

 Published version 1.3.500 with the fix: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/ForgeModuleVersionDetail?moduleVersionId=160A949C492943FF835CFDC6AA606B95 [^]
(0107607)
alostale (manager)
2018-10-26 08:47

 reviewed

- Issue History
Date Modified Username Field Change
2018-10-19 13:25 ngarcia New Issue
2018-10-19 13:25 ngarcia Assigned To => Retail
2018-10-19 13:25 ngarcia Resolution time => 1541718000
2018-10-19 13:25 ngarcia Triggers an Emergency Pack => No
2018-10-19 13:26 ngarcia Relationship added caused by 0038446
2018-10-19 13:26 ngarcia Issue Monitored: networkb
2018-10-22 08:59 caristu Relationship deleted caused by 0038446
2018-10-22 08:59 caristu Relationship added related to 0038446
2018-10-22 11:17 caristu Relationship deleted related to 0038446
2018-10-22 11:17 caristu Relationship added caused by 0038446
2018-10-22 11:18 caristu Regression level => Production - QA Approved
2018-10-22 11:18 caristu Regression date => 2018-06-07
2018-10-22 11:18 caristu Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/b521576871b021e6a286c1553b773c17f6073129 [^]
2018-10-22 12:49 caristu Assigned To Retail => caristu
2018-10-22 12:50 hgbot Checkin
2018-10-22 12:50 hgbot Note Added: 0107474
2018-10-22 12:50 hgbot Status new => resolved
2018-10-22 12:50 hgbot Resolution open => fixed
2018-10-22 12:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/3d8df53c09683aeb7c6cdc666d35dacdb00db1af [^]
2018-10-22 12:51 caristu Review Assigned To => alostale
2018-10-22 12:52 caristu Regression level Production - QA Approved => Packaging and release
2018-10-22 12:53 caristu Regression level Packaging and release => QA functional test
2018-10-22 18:07 caristu Note Added: 0107505
2018-10-22 18:07 caristu Note Edited: 0107505 View Revisions
2018-10-24 15:03 martinsdan Issue Monitored: martinsdan
2018-10-26 08:47 alostale Note Added: 0107607
2018-10-26 08:47 alostale Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker