0040672: Generate Aggregated Data Background process fail

Description

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 [^]

Steps To Reproduce

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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0040670

closed

Sandrahuguet

Generate Aggregated Data Background process fail

Notes
(0111304) hgbot (developer) 2019-04-25 11:13	Repository: erp/backports/3.0PR19Q1.1 Changeset: 7bd38943f1bae206cf378fbaf052254875476854 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Wed Apr 24 13:20:11 2019 +0200 URL: http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/7bd38943f1bae206cf378fbaf052254875476854 [^] Fixed issue 40672 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 ---

(0111347) dmiguelez (developer) 2019-04-26 10:13	Code Review + Testing Ok

Issue History
Date Modified	Username	Field	Change
2019-04-24 13:26	Sandrahuguet	Type	defect => backport
2019-04-24 13:26	Sandrahuguet	Target Version	=> 3.0PR19Q1.1
2019-04-25 11:13	hgbot	Checkin
2019-04-25 11:13	hgbot	Note Added: 0111304
2019-04-25 11:13	hgbot	Status	scheduled => resolved
2019-04-25 11:13	hgbot	Resolution	open => fixed
2019-04-25 11:13	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/7bd38943f1bae206cf378fbaf052254875476854 [^]
2019-04-26 10:13	dmiguelez	Review Assigned To	=> dmiguelez
2019-04-26 10:13	dmiguelez	Note Added: 0111347
2019-04-26 10:13	dmiguelez	Status	resolved => closed
2019-04-26 10:13	dmiguelez	Fixed in Version	=> 3.0PR19Q1.1