Skipping 9,625 KB..
Full LogWHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With All Valid Parameters
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With End Date Only
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With End Time before Start time
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Max Length Name
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Min Length Name
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Name Only
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique End Date Parameter
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique Name
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Non-Unique Start Date Parameter
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Null Interval Number
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With Start Date Only
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule With the same Start and End time
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without Interval Number
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without The Start Date Parameter
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Adding "Interval Job" Schedule Without a Name
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Deleting "Cron Schedule" Triggering
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
12:08:35 Error Code: 0
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Deleting "Device Schedule" Triggering
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
12:08:35 Error Code: 0
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Deleting "Interval Schedule" Triggering
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
12:08:35 Error Code: 0
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Init Security Context for all scenarios
12:08:35 [ERROR] Run 1: java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: java.io.IOException: No such file or directory
12:08:35 [ERROR] Run 2: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Connection is broken: "java.net.ConnectException: Connection refused (Connection refused): localhost:3306" [90067-200]
12:08:35 [INFO]
12:08:35 [ERROR] Trigger service tests.Interval Job" Schedule With Too Long Name
12:08:35 [ERROR] Run 1: An internal error occurred: org.apache.shiro.ShiroException: Unexpected error while looking for the user!.
12:08:35 [ERROR] Run 2: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
12:08:35 Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "ACT_ACCOUNT" not found; SQL statement:
12:08:35 /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 [42102-200]
12:08:35 Error Code: 42102
12:08:35 Call: /*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35
12:08:35 Query: DataModifyQuery(sql="/*******************************************************************************
12:08:35 * Copyright (c) 2017, 2022 Eurotech and/or its affiliates and others
12:08:35 *
12:08:35 * This program and the accompanying materials are made
12:08:35 * available under the terms of the Eclipse Public License 2.0
12:08:35 * which is available at https://www.eclipse.org/legal/epl-2.0/
12:08:35 *
12:08:35 * SPDX-License-Identifier: EPL-2.0
12:08:35 *
12:08:35 * Contributors:
12:08:35 * Eurotech - initial API and implementation
12:08:35 *******************************************************************************/
12:08:35
12:08:35 UPDATE act_account SET scope_id = null;
12:08:35
12:08:35 DELETE
12:08:35 FROM act_account
12:08:35 WHERE id NOT IN (1);
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_credential
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3));
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_access_token;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_mfa_option;
12:08:35
12:08:35 DELETE
12:08:35 FROM atht_scratch_code;
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_role_permission
12:08:35 WHERE NOT (scope_id = 1 AND role_id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_connection;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device;
12:08:35
12:08:35 DELETE
12:08:35 FROM dvc_device_event;
12:08:35
12:08:35 DELETE
12:08:35 FROM sys_configuration
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2, 3, 4, 5, 6, 7, 8, 9));
12:08:35
12:08:35 DELETE
12:08:35 FROM usr_user
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_info
12:08:35 WHERE NOT (scope_id = 1 AND id IN (1, 2));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_permission
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_access_role
12:08:35 WHERE NOT (scope_id = 1 AND id = 1);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain_actions
12:08:35 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);
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_domain
12:08:35 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));
12:08:35
12:08:35 DELETE
12:08:35 FROM athz_group;
12:08:35
12:08:35 DELETE
12:08:35 FROM tag_tag;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_execution;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition
12:08:35 WHERE id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_definition_properties
12:08:35 WHERE step_definition_id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_step_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM job_job_target;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger;
12:08:35
12:08:35 DELETE
12:08:35 FROM schdl_trigger_properties;
12:08:35
12:08:35 DELETE
12:08:35 FROM endp_endpoint_info;
12:08:35 ")
12:08:35 [INFO]
12:08:35 [INFO]
12:08:35 [ERROR] Tests run: 162, Failures: 0, Errors: 50, Skipped: 0
12:08:35 [INFO]
12:08:35 [INFO] ------------------------------------------------------------------------
12:08:35 [INFO] Reactor Summary for kapua 2.1.0-SNAPSHOT:
12:08:35 [INFO]
12:08:35 [INFO] kapua-build-tools .................................. SUCCESS [ 1.870 s]
12:08:35 [INFO] kapua .............................................. SUCCESS [ 24.576 s]
12:08:35 [INFO] kapua-qa ........................................... SUCCESS [ 1.163 s]
12:08:35 [INFO] kapua-qa-markers ................................... SUCCESS [ 2.385 s]
12:08:35 [INFO] kapua-service ...................................... SUCCESS [ 5.840 s]
12:08:35 [INFO] kapua-service-api .................................. SUCCESS [ 9.388 s]
12:08:35 [INFO] kapua-account ...................................... SUCCESS [ 0.288 s]
12:08:35 [INFO] kapua-account-api .................................. SUCCESS [ 1.559 s]
12:08:35 [INFO] kapua-user ......................................... SUCCESS [ 0.232 s]
12:08:35 [INFO] kapua-user-api ..................................... SUCCESS [ 1.293 s]
12:08:35 [INFO] kapua-security ..................................... SUCCESS [ 1.434 s]
12:08:35 [INFO] kapua-security-authorization ....................... SUCCESS [ 0.147 s]
12:08:35 [INFO] kapua-security-authorization-api ................... SUCCESS [ 4.828 s]
12:08:35 [INFO] kapua-security-authentication ...................... SUCCESS [ 0.149 s]
12:08:35 [INFO] kapua-security-authentication-api .................. SUCCESS [ 3.975 s]
12:08:35 [INFO] kapua-commons ...................................... SUCCESS [ 30.492 s]
12:08:35 [INFO] kapua-locator ...................................... SUCCESS [ 0.200 s]
12:08:35 [INFO] kapua-locator-guice ................................ SUCCESS [ 7.522 s]
12:08:35 [INFO] kapua-account-internal ............................. SUCCESS [ 9.572 s]
12:08:35 [INFO] kapua-message ...................................... SUCCESS [ 0.228 s]
12:08:35 [INFO] kapua-message-api .................................. SUCCESS [ 2.400 s]
12:08:35 [INFO] kapua-device ....................................... SUCCESS [ 2.382 s]
12:08:35 [INFO] kapua-device-api ................................... SUCCESS [ 1.784 s]
12:08:35 [INFO] kapua-device-registry .............................. SUCCESS [ 0.805 s]
12:08:35 [INFO] kapua-device-registry-api .......................... SUCCESS [ 2.260 s]
12:08:35 [INFO] kapua-job .......................................... SUCCESS [ 0.438 s]
12:08:35 [INFO] kapua-job-api ...................................... SUCCESS [ 1.619 s]
12:08:35 [INFO] kapua-job-engine ................................... SUCCESS [ 0.436 s]
12:08:35 [INFO] kapua-job-engine-api ............................... SUCCESS [ 3.786 s]
12:08:35 [INFO] kapua-device-management ............................ SUCCESS [ 0.787 s]
12:08:35 [INFO] kapua-device-management-api ........................ SUCCESS [ 1.763 s]
12:08:35 [INFO] kapua-device-management-request .................... SUCCESS [ 0.108 s]
12:08:35 [INFO] kapua-device-management-request-api ................ SUCCESS [ 1.683 s]
12:08:35 [INFO] kapua-commons-rest ................................. SUCCESS [ 0.236 s]
12:08:35 [INFO] kapua-commons-rest-model ........................... SUCCESS [ 5.575 s]
12:08:35 [INFO] kapua-job-engine-client ............................ SUCCESS [ 2.298 s]
12:08:35 [INFO] kapua-job-engine-commons ........................... SUCCESS [ 2.775 s]
12:08:35 [INFO] kapua-transport .................................... SUCCESS [ 0.224 s]
12:08:35 [INFO] kapua-transport-api ................................ SUCCESS [ 4.882 s]
12:08:35 [INFO] kapua-device-call .................................. SUCCESS [ 0.714 s]
12:08:35 [INFO] kapua-device-call-api .............................. SUCCESS [ 5.130 s]
12:08:35 [INFO] kapua-translator ................................... SUCCESS [ 0.428 s]
12:08:35 [INFO] kapua-translator-api ............................... SUCCESS [ 1.826 s]
12:08:35 [INFO] kapua-message-internal ............................. SUCCESS [ 8.628 s]
12:08:35 [INFO] kapua-transport-mqtt ............................... SUCCESS [ 6.099 s]
12:08:35 [INFO] kapua-device-call-kura ............................. SUCCESS [ 4.423 s]
12:08:35 [INFO] kapua-device-management-registry ................... SUCCESS [ 0.165 s]
12:08:35 [INFO] kapua-device-management-registry-api ............... SUCCESS [ 2.577 s]
12:08:35 [INFO] kapua-device-commons ............................... SUCCESS [ 4.902 s]
12:08:35 [INFO] kapua-service-commons .............................. SUCCESS [ 0.292 s]
12:08:35 [INFO] kapua-service-storable ............................. SUCCESS [ 0.143 s]
12:08:35 [INFO] kapua-service-storable-api ......................... SUCCESS [ 4.634 s]
12:08:35 [INFO] kapua-service-elasticsearch ........................ SUCCESS [ 0.213 s]
12:08:35 [INFO] kapua-service-elasticsearch-client-api ............. SUCCESS [ 5.202 s]
12:08:35 [INFO] kapua-datastore .................................... SUCCESS [ 0.612 s]
12:08:35 [INFO] kapua-datastore-api ................................ SUCCESS [ 2.016 s]
12:08:35 [INFO] kapua-service-storable-internal .................... SUCCESS [ 2.081 s]
12:08:35 [INFO] kapua-service-elasticsearch-client-rest ............ SUCCESS [ 2.611 s]
12:08:35 [INFO] kapua-datastore-internal ........................... SUCCESS [ 3.732 s]
12:08:35 [INFO] kapua-plug-ins ..................................... SUCCESS [ 0.136 s]
12:08:35 [INFO] kapua-sso .......................................... SUCCESS [ 0.128 s]
12:08:35 [INFO] kapua-openid-connect ............................... SUCCESS [ 0.126 s]
12:08:35 [INFO] kapua-openid-api ................................... SUCCESS [ 1.170 s]
12:08:35 [INFO] kapua-openid-provider .............................. SUCCESS [ 2.090 s]
12:08:35 [INFO] kapua-security-registration ........................ SUCCESS [ 0.103 s]
12:08:35 [INFO] kapua-security-registration-api .................... SUCCESS [ 1.733 s]
12:08:35 [INFO] kapua-service-commons-utils ........................ SUCCESS [ 0.119 s]
12:08:35 [INFO] kapua-service-commons-utils-api .................... SUCCESS [ 1.660 s]
12:08:35 [INFO] kapua-security-certificate ......................... SUCCESS [ 0.121 s]
12:08:35 [INFO] kapua-security-certificate-api ..................... SUCCESS [ 1.978 s]
12:08:35 [INFO] kapua-service-commons-utils-internal ............... SUCCESS [ 1.614 s]
12:08:35 [INFO] kapua-security-certificate-internal ................ SUCCESS [ 2.109 s]
12:08:35 [INFO] kapua-user-internal ................................ SUCCESS [ 2.512 s]
12:08:35 [INFO] kapua-client ....................................... SUCCESS [ 0.788 s]
12:08:35 [INFO] kapua-client-security .............................. SUCCESS [ 7.896 s]
12:08:35 [INFO] kapua-device-authentication ........................ SUCCESS [ 1.509 s]
12:08:35 [INFO] kapua-tag .......................................... SUCCESS [ 0.167 s]
12:08:35 [INFO] kapua-tag-api ...................................... SUCCESS [ 1.091 s]
12:08:35 [INFO] kapua-device-registry-internal ..................... SUCCESS [ 3.760 s]
12:08:35 [INFO] kapua-security-registration-simple ................. SUCCESS [ 2.015 s]
12:08:35 [INFO] kapua-tag-internal ................................. SUCCESS [ 6.810 s]
12:08:35 [INFO] kapua-security-shiro ............................... SUCCESS [ 39.768 s]
12:08:35 [INFO] kapua-simulator-kura ............................... SUCCESS [ 13.884 s]
12:08:35 [INFO] kapua-stream ....................................... SUCCESS [ 0.094 s]
12:08:35 [INFO] kapua-stream-api ................................... SUCCESS [ 1.309 s]
12:08:35 [INFO] kapua-device-management-asset ...................... SUCCESS [ 0.116 s]
12:08:35 [INFO] kapua-device-management-asset-api .................. SUCCESS [ 1.797 s]
12:08:35 [INFO] kapua-device-management-asset-store ................ SUCCESS [ 0.071 s]
12:08:35 [INFO] kapua-device-management-asset-store-api ............ SUCCESS [ 1.554 s]
12:08:35 [INFO] kapua-device-management-asset-internal ............. SUCCESS [ 2.071 s]
12:08:35 [INFO] kapua-device-management-asset-store-dummy .......... SUCCESS [ 1.569 s]
12:08:35 [INFO] kapua-device-management-bundle ..................... SUCCESS [ 0.097 s]
12:08:35 [INFO] kapua-device-management-bundle-api ................. SUCCESS [ 1.823 s]
12:08:35 [INFO] kapua-device-management-bundle-internal ............ SUCCESS [ 2.062 s]
12:08:35 [INFO] kapua-device-management-command .................... SUCCESS [ 0.097 s]
12:08:35 [INFO] kapua-device-management-command-api ................ SUCCESS [ 1.494 s]
12:08:35 [INFO] kapua-device-management-command-internal ........... SUCCESS [ 1.898 s]
12:08:35 [INFO] kapua-device-management-configuration .............. SUCCESS [ 0.131 s]
12:08:35 [INFO] kapua-device-management-configuration-api .......... SUCCESS [ 1.818 s]
12:08:35 [INFO] kapua-device-management-configuration-message-api .. SUCCESS [ 1.597 s]
12:08:35 [INFO] kapua-device-management-configuration-store ........ SUCCESS [ 0.061 s]
12:08:35 [INFO] kapua-device-management-configuration-store-api .... SUCCESS [ 1.543 s]
12:08:35 [INFO] kapua-device-management-configuration-internal ..... SUCCESS [ 2.316 s]
12:08:35 [INFO] kapua-device-management-configuration-store-dummy .. SUCCESS [ 1.596 s]
12:08:35 [INFO] kapua-device-management-inventory .................. SUCCESS [ 0.229 s]
12:08:35 [INFO] kapua-device-management-inventory-api .............. SUCCESS [ 1.895 s]
12:08:35 [INFO] kapua-device-management-inventory-internal ......... SUCCESS [ 2.331 s]
12:08:35 [INFO] kapua-device-management-keystore ................... SUCCESS [ 0.146 s]
12:08:35 [INFO] kapua-device-management-keystore-api ............... SUCCESS [ 1.733 s]
12:08:35 [INFO] kapua-device-management-keystore-internal .......... SUCCESS [ 2.649 s]
12:08:35 [INFO] kapua-device-management-packages ................... SUCCESS [ 0.276 s]
12:08:35 [INFO] kapua-device-management-packages-api ............... SUCCESS [ 2.080 s]
12:08:35 [INFO] kapua-device-management-registry-internal .......... SUCCESS [ 2.649 s]
12:08:35 [INFO] kapua-device-management-packages-internal .......... SUCCESS [ 2.653 s]
12:08:35 [INFO] kapua-device-management-request-internal ........... SUCCESS [ 1.818 s]
12:08:35 [INFO] kapua-device-management-all ........................ SUCCESS [ 0.067 s]
12:08:35 [INFO] kapua-device-management-all-internal ............... SUCCESS [ 0.167 s]
12:08:35 [INFO] kapua-translator-kapua ............................. SUCCESS [ 0.337 s]
12:08:35 [INFO] kapua-translator-kapua-kura ........................ SUCCESS [ 3.647 s]
12:08:35 [INFO] kapua-translator-kura .............................. SUCCESS [ 0.214 s]
12:08:35 [INFO] kapua-translator-kura-mqtt ......................... SUCCESS [ 1.816 s]
12:08:35 [INFO] kapua-transport-jms ................................ SUCCESS [ 1.758 s]
12:08:35 [INFO] kapua-translator-kura-jms .......................... SUCCESS [ 2.197 s]
12:08:35 [INFO] kapua-qa-common .................................... SUCCESS [ 5.375 s]
12:08:35 [INFO] kapua-account-test-steps ........................... SUCCESS [ 2.634 s]
12:08:35 [INFO] kapua-account-test ................................. SUCCESS [ 47.134 s]
12:08:35 [INFO] kapua-user-test-steps .............................. SUCCESS [ 2.936 s]
12:08:35 [INFO] kapua-user-test .................................... SUCCESS [ 54.692 s]
12:08:35 [INFO] kapua-scheduler .................................... SUCCESS [ 0.300 s]
12:08:35 [INFO] kapua-scheduler-api ................................ SUCCESS [ 1.508 s]
12:08:35 [INFO] kapua-device-management-job ........................ SUCCESS [ 0.101 s]
12:08:35 [INFO] kapua-device-management-job-api .................... SUCCESS [ 1.794 s]
12:08:35 [INFO] kapua-service-client ............................... SUCCESS [ 6.570 s]
12:08:35 [INFO] kapua-broker ....................................... SUCCESS [ 0.205 s]
12:08:35 [INFO] kapua-broker-artemis ............................... SUCCESS [ 0.196 s]
12:08:35 [INFO] kapua-broker-artemis-plugin ........................ SUCCESS [ 7.200 s]
12:08:35 [INFO] kapua-device-registry-test-steps ................... SUCCESS [ 4.664 s]
12:08:35 [INFO] kapua-device-registry-test ......................... SUCCESS [01:51 min]
12:08:35 [INFO] kapua-scheduler-quartz ............................. SUCCESS [ 3.363 s]
12:08:35 [INFO] kapua-job-internal ................................. SUCCESS [ 3.660 s]
12:08:35 [INFO] kapua-job-test-steps ............................... SUCCESS [ 2.994 s]
12:08:35 [INFO] kapua-job-test ..................................... SUCCESS [01:53 min]
12:08:35 [INFO] kapua-tag-test-steps ............................... SUCCESS [ 2.400 s]
12:08:35 [INFO] kapua-tag-test ..................................... SUCCESS [01:29 min]
12:08:35 [INFO] kapua-endpoint ..................................... SUCCESS [ 0.149 s]
12:08:35 [INFO] kapua-endpoint-api ................................. SUCCESS [ 1.108 s]
12:08:35 [INFO] kapua-rest-api ..................................... SUCCESS [ 0.533 s]
12:08:35 [INFO] kapua-rest-api-core ................................ SUCCESS [ 8.522 s]
12:08:35 [INFO] kapua-device-management-all-api .................... SUCCESS [ 0.073 s]
12:08:35 [INFO] kapua-system ....................................... SUCCESS [ 0.071 s]
12:08:35 [INFO] kapua-system-api ................................... SUCCESS [ 1.051 s]
12:08:35 [INFO] kapua-commons-rest-errors .......................... SUCCESS [ 2.116 s]
12:08:35 [INFO] kapua-rest-api-resources ........................... SUCCESS [ 4.130 s]
12:08:35 [INFO] kapua-endpoint-internal ............................ SUCCESS [ 2.181 s]
12:08:35 [INFO] kapua-commons-rest-filters ......................... SUCCESS [ 2.374 s]
12:08:35 [INFO] kapua-stream-internal .............................. SUCCESS [ 1.780 s]
12:08:35 [INFO] kapua-system-internal .............................. SUCCESS [ 1.568 s]
12:08:35 [INFO] kapua-extras ....................................... SUCCESS [ 0.151 s]
12:08:35 [INFO] kapua-foreignkeys .................................. SUCCESS [ 0.108 s]
12:08:35 [INFO] kapua-rest-api-web ................................. SUCCESS [ 19.162 s]
12:08:35 [INFO] kapua-qa-integration-steps ......................... SUCCESS [ 4.417 s]
12:08:35 [INFO] kapua-security-test-steps .......................... SUCCESS [ 3.171 s]
12:08:35 [INFO] kapua-device-management-job-internal ............... SUCCESS [ 2.299 s]
12:08:35 [INFO] kapua-endpoint-test-steps .......................... SUCCESS [ 2.800 s]
12:08:35 [INFO] kapua-device-management-bundle-job ................. SUCCESS [ 1.987 s]
12:08:35 [INFO] kapua-device-management-asset-job .................. SUCCESS [ 1.699 s]
12:08:35 [INFO] kapua-device-management-packages-job ............... SUCCESS [ 1.864 s]
12:08:35 [INFO] kapua-device-management-command-job ................ SUCCESS [ 1.743 s]
12:08:35 [INFO] kapua-device-management-configuration-job .......... SUCCESS [ 1.974 s]
12:08:35 [INFO] kapua-device-management-keystore-job ............... SUCCESS [ 1.932 s]
12:08:35 [INFO] kapua-scheduler-test-steps ......................... SUCCESS [ 2.271 s]
12:08:35 [INFO] kapua-datastore-test-steps ......................... SUCCESS [ 3.652 s]
12:08:35 [INFO] kapua-service-camel ................................ SUCCESS [ 2.196 s]
12:08:35 [INFO] kapua-consumer ..................................... SUCCESS [ 0.122 s]
12:08:35 [INFO] kapua-consumer-lifecycle ........................... SUCCESS [ 2.641 s]
12:08:35 [INFO] kapua-consumer-telemetry ........................... SUCCESS [ 2.890 s]
12:08:35 [INFO] kapua-service-authentication ....................... SUCCESS [ 2.926 s]
12:08:35 [INFO] kapua-qa-integration ............................... FAILURE [ 01:44 h]
12:08:35 [INFO] kapua-dev-tools .................................... SKIPPED
12:08:35 [INFO] kapua-cucumber-reports ............................. SKIPPED
12:08:35 [INFO] kapua-deployment ................................... SKIPPED
12:08:35 [INFO] kapua-deployment-commons ........................... SKIPPED
12:08:35 [INFO] kapua-docker ....................................... SKIPPED
12:08:35 [INFO] kapua-minishift .................................... SKIPPED
12:08:35 [INFO] kapua-openshift .................................... SKIPPED
12:08:35 [INFO] kapua-datastore-test ............................... SKIPPED
12:08:35 [INFO] kapua-device-management-all-job .................... SKIPPED
12:08:35 [INFO] kapua-scheduler-test ............................... SKIPPED
12:08:35 [INFO] kapua-security-test ................................ SKIPPED
12:08:35 [INFO] kapua-system-test-steps ............................ SKIPPED
12:08:35 [INFO] kapua-system-test .................................. SKIPPED
12:08:35 [INFO] kapua-service-authentication-app ................... SKIPPED
12:08:35 [INFO] kapua-translator-test-steps ........................ SKIPPED
12:08:35 [INFO] kapua-translator-test .............................. SKIPPED
12:08:35 [INFO] kapua-es-migrator .................................. SKIPPED
12:08:35 [INFO] kapua-encryption-migrator .......................... SKIPPED
12:08:35 [INFO] kapua-liquibase-unlocker ........................... SKIPPED
12:08:35 [INFO] kapua-openid-provider-generic ...................... SKIPPED
12:08:35 [INFO] kapua-openid-provider-keycloak ..................... SKIPPED
12:08:35 [INFO] kapua-job-engine-jbatch ............................ SKIPPED
12:08:35 [INFO] kapua-job-engine-app ............................... SKIPPED
12:08:35 [INFO] kapua-job-engine-app-core .......................... SKIPPED
12:08:35 [INFO] kapua-job-engine-app-resources ..................... SKIPPED
12:08:35 [INFO] kapua-job-engine-app-web ........................... SKIPPED
12:08:35 [INFO] kapua-consumer-lifecycle-app ....................... SKIPPED
12:08:35 [INFO] kapua-consumer-telemetry-app ....................... SKIPPED
12:08:38 [Checks API] No suitable checks publisher found.
12:08:38 Finished: ABORTED
![[Jenkins]](/kapua/static/eb5811dc/images/svgs/logo.svg){kind=logo}
