Failsafe Report

Summary

Tests	Errors	Failures	Skipped	Success Rate	Time
138	1	0	1	98.6%	65.41 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.03 s
org.openwms.wms.inventory.rest	53	0	1	98.1%	5.370 s
org.openwms.wms.transport.impl	10	0	0	100%	15.07 s
org.openwms.wms.transport	5	0	0	100%	0.827 s
org.openwms.wms.inventory.allocation	1	0	0	100%	0.426 s
org.openwms.wms.inventory	2	0	0	100%	0.345 s
org.openwms.wms	1	0	0	100%	28.33 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
PackagingUnitCreatorImplIT	9	0	100%	0.536 s
PackagingUnitFinderImplIT	7	0	100%	0.406 s
ProductServiceImplIT	0	0	0%	0.992 s
PackagingUnitMoverImplIT$MoveBetweenLocationsTests	3	0	100%	0.284 s
PackagingUnitServiceImplIT	10	0	100%	1.021 s
PackagingUnitMoverImplIT	0	0	0%	1.088 s
LoadUnitServiceImplIT	13	0	100%	6.516 s
ProductIT	1	1	0%	2.463 s
PackagingUnitMoverImplIT$MoveBetweenLoadUnitsTests	5	0	100%	0.370 s
PackagingUnitMoverImplIT$MoveFromLoadUnitToLocationTests	3	0	100%	0.411 s
ProductServiceImplIT$DeletionTests	6	0	100%	0.429 s
ProductServiceImplIT	9	0	100%	0.514 s

org.openwms.wms.inventory.rest

Class	Tests	Skipped	Success Rate	Time
LoadUnitControllerDocumentation	8	0	100%	0.666 s
IndexControllerDocumentation	1	0	100%	0.090 s
ProductControllerDocumentation	16	0	100%	1.208 s
PackagingUnitControllerDocumentation	28	1	96.4%	3.406 s

org.openwms.wms.transport.impl

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

org.openwms.wms.transport

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

org.openwms.wms.inventory.allocation

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

org.openwms.wms.inventory

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

org.openwms.wms

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

Test Cases

[Summary] [Package List] [Test Cases]

PackagingUnitCreatorImplIT

	create_PU_with_UNKNOWN_LU_and_UNKNOWN_LUType_fails	0.056 s
	create2_PU_okay	0.057 s
	create_PU_with_UNKNOWN_LU_and_KNOWN_LUType_okay	0.091 s
	create2_PU_with_failure_Location	0.056 s
	create_PU_in_LU_with_mixedProducts_NOT_allowed	0.050 s
	create_PU_in_LU_with_mixedProducts_allowed	0.052 s
	create_PU_with_UNKNOWN_LU_and_NULL_LUType_fails	0.044 s
	create2_PU_without_LU_and_LOC	0.051 s
	create_fails_with_NULLS	0.055 s

InventoryStartupIT

	contextLoads	0.084 s

PackagingUnitFinderImplIT

	findForSku_fails_with_UNKNOWN	0.084 s
	findByPKey_fails_with_UNKNOWN	0.039 s
	findForSku_returns_existing	0.069 s
	findForSku_fails_with_NULL	0.040 s
	findByPKey_returns_existing	0.043 s
	findOnTU_fails_with_UNKNOWN	0.043 s
	findOnTU_returns_existing	0.066 s

TransportUnitSynchronizerImplIT

	test_synchronize_with_NULL	2.225 s
	test_synchronize_with_UNKNOWN	4.766 s

PackagingUnitIT

	testCreation	0.172 s
	testDelete	0.139 s

TransportUnitControllerDocumentation

	shall_findby_PKey	0.309 s
	shall_fail_with_400	0.227 s
	shall_create_tu	0.086 s
	shall_create_existing_tu	0.085 s
	shall_findby_PKey_404	0.086 s

LoadUnitControllerDocumentation

	shall_return_index	0.062 s
	shall_findby_PKey	0.114 s
	shall_divide409	0.064 s
	shall_findPU_in_LU	0.086 s
	shall_putProductInto	0.071 s
	shall_divide	0.086 s
	shall_NOT_findby_PKey	0.085 s
	shall_putProductInto400	0.067 s

PackagingUnitMoverImplIT$MoveBetweenLocationsTests

	test_move_less_quantity_between_Locations	0.096 s
	test_move_PU_between_Locations	0.072 s
	test_move_more_quantity_between_Locations	0.103 s

TransportUnitServiceImplIT

	test_findBy_with_UNKNOWN	0.145 s
	test_findBy_with_EMPTY	0.166 s
	test_findBy_with_KNOWN	0.072 s
	test_findByPKey	0.079 s
	test_findAllBy_with_NULL	0.141 s
	test_findAllBy	0.149 s
	test_findByPKey_with_empties	0.148 s
	test_findAllBy_with_EMPTY	0.121 s

PackagingUnitServiceImplIT

	shall_deleteQuantityOnLocation	0.068 s
	test_update_move_PU_from_LOC_to_LU	0.100 s
	shall_deleteWrongProductOnLocation	0.063 s
	shall_deleteAllOnLoadUnit	0.104 s
	shall_deleteAllOnLocation	0.073 s
	shall_deleteTooMuchQuantityOnLocation	0.085 s
	test_update_move_PU_from_LOC_to_LOC	0.125 s
	test_update_move_PU_from_LU_to_LOC	0.127 s
	shall_deleteAll	0.189 s
	test_update_move_PU_from_LU_to_LU	0.065 s

IndexControllerDocumentation

	shall_return_index	0.083 s

