Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0040670Openbravo ERP04. Warehouse managementpublic2019-04-24 13:062019-05-21 15:16
Sandrahuguet 
Sandrahuguet 
normalmajorhave not tried
closedfixed 
30Openbravo Appliance 14.04
 
3.0PR19Q3 
dmiguelez
Core
Production - Confirmed Stable
2018-07-24
3.0PR18Q4
https://code.openbravo.com/erp/devel/pi/rev/95dcfa93d706654e1fbddfc3966bec7280081ac1 [^]
No
0040670: Generate Aggregated Data Background process fail
Generate Aggregated Data Background process fail:

2019-04-24 13:04:31,985 [DefaultQuartzScheduler_Worker-4] ERROR org.openbravo.materialmgmt.GenerateAggregatedDataBackground - org.openbravo.model.common.enterprise.Organization cannot be cast to java.lang.String
java.lang.ClassCastException: org.openbravo.model.common.enterprise.Organization cannot be cast to java.lang.String
    at org.hibernate.type.descriptor.java.StringTypeDescriptor.unwrap(StringTypeDescriptor.java:22) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$1.doBind(VarcharTypeDescriptor.java:46) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:74) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:280) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:275) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:53) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:645) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2000) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1914) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.doQuery(Loader.java:937) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.doList(Loader.java:2689) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.doList(Loader.java:2672) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.Loader.list(Loader.java:2501) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505) ~[hibernate-core-5.3.2.Final.jar:5.3.2.Final]
    at org.openbravo.dal.service.OBQuery.list(OBQuery.java:123) ~[classes/:?]
    at org.openbravo.materialmgmt.ResetValuedStockAggregated.costingRuleDefindedForPeriod(ResetValuedStockAggregated.java:245) ~[classes/:?]
    at org.openbravo.materialmgmt.GenerateAggregatedDataBackground.doExecute(GenerateAggregatedDataBackground.java:105) [classes/:?]
    at org.openbravo.service.db.DalBaseProcess.execute(DalBaseProcess.java:85) [classes/:?]
    at org.openbravo.scheduling.DefaultJob.execute(DefaultJob.java:65) [classes/:?]
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-1.6.2.jar:1.6.2]
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) [quartz-1.6.2.jar:1.6.2]

The failure is caused by:
http://wiki.openbravo.com/wiki/Hibernate_5.3_Migration_Guide#Comparing_Business_Objects_and_IDs_with_Query_Parameters [^]
Go to process request and create new record:
 -Client: F&B International Group
 -Organization: F&B España, S.A
 -Process: Generate Aggregated Data Background
 -Timing: Run Immediately
Schedule Process, notice that the process fail
No tags attached.
depends on backport 00406713.0PR19Q2 closed Sandrahuguet Generate Aggregated Data Background process fail 
depends on backport 00406723.0PR19Q1.1 closed Sandrahuguet Generate Aggregated Data Background process fail 
depends on backport 00406733.0PR18Q4.4 closed Sandrahuguet Generate Aggregated Data Background process fail 
caused by feature request 0037064 closed caristu upgrade hibernate to 5.3.2 
related to defect 0040623 closed nonofrancisco Valued Stock Report with aggregated data not working when filtering by old data 
related to defect 0040676 closed dmiguelez Valued Stock Report not properly working when movementDate has more precision than days and aggregated data 
Issue History
2019-04-24 13:06SandrahuguetNew Issue
2019-04-24 13:06SandrahuguetAssigned To => Sandrahuguet
2019-04-24 13:06SandrahuguetModules => Core
2019-04-24 13:06SandrahuguetRegression level => Production - Confirmed Stable
2019-04-24 13:06SandrahuguetRegression date => 2018-07-24
2019-04-24 13:06SandrahuguetRegression introduced in release => 3.0PR18Q4
2019-04-24 13:06SandrahuguetRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/95dcfa93d706654e1fbddfc3966bec7280081ac1 [^]
2019-04-24 13:06SandrahuguetTriggers an Emergency Pack => No
2019-04-24 13:06SandrahuguetRelationship addedrelated to 0040623
2019-04-24 13:07SandrahuguetRelationship addedcaused by 0037064
2019-04-24 13:26SandrahuguetStatusnew => scheduled
2019-04-24 13:30SandrahuguetNote Added: 0111277
2019-04-24 13:31SandrahuguetReview Assigned To => dmiguelez
2019-04-24 13:31SandrahuguetNote Edited: 0111277bug_revision_view_page.php?bugnote_id=0111277#r18662
2019-04-24 15:24hgbotCheckin
2019-04-24 15:24hgbotNote Added: 0111281
2019-04-24 15:24hgbotStatusscheduled => resolved
2019-04-24 15:24hgbotResolutionopen => fixed
2019-04-24 15:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0435d6d78784d1bb62043a95ce0ff0054737f8c5 [^]
2019-04-26 10:14dmiguelezNote Added: 0111349
2019-04-26 10:14dmiguelezStatusresolved => closed
2019-04-26 10:14dmiguelezFixed in Version => 3.0PR19Q3
2019-04-26 10:14dmiguelezRelationship addedrelated to 0040676
2019-05-21 15:16hudsonbotCheckin
2019-05-21 15:16hudsonbotNote Added: 0111995

Notes
(0111277)
Sandrahuguet   
2019-04-24 13:30   
(edited on: 2019-04-24 13:31)
Test Plan:
Go to process request and create new record:
 -Client: F&B International Group
 -Organization: F&B España, S.A
 -Process: Generate Aggregated Data Background
 -Timing: Run Immediately
Schedule Process, notice that the process finish successfully

(0111281)
hgbot   
2019-04-24 15:24   
Repository: erp/devel/pi
Changeset: 0435d6d78784d1bb62043a95ce0ff0054737f8c5
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 24 13:20:11 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0435d6d78784d1bb62043a95ce0ff0054737f8c5 [^]

Fixed issue 40670 Fix query to compare organization with corresponding id.

Fix query to compare organization with corresponding id instead of the
business object.

Fix wrong filter date, period.getEndingDate() is used and the correct
one is period.getStartingDate().

---
M src/org/openbravo/materialmgmt/ResetValuedStockAggregated.java
---
(0111349)
dmiguelez   
2019-04-26 10:14   
Code Review + Testing Ok
(0111995)
hudsonbot   
2019-05-21 15:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9b8f37d9d85e [^]
Maturity status: Test