API tools faq
paste
Advertisement
tko_pb

eror update.database

tko_pb
Aug 30th, 2018
361
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.72 KB | None | 0 0
raw download clone embed print report
  1. ~/kerja/openbravo2$ ant update.database
  2. OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=1024m; support was removed in 8.0
  3. Buildfile: /home/tiko/kerja/openbravo2/build.xml
  4.  
  5. set.code.rev:
  6.  
  7. code.rev:
  8.  
  9. init:
  10.  
  11. core.lib:
  12.  
  13. init:
  14.  
  15. compile:
  16.  
  17. build.jar:
  18.  
  19. build:
  20.  
  21. database.lib:
  22.  
  23. compile:
  24.  
  25. jar:
  26.  
  27. buildvalidation:
  28. [sql] Executing commands
  29. [sql] 2 of 2 SQL statements executed successfully
  30.  
  31. buildvalidation:
  32. [java] 0 [main] INFO org.openbravo.base.ExecutionLimitBaseProcess - Executing buildValidation: org.openbravo.buildvalidation.DatabaseDecimalNumberCheck
  33. [java] 19 [main] INFO org.openbravo.base.ExecutionLimitBaseProcess - Executing buildValidation: org.openbravo.buildvalidation.DatabaseVersionCheck
  34.  
  35. update.database:
  36. [sql] Executing commands
  37. [sql] 2 of 2 SQL statements executed successfully
  38.  
  39. update.database.java:
  40. [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5432/openbravo. User: postgres. System User: postgres
  41. [java] 794 INFO - Executing full update.database
  42. [java] 799 INFO - Max threads 2
  43. [java] 1139 INFO - Loading model from database...
  44. [java] 1154 INFO - Reading tables...
  45. [java] 7442 INFO - Reading views...
  46. [java] 7564 INFO - Reading sequences...
  47. [java] 7570 INFO - Reading triggers...
  48. [java] 7601 INFO - Reading functions...
  49. [java] 8003 INFO - Sorting foreign keys, indexes and checks...
  50. [java] 8081 INFO - Starting function trigger and view standardization in 2 threads
  51. [java] 17880 INFO - Standardidized 308 functions, 318 triggers and 47 views in 9800 ms
  52. [java] 17895 INFO - Reading model files...
  53. [java] 22831 INFO - Loading data from XML files
  54. [java] 25934 INFO - Loading and applying configuration scripts
  55. [java] 25940 INFO - Applying data part of configuration script: org.openbravo.v3
  56. [java] 25942 INFO - Loading configuration script: /home/tiko/kerja/openbravo2/modules/org.openbravo.v3/src-db/database/configScript.xml
  57. [java] 26630 INFO - Applying data part of configuration script: org.openbravo.importProdutCategory.template
  58. [java] 26633 INFO - Loading configuration script: /home/tiko/kerja/openbravo2/modules/org.openbravo.importProdutCategory.template/src-db/database/configScript.xml
  59. [java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 262]
  60. [java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 262]
  61. [java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 262]
  62. [java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 330]
  63. [java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 330]
  64. [java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 330]
  65. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 4674]
  66. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 4687]
  67. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7822]
  68. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7829]
  69. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7843]
  70. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7843]
  71. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7845]
  72. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7885]
  73. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7922]
  74. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7924]
  75. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 7924]
  76. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 8655]
  77. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 9038]
  78. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 9181]
  79. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 9243]
  80. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 9282]
  81. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 9282]
  82. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 9295]
  83. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 802886]
  84. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 803722]
  85. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 1005500001]
  86. [java] We didn't found the row that we wanted to change. Table:[AD_COLUMN] PK[: 1005500001]
  87. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 5969]
  88. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 5982]
  89. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 5982]
  90. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 5982]
  91. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 5984]
  92. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 6018]
  93. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 6018]
  94. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 6018]
  95. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 7152]
  96. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 7152]
  97. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 803231]
  98. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 1005500004]
  99. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 1005500004]
  100. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 1005500004]
  101. [java] We didn't found the row that we wanted to change. Table:[AD_VAL_RULE] PK[: 141]
  102. [java] 26994 INFO - Checking if database structure was modified locally.
  103. [java] 27667 INFO - Checking if data has changed in the application dictionary.
  104. [java] 27726 INFO - Executing script prescript-systemuser-PostgreSql.sql
  105. [java] 27746 INFO - Executed 3 SQL command(s) successfully in 5 ms
  106. [java] 27748 INFO - Executing script prescript-PostgreSql.sql
  107. [java] 27937 INFO - Executed 115 SQL command(s) successfully in 187 ms
  108. [java] 27941 INFO - Updating database model...
  109. [java] 28190 INFO - Executed 53 SQL command(s) successfully in 81 ms
  110. [java] 28199 INFO - Executed 5 forced SQL command(s) with 1 error(s) in 7 ms
  111. [java] 28205 INFO - Executed 1 forced SQL command(s) successfully in 13 ms
  112. [java] 28318 INFO - Executed 104 SQL command(s) successfully in 80 ms
  113. [java] 28354 INFO - Comparing databases to find data differences...
  114. [java] 30448 INFO - Disabling foreign keys
  115. [java] 30531 INFO - Executed 139 SQL command(s) successfully in 79 ms
  116. [java] 30534 INFO - Disabling triggers
  117. [java] 30573 INFO - Executed 226 SQL command(s) successfully in 33 ms
  118. [java] 30676 INFO - Executed 830 SQL command(s) successfully in 86 ms
  119. [java] 30679 INFO - Running modulescripts...
  120. [java] 30705 INFO - Executing moduleScript: org.openbravo.modulescript.HBFix
  121. [java] 30721 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeCostingMigrationPreference
  122. [java] 30770 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.InitializeAPRMReadyPreference
  123. [java] 30788 INFO - Updating Application Dictionary data...
  124. [java] 31137 INFO - Recreating Primary Keys...
  125. [java] 31192 INFO - Executing oncreatedefault statements for mandatory columns...
  126. [java] 31363 INFO - Executed 80 SQL command(s) successfully in 156 ms
  127. [java] 31604 INFO - Executed 900 SQL command(s) successfully in 226 ms
  128. [java] 31606 INFO - Dropping temporary tables...
  129. [java] 31942 INFO - Executed 65 SQL command(s) successfully in 312 ms
  130. [java] 31962 INFO - Executed 3 forced SQL command(s) successfully in 16 ms
  131. [java] 31964 INFO - Enabling Foreign Keys...
  132. [java] 32001 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection.
  133. [java] 32035 WARN - SQL Command failed with: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_element_ad_column"
  134. [java] Detail: Key (ad_element_id)=(912) is not present in table "ad_element".
  135. [java] 32037 WARN - -- END
  136. [java] ALTER TABLE AD_COLUMN
  137. [java] ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  138. [java] 32157 WARN - SQL Command failed with: ERROR: insert or update on table "ad_module_dependency" violates foreign key constraint "ad_module_dependency_ad_depend"
  139. [java] Detail: Key (ad_dependent_module_id)=(FF8081812FBF677A012FBF6A0D3E0003) is not present in table "ad_module".
  140. [java] 32159 WARN - -- END
  141. [java] ALTER TABLE AD_MODULE_DEPENDENCY
  142. [java] ADD CONSTRAINT AD_MODULE_DEPENDENCY_AD_DEPEND FOREIGN KEY (AD_DEPENDENT_MODULE_ID) REFERENCES AD_MODULE (AD_MODULE_ID)
  143. [java] 32478 INFO - Executed 139 SQL command(s) with 2 error(s) in 475 ms
  144. [java] 32480 INFO - Enabling Triggers...
  145. [java] 32539 INFO - Executed 226 SQL command(s) successfully in 53 ms
  146. [java] 32543 INFO - Executing script postscript-PostgreSql.sql
  147. [java] 32569 INFO - Executed 12 SQL command(s) successfully in 23 ms
  148. [java] 33225 ERROR - Not all the foreign keys were correctly activated. Please review which ones were not, and fix the missing references, or recover the backup of your sources.
  149. [java] java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
  150. [java] at org.openbravo.ddlutils.process.DBUpdater.checkErrors(DBUpdater.java:324)
  151. [java] at org.openbravo.ddlutils.process.DBUpdater.update(DBUpdater.java:140)
  152. [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:69)
  153. [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:88)
  154. [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:81)
  155. [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
  156. [java] at org.openbravo.ddlutils.process.DBUpdater.update(DBUpdater.java:145)
  157. [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:69)
  158. [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:88)
  159. [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:81)
  160. [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
  161. [java] at org.openbravo.ddlutils.process.DBUpdater.checkErrors(DBUpdater.java:324)
  162. [java] at org.openbravo.ddlutils.process.DBUpdater.update(DBUpdater.java:140)
  163. [java] ... 3 more
  164.  
  165. BUILD FAILED
  166. /home/tiko/kerja/openbravo2/build.xml:704: The following error occurred while executing this line:
  167. /home/tiko/kerja/openbravo2/src-db/database/build.xml:80: Java returned: 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!