ProductControllerDocumentation

	shall_return_index	0.068 s
	shall_findby_PKey	0.069 s
	shall_create_product_400	0.054 s
	shall_delete_product	0.093 s
	shall_findBySKU404	0.048 s
	shall_findAll	0.072 s
	shall_delete_product_notallowed_LU	0.054 s
	shall_delete_product_notallowed_PU	0.053 s
	shall_findBySKUandUOM	0.062 s
	shall_delete_product_notallowed_UomRelation	0.065 s
	shall_delete_product_notallowed_Unknown	0.051 s
	shall_update_product	0.123 s
	shall_create_product	0.117 s
	shall_findBySKU	0.102 s
	shall_create_products	0.085 s
	shall_findBySKUandUOM404	0.048 s

AllocationDocumentation

	shall_allocate	0.405 s

LoadUnitServiceImplIT

	create	0.150 s
	divide	0.098 s
	load_Successful	0.096 s
	create_LU_already_exists	0.052 s
	load_Already_Loaded	0.058 s
	createWithEmpties	0.046 s
	find_byPKey_EXISTS	0.074 s
	find_byPKey_UNKNOWN	0.046 s
	find_not_existing	0.058 s
	assign_Product	0.079 s
	find_existing	0.046 s
	mixing_Product_unallowed	0.062 s
	create_TU_not_exists	0.053 s

ProductIT

testStacking

+ [ Detail ]

0.017 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:362)
	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:362)
	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:237)
	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 #13 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:362)
		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:362)
		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:275)
		... 2 more
	Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "WMS_INV_PRODUCT" not found; SQL statement:
delete from WMS_INV_PRODUCT [42102-232]
		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:7945)
		at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:7916)
		at org.h2.command.Parser.readTableOrView(Parser.java:7895)
		at org.h2.command.Parser.readTableOrView(Parser.java:7857)
		at org.h2.command.Parser.readSimpleTableFilter(Parser.java:1073)
		at org.h2.command.Parser.parseDelete(Parser.java:1087)
		at org.h2.command.Parser.parsePrepared(Parser.java:656)
		at org.h2.command.Parser.parse(Parser.java:581)
		at org.h2.command.Parser.parse(Parser.java:556)
		at org.h2.command.Parser.prepareCommand(Parser.java:484)
		at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
		at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
		at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
		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-232]
	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:7945)
	at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:7916)
	at org.h2.command.Parser.readTableOrView(Parser.java:7895)
	at org.h2.command.Parser.readTableOrView(Parser.java:7857)
	at org.h2.command.Parser.parseInsert(Parser.java:1521)
	at org.h2.command.Parser.parsePrepared(Parser.java:698)
	at org.h2.command.Parser.parse(Parser.java:581)
	at org.h2.command.Parser.parse(Parser.java:556)
	at org.h2.command.Parser.prepareCommand(Parser.java:484)
	at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
	at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
	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

PackagingUnitMoverImplIT$MoveBetweenLoadUnitsTests

	test_move_quantity_maximum_PU	0.063 s
	shall_move_quantity_with_2_complete_PU	0.070 s
	shall_move_quantity_with_1_complete_PU	0.064 s
	shall_move_PU_and_split_PU	0.066 s
	shall_move_all_between_LU	0.087 s

PackagingUnitMoverImplIT$MoveFromLoadUnitToLocationTests

	shall_move_all_PU_from_LoadUnit_to_Location	0.126 s
	shall_move_whole_quantity_from_LoadUnit_to_Location	0.170 s
	shall_move_quantity_from_LoadUnit_to_Location	0.100 s

PackagingUnitControllerDocumentation

	shall_return_index	0.288 s
	shall_create_PU_without_LU	0.374 s
	shall_findby_pKey	0.205 s
	shall_findOnTUandLU	0.072 s
	shall_deleteOnLocation	0.169 s
	shall_create_PU_and_LU	0.135 s
	shall_delete_single	0.101 s
	shall_move_all_PU_from_Location_to_Location	0.130 s
	shall_findForProductInLGSimple	0.128 s
	shall_findForProductFull	0.135 s
	shall_findForProductInLG	0.152 s
	shall_move_all_from_LU_to_LU	0.141 s
	shall_move_PU_from_LU_to_Location	0.150 s
	shall_move_PU_from_Location_to_Location	0.086 s
	shall_findOnTU	0.089 s
	shall_findForProductSimple	0.076 s
	shall_findForProductVendor	0.072 s
	shall_findOnTUandLUSimple	0.059 s
	shall_move_Quantity_from_LU_to_LU	0.096 s
	shall_findOnTUSimple + - [ Detail ]	0 s
-	Fails with short barcode but must pass, formatter problem	-
	shall_move_Quantity_from_Location_to_LU	0.091 s
	shall_delete_single_404	0.054 s
	shall_create_PU_on_Location	0.116 s
	shall_move_all_from_Location_to_LU	0.098 s
	shall_create_PU_and_LU_fails	0.058 s
	shall_findby_pKey_404	0.058 s
	shall_move_Quantity_from_LU_to_Location	0.097 s
	shall_move_PU_from_LU_to_LU	0.096 s

ProductServiceImplIT$DeletionTests

	testDeleteNonExisting	0.047 s
	testDeleteFailsVoter	0.159 s
	testDeleteExisting	0.058 s
	testDeleteFailsUomRelation	0.053 s
	testDeleteFailsLU	0.046 s
	testDeleteFailsPU	0.047 s

ProductServiceImplIT

	findBySKUandUOM	0.055 s
	updateUnknown	0.045 s
	create	0.056 s
	findBy	0.051 s
	updateExisting	0.072 s
	findAll	0.058 s
	updateNull	0.041 s
	findBySKU	0.048 s
	createAll	0.088 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