Failsafe Report

Summary

Tests	Errors	Failures	Skipped	Success Rate	Time
143	1	0	1	98.6%	73.57 s

Note: failures are anticipated and checked for with assertions while errors are unanticipated.

Package List

[Summary] [Package List] [Test Cases]

Package	Tests	Errors	Skipped	Success Rate	Time
org.openwms.wms.inventory.impl	66	1	0	98.5%	15.47 s
org.openwms.wms.inventory.rest	53	0	1	98.1%	6.036 s
-	5	0	0	100%	1.108 s
org.openwms.wms.transport.impl	10	0	0	100%	41.38 s
org.openwms.wms.transport	5	0	0	100%	1.169 s
org.openwms.wms.inventory.allocation	1	0	0	100%	0.173 s
org.openwms.wms.inventory	2	0	0	100%	0.313 s
org.openwms.wms	1	0	0	100%	7.922 s

Note: package statistics are not computed recursively, they only sum up all of its testsuites numbers.

org.openwms.wms.inventory.impl

Class	Tests	Errors	Success Rate	Time
PackagingUnitMoverImplIT$MoveBetweenLocationsTests	3	0	100%	0.306 s
PackagingUnitFinderImplIT	7	0	100%	0.429 s
ProductServiceImplIT	0	0	0%	1.075 s
PackagingUnitServiceImplIT	10	0	100%	1.074 s
ProductIT	1	1	0%	2.566 s
PackagingUnitCreatorImplIT	9	0	100%	0.526 s
PackagingUnitMoverImplIT$MoveFromLoadUnitToLocationTests	3	0	100%	0.321 s
ProductServiceImplIT$DeletionTests	6	0	100%	0.464 s
ProductServiceImplIT	9	0	100%	0.573 s
PackagingUnitMoverImplIT$MoveBetweenLoadUnitsTests	5	0	100%	0.323 s
PackagingUnitMoverImplIT	0	0	0%	0.963 s
LoadUnitServiceImplIT	13	0	100%	6.847 s

org.openwms.wms.inventory.rest

Class	Tests	Skipped	Success Rate	Time
ProductControllerDocumentation	16	0	100%	1.238 s
LoadUnitControllerDocumentation	8	0	100%	0.677 s
PackagingUnitControllerDocumentation	28	1	96.4%	4.046 s
IndexControllerDocumentation	1	0	100%	0.075 s

-	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	EnsureArchitectureIT	5	0	0	0	100%	1.108 s

org.openwms.wms.transport.impl

-	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	TransportUnitSynchronizerImplIT	2	0	0	0	100%	6.640 s
	TransportUnitServiceImplIT	8	0	0	0	100%	34.74 s

org.openwms.wms.transport

-	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	TransportUnitControllerDocumentation	5	0	0	0	100%	1.169 s

org.openwms.wms.inventory.allocation

-	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	AllocationDocumentation	1	0	0	0	100%	0.173 s

org.openwms.wms.inventory

-	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	PackagingUnitIT	2	0	0	0	100%	0.313 s

org.openwms.wms

-	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	InventoryStartupIT	1	0	0	0	100%	7.922 s

Test Cases

[Summary] [Package List] [Test Cases]

TransportUnitSynchronizerImplIT

	test_synchronize_with_NULL	2.122 s
	test_synchronize_with_UNKNOWN	4.478 s

PackagingUnitMoverImplIT$MoveBetweenLocationsTests

	test_move_less_quantity_between_Locations	0.114 s
	test_move_PU_between_Locations	0.076 s
	test_move_more_quantity_between_Locations	0.100 s

InventoryStartupIT

	contextLoads	0.026 s

PackagingUnitFinderImplIT

	findForSku_fails_with_UNKNOWN	0.061 s
	findByPKey_fails_with_UNKNOWN	0.057 s
	findForSku_returns_existing	0.095 s
	findForSku_fails_with_NULL	0.044 s
	findByPKey_returns_existing	0.051 s
	findOnTU_fails_with_UNKNOWN	0.043 s
	findOnTU_returns_existing	0.062 s

TransportUnitControllerDocumentation

	shall_findby_PKey	0.496 s
	shall_fail_with_400	0.365 s
	shall_create_tu	0.095 s
	shall_create_existing_tu	0.077 s
	shall_findby_PKey_404	0.080 s

