topic Schema from load plan stuck in queue in Data & Schema Discussions

topic Schema from load plan stuck in queue in Data & Schema Discussions https://community.incorta.com/t5/data-schema-discussions/schema-from-load-plan-stuck-in-queue/m-p/5833#M501 <P>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:</P><P>JOB table:</P><P> </P><LI-CODE lang="markup">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';</LI-CODE><P> </P><P>load_plan table:</P><P> </P><LI-CODE lang="markup">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)</LI-CODE><P> </P><P> </P> Mon, 08 Jul 2024 13:42:42 GMT yasminemaximos 2024-07-08T13:42:42Z Schema from load plan stuck in queue https://community.incorta.com/t5/data-schema-discussions/schema-from-load-plan-stuck-in-queue/m-p/5833#M501 <P>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:</P><P>JOB table:</P><P> </P><LI-CODE lang="markup">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';</LI-CODE><P> </P><P>load_plan table:</P><P> </P><LI-CODE lang="markup">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)</LI-CODE><P> </P><P> </P> Mon, 08 Jul 2024 13:42:42 GMT https://community.incorta.com/t5/data-schema-discussions/schema-from-load-plan-stuck-in-queue/m-p/5833#M501 yasminemaximos 2024-07-08T13:42:42Z