The LEDs show that the software we use is not correct.

hello  dear

please  confirm the following two points

1. Please confirm whether the customer has one case multiple dispatch;
2. Please confirm whether the customer sent yesterday's CAD case to today's dispatch

Use the dsecs user to log in to the CAD database and query the following two SQL statements

1.Select count(*) as num, a.sjdbh from t_cjd a where  TO_CHAR(a.cjkssj,'yyyy-mm')=TO_Char(sysdate,'yyyy-mm') group by a.sjdbh order by count(*) desc;
2.Select a.sldbh,a.jjkssj from t_sld a, t_cjd b where a.sjdbh=b.sjdbh and  TO_CHAR(b.cjkssj,'yyyy-mm')=TO_Char(sysdate,'yyyy-mm') and TO_CHAR(a.jjkssj,'yyyy-mm')<TO_Char(sysdate,'yyyy-mm');

Compare inspection results
Usually the total number of dispatch is more than the total number of calltaker, only the following cases:
1 case multiple dispatch