TransportUnitServiceImplIT

	test_findBy_with_UNKNOWN	0.656 s
	test_findBy_with_EMPTY	0.195 s
	test_findBy_with_KNOWN	0.151 s
	test_findByPKey	0.109 s
	test_findAllBy_with_NULL	0.076 s
	test_findAllBy	0.102 s
	test_findByPKey_with_empties	0.055 s
	test_findAllBy_with_EMPTY	0.056 s

PackagingUnitServiceImplIT

	shall_deleteQuantityOnLocation	0.077 s
	test_update_move_PU_from_LOC_to_LU	0.122 s
	shall_deleteWrongProductOnLocation	0.070 s
	shall_deleteAllOnLoadUnit	0.166 s
	shall_deleteAllOnLocation	0.079 s
	shall_deleteTooMuchQuantityOnLocation	0.068 s
	test_update_move_PU_from_LOC_to_LOC	0.087 s
	test_update_move_PU_from_LU_to_LOC	0.108 s
	shall_deleteAll	0.175 s
	test_update_move_PU_from_LU_to_LU	0.070 s

ProductControllerDocumentation

	shall_return_index	0.074 s
	shall_findby_PKey	0.067 s
	shall_create_product_400	0.058 s
	shall_delete_product	0.094 s
	shall_findBySKU404	0.063 s
	shall_findAll	0.085 s
	shall_delete_product_notallowed_LU	0.053 s
	shall_delete_product_notallowed_PU	0.060 s
	shall_findBySKUandUOM	0.069 s
	shall_delete_product_notallowed_UomRelation	0.068 s
	shall_delete_product_notallowed_Unknown	0.056 s
	shall_update_product	0.115 s
	shall_create_product	0.100 s
	shall_findBySKU	0.110 s
	shall_create_products	0.087 s
	shall_findBySKUandUOM404	0.051 s

ProductIT

testStacking

+ [ Detail ]

0.016 s

Failed to execute SQL script statement #1 of class path resource [test.sql]: insert into WMS_INV_PRODUCT (c_pk,c_pid,c_sku,c_label,c_account,c_base_unit_qty,c_base_unit_type,c_description,c_av_state,c_classification,c_group,c_stock_zone,c_height,c_length,c_width,c_uom,c_overbooking_allowed,c_ol,c_created) values (2000,'1','ZS0002029','221156456666','GM',1,'PC@org.openwms.core.units.api.Piece','LiPo battery 12V 4400mAh','AVAILABLE','Hazardous','Internal Goods','A',50,146,25,'MM',true,0,now())

org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [test.sql]: insert into WMS_INV_PRODUCT (c_pk,c_pid,c_sku,c_label,c_account,c_base_unit_qty,c_base_unit_type,c_description,c_av_state,c_classification,c_group,c_stock_zone,c_height,c_length,c_width,c_uom,c_overbooking_allowed,c_ol,c_created) values (2000,'1','ZS0002029','221156456666','GM',1,'PC@org.openwms.core.units.api.Piece','LiPo battery 12V 4400mAh','AVAILABLE','Hazardous','Internal Goods','A',50,146,25,'MM',true,0,now())
	at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:282)
	at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:254)
	at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:54)
	at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.execute(ResourceDatabasePopulator.java:269)
	at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.lambda$executeSqlScripts$9(SqlScriptsTestExecutionListener.java:361)
	at org.springframework.transaction.support.TransactionOperations.lambda$executeWithoutResult$0(TransactionOperations.java:68)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.transaction.support.TransactionOperations.executeWithoutResult(TransactionOperations.java:67)
	at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.executeSqlScripts(SqlScriptsTestExecutionListener.java:361)
	at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.lambda$executeSqlScripts$4(SqlScriptsTestExecutionListener.java:274)
	at java.base/java.lang.Iterable.forEach(Iterable.java:75)
	at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.executeSqlScripts(SqlScriptsTestExecutionListener.java:274)
	at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.executeSqlScripts(SqlScriptsTestExecutionListener.java:221)
	at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.beforeTestMethod(SqlScriptsTestExecutionListener.java:164)
	at org.springframework.test.context.TestContextManager.beforeTestMethod(TestContextManager.java:320)
	at org.springframework.test.context.junit.jupiter.SpringExtension.beforeEach(SpringExtension.java:240)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
	Suppressed: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #11 of class path resource [test-delete.sql]: delete from WMS_INV_PRODUCT
		at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:282)
		at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:254)
		at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:54)
		at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.execute(ResourceDatabasePopulator.java:269)
		at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.lambda$executeSqlScripts$9(SqlScriptsTestExecutionListener.java:361)
		at org.springframework.transaction.support.TransactionOperations.lambda$executeWithoutResult$0(TransactionOperations.java:68)
		at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
		at org.springframework.transaction.support.TransactionOperations.executeWithoutResult(TransactionOperations.java:67)
		at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.executeSqlScripts(SqlScriptsTestExecutionListener.java:361)
		at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.lambda$executeSqlScripts$4(SqlScriptsTestExecutionListener.java:274)
		at java.base/java.lang.Iterable.forEach(Iterable.java:75)
		at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.executeSqlScripts(SqlScriptsTestExecutionListener.java:274)
		at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.executeSqlScripts(SqlScriptsTestExecutionListener.java:221)
		at org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener.afterTestMethod(SqlScriptsTestExecutionListener.java:173)
		at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:487)
		at org.springframework.test.context.junit.jupiter.SpringExtension.afterEach(SpringExtension.java:278)
		... 2 more
	Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "WMS_INV_PRODUCT" not found; SQL statement:
