0029923: upgrading from 2.50 to pi shows errors in update.database log

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #29923		[ All Revisions ] [ Back to Issue ]
Summary	0029923: upgrading from 2.50 to pi shows errors in update.database log

Revision	2015-05-19 10:18 by alostale
Steps To Reproduce	Install 2.50: hg clone pi hg up -C 2.50MP24 ant install.source Prepare to upgrade (fix some data): psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');' Upgrade ant smartbuild -Dlocal=no These errors appear in the log: [java] 124879 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection. [java] 124913 WARN - SQL Command failed with: ERROR: constraint "ad_createfact_template_ad_tabl" of relation "ad_createfact_template" does not exist [java] 124918 WARN - -- END [java] ALTER TABLE AD_CREATEFACT_TEMPLATE [java] DROP CONSTRAINT AD_CREATEFACT_TEMPLATE_AD_TABL [java] 125102 WARN - SQL Command failed with: ERROR: constraint "ad_process_request_ad_process" of relation "ad_process_request" does not exist [java] 125129 WARN - -- END [java] ALTER TABLE AD_PROCESS_REQUEST [java] DROP CONSTRAINT AD_PROCESS_REQUEST_AD_PROCESS [java] 125259 WARN - SQL Command failed with: ERROR: constraint "fact_acct_ad_table" of relation "fact_acct" does not exist [java] 125274 WARN - -- END [java] ALTER TABLE FACT_ACCT [java] DROP CONSTRAINT FACT_ACCT_AD_TABLE You can see this error in CI: https://ci.openbravo.com/job/up-2.50topi-pgsql/74/ [^]

Revision	2015-05-19 10:17 by alostale
Steps To Reproduce	Install 2.50: hg clone pi hg up -C 2.50MP24 ant install.source Prepare to upgrade (fix some data): psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');' Upgrade ant smartbuild -Dlocal=no This errors appear in the log: [java] 124879 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection. [java] 124913 WARN - SQL Command failed with: ERROR: constraint "ad_createfact_template_ad_tabl" of relation "ad_createfact_template" does not exist [java] 124918 WARN - -- END [java] ALTER TABLE AD_CREATEFACT_TEMPLATE [java] DROP CONSTRAINT AD_CREATEFACT_TEMPLATE_AD_TABL [java] 125102 WARN - SQL Command failed with: ERROR: constraint "ad_process_request_ad_process" of relation "ad_process_request" does not exist [java] 125129 WARN - -- END [java] ALTER TABLE AD_PROCESS_REQUEST [java] DROP CONSTRAINT AD_PROCESS_REQUEST_AD_PROCESS [java] 125259 WARN - SQL Command failed with: ERROR: constraint "fact_acct_ad_table" of relation "fact_acct" does not exist [java] 125274 WARN - -- END [java] ALTER TABLE FACT_ACCT [java] DROP CONSTRAINT FACT_ACCT_AD_TABLE You can see this error in CI: https://ci.openbravo.com/job/up-2.50topi-pgsql/74/ [^]

Revision	2015-05-19 09:50 by alostale
Steps To Reproduce	Install 2.50: hg clone pi hg up -C 2.50MP24 ant install.source Prepare to upgrade (fix some data): psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');' psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');' Upgrade ant smartbuild -Dlocal=no This errors appear in the log: [java] 124879 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection. [java] 124913 WARN - SQL Command failed with: ERROR: constraint "ad_createfact_template_ad_tabl" of relation "ad_createfact_template" does not exist [java] 124918 WARN - -- END [java] ALTER TABLE AD_CREATEFACT_TEMPLATE [java] DROP CONSTRAINT AD_CREATEFACT_TEMPLATE_AD_TABL [java] 125102 WARN - SQL Command failed with: ERROR: constraint "ad_process_request_ad_process" of relation "ad_process_request" does not exist [java] 125129 WARN - -- END [java] ALTER TABLE AD_PROCESS_REQUEST [java] DROP CONSTRAINT AD_PROCESS_REQUEST_AD_PROCESS [java] 125259 WARN - SQL Command failed with: ERROR: constraint "fact_acct_ad_table" of relation "fact_acct" does not exist [java] 125274 WARN - -- END [java] ALTER TABLE FACT_ACCT [java] DROP CONSTRAINT FACT_ACCT_AD_TABLE You can see this error in CI: https://ci.openbravo.com/job/up-2.50topi-pgsql/74/ [^]

Revision	2015-05-19 09:45 by alostale
Steps To Reproduce	Install 2.50: hg clone pi hg up -C 2.50MP24 ant install.source Prepare to upgrade (fix some data): psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');' psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');' Upgrade ant smartbuild -Dlocal=no This errors appear in the log: [java] 124879 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection. [java] 124913 WARN - SQL Command failed with: ERROR: constraint "ad_createfact_template_ad_tabl" of relation "ad_createfact_template" does not exist [java] 124918 WARN - -- END [java] ALTER TABLE AD_CREATEFACT_TEMPLATE [java] DROP CONSTRAINT AD_CREATEFACT_TEMPLATE_AD_TABL [java] 125102 WARN - SQL Command failed with: ERROR: constraint "ad_process_request_ad_process" of relation "ad_process_request" does not exist [java] 125129 WARN - -- END [java] ALTER TABLE AD_PROCESS_REQUEST [java] DROP CONSTRAINT AD_PROCESS_REQUEST_AD_PROCESS [java] 125259 WARN - SQL Command failed with: ERROR: constraint "fact_acct_ad_table" of relation "fact_acct" does not exist [java] 125274 WARN - -- END [java] ALTER TABLE FACT_ACCT [java] DROP CONSTRAINT FACT_ACCT_AD_TABLE