API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.85 KB | None | 0 0
raw download clone embed print report
  1. C:\stamps>gradlew flywaymigrate -i
  2. Starting Build
  3. Settings evaluated using settings file 'C:\stamps\settings.gradle'.
  4. Projects loaded. Root project using build file 'C:\stamps\build.gradle'.
  5. Included projects: [root project 'stamps', project ':optimizer', project ':services']
  6. Evaluating root project 'stamps' using build file 'C:\stamps\build.gradle'.
  7. Configuring agent
  8. Evaluating project ':optimizer' using build file 'C:\stamps\optimizer\build.gradle'.
  9. Compiling build file 'C:\stamps\optimizer\build.gradle' using SubsetScriptTransformer.
  10. Compiling build file 'C:\stamps\optimizer\build.gradle' using BuildScriptTransformer.
  11. Configuring agent
  12. Evaluating project ':services' using build file 'C:\stamps\services\build.gradle'.
  13. Compiling build file 'C:\stamps\services\build.gradle' using SubsetScriptTransformer.
  14. Compiling build file 'C:\stamps\services\build.gradle' using BuildScriptTransformer.
  15. file or directory 'C:\stamps\services\src\main\resources\db\pendingmigration', not found
  16. Configuring agent
  17. All projects evaluated.
  18. Selected primary task 'flywayMigrate' from project :
  19. Tasks to be executed: [task ':optimizer:compileJava', task ':optimizer:processResources', task ':optimizer:classes', task ':optimizer:jar', task ':services:compileJava', task ':services:processResources', task ':services:classes', task ':services:compileTestJav
  20. a', task ':services:processTestResources', task ':services:testClasses', task ':services:flywayMigrate']
  21. :optimizer:compileJava (Thread[main,5,main]) started.
  22. :optimizer:compileJava
  23. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
  24. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
  25. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
  26. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
  27. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-websocket', version='null', configuration='default'}
  28. Executing task ':optimizer:compileJava' (up-to-date check took 0.592 secs) due to:
  29. Output file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$StartTimeBin.class has changed.
  30. Output file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$TemporalBucket.class has changed.
  31. Output file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\work\TaskList.class has changed.
  32. All input files are considered out-of-date for incremental task ':optimizer:compileJava'.
  33. Compiling with JDK Java compiler API.
  34. Note: Some input files use or override a deprecated API.
  35. Note: Recompile with -Xlint:deprecation for details.
  36. Note: C:\stamps\optimizer\src\main\java\com\mai\billetoptimizer\util\NavigableSetMultimap.java uses unchecked or unsafe operations.
  37. Note: Recompile with -Xlint:unchecked for details.
  38. :optimizer:compileJava (Thread[main,5,main]) completed. Took 3.716 secs.
  39. :optimizer:processResources (Thread[main,5,main]) started.
  40. :optimizer:processResources
  41. file or directory 'C:\stamps\optimizer\src\main\resources', not found
  42. Skipping task ':optimizer:processResources' as it has no source files.
  43. :optimizer:processResources UP-TO-DATE
  44. :optimizer:processResources (Thread[main,5,main]) completed. Took 0.008 secs.
  45. :optimizer:classes (Thread[main,5,main]) started.
  46. :optimizer:classes
  47. Skipping task ':optimizer:classes' as it has no actions.
  48. :optimizer:classes (Thread[main,5,main]) completed. Took 0.006 secs.
  49. :optimizer:jar (Thread[main,5,main]) started.
  50. :optimizer:jar
  51. Executing task ':optimizer:jar' (up-to-date check took 0.042 secs) due to:
  52. Input file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$StartTimeBin.class has changed.
  53. Input file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$TemporalBucket.class has changed.
  54. Input file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\work\TaskList.class has changed.
  55. :optimizer:jar (Thread[main,5,main]) completed. Took 0.28 secs.
  56. :services:compileJava (Thread[main,5,main]) started.
  57. :services:compileJava
  58. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
  59. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
  60. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
  61. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
  62. Executing task ':services:compileJava' (up-to-date check took 0.236 secs) due to:
  63. Output file C:\stamps\services\build\classes\main\mil\navy\onr\stamps\db\dto\analysis\NmrsStudyOmShipclassWatchstationDetailsDTO.class has changed.
  64. Output file C:\stamps\services\build\classes\main\mil\navy\onr\stamps\db\dto\analysis\NmrsStudyWatchstationMappingDTO.class has changed.
  65. Output file C:\stamps\services\build\classes\main\mil\navy\onr\stamps\controller\analysis\OMAnalysisController.class has changed.
  66. All input files are considered out-of-date for incremental task ':services:compileJava'.
  67. Compiling with JDK Java compiler API.
  68. Note: C:\stamps\services\src\main\java\mil\navy\onr\stamps\service\analysis\OmAnalysisServiceImpl.java uses unchecked or unsafe operations.
  69. Note: Recompile with -Xlint:unchecked for details.
  70. :services:compileJava (Thread[main,5,main]) completed. Took 1.951 secs.
  71. :services:processResources (Thread[main,5,main]) started.
  72. :services:processResources
  73. Executing task ':services:processResources' (up-to-date check took 0.256 secs) due to:
  74. Output file C:\stamps\services\build\resources\main\application.local.properties has changed.
  75. Output file C:\stamps\services\build\resources\main\application.remote.properties has changed.
  76. :services:processResources (Thread[main,5,main]) completed. Took 0.932 secs.
  77. :services:classes (Thread[main,5,main]) started.
  78. :services:classes
  79. Skipping task ':services:classes' as it has no actions.
  80. :services:classes (Thread[main,5,main]) completed. Took 0.002 secs.
  81. :services:compileTestJava (Thread[main,5,main]) started.
  82. :services:compileTestJava
  83. Adding managed exclusion rule commons-logging:commons-logging to DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
  84. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
  85. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
  86. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
  87. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
  88. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
  89. Executing task ':services:compileTestJava' (up-to-date check took 0.222 secs) due to:
  90. No history is available.
  91. All input files are considered out-of-date for incremental task ':services:compileTestJava'.
  92. Compiling with JDK Java compiler API.
  93. Note: C:\stamps\services\src\test\java\mil\navy\onr\stamps\service\analysis\OMAnalysisServiceTest.java uses unchecked or unsafe operations.
  94. Note: Recompile with -Xlint:unchecked for details.
  95. :services:compileTestJava (Thread[main,5,main]) completed. Took 0.726 secs.
  96. :services:processTestResources (Thread[main,5,main]) started.
  97. :services:processTestResources
  98. file or directory 'C:\stamps\services\src\test\resources', not found
  99. Skipping task ':services:processTestResources' as it has no source files.
  100. :services:processTestResources UP-TO-DATE
  101. :services:processTestResources (Thread[main,5,main]) completed. Took 0.007 secs.
  102. :services:testClasses (Thread[main,5,main]) started.
  103. :services:testClasses
  104. Skipping task ':services:testClasses' as it has no actions.
  105. :services:testClasses (Thread[main,5,main]) completed. Took 0.001 secs.
  106. :services:flywayMigrate (Thread[main,5,main]) started.
  107. :services:flywayMigrate
  108. Executing task ':services:flywayMigrate' (up-to-date check took 0.001 secs) due to:
  109. Task has not declared any outputs.
  110. Adding managed exclusion rule commons-logging:commons-logging to DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
  111. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
  112. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
  113. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
  114. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
  115. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
  116. Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-tomcat', version='null', configuration='default'}
  117. Flyway 3.2.1 by Boxfuse
  118. Database: jdbc:postgresql://localhost:5432/stamps?autoReconnect=true (PostgreSQL 9.5)
  119. Validated 269 migrations (execution time 00:00.244s)
  120. Creating Metadata table: "public"."schema_version"
  121. Current version of schema "public": << Empty Schema >>
  122. outOfOrder mode is active. Migration of schema "public" may not be reproducible.
  123. Migrating schema "public" to version 1.0.01 - DDLAddedTheUUIDOSSPExtensionLibrary
  124. Migrating schema "public" to version 1.1.01 - DDLInitialDBCreationScriptsStartingWithDSBEAMigration
  125. Migrating schema "public" to version 1.1.02 - DDLFixGroupingDamageStateColumn
  126. Migrating schema "public" to version 1.1.03 - DDLFixGroupingDamageStateUpdateColumns
  127. Migrating schema "public" to version 1.1.04 - DDLFixDomainPersonOrganizationUpdateColumns
  128. Migrating schema "public" to version 1.1.05 - DDLFixGroupingApprovalStatusUpdateColumns
  129. Migrating schema "public" to version 1.1.06 - DDLFixScenarioShipScenarioUpdateColumns
  130. Migrating schema "public" to version 1.1.07 - DDLFixShipShipUpdateColumns
  131. Migrating schema "public" to version 1.1.08 - DDLAddEquipmentShipEquipmentInheritedConstrant
  132. Migrating schema "public" to version 1.1.09 - DMLInsertShipOrganizationalUnits
  133. Migrating schema "public" to version 1.1.10 - DMLInsertShipClasses
  134. Migrating schema "public" to version 1.1.11 - DMLInsertShips
  135. Migrating schema "public" to version 1.1.12 - DDLCreateTransitShipTransitPathView
  136. Migrating schema "public" to version 1.1.13 - DDLCreateShipShipCompartmentBoundaryShipCompartmentTable
  137. Migrating schema "public" to version 1.1.14 - DDLModifyShipCompartmentTableDropShipId
  138. Migrating schema "public" to version 1.1.15 - DDLModifyScenarioScenarioEventTableToRemoveScheduleRelatedFields
  139. Migrating schema "public" to version 1.1.16 - DDLCreateScenarioScenarioEquipmentEventTable
  140. Migrating schema "public" to version 1.1.17 - DDLCreateScenarioScenarioShipCompartmentEventTable
  141. Migrating schema "public" to version 1.1.18 - DDLCreateTrainingPQSSchemaAndTable
  142. Migrating schema "public" to version 1.1.19 - DDLCreateRoleRoleTableAndSchema
  143. Migrating schema "public" to version 1.1.20 - DDLModifyShipShipLocationTableFields
  144. Migrating schema "public" to version 1.1.21 - DDLModifyShipShipCompartmentTableFields
  145. Migrating schema "public" to version 1.1.22 - DDLCreateBilletBilletAndCrewTableAndSchema
  146. Migrating schema "public" to version 1.1.23 - DDLCreateWorkItemStateTables
  147. Migrating schema "public" to version 1.1.24 - DDLCreateBilletCrewMemberConfigurationBilletConditionShipLocationTable
  148. DB: identifier "crewconfiguration_billet__conditionshiplocation_crewconfiguration_billet_id_fkey" will be truncated to "crewconfiguration_billet__conditionshiplocation_crewconfigurati" (SQL State: 42622 - Error Code: 0)
  149. DB: identifier "crewconfiguration_billet__conditionshiplocation_condition_id_fkey" will be truncated to "crewconfiguration_billet__conditionshiplocation_condition_id_fk" (SQL State: 42622 - Error Code: 0)
  150. DB: identifier "crewconfiguration_billet__conditionshiplocation_shiplocation_id_fkey" will be truncated to "crewconfiguration_billet__conditionshiplocation_shiplocation_id" (SQL State: 42622 - Error Code: 0)
  151. Migrating schema "public" to version 1.1.25 - DDLModifyBilletCrewConfigurationBilletTable
  152. Migrating schema "public" to version 1.1.26 - DDLModifyShipShipLocationTableAddCoordinates
  153. Migrating schema "public" to version 1.1.27 - DDLCreateShipWatchAndWatchStationTables
  154. Migrating schema "public" to version 1.1.28 - DDLCreateEventEventTableAndModifiedEventEventToAddFields
  155. Migrating schema "public" to version 1.1.29 - DDLCreateTableBilletCrewConfigurationBilletWatchStationAssignment
  156. DB: identifier "crewconfiguration_billet__watchstationassignment_condition_id_fkey" will be truncated to "crewconfiguration_billet__watchstationassignment_condition_id_f" (SQL State: 42622 - Error Code: 0)
  157. DB: identifier "crewconfiguration_billet__watchstationassignment_crewconfiguration_billet_id_fkey" will be truncated to "crewconfiguration_billet__watchstationassignment_crewconfigurat" (SQL State: 42622 - Error Code: 0)
  158. DB: identifier "crewconfiguration_billet__watchstationassignment_watchstation_id" will be truncated to "crewconfiguration_billet__watchstationassignment_watchstation_i" (SQL State: 42622 - Error Code: 0)
  159. Migrating schema "public" to version 1.1.30 - DDLAlterTableScenarioScenario
  160. Migrating schema "public" to version 1.1.31 - DDLAlterScenarioScenarioEventTable
  161. Migrating schema "public" to version 1.1.32 - DMLInsertShipDepartmentDivisionWorkcenter
  162. Migrating schema "public" to version 1.1.33 - DDLCreatePQSSectionTable
  163. Migrating schema "public" to version 1.1.34 - DDLAlterBilletCrewConfigurationBilletWatchStationAssignment
  164. Migrating schema "public" to version 1.1.35 - DMLInsertPQS
  165. Migrating schema "public" to version 1.1.36 - DDLAlterTableBilletCrewConfigurationBilletWatchStationAssignmentShipWatchStationConstraint
  166. Migrating schema "public" to version 1.1.37 - DDLAlterTableScenarioScenarioEventAddColumn
  167. Migrating schema "public" to version 1.1.38 - DDLCreateTableEquipmentEquipmentEventProcedure
  168. Migrating schema "public" to version 1.1.39 - DDLCreateTableEquipmentEquipmentProcedureWorkItem
  169. Migrating schema "public" to version 1.1.40 - DDLCreateTableScenarioContainmentEvent
  170. Migrating schema "public" to version 1.1.41 - DDLAlterTableScenarioScenarioEquipmentEventChangeConstraint
  171. Migrating schema "public" to version 1.1.42 - DDLAlterTableScenarioScenarioCompartmentEventChangeConstraint
  172. Migrating schema "public" to version 1.1.43 - DDLAlterShipCompartmentTableAddNewFields
  173. Migrating schema "public" to version 1.1.44 - DDLAlterShipShipCompartmentTableRemovedFieldsInheritFromShipCompartmentTable
  174. Migrating schema "public" to version 1.1.45 - DDLAlterShipCompartmentAndShipShipCompartmentTablesAddedFields
  175. Migrating schema "public" to version 1.1.46 - DMLShipCompartmentInsert
  176. Migrating schema "public" to version 1.1.47 - DDLAlterShipCompartmentTableRemovedFields
  177. Migrating schema "public" to version 1.1.48 - DDLAddCompartmentNumberColumn
  178. Migrating schema "public" to version 1.1.49 - DDLAddBilletSequenceNumberToBilletTable
  179. Migrating schema "public" to version 1.1.50 - DMLInsertDDG1000Billets
  180. Migrating schema "public" to version 1.1.51 - DDLCreateTableSimulationScenario
  181. DB: identifier "simulation_event__workitem_simulation_predecessor_workitem_id_fkey" will be truncated to "simulation_event__workitem_simulation_predecessor_workitem_id_f" (SQL State: 42622 - Error Code: 0)
  182. DB: identifier "simulationcompartmenteventsignal_simulationcompartmentevent_id_fkey" will be truncated to "simulationcompartmenteventsignal_simulationcompartmentevent_id_" (SQL State: 42622 - Error Code: 0)
  183. Migrating schema "public" to version 1.1.52 - DDLAlterAndDropScenarioTables
  184. Migrating schema "public" to version 1.1.53 - DMLReinsertDDG1000Billets
  185. Migrating schema "public" to version 1.1.54 - DDLAlterTableScenarioShipScenario
  186. Migrating schema "public" to version 1.1.55 - DDLAlterSimulationTablesRename
  187. Migrating schema "public" to version 1.1.56 - DDLAlterTableSimulationShipSimulationAddShipId
  188. Migrating schema "public" to version 1.1.57 - DDLAlterTablesWorkWorkCatalystWorkItem
  189. Migrating schema "public" to version 1.1.58 - DDLAlterTableShipShipWatchStationAddShipLocation
  190. Migrating schema "public" to version 1.1.59 - DDLAlterTableSimulationSimulation EventAddColumns
  191. Migrating schema "public" to version 1.1.60 - DMLInsertWatchAndWatchStations
  192. Migrating schema "public" to version 1.1.61 - AlterAndCreateTablesForBilletShipCrewConfiguration
  193. Migrating schema "public" to version 1.1.62 - DMLInsertRoleRoleData
  194. Migrating schema "public" to version 1.1.63 - DMLInsertBilletCrewGroupData
  195. Migrating schema "public" to version 1.1.64 - DMLInsertBilletCrewGroupRoleData
  196. Migrating schema "public" to version 1.1.65 - DMLInsertBilletCrewConfigurationData
  197. Migrating schema "public" to version 1.1.66 - DMLInsertShipCrewConfigurationBilletData
  198. Migrating schema "public" to version 1.1.67 - DMLInsertItemStateWatchCondition
  199. Migrating schema "public" to version 1.1.68 - DMLInsertBilletShipCrewConfigurationBilletWatchStationAssignmentData
  200. Migrating schema "public" to version 1.1.69 - DDLCreatedViewBilletShipCrewConfigurationView
  201. Migrating schema "public" to version 1.1.70 - DDLCreateCareerFieldandRelatedTables
  202. Migrating schema "public" to version 1.1.71 - DDLCreateDesignatorTablesAndInsertData
  203. Migrating schema "public" to version 1.1.72 - DDLCreateRankTables
  204. Migrating schema "public" to version 1.1.73 - DMLUpdateCrewConfigurationRankCareerfieldPaygrade
  205. Migrating schema "public" to version 1.1.74 - DDLAlterBilletShipCrewConfigurationViewToAddId
  206. Migrating schema "public" to version 1.1.75 - DMLInsertTransitMap
  207. Migrating schema "public" to version 1.1.76 - DMLInsertNodeTypes
  208. Migrating schema "public" to version 1.1.77 - DMLInsertTransitNodeCoords
  209. Migrating schema "public" to version 1.1.78 - DMLInsertTransitNodes
  210. Migrating schema "public" to version 1.1.79 - DMLInsertTransitNodeAssocs
  211. Migrating schema "public" to version 1.1.80 - DMLInsertMapAssocs
  212. Migrating schema "public" to version 1.1.81 - DDLRenameDupNodeDelimiters
  213. Migrating schema "public" to version 1.1.82 - DDLAlterShipTransitPathView
  214. Migrating schema "public" to version 1.1.83 - DDLCreateShipShipCompartmentBoundaryView
  215. Migrating schema "public" to version 1.1.84 - DDLAlterShipShipCompartmentBoundaryViewFixColumnName
  216. Migrating schema "public" to version 1.1.85 - DDLAlterSimulationSimulationShipEquipmentEventRenameAlterConstrant
  217. Migrating schema "public" to version 1.1.86 - DDLCreateSimulationSimulationEventDetailView
  218. Migrating schema "public" to version 1.1.87 - DDLAlterSimulationSimulationShipEquipmentDamageEventRenameAlterConstrant
  219. Migrating schema "public" to version 1.1.88 - DDLCreateSimulationSimulationDamageEventDetailView
  220. Migrating schema "public" to version 1.1.89 - DDLCreateSimulationSimulationDamageEventDetailView
  221. Migrating schema "public" to version 1.1.90 - DMLClearOldTransitMapData
  222. Migrating schema "public" to version 1.1.91 - DMLCreateShipBoundaries
  223. Migrating schema "public" to version 1.1.92 - DMLInsertTransitNodeTypes
  224. Migrating schema "public" to version 1.1.93 - DMLInsertTransitNodes
  225. Migrating schema "public" to version 1.1.94 - DMLInsertTransitNodeAssociations
  226. Migrating schema "public" to version 1.1.95 - DMLInsertMapTransitNodeAssociations
  227. Migrating schema "public" to version 1.2.1460662468 - DDLModifyBilletBilletTables
  228. Migrating schema "public" to version 1.2.1460663154 - DDLAddedBilletBilletPqsSectionTable
  229. Migrating schema "public" to version 1.2.1460665927 - DDLDropRoleRolePqsAddRoleRolePqsSectionTable
  230. Migrating schema "public" to version 1.2.1460666135 - DDLDropBilletShipCrewConfigurationBilletPqsTableAddShipCrewConfigurationBilletPqsSectionTable
  231. DB: identifier "crewconfiguration_billet__pqssection_crewconfiguration_billet_id_fkey" will be truncated to "crewconfiguration_billet__pqssection_crewconfiguration_billet_i" (SQL State: 42622 - Error Code: 0)
  232. Migrating schema "public" to version 1.2.1460666905 - DMLUpdateBilletBilletCareerFieldAndPayGradeFields
  233. Migrating schema "public" to version 1.2.1460667130 - DDLModifyBilletBilletSetCareerFieldAndPayGradeFieldsToNotNull
  234. Migrating schema "public" to version 1.2.1460730855 - DDLModifyBilletBilletPqsSectionTableAddFields
  235. Migrating schema "public" to version 1.2.1460745097 - DDLCreateBilletCrewGroupRolesView
  236. Migrating schema "public" to version 1.2.1460757147 - DDLModifyBilletCrewGroupRoleTable
  237. Migrating schema "public" to version 1.2.1460849773 - DDLCreateSimulationSignalView
  238. Migrating schema "public" to version 1.2.1460912691 - DDLCreateEquipmentShipEquipmentView
  239. Migrating schema "public" to version 1.2.1461075766 - DDLModifiedEquipmentShipEquipmentDetailView
  240. Migrating schema "public" to version 1.2.1461089249 - DDLDropAndCreateSimulationSignalTablesAndView
  241. Migrating schema "public" to version 1.2.1461089340 - DDLCreateRuleRuleTables
  242. Migrating schema "public" to version 1.2.1461089404 - DDLCreateSimulationRuleTables
  243. Migrating schema "public" to version 1.2.1461090650 - DDLDropEquipmentShipEquipmentDetailView
  244. Migrating schema "public" to version 1.2.1461090652 - DDLDropViewCreateEquipmentShipEquipmentDetailView
  245. DB: view "shipequipmentdetail_view" does not exist, skipping
  246. Migrating schema "public" to version 1.2.1461090656 - DDLAlterEquipmentShipEquipmentTableAddShipLocationColumn
  247. Migrating schema "public" to version 1.2.1461104069 - DDLAlterEquipmentShipEquipmentView
  248. Migrating schema "public" to version 1.2.1461111555 - DDLAlterSimulationShipEquipmentAndCompartmentSignalTablesAddSimulationColumn
  249. Migrating schema "public" to version 1.2.1461111766 - DDLAlterSimulationShipEquipmentAndCompartmentSignalViewsAddSimulationColumn
  250. Migrating schema "public" to version 1.2.1461161707 - DDLCreateEquipmentShipEquipmentDetailView
  251. Migrating schema "public" to version 1.2.1461163671 - DDLRecreateSimulationEventDetailViewAndEquipmentShipEquipmentDetailView
  252. Migrating schema "public" to version 1.2.1461179668 - DMLInsertEquipmentEquipmentTypeDataFromOarsDatabase
  253. Migrating schema "public" to version 1.2.1461181042 - DMLInsertEquipmentEquipmentDataFromSkedDatabase
  254. Migrating schema "public" to version 1.2.1461187748 - DMLInsertShipCompartmentAndShipShipCompartmentDataFromSkedDatabase
  255. Migrating schema "public" to version 1.2.1461191219 - DMLInsertEquipmentShipLocationDataFromSkedDatabase
  256. Migrating schema "public" to version 1.2.1461192478 - DMLInsertEquipmentShipSystemDataFromSkedDatabase
  257. Migrating schema "public" to version 1.2.1461192817 - DMLInsertEquipmentShipSystemShipEquipmentDataFromSkedDatabase
  258. Migrating schema "public" to version 1.2.1461194656 - DMLInsertLocationCoordinateAndUpdateShipLocationCoordinateDataFromDSBEALocation
  259. Migrating schema "public" to version 1.2.1461285495 - DDLAlterSimulationEventDetailViewAddedEventType
  260. Migrating schema "public" to version 1.2.1461338216 - DMLInsertRuleRuleCategoryData
  261. Migrating schema "public" to version 1.2.1461339147 - DMLInsertRuleRuleTypeData
  262. Migrating schema "public" to version 1.2.1461345882 - DMLInsertGroupingDamageTypeEquipmentDamageTypeAndCompartmentDamageTypeData
  263. Migrating schema "public" to version 1.2.1461606311 - DDLAlterTableRuleRuleDropNameColumn
  264. Migrating schema "public" to version 1.2.1461648496 - DDLDropDamageCategoryTableAddDamageTypeToSimulationEventDamage
  265. Migrating schema "public" to version 1.2.1461680688 - DDLCreateWorkItemByWorkCatalystView
  266. Migrating schema "public" to version 1.2.1461682925 - DDLCreateWorkItemStatesByGroupView
  267. Migrating schema "public" to version 1.2.1461697755 - DDLAlterTableWorkWorkCatalystWorkItemChangeConstraintOnPredecessorWorkItemId
  268. Migrating schema "public" to version 1.2.1461861847 - DDLCreateTableWorkExecutionTask
  269. Migrating schema "public" to version 1.2.1461861940 - DDLDropTableSimulationSimulationEventWorkItemAndCreateTableSimulationSimulationEventExecutionTask
  270. DB: identifier "simulation_event__executiontask_simulation_predecessor_workitem_id_f" will be truncated to "simulation_event__executiontask_simulation_predecessor_workitem" (SQL State: 42622 - Error Code: 0)
  271. Migrating schema "public" to version 1.2.1462551098 - DDLAlterSimulationSimulationShipEquipmentSignalsViewAddedEquipmentDescriptionAndName
  272. Migrating schema "public" to version 1.2.1462553906 - DDLCreateTableLocationReferenceLocation
  273. Migrating schema "public" to version 1.2.1462554252 - DMLInsertLocationReferenceLocationDataFromDSBEAForExecutionTask
  274. Migrating schema "public" to version 1.2.1462554430 - DDLAlterTableWorkExecutionTaskAddDSBEATaskFields
  275. Migrating schema "public" to version 1.2.1462554701 - DDLAlterTableSimulationShipSimulationAddedShipCrewConfigurationId
  276. Migrating schema "public" to version 1.2.1462559733 - DDLCreateTableGroupingExecutionTaskType
  277. Migrating schema "public" to version 1.2.1462559789 - DDLAlterTableWorkExecutionTaskAddDescriptionAndType
  278. Migrating schema "public" to version 1.2.1462560135 - DMLInsertGroupingExecutionTaskTypeFromDSBEA
  279. Migrating schema "public" to version 1.2.1462562233 - DMLInsertWorkWorkItemFromDSBEA
  280. Migrating schema "public" to version 1.2.1462562294 - DMLInsertWorkExecutionTaskFromDSBEA
  281. Migrating schema "public" to version 1.2.1462596304 - DMLInsertWorkWorkCatalystFromDSBEA
  282. Migrating schema "public" to version 1.2.1462596633 - DMLInsertEventEventTypeFromDSBEA
  283. Migrating schema "public" to version 1.2.1462597112 - DMLInsertEventEventFromDSBEA
  284. Migrating schema "public" to version 1.2.1462597549 - DMLInsertWorkCatalystWorkItemFromDSBEA
  285. Migrating schema "public" to version 1.2.1462598116 - DMLUpdateWorkCatalystWorkItemPredecessorWorkItemId
  286. Migrating schema "public" to version 1.2.1462811966 - DDLCreateFunctionPublicGetTableDependency
  287. Migrating schema "public" to version 1.2.1463107539 - DDLCreateTableWorkWorkCatalystWorkItemRole
  288. Migrating schema "public" to version 1.2.1463107776 - DDLCreateTableWorkWorkCatalystRole
  289. Migrating schema "public" to version 1.2.1463109120 - DMLInsertWorkWorkCatalystWorkItemRoleFromDSBEA
  290. Migrating schema "public" to version 1.2.1463452243 - DDLCreateTableGroupingConfoundedType
  291. Migrating schema "public" to version 1.2.1463452516 - DDLCreateTableSimulationConfoundedShipCompartment
  292. Migrating schema "public" to version 1.2.1463452976 - DMLInsertDataIntoTableGroupingConfoundedType
  293. Migrating schema "public" to version 1.2.1463600611 - DDLCreateLibraryMilitaryCombatInjuryScaleTable
  294. Migrating schema "public" to version 1.2.1463600720 - DDLCreateLibraryInjuryImpactTable
  295. Migrating schema "public" to version 1.2.1463600723 - DDLCreateLibraryInjuryImparimentTable
  296. Migrating schema "public" to version 1.2.1463600833 - DDLCreateLibraryMilitaryCombatInjuryScaleInjuryImpairmentTable
  297. DB: identifier "militarycombatinjuryscaleinjuryimpairment_militarycombatinjuryscale_id_fkey" will be truncated to "militarycombatinjuryscaleinjuryimpairment_militarycombatinjurys" (SQL State: 42622 - Error Code: 0)
  298. DB: identifier "militarycombatinjuryscaleinjuryimpairment_injuryimpairment_id_fkey" will be truncated to "militarycombatinjuryscaleinjuryimpairment_injuryimpairment_id_f" (SQL State: 42622 - Error Code: 0)
  299. Migrating schema "public" to version 1.2.1463602392 - DMLInsertDataIntoLibraryMilitaryCombatInjuryScaleFromDSBEA
  300. Migrating schema "public" to version 1.2.1463603136 - DMLInsertDataIntoLibraryInjuryImpactFromDSBEA
  301. Migrating schema "public" to version 1.2.1463605639 - DMLInsertDataIntoLibraryInjuryImpairmentFromDSBEA
  302. Migrating schema "public" to version 1.2.1463616057 - DMLInsertDataIntoLibraryMilitaryCombatInjuryScaleInjuryImpairmentFromDSBEA
  303. Migrating schema "public" to version 1.2.1463640177 - DDLCreateGroupingDispositionTypeTable
  304. Migrating schema "public" to version 1.2.1463640235 - DDLCreateSimulationSimulationShipCrewTable
  305. Migrating schema "public" to version 1.2.1463640486 - DMLInsertDataIntoGroupingDispositionTypeFromDSBEA
  306. Migrating schema "public" to version 1.2.1463640911 - DDLCreateRoleRoleMilitaryCombatInjuryScaleTable
  307. Migrating schema "public" to version 1.2.1463717622 - DMLInsertRoleRoleMilitaryCombatInjuryScaleFromDSBEA
  308. Migrating schema "public" to version 1.2.1464021280 - DMLUpdateShipCompartmentDescriptionToMatchDSBEACompartmentDescription
  309. Migrating schema "public" to version 1.2.1465311034 - DDLCreateBillet.ShipCrewConfigurationBilletRoleTable
  310. Migrating schema "public" to version 1.2.1465312012 - DDLCreateSimulationSimulationCrewDetailView
  311. Migrating schema "public" to version 1.2.1465333730 - DDLModifiySimulationSimulationCrewDetailViewAddedShipCrewConfigurationId
  312. Migrating schema "public" to version 1.2.1465388801 - DMLInsertDataIntoBilletShipCrewConfigurationBilletRoleFromDSBEA
  313. Migrating schema "public" to version 1.2.1465426142 - DMLInsertDataIntoGroupingDispositionTypeTable
  314. Migrating schema "public" to version 1.2.1465426332 - DDLModifiyLibraryMilitaryCombatInjuryScaleTableAddedViableForDuty
  315. Migrating schema "public" to version 1.2.1465426578 - DDLCreateBilletShipCrewConfigurationDetailView
  316. Migrating schema "public" to version 1.2.1465427829 - DMLInsertDataIntoMilitaryCombatInjuryScaleTable
  317. Migrating schema "public" to version 1.2.1465487625 - DDLModifiyBilletShipCrewConfigurationDetailViewAddedId
  318. Migrating schema "public" to version 1.2.1465492115 - DDLModifiySimulationSimulationCrewDetailViewAddedId
  319. Migrating schema "public" to version 1.2.1465492124 - DDLCreateTableLibraryPeriodicityTable
  320. Migrating schema "public" to version 1.2.1465492125 - DDLModifiyShipCompartmentTableAddedDeleted
  321. Migrating schema "public" to version 1.2.1465492126 - DDLCreateShipShipClassCompartmentTable
  322. Migrating schema "public" to version 1.2.1465492127 - DDLCreateShipShipStateTable
  323. Migrating schema "public" to version 1.2.1465492128 - CreateShipShipStatePeriodTable
  324. Migrating schema "public" to version 1.2.1465492145 - CreateFMSchemaAndTables
  325. Migrating schema "public" to version 1.2.1465492150 - CreateAnalysisSchemaAndTables
  326. Migrating schema "public" to version 1.2.1465505094 - DDLModifiyAnalysisStudyAddDescriptionColumn
  327. Migrating schema "public" to version 1.2.1465505770 - DDLModifiyShipWatchStationAddNMRSWatchStationIdColumn
  328. Migrating schema "public" to version 1.2.1465507483 - DDLCreateOMShipClassStudyTable
  329. Migrating schema "public" to version 1.2.1465511102 - DMLDeleteDuplicateMCISCodesFromLibraryMilitaryCombatInjuryScale
  330. Migrating schema "public" to version 1.2.1465512562 - DDLCreateSimulationSimulationCrewInjuryDetailView
  331. Migration of schema "public" to version 1.2.1465512562 failed! Changes successfully rolled back.
  332. :services:flywayMigrate FAILED
  333. :services:flywayMigrate (Thread[main,5,main]) completed. Took 9.849 secs.
  334.  
  335. FAILURE: Build failed with an exception.
  336.  
  337. * What went wrong:
  338. Execution failed for task ':services:flywayMigrate'.
  339. > Error occurred while executing flywayMigrate
  340.  
  341. Migration V1_2.1465512562__DDLCreateSimulationSimulationCrewInjuryDetailView.sql failed
  342. ---------------------------------------------------------------------------------------
  343. SQL State : 42883
  344. Error Code : 0
  345. Message : ERROR: function uuid_generate_v4() does not exist
  346. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  347. Position: 79
  348. Location : db/migration/V1_2.1465512562__DDLCreateSimulationSimulationCrewInjuryDetailView.sql (C:\stamps\services\build\resources\main\db\migration\V1_2.1465512562__DDLCreateSimulationSimulationCrewInjuryDetailView.sql)
  349. Line : 1
  350. Statement : CREATE OR REPLACE VIEW simulation.simulationcrewinjurydetail_view AS
  351. SELECT uuid_generate_v4() AS id,
  352. sccb.crewconfiguration_id AS shipcrewconfiguration_id,
  353. sccb.id AS crew_id,
  354. sss.id as simulation_id,
  355. CASE
  356. WHEN ssc.iteration IS NULL THEN 0
  357. ELSE ssc.iteration
  358. END AS iteration,
  359. CASE
  360. WHEN mcis.mcis_code IS NULL THEN 0
  361. ELSE mcis.mcis_code
  362. END AS mcisinjury,
  363. CASE
  364. WHEN dt.name IS NULL THEN 'Available'::character varying
  365. ELSE dt.name
  366. END AS finaldisposition,
  367. CASE
  368. WHEN ssc.time_of_disposition_in_seconds IS NULL THEN 0::bigint
  369. ELSE ssc.time_of_disposition_in_seconds
  370. END AS timeoffinaldisposition
  371. FROM
  372. billet.shipcrewconfiguration_billet sccb
  373. join simulation.shipsimulation sss on sccb.crewconfiguration_id = sss.shipcrewconfiguration_id
  374. left join simulation.simulation_shipcrew ssc ON sccb.id = ssc.shipcrewbillet_id
  375. left join library.militarycombatinjuryscale mcis ON ssc.militarycombatinjuryscale_id = mcis.id
  376. left join "grouping".dispositiontype dt ON ssc.dispositiontype_id = dt.id
  377.  
  378. ERROR: function uuid_generate_v4() does not exist
  379. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  380. Position: 79
  381.  
  382. * Try:
  383. Run with --stacktrace option to get the stack trace. Run with --debug option to get more log output.
  384.  
  385. BUILD FAILED
  386.  
  387. Total time: 21.108 secs
  388. Stopped 0 compiler daemon(s).
  389.  
  390. C:\stamps>
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!