API tools faq
paste
Advertisement
edje8989

with db

edje8989
Dec 10th, 2014
202
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.38 KB | None | 0 0
raw download clone embed print report
  1. MBP-van-Edwin:openbravo erasser$ ant update.database -Dforce=true compile.complete
  2. Buildfile: /Users/erasser/Documents/work/openbravo/build.xml
  3.  
  4. set.code.rev:
  5.  
  6. code.rev:
  7.  
  8. init:
  9.  
  10. core.lib:
  11.  
  12. init:
  13.  
  14. compile:
  15.  
  16. build.jar:
  17.  
  18. build:
  19.  
  20. copy.core.lib:
  21.  
  22. database.lib:
  23.  
  24. init:
  25.  
  26. compile:
  27.  
  28. build.jar:
  29.  
  30. jar:
  31.  
  32. buildvalidation:
  33. [sql] Executing commands
  34. [sql] 2 of 2 SQL statements executed successfully
  35.  
  36. buildvalidation:
  37. [java] 1 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.AccountingTabs
  38. [java] 818 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicateDocExchangeRate
  39. [java] 879 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedJavaPackage
  40. [java] 917 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedPriceListVersion
  41. [java] 960 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.PaymentGLItemCheck
  42. [java] 977 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.PreferenceConflict
  43. [java] 1055 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.User1Ready
  44. [java] 1151 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UniquePaymentForTransaction
  45. [java] 1218 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments
  46. [java] 1265 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.WrongPaymentScheduleDetailsCheck
  47.  
  48. update.database:
  49. [sql] Executing commands
  50. [sql] 2 of 2 SQL statements executed successfully
  51.  
  52. update.database.java:
  53. [java] Executing database update process without checking changes in local files.
  54. [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5433/openbravo. User: tad
  55. [java] 1568 INFO - Executing full update.database
  56. [java] 1582 INFO - Reading tables...
  57. [java] 24068 INFO - Reading views...
  58. [java] 24479 INFO - Reading sequences...
  59. [java] 24496 INFO - Reading triggers...
  60. [java] 24613 INFO - Reading functions...
  61. [java] 25544 INFO - Sorting foreign keys, indexes and checks...
  62. [java] 25682 INFO - Starting function and trigger standardization.
  63. [java] 56325 INFO - Checking datatypes from the model loaded from the database
  64. [java] 56334 INFO - Original model loaded from database.
  65. [java] 56494 INFO - Reading model files...
  66. [java] 68047 INFO - Checking datatypes from the model loaded from XML files
  67. [java] 68136 INFO - Loading data from XML files
  68. [java] 77974 INFO - Loading and applying configuration scripts
  69. [java] 77998 INFO - Applying structure part of configuration script: org.openbravo.v3
  70. [java] 78009 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/org.openbravo.v3/src-db/database/configScript.xml
  71. [java] 78118 INFO - Applying structure part of configuration script: biz.cleardrop.warehouse.pickinglist.template
  72. [java] 78126 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.warehouse.pickinglist.template/src-db/database/configScript.xml
  73. [java] 78153 INFO - Applying structure part of configuration script: biz.cleardrop.salarypaymentapprovaltemplate
  74. [java] 78177 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.salarypaymentapprovaltemplate/src-db/database/configScript.xml
  75. [java] 78199 INFO - Applying structure part of configuration script: biz.cleardrop.webshopproducts.template
  76. [java] 78215 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.webshopproducts.template/src-db/database/configScript.xml
  77. [java] 78227 INFO - Applying structure part of configuration script: biz.cleardrop.createrfctpl
  78. [java] 78240 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.createrfctpl/src-db/database/configScript.xml
  79. [java] 78262 INFO - Applying structure part of configuration script: biz.cleardrop.pricingengine.template
  80. [java] 78278 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.pricingengine.template/src-db/database/configScript.xml
  81. [java] 78292 INFO - Applying structure part of configuration script: biz.cleardrop.poapprovaltemplate
  82. [java] 78307 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.poapprovaltemplate/src-db/database/configScript.xml
  83. [java] 78326 INFO - Applying structure part of configuration script: biz.cleardrop.pricecalculation.template
  84. [java] 78343 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.pricecalculation.template/src-db/database/configScript.xml
  85. [java] Checking if database structure was modified locally.
  86. [java] 80058 INFO - Database was modified locally, but as update.database command is forced, the database will be updated anyway.
  87. [java] 80070 INFO - Executing default prescript
  88. [java] 80215 WARN - SQL Command failed with: ERROR: must be owner of operator +
  89. [java] 80222 WARN - -- END
  90. [java]
  91. [java] CREATE OPERATOR +(
  92. [java] PROCEDURE = "add_days",
  93. [java] LEFTARG = timestamptz,
  94. [java] RIGHTARG = numeric,
  95. [java] COMMUTATOR = +)
  96. [java] 80228 WARN - SQL Command failed with: ERROR: must be owner of operator +
  97. [java] 80235 WARN - -- END
  98. [java]
  99. [java] CREATE OPERATOR + (
  100. [java] LEFTARG = date,
  101. [java] RIGHTARG = numeric,
  102. [java] PROCEDURE = add_days,
  103. [java] COMMUTATOR = +
  104. [java] )
  105. [java] 80404 WARN - SQL Command failed with: ERROR: permission denied for language c
  106. [java] 80418 WARN - -- END
  107. [java]
  108. [java]
  109. [java] CREATE OR REPLACE FUNCTION uuid_generate_v4()
  110. [java] RETURNS uuid
  111. [java] AS '$libdir/uuid-ossp', 'uuid_generate_v4'
  112. [java] VOLATILE STRICT LANGUAGE C;
  113. [java]
  114. [java] CREATE OR REPLACE FUNCTION get_uuid()
  115. [java] RETURNS varchar AS
  116. [java] $BODY$ DECLARE
  117. [java] /*************************************************************************
  118. [java] * The contents of this file are subject to the Openbravo Public License
  119. [java] * Version 1.1 (the "License"), being the Mozilla Public License
  120. [java] * Version 1.1 with a permitted attribution clause; you may not use this
  121. [java] * file except in compliance with the License. You may obtain a copy of
  122. [java] * the License at http://www.openbravo.com/legal/license.html
  123. [java] * Software distributed under the License is distributed on an "AS IS"
  124. [java] * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
  125. [java] * License for the specific language governing rights and limitations
  126. [java] * under the License.
  127. [java] * The Original Code is Openbravo ERP.
  128. [java] * The Initial Developer of the Original Code is Openbravo SLU
  129. [java] * All portions are Copyright (C) 2008-2009 Openbravo SLU
  130. [java] * All Rights Reserved.
  131. [java] * Contributor(s): ______________________________________.
  132. [java] ************************************************************************/
  133. [java] var VARCHAR:=uuid_generate_v4();
  134. [java] BEGIN
  135. [java] WHILE var=uuid_generate_v4()::varchar LOOP
  136. [java] END LOOP;
  137. [java] return replace(upper(uuid_generate_v4()::varchar),'-','');
  138. [java] END; $BODY$
  139. [java] LANGUAGE 'plpgsql' VOLATILE
  140. [java] 80455 INFO - Executed 117 SQL command(s) with 3 error(s)
  141. [java] 80463 INFO - Updating database model...
  142. [java] 81147 INFO - Executed 81 SQL command(s) successfully
  143. [java] 81162 INFO - Executed 6 forced SQL command(s) with 1 error(s)
  144. [java] 81168 INFO - Executed 1 forced SQL command(s) successfully
  145. [java] 81172 INFO - Model update complete.
  146. [java] 81215 INFO - Disabling foreign keys
  147. [java] 82111 INFO - Executed 408 SQL command(s) successfully
  148. [java] 82122 INFO - Disabling triggers
  149. [java] 82309 INFO - Executed 398 SQL command(s) successfully
  150. [java] 82478 INFO - Executed 836 SQL command(s) successfully
  151. [java] 82496 INFO - Executing moduleScript: org.openbravo.modulescript.AdminFlagOnCreateDefaults
  152. [java] 82552 INFO - Executing moduleScript: org.openbravo.modulescript.AlertMASequenceProduct
  153. [java] 82597 INFO - Executing moduleScript: org.openbravo.modulescript.ConvertImages
  154. [java] 82643 INFO - Executing moduleScript: org.openbravo.modulescript.CreateDoctypeTemplate
  155. [java] 82689 INFO - Executing moduleScript: org.openbravo.modulescript.CreateLineForSequenceProduct
  156. [java] 82713 INFO - Executing moduleScript: org.openbravo.modulescript.DeleteDuplicateMatchInvoice
  157. [java] 82844 INFO - Executing moduleScript: org.openbravo.modulescript.DeleteInventoryLines
  158. [java] 82922 INFO - Executing moduleScript: org.openbravo.modulescript.DeleteRedundantTranslations
  159. [java] 82997 INFO - Executing moduleScript: org.openbravo.modulescript.HBFix
  160. [java] 83049 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeAcctDimensionsInClient
  161. [java] 83263 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeAlertStatus
  162. [java] 83311 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeBPCurrency
  163. [java] 83355 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeCostingMigrationPreference
  164. [java] 83376 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeGeneralLedgerOrganization
  165. [java] 83417 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeIsPaymentPaid
  166. [java] 83430 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeOnHandWarehouse
  167. [java] 83452 INFO - Executing moduleScript: org.openbravo.modulescript.Issue21640WrongMatchInvAccounting
  168. [java] 83503 INFO - Executing moduleScript: org.openbravo.modulescript.PaymentZeroAmount
  169. [java] 83548 INFO - Executing moduleScript: org.openbravo.modulescript.UniqueValidCombination
  170. [java] 83826 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateADClientInfo
  171. [java] 83898 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateADTrees
  172. [java] 83940 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateCostingRulesWhenNotCalculatedCosts
  173. [java] 83992 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateDueDate
  174. [java] 84033 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateEmailPasswords
  175. [java] 84061 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateFactAcctDescription
  176. [java] 84073 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateFinancialAccountAccounts
  177. [java] 84112 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateGrandTotal
  178. [java] 84126 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateMTransactionCostingStatus
  179. [java] 84141 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateOpenClosePeriodsButton
  180. [java] 84159 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateProcessGoodsJavaDocAction
  181. [java] 84172 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateProductPrice
  182. [java] 84219 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateRequestProcessOrg
  183. [java] 84233 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateReservationQtys
  184. [java] 84245 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateReversalDocumentTypes
  185. [java] 84300 INFO - Executing moduleScript: org.openbravo.modulescript.UpgradeToPocEmail
  186. [java] 84332 INFO - Executing moduleScript: biz.cleardrop.magentoconnectorenterprise.modulescript.TaskValidation
  187. [java] 84346 INFO - Executing moduleScript: nl.cleardrop.erpmag.modulescript.TaskValidation
  188. [java] 84416 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.AlertsForWrongInvoices
  189. [java] 84476 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.AlertsForWrongOrders
  190. [java] 84529 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.CreateAccountingConfiguration
  191. [java] 84681 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.CreateDocumentNoSequence
  192. [java] 84778 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.InitializeAPRMReadyPreference
  193. [java] 84791 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.LinkCreditPayments
  194. [java] 84844 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateCustomerBalance
  195. [java] 84872 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateGeneratedUsedCreditColumns
  196. [java] 84927 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdatePaymentScheduledetail
  197. [java] 84943 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateReconciliationProcessButtonValue
  198. [java] 84995 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateReconciliationStatementProcessedValue
  199. [java] 85065 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateRecordId2Value
  200. [java] 85109 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateTransactionBPExchangeRate
  201. [java] 85158 INFO - Executing moduleScript: org.openbravo.userinterface.selector.UpdateLanguageColumn
  202. [java] 85197 INFO - Executing moduleScript: org.openbravo.userinterface.skin.s250to300Comp.modulescript.DefaultSkin
  203. [java] 85237 INFO - Executing moduleScript: org.openbravo.v3.datasets.SetDefaultRole
  204. [java] 85269 INFO - Loading and applying configuration scripts
  205. [java] 85276 INFO - Applying data part of configuration script: org.openbravo.v3
  206. [java] 85280 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/org.openbravo.v3/src-db/database/configScript.xml
  207. [java] 86122 INFO - Applying data part of configuration script: biz.cleardrop.warehouse.pickinglist.template
  208. [java] 86134 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.warehouse.pickinglist.template/src-db/database/configScript.xml
  209. [java] 86149 INFO - Applying data part of configuration script: biz.cleardrop.salarypaymentapprovaltemplate
  210. [java] 86153 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.salarypaymentapprovaltemplate/src-db/database/configScript.xml
  211. [java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 0FE0C09374EC45F2998A7FF61F09EC75]
  212. [java] 86171 INFO - Applying data part of configuration script: biz.cleardrop.webshopproducts.template
  213. [java] 86174 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.webshopproducts.template/src-db/database/configScript.xml
  214. [java] 86185 INFO - Applying data part of configuration script: biz.cleardrop.createrfctpl
  215. [java] 86193 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.createrfctpl/src-db/database/configScript.xml
  216. [java] 86200 INFO - Applying data part of configuration script: biz.cleardrop.pricingengine.template
  217. [java] 86206 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.pricingengine.template/src-db/database/configScript.xml
  218. [java] 86217 INFO - Applying data part of configuration script: biz.cleardrop.poapprovaltemplate
  219. [java] 86221 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.poapprovaltemplate/src-db/database/configScript.xml
  220. [java] Warning: old value in row not equal to expected one. Table:[AD_COLUMN] PK[: 2221] Old Value found: @Processed@='Y' Old value expected @Posted@='Y'
  221. [java] 86277 INFO - Applying data part of configuration script: biz.cleardrop.pricecalculation.template
  222. [java] 86281 INFO - Loading configuration script: /Users/erasser/Documents/work/openbravo/modules/biz.cleardrop.pricecalculation.template/src-db/database/configScript.xml
  223. [java] 86298 INFO - Comparing databases to find differences
  224. [java] 89924 INFO - Updating Application Dictionary data...
  225. [java] 93215 INFO - Removing invalid rows.
  226. [java] 93836 INFO - Executed 92 SQL command(s) successfully
  227. [java] 93845 INFO - Recreating Primary Keys
  228. [java] 93933 INFO - Executing oncreatedefault statements for mandatory columns
  229. [java] 94779 INFO - Executed 247 SQL command(s) successfully
  230. [java] 94783 INFO - Recreating not null constraints
  231. [java] 95365 INFO - Executed 908 SQL command(s) successfully
  232. [java] 95370 INFO - Executing update final script (dropping temporary tables)
  233. [java] 96078 INFO - Executed 76 SQL command(s) successfully
  234. [java] 96127 INFO - Executed 5 forced SQL command(s) with 1 error(s)
  235. [java] 96132 INFO - Executed 1 forced SQL command(s) with 1 error(s)
  236. [java] 96139 INFO - Executed 1 forced SQL command(s) with 1 error(s)
  237. [java] 96146 INFO - Executed 1 forced SQL command(s) with 1 error(s)
  238. [java] 96153 INFO - Executed 1 forced SQL command(s) with 1 error(s)
  239. [java] 96156 WARN - SQL Command failed with: ERROR: operator does not exist: timestamp with time zone + numeric
  240. [java] Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  241. [java] Position: 2273
  242. [java] 96162 WARN - There are still 1 forced commands not executed sucessfully (likely related to failed view statements).
  243. [java] 96165 INFO - Enabling Foreign Keys and Triggers
  244. [java] 97957 INFO - Executed 408 SQL command(s) successfully
  245. [java] 98175 INFO - Executed 398 SQL command(s) successfully
  246. [java] 98183 INFO - Executing default postscript
  247. [java] 98223 WARN - SQL Command failed with: ERROR: permission denied for language c
  248. [java] 98227 WARN - -- END
  249. [java]
  250. [java] CREATE OR REPLACE FUNCTION uuid_generate_v4()
  251. [java] RETURNS uuid
  252. [java] AS '$libdir/uuid-ossp', 'uuid_generate_v4'
  253. [java] VOLATILE STRICT LANGUAGE C;
  254. [java] 98340 INFO - Executed 13 SQL command(s) with 1 error(s)
  255. [java] 100018 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.
  256. [java] java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
  257. [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:231)
  258. [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
  259. [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
  260. [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
  261. [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:250)
  262. [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
  263. [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
  264. [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
  265. [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:231)
  266. [java] ... 2 more
  267. [java] --- Nested Exception ---
  268. [java] java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
  269. [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:231)
  270. [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
  271. [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
  272.  
  273. BUILD FAILED
  274. /Users/erasser/Documents/work/openbravo/build.xml:740: The following error occurred while executing this line:
  275. /Users/erasser/Documents/work/openbravo/src-db/database/build.xml:80: Java returned: 1
  276.  
  277. Total time: 1 minute 46 seconds
  278. MBP-van-Edwin:openbravo erasser$
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!