Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017889Openbravo ERPA. Platformpublic2011-07-05 11:442011-07-14 17:51
Reporteregoitz 
Assigned Togorkaion 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP0.1 
Target Version3.0MP1Fixed in Version3.0MP1 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017889: Imposible to update to Openbravo3mp0.1 from 2.50 or openbravo 3rc5 or older
DescriptionImposible to update to Openbravo3mp0.1 from 2.50 or openbravo 3rc5 or older.
The problem is on the buildvalidation WrongPaymentScheduleDetailsCheck.
On this validation the column AD_ALERT.STATUS is referenced on the select, but this column does not exist on old releases.


Steps To ReproduceTry to update to Openbravo3mp0.1 from Openravo3rc4 or 2.50mp31.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-05 11:44egoitzNew Issue
2011-07-05 11:44egoitzAssigned To => alostale
2011-07-05 11:44egoitzModules => Core
2011-07-05 11:44egoitzOBNetwork customer => Yes
2011-07-05 11:44egoitzAssigned Toalostale => gorkaion
2011-07-05 12:07egoitzNote Added: 0038766
2011-07-05 12:17dmitry_mezentsevTarget Version3.0MP1 => 3.0MP0
2011-07-05 12:24gorkaionTarget Version3.0MP0 => 3.0MP0.1
2011-07-05 12:34shuehnerIssue Monitored: shuehner
2011-07-05 14:03gorkaionTarget Version3.0MP0.1 => 3.0MP1
2011-07-05 14:06hgbotCheckin
2011-07-05 14:06hgbotNote Added: 0038782
2011-07-05 14:06hgbotStatusnew => resolved
2011-07-05 14:06hgbotResolutionopen => fixed
2011-07-05 14:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8a3f82b01a3eb1de0ba961ebed3807e764817075 [^]
2011-07-06 02:43hudsonbotCheckin
2011-07-06 02:43hudsonbotNote Added: 0038884
2011-07-14 17:51psarobeNote Added: 0039069
2011-07-14 17:51psarobeStatusresolved => closed
2011-07-14 17:51psarobeFixed in Version => 3.0MP1

Notes
(0038766)
egoitz   
2011-07-05 12:07   
buildvalidation:
[java] 0 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing
build validation: org.openbravo.buildvalidation.Cbpvendoracct
[java] 1041 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler -
Executing build validation: org.openbravo.buildvalidation.DuplicatedJavaPackage
[java] 1051 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler -
Executing build validation: org.openbravo.buildvalidation.PaymentGLItemCheck
[java] 1077 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler -
Executing build validation: org.openbravo.buildvalidation.PreferenceConflict
[java] 1097 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler -
Executing build validation:
org.openbravo.advpaymentmngt.buildvalidation.UniquePaymentForTransaction
[java] 1154 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler -
Executing build validation:
org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments
[java] 1225 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler -
Executing build validation:
org.openbravo.advpaymentmngt.buildvalidation.WrongPaymentScheduleDetailsCheck
[java] 2789 [main] ERROR
org.openbravo.advpaymentmngt.buildvalidation.WrongPaymentScheduleDetailsCheckData -
SQL error in query: SELECT COUNT(*) AS EXISTING FROM AD_ALERT WHERE AD_ALERTRULE_ID =
? AND REFERENCEKEY_ID = ? AND STATUS !=
'SOLVED'Exception:org.postgresql.util.PSQLException: ERROR: column "status" does not
exist
[java] Position: 127
[java] 3062 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - The
build validation failed.
[java] 3069 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - Error
executing build-validation
org.openbravo.advpaymentmngt.buildvalidation.WrongPaymentScheduleDetailsCheck:
@CODE=0@ERROR: column "status" does not exist
[java] Position: 127
[java] The build validation couldn't be properly executed
[java]
(0038782)
hgbot   
2011-07-05 14:06   
Repository: erp/devel/pi
Changeset: 8a3f82b01a3eb1de0ba961ebed3807e764817075
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Jul 05 14:03:51 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8a3f82b01a3eb1de0ba961ebed3807e764817075 [^]

Fixed issue 17889.Build validation now checks the existance of AD_Alert.status column.

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheck.class
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheckData.class
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheck.java
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheck_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheckData.java
---
(0038884)
hudsonbot   
2011-07-06 02:43   
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/f1c481b1a146 [^]

Maturity status: Test
(0039069)
psarobe   
2011-07-14 17:51   
Tested:
1. 2.50MP31 to MP0.1 works fine
2. 3.0rc5.1 to 3.0MP0.1 works fine