delete from WMS_INV_PRODUCT [42102-224]
		at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
		at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
		at org.h2.message.DbException.get(DbException.java:223)
		at org.h2.message.DbException.get(DbException.java:199)
		at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8064)
		at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8035)
		at org.h2.command.Parser.readTableOrView(Parser.java:8024)
		at org.h2.command.Parser.readTableOrView(Parser.java:7990)
		at org.h2.command.Parser.readSimpleTableFilter(Parser.java:1094)
		at org.h2.command.Parser.parseDelete(Parser.java:1108)
		at org.h2.command.Parser.parsePrepared(Parser.java:677)
		at org.h2.command.Parser.parse(Parser.java:592)
		at org.h2.command.Parser.parse(Parser.java:564)
		at org.h2.command.Parser.prepareCommand(Parser.java:483)
		at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:639)
		at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:559)
		at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1166)
		at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:245)
		at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:231)
		at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:261)
		... 17 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "WMS_INV_PRODUCT" not found; SQL statement:
insert into WMS_INV_PRODUCT (c_pk,c_pid,c_sku,c_label,c_account,c_base_unit_qty,c_base_unit_type,c_description,c_av_state,c_classification,c_group,c_stock_zone,c_height,c_length,c_width,c_uom,c_overbooking_allowed,c_ol,c_created) values (2000,'1','ZS0002029','221156456666','GM',1,'PC@org.openwms.core.units.api.Piece','LiPo battery 12V 4400mAh','AVAILABLE','Hazardous','Internal Goods','A',50,146,25,'MM',true,0,now()) [42102-224]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
	at org.h2.message.DbException.get(DbException.java:223)
	at org.h2.message.DbException.get(DbException.java:199)
	at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8064)
	at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8035)
	at org.h2.command.Parser.readTableOrView(Parser.java:8024)
	at org.h2.command.Parser.readTableOrView(Parser.java:7990)
	at org.h2.command.Parser.parseInsert(Parser.java:1540)
	at org.h2.command.Parser.parsePrepared(Parser.java:719)
	at org.h2.command.Parser.parse(Parser.java:592)
	at org.h2.command.Parser.parse(Parser.java:564)
	at org.h2.command.Parser.prepareCommand(Parser.java:483)
	at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:639)
	at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:559)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1166)
	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:245)
	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:231)
	at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:261)
	... 17 more

AllocationDocumentation

	shall_allocate	0.143 s

LoadUnitControllerDocumentation

	shall_return_index	0.086 s
	shall_findby_PKey	0.097 s
	shall_divide409	0.073 s
	shall_findPU_in_LU	0.076 s
	shall_putProductInto	0.086 s
	shall_divide	0.100 s
	shall_NOT_findby_PKey	0.070 s
	shall_putProductInto400	0.070 s

PackagingUnitCreatorImplIT

	create_PU_with_UNKNOWN_LU_and_UNKNOWN_LUType_fails	0.061 s
	create2_PU_okay	0.068 s
	create_PU_with_UNKNOWN_LU_and_KNOWN_LUType_okay	0.074 s
	create2_PU_with_failure_Location	0.059 s
	create_PU_in_LU_with_mixedProducts_NOT_allowed	0.051 s
	create_PU_in_LU_with_mixedProducts_allowed	0.058 s
	create_PU_with_UNKNOWN_LU_and_NULL_LUType_fails	0.044 s
	create2_PU_without_LU_and_LOC	0.046 s
	create_fails_with_NULLS	0.041 s

PackagingUnitIT

	testCreation	0.174 s
	testDelete	0.107 s

