Application started at 2025-03-14 5:35:34 AM Time taken to start: 00:02:31.1541991 Connection 'sofvie_dev_aws_db' was connected. Connection 'Epiroc_Production_DB' was connected. Connection 'Epiroc_Production_DB' was disconnected. The connection 'sofvie_dev_aws_db' was closed due to the error 'Lost connection to MySQL server during query (35.183.106.134:3306)'. SQL1.sql: Error (1,1): Lost connection to MySQL server during query (35.183.106.134:3306) ------ Execution started: Connection: SQL1.sql ------ Query opened in 1.030s [0.232s exec, 0.798s fetch] Query opened in 0.716s [0.230s exec, 0.486s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.746s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.219s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.226s] Execute succeeded. 0 rows affected [0.219s] Execute succeeded. 0 rows affected [0.218s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.226s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.220s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.678s [0.232s exec, 0.446s fetch] Query opened in 0.473s [0.232s exec, 0.241s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.151s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.233s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.246s] Execute succeeded. 0 rows affected [0.244s] Execute succeeded. 0 rows affected [0.233s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.240s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.232s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.681s [0.233s exec, 0.448s fetch] Query opened in 0.477s [0.231s exec, 0.246s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.158s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.223s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.233s] Execute succeeded. 0 rows affected [0.221s] Execute succeeded. 0 rows affected [0.222s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.226s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.220s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.685s [0.234s exec, 0.451s fetch] Query opened in 0.703s [0.243s exec, 0.460s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.388s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.235s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.239s] Execute succeeded. 0 rows affected [0.234s] Execute succeeded. 0 rows affected [0.234s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.239s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.232s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.682s [0.235s exec, 0.447s fetch] Query opened in 0.476s [0.230s exec, 0.246s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.158s] ------------- sofvie_dev.rpt_get_training_records_by_employee: Execute succeeded. 0 rows affected [0.220s] sofvie_dev.rpt_get_training_records_by_employee: Execute succeeded. 0 rows affected [0.232s] Execute succeeded. 0 rows affected [0.221s] Execute succeeded. 0 rows affected [0.219s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.229s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.220s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.680s [0.233s exec, 0.447s fetch] Query opened in 0.468s [0.230s exec, 0.238s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.148s] ------------- sofvie_dev.rpt_get_training_records_by_employee: Execute succeeded. 0 rows affected [0.233s] sofvie_dev.rpt_get_training_records_by_employee: Execute succeeded. 0 rows affected [0.240s] Execute succeeded. 0 rows affected [0.245s] Execute succeeded. 0 rows affected [0.239s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.239s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.235s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.686s [0.237s exec, 0.449s fetch] Query opened in 0.676s [0.230s exec, 0.446s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.362s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.233s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.250s] Execute succeeded. 0 rows affected [0.231s] Execute succeeded. 0 rows affected [0.233s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.238s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.233s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.689s [0.241s exec, 0.448s fetch] Query opened in 0.248s [0.229s exec, 0.019s fetch] ------------ Done: SQL1.sql [0.937s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.219s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.229s] Execute succeeded. 0 rows affected [0.221s] Execute succeeded. 0 rows affected [0.225s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.227s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.220s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.707s [0.244s exec, 0.463s fetch] Error (2,1): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (et.etr_created_date BETWEEN 2020-01-01 AND 2025-03-15 OR et.etr_created_...' at line 36 ------------ Done: SQL1.sql [0.934s] ------------- ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.677s [0.229s exec, 0.448s fetch] Error (2,1): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (et.etr_created_date BETWEEN 2020-01-01 AND 2025-03-15 OR et.etr_created_...' at line 36 ------------ Done: SQL1.sql [0.903s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.221s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.227s] Execute succeeded. 0 rows affected [0.231s] Execute succeeded. 0 rows affected [0.220s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.235s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.230s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.678s [0.231s exec, 0.447s fetch] Query opened in 0.679s [0.232s exec, 0.447s fetch] SQL1.sql: Warning: Truncated incorrect datetime value: '2018' Warning: Truncated incorrect datetime value: '2007' ------------ Done: SQL1.sql [1.357s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.232s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.226s] Execute succeeded. 0 rows affected [0.219s] Execute succeeded. 0 rows affected [0.219s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.226s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.219s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.680s [0.232s exec, 0.448s fetch] Query opened in 0.455s [0.229s exec, 0.226s fetch] ------------ Done: SQL1.sql [1.135s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.219s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.227s] Execute succeeded. 0 rows affected [0.220s] Execute succeeded. 0 rows affected [0.221s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.227s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.220s] ------ Execution started: Connection: SQL1.sql ------ The connection 'sofvie_dev_aws_db' was closed due to the error 'Lost connection to MySQL server during query (35.183.106.134:3306)'. Error (1,1): Lost connection to MySQL server during query (35.183.106.134:3306) ------------ Done: SQL1.sql [0.005s] ------------- ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.669s [0.229s exec, 0.440s fetch] Query opened in 0.248s [0.220s exec, 0.028s fetch] ------------ Done: SQL1.sql [0.917s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.231s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.234s] Execute succeeded. 0 rows affected [0.228s] Execute succeeded. 0 rows affected [0.227s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.235s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.229s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.218s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.225s] Execute succeeded. 0 rows affected [0.240s] Execute succeeded. 0 rows affected [0.221s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.223s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.216s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.702s [0.243s exec, 0.459s fetch] Error (2,1): Unknown column '1LEFT' in 'on clause' ------------ Done: SQL1.sql [0.930s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.234s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.249s] Execute succeeded. 0 rows affected [0.230s] Execute succeeded. 0 rows affected [0.229s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.236s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.227s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.686s [0.230s exec, 0.456s fetch] Query opened in 0.470s [0.226s exec, 0.244s fetch] ------------ Done: SQL1.sql [1.156s] ------------- sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.229s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.225s] Execute succeeded. 0 rows affected [0.221s] Execute succeeded. 0 rows affected [0.222s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.225s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.217s] ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.691s [0.241s exec, 0.450s fetch] Query opened in 0.451s [0.223s exec, 0.228s fetch] ------------ Done: SQL1.sql [1.142s] ------------- ------ Execution started: Connection: SQL1.sql ------ Query opened in 0.677s [0.229s exec, 0.448s fetch] Query opened in 0.245s [0.221s exec, 0.024s fetch] ------------ Done: SQL1.sql [0.922s] ------------- Object prompt error caused by failure in describing objects due to server disconnection or insufficient rights. Lost connection to MySQL server during query (35.183.106.134:3306) sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.240s] sofvie_dev.rpt_get_training_records_by_employee_3243: Execute succeeded. 0 rows affected [0.243s] Execute succeeded. 0 rows affected [0.237s] Execute succeeded. 0 rows affected [0.236s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.245s] Execute succeeded. 0 rows affected [< 0,001s] Execute succeeded. 0 rows affected [0.238s] ------ Execution started: Connection: SQL2.sql ------ Query opened in 0.685s [0.235s exec, 0.450s fetch] Query opened in 0.240s [0.229s exec, 0.011s fetch] ------------ Done: SQL2.sql [0.925s] ------------- ------ Execution started: Connection: SQL2.sql ------ The connection 'sofvie_dev_aws_db' was closed due to the error 'Lost connection to MySQL server during query (35.183.106.134:3306)'. Error (1,1): Lost connection to MySQL server during query (35.183.106.134:3306) ------------ Done: SQL2.sql [0.011s] ------------- ------ Execution started: Connection: SQL2.sql ------ Query opened in 0.705s [0.238s exec, 0.467s fetch] Query opened in 0.473s [0.241s exec, 0.232s fetch] ------------ Done: SQL2.sql [1.178s] -------------