Failed
Trigger service tests.Adding "Device Connect" Schedule With Name Only (from org.eclipse.kapua.integration.service.jobScheduling.RunTriggerServiceI9nTest)
Error Message
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; [42102-200] Error Code: 42102 Call: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; Query: DataModifyQuery(sql="/******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; ")
Stacktrace
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; [42102-200] Error Code: 42102 Call: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; Query: DataModifyQuery(sql="/******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; ") at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:312) at org.eclipse.kapua.commons.jpa.ResourceSqlScriptExecutor.executeUpdate(ResourceSqlScriptExecutor.java:106) at org.eclipse.kapua.commons.configuration.KapuaConfigurableServiceSchemaUtilsWithResources.scriptSession(KapuaConfigurableServiceSchemaUtilsWithResources.java:52) at org.eclipse.kapua.qa.common.DBHelper.deleteAll(DBHelper.java:102) at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDocker(BasicSteps.java:444) at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDockerFull(BasicSteps.java:415) Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; [42102-200] Error Code: 42102 Call: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; Query: DataModifyQuery(sql="/******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; ") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:700) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:313) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:317) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:288) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:87) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845) at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:302) at org.eclipse.kapua.commons.jpa.ResourceSqlScriptExecutor.executeUpdate(ResourceSqlScriptExecutor.java:106) at org.eclipse.kapua.commons.configuration.KapuaConfigurableServiceSchemaUtilsWithResources.scriptSession(KapuaConfigurableServiceSchemaUtilsWithResources.java:52) at org.eclipse.kapua.qa.common.DBHelper.deleteAll(DBHelper.java:102) at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDocker(BasicSteps.java:444) at org.eclipse.kapua.qa.common.BasicSteps.afterScenarioDockerFull(BasicSteps.java:415) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at io.cucumber.java.Invoker.doInvoke(Invoker.java:66) at io.cucumber.java.Invoker.invoke(Invoker.java:24) at io.cucumber.java.AbstractGlueDefinition.invokeMethod(AbstractGlueDefinition.java:47) at io.cucumber.java.JavaHookDefinition.execute(JavaHookDefinition.java:59) at io.cucumber.core.runner.CoreHookDefinition.execute(CoreHookDefinition.java:46) at io.cucumber.core.runner.HookDefinitionMatch.runStep(HookDefinitionMatch.java:21) at io.cucumber.core.runner.ExecutionMode$1.execute(ExecutionMode.java:10) at io.cucumber.core.runner.TestStep.executeStep(TestStep.java:92) at io.cucumber.core.runner.TestStep.run(TestStep.java:64) at io.cucumber.core.runner.TestCase.run(TestCase.java:110) at io.cucumber.core.runner.Runner.runPickle(Runner.java:73) at io.cucumber.junit.PickleRunners$NoStepDescriptions.run(PickleRunners.java:151) at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:135) at io.cucumber.junit.FeatureRunner.runChild(FeatureRunner.java:27) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at io.cucumber.junit.Cucumber.runChild(Cucumber.java:200) at io.cucumber.junit.Cucumber.runChild(Cucumber.java:90) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at io.cucumber.junit.Cucumber$RunCucumber.evaluate(Cucumber.java:235) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169) at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581) Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement: /******************************************************************************* * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others * * This program and the accompanying materials are made * available under the terms of the Eclipse Public License 2.0 * which is available at https://www.eclipse.org/legal/epl-2.0/ * * SPDX-License-Identifier: EPL-2.0 * * Contributors: * Eurotech - initial API and implementation *******************************************************************************/ UPDATE act_account SET scope_id = null; DELETE FROM act_account WHERE id NOT IN (1); DELETE FROM atht_credential WHERE NOT (scope_id = 1 AND id IN (1, 2, 3)); DELETE FROM atht_access_token; DELETE FROM atht_mfa_option; DELETE FROM atht_scratch_code; DELETE FROM athz_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_role_permission WHERE NOT (scope_id = 1 AND role_id = 1); DELETE FROM dvc_device_connection; DELETE FROM dvc_device; DELETE FROM dvc_device_event; DELETE FROM sys_configuration WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9)); DELETE FROM usr_user WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_info WHERE NOT (scope_id = 1 AND id IN (1, 2)); DELETE FROM athz_access_permission WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_access_role WHERE NOT (scope_id = 1 AND id = 1); DELETE FROM athz_domain_actions WHERE domain_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21); DELETE FROM athz_domain WHERE NOT (scope_id IS null AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21)); DELETE FROM athz_group; DELETE FROM tag_tag; DELETE FROM job_job; DELETE FROM job_job_execution; DELETE FROM job_job_step; DELETE FROM job_job_step_definition WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_definition_properties WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); DELETE FROM job_job_step_properties; DELETE FROM job_job_target; DELETE FROM schdl_trigger; DELETE FROM schdl_trigger_properties; DELETE FROM endp_endpoint_info; [42102-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) at org.h2.message.DbException.get(DbException.java:205) at org.h2.message.DbException.get(DbException.java:181) at org.h2.command.Parser.readTableOrView(Parser.java:7628) at org.h2.command.Parser.readTableOrView(Parser.java:7599) at org.h2.command.Parser.readSimpleTableFilter(Parser.java:1350) at org.h2.command.Parser.parseUpdate(Parser.java:1288) at org.h2.command.Parser.parsePrepared(Parser.java:1005) at org.h2.command.Parser.parse(Parser.java:843) at org.h2.command.Parser.parse(Parser.java:815) at org.h2.command.Parser.prepareCommand(Parser.java:738) at org.h2.engine.Session.prepareLocal(Session.java:657) at org.h2.engine.Session.prepareCommand(Session.java:595) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352) at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1611) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1558) at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:762) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628) ... 63 more