API tools faq
paste
Guest User

Untitled

a guest
Oct 18th, 2017
128
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 17.92 KB | None | 0 0
raw download clone embed print report
  1. Buildfile: /opt/OpenbravoERP-3.0/openbravo-erp/build.xml
  2.  
  3. set.code.rev:
  4.  
  5. code.rev:
  6.  
  7. init:
  8.  
  9. core.lib:
  10.  
  11. init:
  12.  
  13. compile:
  14.  
  15. build.jar:
  16.  
  17. build:
  18.  
  19. copy.core.lib:
  20.  
  21. database.lib:
  22.  
  23. init:
  24.  
  25. compile:
  26.  
  27. build.jar:
  28.  
  29. jar:
  30.  
  31. create.database:
  32.  
  33. create.database:
  34.  
  35. clean.database.POSTGRE:
  36.       [sql] Executing commands
  37.       [sql] 1 of 1 SQL statements executed successfully
  38.       [sql] Executing commands
  39.       [sql] 1 of 1 SQL statements executed successfully
  40.  
  41. prepare.database:
  42.  
  43. POSTGRE.structure:
  44.       [sql] Executing commands
  45.       [sql] 2 of 2 SQL statements executed successfully
  46.       [sql] Executing commands
  47.       [sql] 1 of 1 SQL statements executed successfully
  48.  
  49. create.database.all:
  50. Database connection: jdbc:postgresql://localhost:5932/openbravo. User: tad
  51. Executing default prescript
  52. Executed 118 SQL command(s) successfully
  53. Executing creation script
  54. for the complete database
  55. Executed 10759 SQL command(s) successfully
  56. Executed 4 forced SQL command(s) successfully
  57. Executing default postscript
  58. Executed 18 SQL command(s) successfully
  59. Writing checksum info
  60. Inserting data into the database.
  61. Executed 558 SQL command(s) successfully
  62. Executed 2307 SQL command(s) successfully
  63. Executed 63 SQL command(s) successfully
  64. Loading config script for module Openbravo 3.0. Path: /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/../../modules/org.openbravo.v3/src-db/database/configScript.xml
  65. Executed 450 SQL command(s) successfully
  66. Executed 142 SQL command(s) successfully
  67. Executed 5521 SQL command(s) successfully
  68. Executed 558 SQL command(s) successfully
  69. Error while executing SQL -- END
  70. ALTER TABLE AD_COLUMN
  71.     ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  72. [createdatabase] org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
  73. [createdatabase] ALTER TABLE AD_COLUMN
  74. [createdatabase]     ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  75. [createdatabase]    at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:361)
  76. [createdatabase]    at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
  77. [createdatabase]    at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
  78. [createdatabase]    at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:216)
  79. [createdatabase]    at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
  80. [createdatabase]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  81. [createdatabase]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  82. [createdatabase]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  83. [createdatabase]    at java.lang.reflect.Method.invoke(Method.java:597)
  84. [createdatabase]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  85. [createdatabase]    at org.apache.tools.ant.Task.perform(Task.java:348)
  86. [createdatabase]    at org.apache.tools.ant.Target.execute(Target.java:390)
  87. [createdatabase]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
  88. [createdatabase]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  89. [createdatabase]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  90. [createdatabase]    at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  91. [createdatabase]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
  92. [createdatabase]    at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
  93. [createdatabase]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  94. [createdatabase]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  95. [createdatabase]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  96. [createdatabase]    at java.lang.reflect.Method.invoke(Method.java:597)
  97. [createdatabase]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  98. [createdatabase]    at org.apache.tools.ant.Task.perform(Task.java:348)
  99. [createdatabase]    at org.apache.tools.ant.Target.execute(Target.java:390)
  100. [createdatabase]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
  101. [createdatabase]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  102. [createdatabase]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  103. [createdatabase]    at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  104. [createdatabase]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
  105. [createdatabase]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  106. [createdatabase]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  107. [createdatabase]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  108. [createdatabase]    at java.lang.reflect.Method.invoke(Method.java:597)
  109. [createdatabase]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  110. [createdatabase]    at org.apache.tools.ant.Task.perform(Task.java:348)
  111. [createdatabase]    at org.apache.tools.ant.Target.execute(Target.java:390)
  112. [createdatabase]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
  113. [createdatabase]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  114. [createdatabase]    at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
  115. [createdatabase]    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  116. [createdatabase]    at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  117. [createdatabase]    at org.apache.tools.ant.Main.runBuild(Main.java:801)
  118. [createdatabase]    at org.apache.tools.ant.Main.startAnt(Main.java:218)
  119. [createdatabase]    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
  120. [createdatabase]    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
  121. [createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_element_ad_column"
  122. [createdatabase]   Dettaglio: Key (ad_element_id)=(2083) is not present in table "ad_element".
  123. [createdatabase]    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  124. [createdatabase]    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  125. [createdatabase]    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  126. [createdatabase]    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  127. [createdatabase]    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  128. [createdatabase]    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  129. [createdatabase]    at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  130. [createdatabase]    at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  131. [createdatabase]    at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:328)
  132. [createdatabase]    ... 45 more
  133. Error while enabling foreign key
  134. [createdatabase] org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
  135. [createdatabase]    at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:315)
  136. [createdatabase]    at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
  137. [createdatabase]    at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:216)
  138. [createdatabase]    at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
  139. [createdatabase]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  140. [createdatabase]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  141. [createdatabase]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  142. [createdatabase]    at java.lang.reflect.Method.invoke(Method.java:597)
  143. [createdatabase]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  144. [createdatabase]    at org.apache.tools.ant.Task.perform(Task.java:348)
  145. [createdatabase]    at org.apache.tools.ant.Target.execute(Target.java:390)
  146. [createdatabase]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
  147. [createdatabase]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  148. [createdatabase]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  149. [createdatabase]    at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  150. [createdatabase]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
  151. [createdatabase]    at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
  152. [createdatabase]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  153. [createdatabase]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  154. [createdatabase]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  155. [createdatabase]    at java.lang.reflect.Method.invoke(Method.java:597)
  156. [createdatabase]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  157. [createdatabase]    at org.apache.tools.ant.Task.perform(Task.java:348)
  158. [createdatabase]    at org.apache.tools.ant.Target.execute(Target.java:390)
  159. [createdatabase]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
  160. [createdatabase]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  161. [createdatabase]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  162. [createdatabase]    at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  163. [createdatabase]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
  164. [createdatabase]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  165. [createdatabase]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  166. [createdatabase]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  167. [createdatabase]    at java.lang.reflect.Method.invoke(Method.java:597)
  168. [createdatabase]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  169. [createdatabase]    at org.apache.tools.ant.Task.perform(Task.java:348)
  170. [createdatabase]    at org.apache.tools.ant.Target.execute(Target.java:390)
  171. [createdatabase]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
  172. [createdatabase]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  173. [createdatabase]    at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
  174. [createdatabase]    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  175. [createdatabase]    at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  176. [createdatabase]    at org.apache.tools.ant.Main.runBuild(Main.java:801)
  177. [createdatabase]    at org.apache.tools.ant.Main.startAnt(Main.java:218)
  178. [createdatabase]    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
  179. [createdatabase]    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
  180. [createdatabase] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
  181. [createdatabase] ALTER TABLE AD_COLUMN
  182. [createdatabase]     ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  183. [createdatabase]    at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:361)
  184. [createdatabase]    at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
  185. [createdatabase]    ... 44 more
  186. [createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_element_ad_column"
  187. [createdatabase]   Dettaglio: Key (ad_element_id)=(2083) is not present in table "ad_element".
  188. [createdatabase]    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  189. [createdatabase]    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  190. [createdatabase]    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  191. [createdatabase]    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  192. [createdatabase]    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  193. [createdatabase]    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  194. [createdatabase]    at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  195. [createdatabase]    at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  196. [createdatabase]    at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:328)
  197. [createdatabase]    ... 45 more
  198.  
  199. BUILD FAILED
  200. /opt/OpenbravoERP-3.0/openbravo-erp/build.xml:707: The following error occurred while executing this line:
  201. /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/build-create.xml:52: The following error occurred while executing this line:
  202. /opt/OpenbravoERP-3.0/openbravo-erp/src-db/database/build-create.xml:228: org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
  203.     at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:315)
  204.     at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
  205.     at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:216)
  206.     at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
  207.     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  208.     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  209.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  210.     at java.lang.reflect.Method.invoke(Method.java:597)
  211.     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  212.     at org.apache.tools.ant.Task.perform(Task.java:348)
  213.     at org.apache.tools.ant.Target.execute(Target.java:390)
  214.     at org.apache.tools.ant.Target.performTasks(Target.java:411)
  215.     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  216.     at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  217.     at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  218.     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
  219.     at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
  220.     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  221.     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  222.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  223.     at java.lang.reflect.Method.invoke(Method.java:597)
  224.     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  225.     at org.apache.tools.ant.Task.perform(Task.java:348)
  226.     at org.apache.tools.ant.Target.execute(Target.java:390)
  227.     at org.apache.tools.ant.Target.performTasks(Target.java:411)
  228.     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  229.     at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  230.     at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  231.     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
  232.     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  233.     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  234.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  235.     at java.lang.reflect.Method.invoke(Method.java:597)
  236.     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  237.     at org.apache.tools.ant.Task.perform(Task.java:348)
  238.     at org.apache.tools.ant.Target.execute(Target.java:390)
  239.     at org.apache.tools.ant.Target.performTasks(Target.java:411)
  240.     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)
  241.     at org.apache.tools.ant.Project.executeTarget(Project.java:1329)
  242.     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  243.     at org.apache.tools.ant.Project.executeTargets(Project.java:1212)
  244.     at org.apache.tools.ant.Main.runBuild(Main.java:801)
  245.     at org.apache.tools.ant.Main.startAnt(Main.java:218)
  246.     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
  247.     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
  248. Caused by: org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
  249. ALTER TABLE AD_COLUMN
  250.     ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  251.     at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:361)
  252.     at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
  253.     ... 44 more
  254. Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_element_ad_column"
  255.   Dettaglio: Key (ad_element_id)=(2083) is not present in table "ad_element".
  256.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  257.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  258.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  259.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  260.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  261.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  262.     at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  263.     at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  264.     at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:328)
  265.     ... 45 more
  266.  
  267. Total time: 2 minutes 15 seconds
Add Comment
Please, Sign In to add comment
Public Pastes
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!