AiDOPWarehouse/doc/plan/sql/uat-data/_tmp_uat_refresh_status.sql

UPDATE aidop_action_run_log
SET status='FAILED',
    message='UAT_RECOVERY：后端重启后清理遗留运行标记',
    end_time=NOW()
WHERE id IN (839674329174085,839674331217989)
  AND status='RUNNING'
  AND start_time < DATE_SUB(NOW(), INTERVAL 2 HOUR);

SELECT id,module_code,tenant_id,factory_id,status,current_stage,error_message,
       submitted_at,started_at,heartbeat_at,finished_at
FROM ado_module_dashboard_rebuild_job
WHERE id IN (7790,7793,7796,7797,7800,7804,7820,7821,7822,7856,7862)
ORDER BY id;

SELECT id,tenant_id,status,message,start_time,end_time
FROM aidop_action_run_log
WHERE id IN (839723670278213,839674329174085,839674331217989)
ORDER BY id;

WITH scopes AS (
  SELECT 838257186181189 tenant_id,'A' tenant_code
  UNION ALL SELECT 838257212780613,'B'
  UNION ALL SELECT 838257237606469,'DEMO'
), expected AS (
  SELECT s.tenant_id,s.tenant_code,m.ModuleCode module_code,m.MetricCode metric_code
  FROM scopes s JOIN ado_smart_ops_kpi_master m ON m.TenantId=s.tenant_id
  WHERE m.MetricLevel=1 AND m.IsEnabled=1
    AND m.ModuleCode IN ('S1','S2','S3','S4','S5','S6','S7','S9')
), ranked AS (
  SELECT v.*,ROW_NUMBER() OVER (
    PARTITION BY v.tenant_id,v.metric_code
    ORDER BY v.biz_date DESC,v.calc_time DESC,v.id DESC
  ) rn
  FROM ado_s9_kpi_value_l1_day v
  JOIN scopes s ON s.tenant_id=v.tenant_id
  WHERE v.factory_id=1 AND v.is_deleted=0
)
SELECT e.tenant_code,e.module_code,COUNT(*) expected_metrics,
       SUM(r.metric_value IS NOT NULL) metrics_with_value,
       GROUP_CONCAT(CASE WHEN r.metric_value IS NULL THEN e.metric_code END ORDER BY e.metric_code) missing_metrics
FROM expected e
LEFT JOIN ranked r ON r.tenant_id=e.tenant_id AND r.metric_code=e.metric_code AND r.rn=1
GROUP BY e.tenant_code,e.module_code
ORDER BY FIELD(e.tenant_code,'A','B','DEMO'),e.module_code;

SELECT TenantId,ModuleCode,MetricCode,MetricName,FormulaExpression,DataSource
FROM ado_smart_ops_kpi_master
WHERE TenantId IN (838257186181189,838257212780613,838257237606469)
  AND MetricCode IN ('S1_L1_004','S3_L1_004','S9_L1_001')
ORDER BY TenantId,MetricCode;