0036886: install.source finishes with success even if a view cannot be created

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #36886		[ Back to Issue ]
Summary	0036886: install.source finishes with success even if a view cannot be created

Revision	2017-09-19 11:57 by AugustoMauch
Description	If there is a problem with the definition of a view (i.e. the view references a table that does not exist), the install.source task will finish with a success message, even though the following log will be written during the create.database subtask: SQL Command failed with: ERROR: relation "butipay_payment" does not exist Position: 2041 SQL Command failed with: ERROR: relation "butipay_payment" does not exist Position: 1740 SQL Command failed with: ERROR: relation "butipay_payment" does not exist Position: 1139 There are still 3 forced commands not executed sucessfully (likely related to failed view statements). If the update.database task is executed instead of install.source, the task will end with error, at is should: [java] 91617 INFO - Executed 6 forced SQL command(s) with 3 error(s) [java] 91625 INFO - Executed 3 forced SQL command(s) with 3 error(s) [java] 91632 INFO - Executed 3 forced SQL command(s) with 3 error(s) [java] 91639 INFO - Executed 3 forced SQL command(s) with 3 error(s) [java] 91645 INFO - Executed 3 forced SQL command(s) with 3 error(s) [java] 91650 WARN - SQL Command failed with: ERROR: relation "butipay_payment" does not exist [java] Position: 2041 [java] 91654 WARN - SQL Command failed with: ERROR: relation "butipay_payment" does not exist [java] Position: 1740 [java] 91659 WARN - SQL Command failed with: ERROR: relation "butipay_payment" does not exist [java] Position: 1139 [java] 91664 WARN - There are still 3 forced commands not executed sucessfully (likely related to failed view statements). [java] 91669 INFO - Enabling Foreign Keys and Triggers [java] 91708 INFO - Executed 11 SQL command(s) successfully [java] 91766 INFO - Executed 265 SQL command(s) successfully [java] 91775 INFO - Executing default postscript [java] 91953 INFO - Executed 14 SQL command(s) successfully [java] java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:277) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:57) [java] Exception in thread "main" java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:296) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:57) [java] Caused by: java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:277) [java] ... 2 more [java] 92653 ERROR - Not all the commands in the final update step were executed correctly. This likely means at least one foreign key was not activated successfully. Please review which one, and fix the missing references, or recover the backup of your sources. BUILD FAILED

Revision	2017-09-19 11:54 by AugustoMauch
Description	If there is a problem with the definition of a view (i.e. the view references a table that does not exist), the install.source task will finish with a success message, even though the following log will be written during the create.database subtask: SQL Command failed with: ERROR: relation "butipay_payment" does not exist Position: 2041 SQL Command failed with: ERROR: relation "butipay_payment" does not exist Position: 1740 SQL Command failed with: ERROR: relation "butipay_payment" does not exist Position: 1139 There are still 3 forced commands not executed sucessfully (likely related to failed view statements).