Skipping 9,663 KB..
Full LogWHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With End Time before Start time
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Max Length Name
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Min Length Name
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Name Only
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique End Date Parameter
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique Name
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique Start Date Parameter
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Null Interval Number
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Start Date Only
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With the same Start and End time
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without Interval Number
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without The Start Date Parameter
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without a Name
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Deleting "Cron Schedule" Triggering
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
13:08:30 Error Code: 0
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Deleting "Device Schedule" Triggering
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
13:08:30 Error Code: 0
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Deleting "Interval Schedule" Triggering
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
13:08:30 Error Code: 0
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Init Security Context for all scenarios
13:08:30 [ERROR] Run 1: java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: java.io.IOException: No such file or directory
13:08:30 [ERROR] Run 2: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Connection is broken: "java.net.ConnectException: Connection refused (Connection refused): localhost:3306" [90067-200]
13:08:30 [INFO]
13:08:30 [ERROR] Trigger service tests.Interval Job" Schedule With Too Long Name
13:08:30 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
13:08:30 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
13:08:30 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
13:08:30 /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 [42102-200]
13:08:30 Error Code: 42102
13:08:30 Call: /*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30
13:08:30 Query: DataModifyQuery(sql="/*******************************************************************************
13:08:30 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
13:08:30 *
13:08:30 * This program and the accompanying materials are made
13:08:30 * available under the terms of the Eclipse Public License 2.0
13:08:30 * which is available at https://www.eclipse.org/legal/epl-2.0/
13:08:30 *
13:08:30 * SPDX-License-Identifier: EPL-2.0
13:08:30 *
13:08:30 * Contributors:
13:08:30 * Eurotech - initial API and implementation
13:08:30 *******************************************************************************/
13:08:30
13:08:30 UPDATE act_account SET scope_id = null;
13:08:30
13:08:30 DELETE
13:08:30 FROM act_account
13:08:30 WHERE id NOT IN (1);
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_credential
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_access_token;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_mfa_option;
13:08:30
13:08:30 DELETE
13:08:30 FROM atht_scratch_code;
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_role_permission
13:08:30 WHERE NOT (scope_id = 1 AND role_id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_connection;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device;
13:08:30
13:08:30 DELETE
13:08:30 FROM dvc_device_event;
13:08:30
13:08:30 DELETE
13:08:30 FROM sys_configuration
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
13:08:30
13:08:30 DELETE
13:08:30 FROM usr_user
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_info
13:08:30 WHERE NOT (scope_id = 1 AND id IN (1, 2));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_permission
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_access_role
13:08:30 WHERE NOT (scope_id = 1 AND id = 1);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain_actions
13:08:30 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);
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_domain
13:08:30 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));
13:08:30
13:08:30 DELETE
13:08:30 FROM athz_group;
13:08:30
13:08:30 DELETE
13:08:30 FROM tag_tag;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_execution;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition
13:08:30 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_definition_properties
13:08:30 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_step_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM job_job_target;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger;
13:08:30
13:08:30 DELETE
13:08:30 FROM schdl_trigger_properties;
13:08:30
13:08:30 DELETE
13:08:30 FROM endp_endpoint_info;
13:08:30 ")
13:08:30 [INFO]
13:08:30 [INFO]
13:08:30 [ERROR] Tests run: 164, Failures: 0, Errors: 50, Skipped: 0
13:08:30 [INFO]
13:08:30 [INFO] ------------------------------------------------------------------------
13:08:30 [INFO] Reactor Summary for kapua 2.1.0-SNAPSHOT:
13:08:30 [INFO]
13:08:30 [INFO] kapua-build-tools .................................. SUCCESS [ 1.699 s]
13:08:30 [INFO] kapua .............................................. SUCCESS [ 20.339 s]
13:08:30 [INFO] kapua-qa ........................................... SUCCESS [ 0.965 s]
13:08:30 [INFO] kapua-qa-markers ................................... SUCCESS [ 1.497 s]
13:08:30 [INFO] kapua-service ...................................... SUCCESS [ 6.320 s]
13:08:30 [INFO] kapua-service-api .................................. SUCCESS [ 9.109 s]
13:08:30 [INFO] kapua-account ...................................... SUCCESS [ 0.324 s]
13:08:30 [INFO] kapua-account-api .................................. SUCCESS [ 1.764 s]
13:08:30 [INFO] kapua-user ......................................... SUCCESS [ 0.266 s]
13:08:30 [INFO] kapua-user-api ..................................... SUCCESS [ 1.512 s]
13:08:30 [INFO] kapua-security ..................................... SUCCESS [ 1.385 s]
13:08:30 [INFO] kapua-security-authorization ....................... SUCCESS [ 0.175 s]
13:08:30 [INFO] kapua-security-authorization-api ................... SUCCESS [ 4.966 s]
13:08:30 [INFO] kapua-security-authentication ...................... SUCCESS [ 0.192 s]
13:08:30 [INFO] kapua-security-authentication-api .................. SUCCESS [ 4.168 s]
13:08:30 [INFO] kapua-commons ...................................... SUCCESS [ 32.363 s]
13:08:30 [INFO] kapua-locator ...................................... SUCCESS [ 0.240 s]
13:08:30 [INFO] kapua-locator-guice ................................ SUCCESS [ 7.741 s]
13:08:30 [INFO] kapua-account-internal ............................. SUCCESS [ 8.897 s]
13:08:30 [INFO] kapua-message ...................................... SUCCESS [ 0.187 s]
13:08:30 [INFO] kapua-message-api .................................. SUCCESS [ 1.983 s]
13:08:30 [INFO] kapua-device ....................................... SUCCESS [ 2.072 s]
13:08:30 [INFO] kapua-device-api ................................... SUCCESS [ 2.129 s]
13:08:30 [INFO] kapua-device-registry .............................. SUCCESS [ 0.729 s]
13:08:30 [INFO] kapua-device-registry-api .......................... SUCCESS [ 2.457 s]
13:08:30 [INFO] kapua-job .......................................... SUCCESS [ 0.354 s]
13:08:30 [INFO] kapua-job-api ...................................... SUCCESS [ 1.516 s]
13:08:30 [INFO] kapua-job-engine ................................... SUCCESS [ 0.351 s]
13:08:30 [INFO] kapua-job-engine-api ............................... SUCCESS [ 3.900 s]
13:08:30 [INFO] kapua-device-management ............................ SUCCESS [ 0.690 s]
13:08:30 [INFO] kapua-device-management-api ........................ SUCCESS [ 1.759 s]
13:08:30 [INFO] kapua-device-management-request .................... SUCCESS [ 0.103 s]
13:08:30 [INFO] kapua-device-management-request-api ................ SUCCESS [ 1.712 s]
13:08:30 [INFO] kapua-commons-rest ................................. SUCCESS [ 0.279 s]
13:08:30 [INFO] kapua-commons-rest-model ........................... SUCCESS [ 5.790 s]
13:08:30 [INFO] kapua-job-engine-client ............................ SUCCESS [ 2.434 s]
13:08:30 [INFO] kapua-job-engine-commons ........................... SUCCESS [ 2.530 s]
13:08:30 [INFO] kapua-transport .................................... SUCCESS [ 0.205 s]
13:08:30 [INFO] kapua-transport-api ................................ SUCCESS [ 5.784 s]
13:08:30 [INFO] kapua-device-call .................................. SUCCESS [ 0.602 s]
13:08:30 [INFO] kapua-device-call-api .............................. SUCCESS [ 4.815 s]
13:08:30 [INFO] kapua-translator ................................... SUCCESS [ 0.395 s]
13:08:30 [INFO] kapua-translator-api ............................... SUCCESS [ 1.788 s]
13:08:30 [INFO] kapua-message-internal ............................. SUCCESS [ 8.617 s]
13:08:30 [INFO] kapua-transport-mqtt ............................... SUCCESS [ 7.093 s]
13:08:30 [INFO] kapua-device-call-kura ............................. SUCCESS [ 4.415 s]
13:08:30 [INFO] kapua-device-management-registry ................... SUCCESS [ 0.230 s]
13:08:30 [INFO] kapua-device-management-registry-api ............... SUCCESS [ 2.116 s]
13:08:30 [INFO] kapua-device-commons ............................... SUCCESS [ 5.834 s]
13:08:30 [INFO] kapua-service-commons .............................. SUCCESS [ 0.304 s]
13:08:30 [INFO] kapua-service-storable ............................. SUCCESS [ 0.151 s]
13:08:30 [INFO] kapua-service-storable-api ......................... SUCCESS [ 5.068 s]
13:08:30 [INFO] kapua-service-elasticsearch ........................ SUCCESS [ 0.178 s]
13:08:30 [INFO] kapua-service-elasticsearch-client-api ............. SUCCESS [ 5.322 s]
13:08:30 [INFO] kapua-datastore .................................... SUCCESS [ 0.650 s]
13:08:30 [INFO] kapua-datastore-api ................................ SUCCESS [ 2.191 s]
13:08:30 [INFO] kapua-service-storable-internal .................... SUCCESS [ 2.162 s]
13:08:30 [INFO] kapua-service-elasticsearch-client-rest ............ SUCCESS [ 2.810 s]
13:08:30 [INFO] kapua-datastore-internal ........................... SUCCESS [ 3.879 s]
13:08:30 [INFO] kapua-plug-ins ..................................... SUCCESS [ 0.226 s]
13:08:30 [INFO] kapua-sso .......................................... SUCCESS [ 0.156 s]
13:08:30 [INFO] kapua-openid-connect ............................... SUCCESS [ 0.149 s]
13:08:30 [INFO] kapua-openid-api ................................... SUCCESS [ 1.146 s]
13:08:30 [INFO] kapua-openid-provider .............................. SUCCESS [ 2.331 s]
13:08:30 [INFO] kapua-security-registration ........................ SUCCESS [ 0.126 s]
13:08:30 [INFO] kapua-security-registration-api .................... SUCCESS [ 1.708 s]
13:08:30 [INFO] kapua-service-commons-utils ........................ SUCCESS [ 0.084 s]
13:08:30 [INFO] kapua-service-commons-utils-api .................... SUCCESS [ 1.644 s]
13:08:30 [INFO] kapua-security-certificate ......................... SUCCESS [ 0.239 s]
13:08:30 [INFO] kapua-security-certificate-api ..................... SUCCESS [ 2.173 s]
13:08:30 [INFO] kapua-service-commons-utils-internal ............... SUCCESS [ 1.762 s]
13:08:30 [INFO] kapua-security-certificate-internal ................ SUCCESS [ 2.301 s]
13:08:30 [INFO] kapua-user-internal ................................ SUCCESS [ 2.733 s]
13:08:30 [INFO] kapua-client ....................................... SUCCESS [ 0.818 s]
13:08:30 [INFO] kapua-client-security .............................. SUCCESS [ 3.713 s]
13:08:30 [INFO] kapua-device-authentication ........................ SUCCESS [ 1.730 s]
13:08:30 [INFO] kapua-tag .......................................... SUCCESS [ 0.137 s]
13:08:30 [INFO] kapua-tag-api ...................................... SUCCESS [ 1.101 s]
13:08:30 [INFO] kapua-device-registry-internal ..................... SUCCESS [ 3.930 s]
13:08:30 [INFO] kapua-security-registration-simple ................. SUCCESS [ 2.058 s]
13:08:30 [INFO] kapua-tag-internal ................................. SUCCESS [ 6.686 s]
13:08:30 [INFO] kapua-security-shiro ............................... SUCCESS [ 41.767 s]
13:08:30 [INFO] kapua-simulator-kura ............................... SUCCESS [ 13.537 s]
13:08:30 [INFO] kapua-stream ....................................... SUCCESS [ 0.078 s]
13:08:30 [INFO] kapua-stream-api ................................... SUCCESS [ 1.558 s]
13:08:30 [INFO] kapua-device-management-asset ...................... SUCCESS [ 0.135 s]
13:08:30 [INFO] kapua-device-management-asset-api .................. SUCCESS [ 1.829 s]
13:08:30 [INFO] kapua-device-management-asset-store ................ SUCCESS [ 0.075 s]
13:08:30 [INFO] kapua-device-management-asset-store-api ............ SUCCESS [ 1.556 s]
13:08:30 [INFO] kapua-device-management-asset-internal ............. SUCCESS [ 2.403 s]
13:08:30 [INFO] kapua-device-management-asset-store-dummy .......... SUCCESS [ 1.882 s]
13:08:30 [INFO] kapua-device-management-bundle ..................... SUCCESS [ 0.093 s]
13:08:30 [INFO] kapua-device-management-bundle-api ................. SUCCESS [ 1.502 s]
13:08:30 [INFO] kapua-device-management-bundle-internal ............ SUCCESS [ 2.006 s]
13:08:30 [INFO] kapua-device-management-command .................... SUCCESS [ 0.144 s]
13:08:30 [INFO] kapua-device-management-command-api ................ SUCCESS [ 1.660 s]
13:08:30 [INFO] kapua-device-management-command-internal ........... SUCCESS [ 1.986 s]
13:08:30 [INFO] kapua-device-management-configuration .............. SUCCESS [ 0.123 s]
13:08:30 [INFO] kapua-device-management-configuration-api .......... SUCCESS [ 1.911 s]
13:08:30 [INFO] kapua-device-management-configuration-message-api .. SUCCESS [ 1.613 s]
13:08:30 [INFO] kapua-device-management-configuration-store ........ SUCCESS [ 0.075 s]
13:08:30 [INFO] kapua-device-management-configuration-store-api .... SUCCESS [ 1.602 s]
13:08:30 [INFO] kapua-device-management-configuration-internal ..... SUCCESS [ 2.642 s]
13:08:30 [INFO] kapua-device-management-configuration-store-dummy .. SUCCESS [ 1.863 s]
13:08:30 [INFO] kapua-device-management-inventory .................. SUCCESS [ 0.139 s]
13:08:30 [INFO] kapua-device-management-inventory-api .............. SUCCESS [ 1.912 s]
13:08:30 [INFO] kapua-device-management-inventory-internal ......... SUCCESS [ 2.563 s]
13:08:30 [INFO] kapua-device-management-keystore ................... SUCCESS [ 0.228 s]
13:08:30 [INFO] kapua-device-management-keystore-api ............... SUCCESS [ 1.955 s]
13:08:30 [INFO] kapua-device-management-keystore-internal .......... SUCCESS [ 2.468 s]
13:08:30 [INFO] kapua-device-management-packages ................... SUCCESS [ 0.204 s]
13:08:30 [INFO] kapua-device-management-packages-api ............... SUCCESS [ 1.923 s]
13:08:30 [INFO] kapua-device-management-registry-internal .......... SUCCESS [ 2.772 s]
13:08:30 [INFO] kapua-device-management-packages-internal .......... SUCCESS [ 2.711 s]
13:08:30 [INFO] kapua-device-management-request-internal ........... SUCCESS [ 1.895 s]
13:08:30 [INFO] kapua-device-management-all ........................ SUCCESS [ 0.108 s]
13:08:30 [INFO] kapua-device-management-all-internal ............... SUCCESS [ 0.162 s]
13:08:30 [INFO] kapua-translator-kapua ............................. SUCCESS [ 0.363 s]
13:08:30 [INFO] kapua-translator-kapua-kura ........................ SUCCESS [ 3.724 s]
13:08:30 [INFO] kapua-translator-kura .............................. SUCCESS [ 0.115 s]
13:08:30 [INFO] kapua-translator-kura-mqtt ......................... SUCCESS [ 1.958 s]
13:08:30 [INFO] kapua-transport-jms ................................ SUCCESS [ 2.082 s]
13:08:30 [INFO] kapua-translator-kura-jms .......................... SUCCESS [ 1.899 s]
13:08:30 [INFO] kapua-qa-common .................................... SUCCESS [ 6.630 s]
13:08:30 [INFO] kapua-account-test-steps ........................... SUCCESS [ 2.760 s]
13:08:30 [INFO] kapua-account-test ................................. SUCCESS [ 48.600 s]
13:08:30 [INFO] kapua-user-test-steps .............................. SUCCESS [ 3.000 s]
13:08:30 [INFO] kapua-user-test .................................... SUCCESS [ 54.434 s]
13:08:30 [INFO] kapua-scheduler .................................... SUCCESS [ 0.234 s]
13:08:30 [INFO] kapua-scheduler-api ................................ SUCCESS [ 1.467 s]
13:08:30 [INFO] kapua-device-management-job ........................ SUCCESS [ 0.092 s]
13:08:30 [INFO] kapua-device-management-job-api .................... SUCCESS [ 1.757 s]
13:08:30 [INFO] kapua-service-client ............................... SUCCESS [ 6.385 s]
13:08:30 [INFO] kapua-broker ....................................... SUCCESS [ 0.196 s]
13:08:30 [INFO] kapua-broker-artemis ............................... SUCCESS [ 0.241 s]
13:08:30 [INFO] kapua-broker-artemis-plugin ........................ SUCCESS [ 7.205 s]
13:08:30 [INFO] kapua-device-registry-test-steps ................... SUCCESS [ 4.678 s]
13:08:30 [INFO] kapua-device-registry-test ......................... SUCCESS [01:44 min]
13:08:30 [INFO] kapua-scheduler-quartz ............................. SUCCESS [ 3.372 s]
13:08:30 [INFO] kapua-job-internal ................................. SUCCESS [ 3.339 s]
13:08:30 [INFO] kapua-job-test-steps ............................... SUCCESS [ 3.033 s]
13:08:30 [INFO] kapua-job-test ..................................... SUCCESS [01:48 min]
13:08:30 [INFO] kapua-tag-test-steps ............................... SUCCESS [ 2.308 s]
13:08:30 [INFO] kapua-tag-test ..................................... SUCCESS [01:23 min]
13:08:30 [INFO] kapua-endpoint ..................................... SUCCESS [ 0.137 s]
13:08:30 [INFO] kapua-endpoint-api ................................. SUCCESS [ 1.139 s]
13:08:30 [INFO] kapua-rest-api ..................................... SUCCESS [ 0.675 s]
13:08:30 [INFO] kapua-rest-api-core ................................ SUCCESS [ 8.909 s]
13:08:30 [INFO] kapua-device-management-all-api .................... SUCCESS [ 0.088 s]
13:08:30 [INFO] kapua-system ....................................... SUCCESS [ 0.085 s]
13:08:30 [INFO] kapua-system-api ................................... SUCCESS [ 0.972 s]
13:08:30 [INFO] kapua-commons-rest-errors .......................... SUCCESS [ 2.201 s]
13:08:30 [INFO] kapua-rest-api-resources ........................... SUCCESS [ 4.620 s]
13:08:30 [INFO] kapua-endpoint-internal ............................ SUCCESS [ 2.745 s]
13:08:30 [INFO] kapua-commons-rest-filters ......................... SUCCESS [ 1.989 s]
13:08:30 [INFO] kapua-stream-internal .............................. SUCCESS [ 1.734 s]
13:08:30 [INFO] kapua-system-internal .............................. SUCCESS [ 1.789 s]
13:08:30 [INFO] kapua-extras ....................................... SUCCESS [ 0.160 s]
13:08:30 [INFO] kapua-foreignkeys .................................. SUCCESS [ 0.101 s]
13:08:30 [INFO] kapua-rest-api-web ................................. SUCCESS [ 20.512 s]
13:08:30 [INFO] kapua-qa-integration-steps ......................... SUCCESS [ 4.201 s]
13:08:30 [INFO] kapua-security-test-steps .......................... SUCCESS [ 3.321 s]
13:08:30 [INFO] kapua-device-management-job-internal ............... SUCCESS [ 2.485 s]
13:08:30 [INFO] kapua-endpoint-test-steps .......................... SUCCESS [ 2.585 s]
13:08:30 [INFO] kapua-device-management-bundle-job ................. SUCCESS [ 1.734 s]
13:08:30 [INFO] kapua-device-management-asset-job .................. SUCCESS [ 1.681 s]
13:08:30 [INFO] kapua-device-management-packages-job ............... SUCCESS [ 1.928 s]
13:08:30 [INFO] kapua-device-management-command-job ................ SUCCESS [ 1.846 s]
13:08:30 [INFO] kapua-device-management-configuration-job .......... SUCCESS [ 1.646 s]
13:08:30 [INFO] kapua-device-management-keystore-job ............... SUCCESS [ 1.876 s]
13:08:30 [INFO] kapua-scheduler-test-steps ......................... SUCCESS [ 2.501 s]
13:08:30 [INFO] kapua-datastore-test-steps ......................... SUCCESS [ 3.223 s]
13:08:30 [INFO] kapua-service-camel ................................ SUCCESS [ 2.424 s]
13:08:30 [INFO] kapua-consumer ..................................... SUCCESS [ 0.157 s]
13:08:30 [INFO] kapua-consumer-lifecycle ........................... SUCCESS [ 4.306 s]
13:08:30 [INFO] kapua-consumer-telemetry ........................... SUCCESS [ 2.552 s]
13:08:30 [INFO] kapua-service-authentication ....................... SUCCESS [ 2.855 s]
13:08:30 [INFO] kapua-qa-integration ............................... FAILURE [ 01:45 h]
13:08:30 [INFO] kapua-dev-tools .................................... SKIPPED
13:08:30 [INFO] kapua-cucumber-reports ............................. SKIPPED
13:08:30 [INFO] kapua-deployment ................................... SKIPPED
13:08:30 [INFO] kapua-deployment-commons ........................... SKIPPED
13:08:30 [INFO] kapua-docker ....................................... SKIPPED
13:08:30 [INFO] kapua-minishift .................................... SKIPPED
13:08:30 [INFO] kapua-openshift .................................... SKIPPED
13:08:30 [INFO] kapua-datastore-test ............................... SKIPPED
13:08:30 [INFO] kapua-device-management-all-job .................... SKIPPED
13:08:30 [INFO] kapua-scheduler-test ............................... SKIPPED
13:08:30 [INFO] kapua-security-test ................................ SKIPPED
13:08:30 [INFO] kapua-system-test-steps ............................ SKIPPED
13:08:30 [INFO] kapua-system-test .................................. SKIPPED
13:08:30 [INFO] kapua-service-authentication-app ................... SKIPPED
13:08:30 [INFO] kapua-translator-test-steps ........................ SKIPPED
13:08:30 [INFO] kapua-translator-test .............................. SKIPPED
13:08:30 [INFO] kapua-es-migrator .................................. SKIPPED
13:08:30 [INFO] kapua-encryption-migrator .......................... SKIPPED
13:08:30 [INFO] kapua-liquibase-unlocker ........................... SKIPPED
13:08:30 [INFO] kapua-openid-provider-generic ...................... SKIPPED
13:08:30 [INFO] kapua-openid-provider-keycloak ..................... SKIPPED
13:08:30 [INFO] kapua-job-engine-jbatch ............................ SKIPPED
13:08:30 [INFO] kapua-job-engine-app ............................... SKIPPED
13:08:30 [INFO] kapua-job-engine-app-core .......................... SKIPPED
13:08:30 [INFO] kapua-job-engine-app-resources ..................... SKIPPED
13:08:30 [INFO] kapua-job-engine-app-web ........................... SKIPPED
13:08:30 [INFO] kapua-consumer-lifecycle-app ....................... SKIPPED
13:08:30 [INFO] kapua-consumer-telemetry-app ....................... SKIPPED
13:08:30 [INFO] kapua-client-gateway ............................... SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: API ............. SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: SPI ............. SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Provider ........ SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Provider :: Core MQTT SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Provider :: FUSE MQTT SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Provider :: Eclipse Paho SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Profile :: Eclipse Kura SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Features ........ SKIPPED
13:08:30 [INFO] Eclipse Kapua :: Gateway Client :: Features :: Karaf SKIPPED
13:08:30 [INFO] kapua-assembly ..................................... SKIPPED
13:08:30 [INFO] kapua-assembly-java-base ........................... SKIPPED
13:08:30 [INFO] kapua-assembly-jetty-base .......................... SKIPPED
13:08:30 [INFO] kapua-assembly-sql ................................. SKIPPED
13:08:30 [INFO] kapua-assembly-events-broker ....................... SKIPPED
13:08:30 [INFO] kapua-assembly-broker-artemis ...................... SKIPPED
13:08:30 [INFO] kapua-assembly-api ................................. SKIPPED
13:08:30 [INFO] kapua-assembly-consumer ............................ SKIPPED
13:08:30 [INFO] kapua-assembly-consumer-telemetry .................. SKIPPED
13:08:30 [INFO] kapua-assembly-consumer-lifecycle .................. SKIPPED
13:08:30 [INFO] kapua-assembly-service ............................. SKIPPED
13:08:30 [INFO] kapua-assembly-service-authentication .............. SKIPPED
13:08:30 [INFO] kapua-assembly-job-engine .......................... SKIPPED
13:08:30 [INFO] ------------------------------------------------------------------------
13:08:30 [INFO] BUILD FAILURE
13:08:30 [INFO] ------------------------------------------------------------------------
13:08:30 [INFO] Total time: 01:59 h
13:08:30 [INFO] Finished at: 2024-04-16T17:08:30Z
13:08:30 [INFO] ------------------------------------------------------------------------
13:08:30 [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M7:test (default-test) on project kapua-qa-integration:
13:08:30 [ERROR]
13:08:30 [ERROR] Please refer to /home/jenkins/agent/workspace/develop-test/qa/integration/target/surefire-reports for the individual test results.
13:08:30 [ERROR] Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
13:08:30 [ERROR] The forked VM terminated without properly saying goodbye. VM crash or System.exit called?
13:08:30 [ERROR] Command was /bin/sh -c cd '/home/jenkins/agent/workspace/develop-test/qa/integration' && '/opt/tools/java/openjdk/jdk-11/latest/bin/java' '-javaagent:/home/jenkins/agent/workspace/develop-test/.repository/org/jacoco/org.jacoco.agent/0.8.8/org.jacoco.agent-0.8.8-runtime.jar=destfile=/home/jenkins/agent/workspace/develop-test/qa/integration/target/jacoco.exec' '-jar' '/home/jenkins/agent/workspace/develop-test/qa/integration/target/surefire/surefirebooter-20240416152327284_488.jar' '/home/jenkins/agent/workspace/develop-test/qa/integration/target/surefire' '2024-04-16T15-09-04_868-jvmRun1' 'surefire-20240416152327284_486tmp' 'surefire_27-20240416152327284_487tmp'
13:08:30 [ERROR] Error occurred in starting fork, check output in log
13:08:30 [ERROR] Process Exit Code: 143
13:08:30 [ERROR] Crashed tests:
13:08:30 [ERROR] Device Management Inventory Service Tests
13:08:30 [ERROR] org.apache.maven.surefire.booter.SurefireBooterForkException: The forked VM terminated without properly saying goodbye. VM crash or System.exit called?
13:08:30 [ERROR] Command was /bin/sh -c cd '/home/jenkins/agent/workspace/develop-test/qa/integration' && '/opt/tools/java/openjdk/jdk-11/latest/bin/java' '-javaagent:/home/jenkins/agent/workspace/develop-test/.repository/org/jacoco/org.jacoco.agent/0.8.8/org.jacoco.agent-0.8.8-runtime.jar=destfile=/home/jenkins/agent/workspace/develop-test/qa/integration/target/jacoco.exec' '-jar' '/home/jenkins/agent/workspace/develop-test/qa/integration/target/surefire/surefirebooter-20240416152327284_488.jar' '/home/jenkins/agent/workspace/develop-test/qa/integration/target/surefire' '2024-04-16T15-09-04_868-jvmRun1' 'surefire-20240416152327284_486tmp' 'surefire_27-20240416152327284_487tmp'
13:08:30 [ERROR] Error occurred in starting fork, check output in log
13:08:30 [ERROR] Process Exit Code: 143
13:08:30 [ERROR] Crashed tests:
13:08:30 [ERROR] Device Management Inventory Service Tests
13:08:30 [ERROR] at org.apache.maven.plugin.surefire.booterclient.ForkStarter.fork(ForkStarter.java:714)
13:08:30 [ERROR] at org.apache.maven.plugin.surefire.booterclient.ForkStarter.run(ForkStarter.java:311)
13:08:30 [ERROR] at org.apache.maven.plugin.surefire.booterclient.ForkStarter.run(ForkStarter.java:268)
13:08:30 [ERROR] at org.apache.maven.plugin.surefire.AbstractSurefireMojo.executeProvider(AbstractSurefireMojo.java:1334)
13:08:30 [ERROR] at org.apache.maven.plugin.surefire.AbstractSurefireMojo.executeAfterPreconditionsChecked(AbstractSurefireMojo.java:1167)
13:08:30 [ERROR] at org.apache.maven.plugin.surefire.AbstractSurefireMojo.execute(AbstractSurefireMojo.java:931)
13:08:30 [ERROR] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:126)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute2(MojoExecutor.java:328)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute(MojoExecutor.java:316)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:174)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.access$000(MojoExecutor.java:75)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor$1.run(MojoExecutor.java:162)
13:08:30 [ERROR] at org.apache.maven.plugin.DefaultMojosExecutionStrategy.execute(DefaultMojosExecutionStrategy.java:39)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:159)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:105)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:73)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:53)
13:08:30 [ERROR] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:118)
13:08:30 [ERROR] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:261)
13:08:30 [ERROR] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:173)
13:08:30 [ERROR] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:101)
13:08:30 [ERROR] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:906)
13:08:30 [ERROR] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:283)
13:08:30 [ERROR] at org.apache.maven.cli.MavenCli.main(MavenCli.java:206)
13:08:30 [ERROR] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
13:08:30 [ERROR] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
13:08:30 [ERROR] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
13:08:30 [ERROR] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
13:08:30 [ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:283)
13:08:30 [ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:226)
13:08:30 [ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:407)
13:08:30 [ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:348)
13:08:30 [ERROR] -> [Help 1]
13:08:30 [ERROR]
13:08:30 [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
13:08:30 [ERROR] Re-run Maven using the -X switch to enable full debug logging.
13:08:30 [ERROR]
13:08:30 [ERROR] For more information about the errors and possible solutions, please read the following articles:
13:08:30 [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
13:08:30 [ERROR]
13:08:30 [ERROR] After correcting the problems, you can resume the build with the command
13:08:30 [ERROR] mvn <args> -rf :kapua-qa-integration
13:08:33 [Checks API] No suitable checks publisher found.
13:08:33 Finished: ABORTED
![[Jenkins]](/kapua/static/922b6dea/images/svgs/logo.svg){kind=logo}
