Project:
View Revisions: Issue #36984 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0036984: Upgrading from 2.50 to pi some unique constraints are violated | ||
Revision | 2017-10-02 14:11 by inigosanchez | ||
Steps To Reproduce | Following the steps in the job[1]: 1.- hg clone a fresh pi 2.- hg up 2.50MP24 3.- ant install.source 4.- Execute the following query into the db: DELETE FROM C_BP_CUSTOMER_ACCT WHERE C_BP_CUSTOMER_ACCT_id IN ('1000020', '1000019', '1000024', '1000022', '1000021'); 5.- hg update tip 6.- ant smartbuild -Dlocal=no The following ERROR is raised: [java] 75270 INFO - Updating Application Dictionary data... [java] org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: duplicate key value violates unique constraint "ad_window_name" [java] Detail: Key (ad_client_id, name, ad_module_id)=(0, Cost Center, 0) already exists. [java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1724) [java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1618) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:851) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:228) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:57) |
||
Revision | 2017-10-02 13:52 by inigosanchez | ||
Steps To Reproduce | Following the steps in the job[1]: 1.- hg clone a fresh pi 2.- hg up 2.50MP24 3.- ant install.source 4.- Execute the following query into the db: DELETE FROM C_BP_CUSTOMER_ACCT WHERE C_BP_CUSTOMER_ACCT_id IN ('1000020', '1000019', '1000024', '1000022', '1000021'); 5.- hg update tip 6.- ant smartbuild -Dlocal=no The following ERROR is raised: ...................................... ...................................... [java] 75270 INFO - Updating Application Dictionary data... [java] org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: duplicate key value violates unique constraint "ad_window_name" [java] Detail: Key (ad_client_id, name, ad_module_id)=(0, Cost Center, 0) already exists. [java] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1724) [java] at org.apache.ddlutils.platform.PlatformImplBase.upsert(PlatformImplBase.java:1618) [java] at org.apache.ddlutils.platform.PlatformImplBase.alterData(PlatformImplBase.java:851) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:228) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:57) |
Copyright © 2000 - 2009 MantisBT Group |