PackagingUnitControllerDocumentation

	shall_return_index	0.341 s
	shall_create_PU_without_LU	0.494 s
	shall_findby_pKey	0.248 s
	shall_findOnTUandLU	0.089 s
	shall_deleteOnLocation	0.178 s
	shall_create_PU_and_LU	0.177 s
	shall_delete_single	0.116 s
	shall_move_all_PU_from_Location_to_Location	0.163 s
	shall_findForProductInLGSimple	0.171 s
	shall_findForProductFull	0.144 s
	shall_findForProductInLG	0.164 s
	shall_move_all_from_LU_to_LU	0.135 s
	shall_move_PU_from_LU_to_Location	0.152 s
	shall_move_PU_from_Location_to_Location	0.092 s
	shall_findOnTU	0.100 s
	shall_findForProductSimple	0.087 s
	shall_findForProductVendor	0.095 s
	shall_findOnTUandLUSimple	0.065 s
	shall_move_Quantity_from_LU_to_LU	0.094 s
	shall_findOnTUSimple + - [ Detail ]	0 s
-	Fails with short barcode but must pass, formatter problem	-
	shall_move_Quantity_from_Location_to_LU	0.103 s
	shall_delete_single_404	0.054 s
	shall_create_PU_on_Location	0.187 s
	shall_move_all_from_Location_to_LU	0.125 s
	shall_create_PU_and_LU_fails	0.071 s
	shall_findby_pKey_404	0.060 s
	shall_move_Quantity_from_LU_to_Location	0.120 s
	shall_move_PU_from_LU_to_LU	0.114 s

PackagingUnitMoverImplIT$MoveFromLoadUnitToLocationTests

	shall_move_all_PU_from_LoadUnit_to_Location	0.111 s
	shall_move_whole_quantity_from_LoadUnit_to_Location	0.104 s
	shall_move_quantity_from_LoadUnit_to_Location	0.090 s

EnsureArchitectureIT

	verify_logger_definition	1.083 s
	verify_api_package	0 s
	verify_services	0.001 s
	verify_transactional_repository_access	0 s
	verify_no_cycles	0.024 s

IndexControllerDocumentation

	shall_return_index	0.065 s

ProductServiceImplIT$DeletionTests

	testDeleteNonExisting	0.052 s
	testDeleteFailsVoter	0.169 s
	testDeleteExisting	0.060 s
	testDeleteFailsUomRelation	0.053 s
	testDeleteFailsLU	0.056 s
	testDeleteFailsPU	0.057 s

ProductServiceImplIT

	findBySKUandUOM	0.100 s
	updateUnknown	0.044 s
	create	0.063 s
	findBy	0.053 s
	updateExisting	0.088 s
	findAll	0.059 s
	updateNull	0.043 s
	findBySKU	0.048 s
	createAll	0.075 s

PackagingUnitMoverImplIT$MoveBetweenLoadUnitsTests

	test_move_quantity_maximum_PU	0.058 s
	shall_move_quantity_with_2_complete_PU	0.057 s
	shall_move_quantity_with_1_complete_PU	0.055 s
	shall_move_PU_and_split_PU	0.060 s
	shall_move_all_between_LU	0.076 s

LoadUnitServiceImplIT

	create	0.188 s
	divide	0.074 s
	load_Successful	0.067 s
	create_LU_already_exists	0.045 s
	load_Already_Loaded	0.053 s
	createWithEmpties	0.043 s
	find_byPKey_EXISTS	0.046 s
	find_byPKey_UNKNOWN	0.039 s
	find_not_existing	0.042 s
	assign_Product	0.058 s
	find_existing	0.055 s
	mixing_Product_unallowed	0.059 s
	create_TU_not_exists	0.059 s

Failure Details

[Summary] [Package List] [Test Cases]

	testStacking
-	org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [test.sql]: insert into WMS_INV_PRODUCT (c_pk,c_pid,c_sku,c_label,c_account,c_base_unit_qty,c_base_unit_type,c_description,c_av_state,c_classification,c_group,c_stock_zone,c_height,c_length,c_width,c_uom,c_overbooking_allowed,c_ol,c_created) values (2000,'1','ZS0002029','221156456666','GM',1,'PC@org.openwms.core.units.api.Piece','LiPo battery 12V 4400mAh','AVAILABLE','Hazardous','Internal Goods','A',50,146,25,'MM',true,0,now())
-	org.openwms.wms.inventory.impl.ProductIT:
	shall_findOnTUSimple
-	skipped: Fails with short barcode but must pass, formatter problem