Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039491Retail ModulesRetail Analyticspublic2018-10-19 13:252018-10-26 08:47
Reporterngarcia 
Assigned Tocaristu 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Support ticket
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
Summary0039491: 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)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 00384463.0PR18Q3 closed jarmendariz Openbravo ERP Do not use positional query parameters with Query (Modules) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-10-19 13:25ngarciaNew Issue
2018-10-19 13:25ngarciaAssigned To => Retail
2018-10-19 13:25ngarciaResolution time => 1541718000
2018-10-19 13:25ngarciaTriggers an Emergency Pack => No
2018-10-19 13:26ngarciaRelationship addedcaused by 0038446
2018-10-19 13:26ngarciaIssue Monitored: networkb
2018-10-22 08:59caristuRelationship deletedcaused by 0038446
2018-10-22 08:59caristuRelationship addedrelated to 0038446
2018-10-22 11:17caristuRelationship deletedrelated to 0038446
2018-10-22 11:17caristuRelationship addedcaused by 0038446
2018-10-22 11:18caristuRegression level => Production - QA Approved
2018-10-22 11:18caristuRegression date => 2018-06-07
2018-10-22 11:18caristuRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/b521576871b021e6a286c1553b773c17f6073129 [^]
2018-10-22 12:49caristuAssigned ToRetail => caristu
2018-10-22 12:50hgbotCheckin
2018-10-22 12:50hgbotNote Added: 0107474
2018-10-22 12:50hgbotStatusnew => resolved
2018-10-22 12:50hgbotResolutionopen => fixed
2018-10-22 12:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/3d8df53c09683aeb7c6cdc666d35dacdb00db1af [^]
2018-10-22 12:51caristuReview Assigned To => alostale
2018-10-22 12:52caristuRegression levelProduction - QA Approved => Packaging and release
2018-10-22 12:53caristuRegression levelPackaging and release => QA functional test
2018-10-22 18:07caristuNote Added: 0107505
2018-10-22 18:07caristuNote Edited: 0107505bug_revision_view_page.php?bugnote_id=0107505#r17803
2018-10-24 15:03martinsdanIssue Monitored: martinsdan
2018-10-26 08:47alostaleNote Added: 0107607
2018-10-26 08:47alostaleStatusresolved => closed

Notes
(0107474)
hgbot   
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   
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   
2018-10-26 08:47   
reviewed