API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 1st, 2017
120
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.17 KB | None | 0 0
raw download clone embed print report
  1. openbravo@Rajagopal-desktop:~/workspaces/sprint19/openbravo$ ant install.source
  2. Buildfile: 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. create.database:
  33.  
  34. create.database:
  35.  
  36. clean.database.POSTGRE:
  37. [sql] Executing commands
  38. [sql] 1 of 1 SQL statements executed successfully
  39. [sql] Executing commands
  40. [sql] 1 of 1 SQL statements executed successfully
  41.  
  42. prepare.database:
  43.  
  44. POSTGRE.structure:
  45. [sql] Executing commands
  46. [sql] 2 of 2 SQL statements executed successfully
  47. [sql] Executing commands
  48. [sql] 1 of 1 SQL statements executed successfully
  49.  
  50. create.database.all:
  51. Database connection: jdbc:postgresql://localhost:5432/sprint19. User: sprint19
  52. Executing default prescript
  53. Executed 116 SQL command(s) with 0 error(s)
  54. Executing creation script
  55. for the complete database
  56. Executed 5596 SQL command(s) with 0 error(s)
  57. Executed 10 forced SQL command(s) with 0 error(s)
  58. Executing default postscript
  59. Executed 20 SQL command(s) with 0 error(s)
  60. Writing checksum info
  61. Inserting data into the database.
  62. Executed 436 SQL command(s) with 0 error(s)
  63. Executed 2341 SQL command(s) with 0 error(s)
  64. Executed 74 SQL command(s) with 0 error(s)
  65. Executed 137 SQL command(s) with 0 error(s)
  66. Executed 5232 SQL command(s) with 0 error(s)
  67. Executed 436 SQL command(s) with 0 error(s)
  68. Error while executing SQL -- END
  69. ALTER TABLE AD_COLUMN
  70. ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  71. [createdatabase] org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
  72. [createdatabase] ALTER TABLE AD_COLUMN
  73. [createdatabase] ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  74. [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:354)
  75. [createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:302)
  76. [createdatabase] at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
  77. [createdatabase] at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:191)
  78. [createdatabase] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:79)
  79. [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
  80. [createdatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  81. [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  82. [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
  83. [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  84. [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
  85. [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
  86. [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
  87. [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
  88. [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  89. [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
  90. [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
  91. [createdatabase] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
  92. [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
  93. [createdatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  94. [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  95. [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
  96. [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  97. [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
  98. [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
  99. [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
  100. [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
  101. [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  102. [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
  103. [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
  104. [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
  105. [createdatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  106. [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  107. [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
  108. [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  109. [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
  110. [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
  111. [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
  112. [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
  113. [createdatabase] at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
  114. [createdatabase] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  115. [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
  116. [createdatabase] at org.apache.tools.ant.Main.runBuild(Main.java:758)
  117. [createdatabase] at org.apache.tools.ant.Main.startAnt(Main.java:217)
  118. [createdatabase] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
  119. [createdatabase] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
  120. [createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_element_ad_column"
  121. [createdatabase] Detail: Key (ad_element_id)=(4FCEE23FA4B14007BAAA71CC8FF856FD) is not present in table "ad_element".
  122. [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
  123. [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
  124. [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
  125. [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
  126. [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
  127. [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
  128. [createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
  129. [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:321)
  130. [createdatabase] ... 45 more
  131. Error while enabling foreign key
  132. [createdatabase] org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
  133. [createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:310)
  134. [createdatabase] at org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:245)
  135. [createdatabase] at org.openbravo.ddlutils.task.CreateDatabase.doExecute(CreateDatabase.java:191)
  136. [createdatabase] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:79)
  137. [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
  138. [createdatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  139. [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  140. [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
  141. [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  142. [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
  143. [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
  144. [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
  145. [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
  146. [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  147. [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
  148. [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
  149. [createdatabase] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
  150. [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
  151. [createdatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  152. [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  153. [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
  154. [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  155. [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
  156. [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
  157. [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
  158. [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
  159. [createdatabase] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  160. [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
  161. [createdatabase] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
  162. [createdatabase] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
  163. [createdatabase] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  164. [createdatabase] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  165. [createdatabase] at java.lang.reflect.Method.invoke(Method.java:597)
  166. [createdatabase] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  167. [createdatabase] at org.apache.tools.ant.Task.perform(Task.java:348)
  168. [createdatabase] at org.apache.tools.ant.Target.execute(Target.java:357)
  169. [createdatabase] at org.apache.tools.ant.Target.performTasks(Target.java:385)
  170. [createdatabase] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
  171. [createdatabase] at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
  172. [createdatabase] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  173. [createdatabase] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
  174. [createdatabase] at org.apache.tools.ant.Main.runBuild(Main.java:758)
  175. [createdatabase] at org.apache.tools.ant.Main.startAnt(Main.java:217)
  176. [createdatabase] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
  177. [createdatabase] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
  178. [createdatabase] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while executing SQL -- END
  179. [createdatabase] ALTER TABLE AD_COLUMN
  180. [createdatabase] ADD CONSTRAINT AD_ELEMENT_AD_COLUMN FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
  181. [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:354)
  182. [createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:302)
  183. [createdatabase] ... 44 more
  184. [createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_element_ad_column"
  185. [createdatabase] Detail: Key (ad_element_id)=(4FCEE23FA4B14007BAAA71CC8FF856FD) is not present in table "ad_element".
  186. [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
  187. [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
  188. [createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
  189. [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
  190. [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
  191. [createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
  192. [createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
  193. [createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:321)
  194. [createdatabase] ... 45 more
  195.  
  196. BUILD FAILED
  197. /home/openbravo/workspaces/sprint19/openbravo/build.xml:564: The following error occurred while executing this line:
  198. /home/openbravo/workspaces/sprint19/openbravo/src-db/database/build-create.xml:52: The following error occurred while executing this line:
  199. /home/openbravo/workspaces/sprint19/openbravo/src-db/database/build-create.xml:228: org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
  200.  
  201. Total time: 9 minutes 21 seconds
  202. openbravo@Rajagopal-desktop:~/workspaces/sprint19/openbravo$
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!