Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017342Openbravo ERP09. Financial managementpublic2011-05-24 16:552011-05-25 15:40
Reporterpsarobe 
Assigned Tomirurita 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP29 
Target Version2.50MP30Fixed in Version2.50MP30 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017342: You cannot install current APRM version on top of MP30. Build validation is not working
DescriptionIt is correct that you cannot install 1.14 APRM version on top of 2.50MP30 but the installation should stop in build validation phase and not in the next phase
Steps To Reproduce1. Having mp30
2. Install 1.14 APRM

In the build validation should stop but instead is failing in next phase which is not correct
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00173412.50MP30 closed mirurita You cannot install current APRM version on top of MP30. Build validation is not working 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-24 16:55psarobeTypedefect => backport
2011-05-24 16:55psarobefix_in_branch => 2.50
2011-05-24 16:57psarobePrioritynormal => immediate
2011-05-24 17:19dmitry_mezentsevIssue Monitored: dmitry_mezentsev
2011-05-24 18:38hgbotCheckin
2011-05-24 18:38hgbotNote Added: 0037405
2011-05-24 18:38hgbotStatusscheduled => resolved
2011-05-24 18:38hgbotResolutionopen => fixed
2011-05-24 18:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/6994a95adc51eac7f9dc60327597e2e6f1f6a8a0 [^]
2011-05-25 10:38psarobeNote Added: 0037410
2011-05-25 10:38psarobeStatusresolved => new
2011-05-25 10:38psarobeResolutionfixed => open
2011-05-25 10:41psarobeNote Added: 0037412
2011-05-25 15:39psarobeStatusnew => scheduled
2011-05-25 15:39psarobefix_in_branch2.50 => pi
2011-05-25 15:39psarobeStatusscheduled => resolved
2011-05-25 15:39psarobeResolutionopen => fixed
2011-05-25 15:40psarobeStatusresolved => closed
2011-05-25 15:40psarobeFixed in Version => 2.50MP30

Notes
(0037405)
hgbot   
2011-05-24 18:38   
Repository: erp/stable/2.50
Changeset: 6994a95adc51eac7f9dc60327597e2e6f1f6a8a0
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Tue May 24 18:32:18 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/6994a95adc51eac7f9dc60327597e2e6f1f6a8a0 [^]

Fixes issue 17342: You cannot install current APRM version on top of MP30. Build validation is not working

---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CheckAPRMVersionDependency.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CheckAPRMVersionDependencyData.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/CheckAPRMVersionDependency.java
M src-util/buildvalidation/src/org/openbravo/buildvalidation/CheckAPRMVersionDependency_data.xsql
---
(0037410)
psarobe   
2011-05-25 10:38   
Still same issue
(0037412)
psarobe   
2011-05-25 10:41   
set.code.rev:

code.rev:

init:

core.lib:

init:

compile:

build.jar:

build:

copy.core.lib:

database.lib:

init:

compile:

build.jar:

jar:

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.advpaymentmngt.buildvalidation.UniquePaymentForTransaction
[java] 11406 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments

update.database:
[sql] Executing commands
[sql] 2 of 2 SQL statements executed successfully

update.database.java:
[java] Executing database update process without checking changes in local files.
[java] 0 INFO - Database connection: jdbc:oracle:thin:@localhost:1521:oborcl. User: TAD
[java] 22238 INFO - Executing full update.database
[java] 22259 INFO - Reading tables...
[java] 50406 INFO - Reading views...
[java] 50531 INFO - Reading sequences...
[java] 50587 INFO - Reading triggers...
[java] 51028 INFO - Reading functions...
[java] 52159 INFO - Sorting foreign keys, indexes and checks...
[java] 52277 INFO - Checking datatypes from the model loaded from the database
[java] 52301 INFO - Original model loaded from database.
[java] 61093 INFO - Checking datatypes from the model loaded from XML files
[java] 61501 INFO - Loading data from XML files
[java] 69156 INFO - Loading and applying configuration scripts
[java] Checking if database structure was modified locally.
[java] Checking if data has changed in the application dictionary.
[java] 71568 INFO - Executing default prescript
[java] 73710 INFO - Executed 10 SQL command(s) successfully
[java] 73728 INFO - Updating database model...
[java] 86182 INFO - Executed 359 SQL command(s) successfully
[java] 86241 INFO - Model update complete.
[java] 86253 INFO - Disabling foreign keys
[java] 166372 INFO - Disabling triggers
[java] 193150 INFO - Executed 513 SQL command(s) successfully
[java] 193192 INFO - Executing moduleScript: org.openbravo.modulescript.AdminFlagOnCreateDefaults
[java] 193292 INFO - Executing moduleScript: org.openbravo.modulescript.CreateDoctypeTemplate
[java] 193391 INFO - Executing moduleScript: org.openbravo.modulescript.HBFix
[java] 193434 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateEmailPasswords
[java] 193465 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateFinancialAccountAccounts
[java] 193504 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateReversalDocumentTypes
[java] 193534 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.AlertsForWrongInvoices
[java] 193602 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.CreateAccountingConfiguration
[java] 198953 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.CreateDocumentNoSequence
[java] 199356 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateGeneratedUsedCreditColumns
[java] 199416 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateOldFlowInvoices
[java] 199549 INFO - Executing moduleScript: org.openbravo.userinterface.selector.UpdateLanguageColumn
[java] 199593 INFO - Loading and applying configuration scripts
[java] 199620 INFO - Comparing databases to find differences
[java] 206709 INFO - Updating Application Dictionary data...
[java] 218764 ERROR - Error while inserting into the database: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
[java] org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1609)
[java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1513)
[java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:780)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:184)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1600)
[java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1513)
[java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:780)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:184)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1600)
[java] ... 5 more
[java] Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:225)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1609)
[java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1513)
[java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:780)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:184)
[java] ... 2 more
[java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1600)
[java] ... 5 more
[java] --- Nested Exception ---
[java] org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1609)
[java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1513)
[java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:780)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:184)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TAD.AD_EXTENSION_POINTS_KEY) violated
[java]
[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
[java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1600)
[java] ... 5 more