Skipping 9,545 KB..
Full Log
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Device Connect" Schedule With the same Start and End time
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Device Connect" Schedule Without Name
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Device Connect" Schedule Without The Start Date Parameter
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With All Valid Parameters
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With End Date Only
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With End Time before Start time
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Max Length Name
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Min Length Name
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Name Only
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique End Date Parameter
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique Name
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique Start Date Parameter
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Null Interval Number
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Start Date Only
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With the same Start and End time
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without Interval Number
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without The Start Date Parameter
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without a Name
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Deleting "Cron Schedule" Triggering
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
14:09:34 Error Code: 0
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Deleting "Device Schedule" Triggering
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
14:09:34 Error Code: 0
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Deleting "Interval Schedule" Triggering
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
14:09:34 Error Code: 0
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Init Security Context for all scenarios
14:09:34 [ERROR] Run 1: java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: java.io.IOException: No such file or directory
14:09:34 [ERROR] Run 2: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Connection is broken: "java.net.ConnectException: Connection refused (Connection refused): localhost:3306" [90067-200]
14:09:34 [INFO]
14:09:34 [ERROR] Trigger service tests.Interval Job" Schedule With Too Long Name
14:09:34 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
14:09:34 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
14:09:34 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
14:09:34 /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 [42102-200]
14:09:34 Error Code: 42102
14:09:34 Call: /*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34
14:09:34 Query: DataModifyQuery(sql="/*******************************************************************************
14:09:34 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
14:09:34 *
14:09:34 * This program and the accompanying materials are made
14:09:34 * available under the terms of the Eclipse Public License 2.0
14:09:34 * which is available at https://www.eclipse.org/legal/epl-2.0/
14:09:34 *
14:09:34 * SPDX-License-Identifier: EPL-2.0
14:09:34 *
14:09:34 * Contributors:
14:09:34 * Eurotech - initial API and implementation
14:09:34 *******************************************************************************/
14:09:34
14:09:34 UPDATE act_account SET scope_id = null;
14:09:34
14:09:34 DELETE
14:09:34 FROM act_account
14:09:34 WHERE id NOT IN (1);
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_credential
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_access_token;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_mfa_option;
14:09:34
14:09:34 DELETE
14:09:34 FROM atht_scratch_code;
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_role_permission
14:09:34 WHERE NOT (scope_id = 1 AND role_id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_connection;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device;
14:09:34
14:09:34 DELETE
14:09:34 FROM dvc_device_event;
14:09:34
14:09:34 DELETE
14:09:34 FROM sys_configuration
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
14:09:34
14:09:34 DELETE
14:09:34 FROM usr_user
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_info
14:09:34 WHERE NOT (scope_id = 1 AND id IN (1, 2));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_permission
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_access_role
14:09:34 WHERE NOT (scope_id = 1 AND id = 1);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain_actions
14:09:34 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);
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_domain
14:09:34 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));
14:09:34
14:09:34 DELETE
14:09:34 FROM athz_group;
14:09:34
14:09:34 DELETE
14:09:34 FROM tag_tag;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_execution;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition
14:09:34 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_definition_properties
14:09:34 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_step_properties;
14:09:34
14:09:34 DELETE
14:09:34 FROM job_job_target;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger;
14:09:34
14:09:34 DELETE
14:09:34 FROM schdl_trigger_properties;
14:09:34 ")
14:09:34 [INFO]
14:09:34 [INFO]
14:09:34 [ERROR] Tests run: 164, Failures: 0, Errors: 50, Skipped: 0
14:09:34 [INFO]
14:09:39 [Checks API] No suitable checks publisher found.
14:09:39 Finished: ABORTED
![[Jenkins]](/kapua/static/922b6dea/images/svgs/logo.svg){kind=logo}
