cancel
Showing results for 
Search instead for 
Did you mean: 

Schema from load plan stuck in queue

yasminemaximos
Employee
Employee

If a certain schema is stuck in queue and the stuck load run was part of a load plan , run below queries in metadata db against JOB and load_plan tables:

JOB table:

 

SELECT * from 'JOB' where GUID='0b768a92-d84c-4b65-be4e-f5490702d85a';

UPDATE JOB Set END_TIME=START_TIME where GUID='0b768a92-d84c-4b65-be4e-f5490702d85a';

UPDATE JOB Set state=101 where GUID='0b768a92-d84c-4b65-be4e-f5490702d85a';

 

load_plan table:

 

MySQL [icdb]> select * from load_plan where name='eFinance_Every1hr_full';
+----+------------------------+-------------+----------+-----------+-------------------------+-------------------+-------------+
| ID | NAME                   | DESCRIPTION | OWNER_ID | TENANT_ID | CREATION_DATE           | MODIFICATION_DATE | MODIFIER_ID |
+----+------------------------+-------------+----------+-----------+-------------------------+-------------------+-------------+
|  5 | eFinance_Every1hr_full |             |      150 |         9 | 2024-04-12 12:39:44.546 | NULL              |        NULL |
+----+------------------------+-------------+----------+-----------+-------------------------+-------------------+-------------+
1 row in set (0.001 sec)


MySQL [icdb]> select * from load_plan_execution where load_plan_id=5 and is_recent =1;
+------+--------------+------------------------+-------------------------+----------+--------+---------+---------+-----------+------------------+-----------+--------------+
| ID   | LOAD_PLAN_ID | LOAD_PLAN_NAME         | START_TIME              | END_TIME | STATUS | MESSAGE | USER_ID | TENANT_ID | SCHEDULER_JOB_ID | IS_RECENT | SERVICE_NAME |
+------+--------------+------------------------+-------------------------+----------+--------+---------+---------+-----------+------------------+-----------+--------------+
| 6757 |            5 | eFinance_Every1hr_full | 2024-06-06 15:00:00.000 | NULL     |     46 | NULL    |     150 |         9 |              145 | 1         | NULL         |
+------+--------------+------------------------+-------------------------+----------+--------+---------+---------+-----------+------------------+-----------+--------------+
1 row in set (0.003 sec)

MySQL [icdb]>  UPDATE load_plan_execution SET END_TIME=START_TIME WHERE ID=6757;
Query OK, 1 row affected (0.007 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MySQL [icdb]>  UPDATE load_plan_execution SET STATUS=101 WHERE ID=6757;
Query OK, 1 row affected (0.007 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MySQL [icdb]> select * from load_plan_execution where load_plan_id=5 and is_recent =1;
+------+--------------+------------------------+-------------------------+-------------------------+--------+---------+---------+-----------+------------------+-----------+--------------+
| ID   | LOAD_PLAN_ID | LOAD_PLAN_NAME         | START_TIME              | END_TIME                | STATUS | MESSAGE | USER_ID | TENANT_ID | SCHEDULER_JOB_ID | IS_RECENT | SERVICE_NAME |
+------+--------------+------------------------+-------------------------+-------------------------+--------+---------+---------+-----------+------------------+-----------+--------------+
| 6757 |            5 | eFinance_Every1hr_full | 2024-06-06 15:00:00.000 | 2024-06-06 15:00:00.000 |    101 | NULL    |     150 |         9 |              145 | 1         | NULL         |
+------+--------------+------------------------+-------------------------+-------------------------+--------+---------+---------+-----------+------------------+-----------+--------------+
1 row in set (0.003 sec)

 

 

0 REPLIES 0