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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027273
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupcriticalhave not tried2014-08-04 15:132014-08-08 18:54
ReporterpriyamView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityimmediateResolutionfixedFixed in Version3.0PR14Q4
StatusclosedFix in branchpiFixed in SCM revisiona2c903436f86
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned TodaniOpenbravo
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date2014-07-25
Regression introduced in releasepi
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/c3d258163d89 [^]
Triggers an Emergency PackNo
Summary

0027273: Upgrade from 2.50 to 3.0 fails

DescriptionUpgrade of ERP 2.50 to latest pi fails in build validation due the changeset
https://code.openbravo.com/erp/devel/pi/rev/c3d258163d89 [^]

<error snip>

buildvalidation:
      [sql] Executing commands
      [sql] 2 of 2 SQL statements executed successfully

buildvalidation:
     [java] 0 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.AccountingTabs
     [java] 707 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicateDocExchangeRate
     [java] 747 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedJavaPackage
     [java] 765 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedOrgWarehouse
     [java] 784 [main] ERROR org.openbravo.buildvalidation.DuplicatedOrgWarehouseData - SQL error in query: SELECT count(*) AS EXISTING FROM ad_org_warehouse GROUP BY ad_org_id, m_warehouse_id HAVING count(*)>1Exception:org.postgresql.util.PSQLException: ERROR: relation "ad_org_warehouse" does not exist
     [java] Position: 41
     [java] 792 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - The build validation failed.
     [java] 796 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - Error executing build-validation org.openbravo.buildvalidation.DuplicatedOrgWarehouse: @CODE=0@ERROR: relation "ad_org_warehouse" does not exist
     [java] Position: 41
     [java] The build validation couldn't be properly executed
     [java]

BUILD FAILED
</error snip>

Complete log : https://ci.openbravo.com/job/up-2.50topi-pgsql/33/consoleText [^]
Steps To Reproduce1) check out erp/devel/pi
2) update the workspaceto latest 2.50MP51
3) Install.source
4) Update the workspace source to latest pi (or to the changeset causing this failure)
5) # 2.50 sampledata needs to be fixed, otherwise some new 3.0 validation will fail
"delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('1000020', '1000019', '1000024', '1000022', '1000021');"
6) smartbuild -Dlocal=no

and Fails in build validation
[java] 784 [main] ERROR org.openbravo.buildvalidation.DuplicatedOrgWarehouseData - SQL error in query: SELECT count(*) AS EXISTING FROM ad_org_warehouse GROUP BY ad_org_id, m_warehouse_id HAVING count(*)>1Exception:org.postgresql.util.PSQLException: ERROR: relation "ad_org_warehouse" does not exist
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by defect 0027056 closeddaniOpenbravo It is possible to assign more than once the same warehouse to one organization 

-  Notes
(0069070)
shuehner (administrator)
2014-08-04 15:20

 Special case.
When updating from 2.50 to 3.0 the 3.0 buildvalidations are run against the 2.50 database.

In this case this validation uses the ad_org_warehouse table which did not exist in 2.50.

In that case the check can be skipped but must not fail.

So a extra step needs to be added to not run that sql when the table does not exist.

This is not first case so example should exist in some other build-validation doing that check (does a table exist)
(0069081)
hgbot (developer)
2014-08-04 20:06

 Repository: erp/devel/pi
Changeset: a2c903436f862a0290c61a7f9bbfc0aa9a7edf75
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Aug 04 19:31:59 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/a2c903436f862a0290c61a7f9bbfc0aa9a7edf75 [^]

Fixes Issue 0027273:Avoids upgrade failure from 2.50 to 3.0

---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedOrgWarehouse.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedOrgWarehouseData.class
M src-util/buildvalidation/build/javasqlc/src/org/openbravo/buildvalidation/DuplicatedOrgWarehouseData.java
M src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedOrgWarehouse.java
M src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedOrgWarehouse_data.xsql
---
(0069121)
daniOpenbravo (viewer)
2014-08-08 09:14

 Verified.
(0069262)
hudsonbot (viewer)
2014-08-08 18:54

 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/4450016dee64 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-08-04 15:13 priyam New Issue
2014-08-04 15:13 priyam Assigned To => AtulOpenbravo
2014-08-04 15:13 priyam OBNetwork customer => No
2014-08-04 15:13 priyam Modules => Core
2014-08-04 15:13 priyam Triggers an Emergency Pack => No
2014-08-04 15:20 shuehner Note Added: 0069070
2014-08-04 15:20 shuehner Issue Monitored: shuehner
2014-08-04 15:21 shuehner Regression level => Automated tests
2014-08-04 15:21 shuehner Regression date => 2014-07-25
2014-08-04 15:21 shuehner Regression introduced in release => pi
2014-08-04 15:21 shuehner Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/c3d258163d89 [^]
2014-08-04 15:21 shuehner Relationship added caused by 0027056
2014-08-04 15:44 AtulOpenbravo Status new => scheduled
2014-08-04 15:44 AtulOpenbravo fix_in_branch => pi
2014-08-04 20:01 AtulOpenbravo Review Assigned To => priyam
2014-08-04 20:01 AtulOpenbravo fix_in_branch pi =>
2014-08-04 20:06 hgbot Checkin
2014-08-04 20:06 hgbot Note Added: 0069081
2014-08-04 20:06 hgbot Status scheduled => resolved
2014-08-04 20:06 hgbot Resolution open => fixed
2014-08-04 20:06 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a2c903436f862a0290c61a7f9bbfc0aa9a7edf75 [^]
2014-08-06 13:28 Sandrahuguet Status resolved => new
2014-08-06 13:28 Sandrahuguet Resolution fixed => open
2014-08-06 13:29 Sandrahuguet Review Assigned To priyam => daniOpenbravo
2014-08-06 13:29 Sandrahuguet Status new => scheduled
2014-08-06 13:29 Sandrahuguet fix_in_branch => pi
2014-08-06 13:29 Sandrahuguet Status scheduled => resolved
2014-08-06 13:29 Sandrahuguet Resolution open => fixed
2014-08-08 09:14 daniOpenbravo Note Added: 0069121
2014-08-08 09:14 daniOpenbravo Status resolved => closed
2014-08-08 09:14 daniOpenbravo Fixed in Version => 3.0PR14Q4
2014-08-08 18:54 hudsonbot Checkin
2014-08-08 18:54 hudsonbot Note Added: 0069262

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker