Error executing sql statement @@

[agola3bie]

Hi guys. My query here : 

count(case when STATUS_NEW in (2, 3) then 'Da phe duyet' end) as DaPheDuyet,

count(case when STATUS_NEW in (5, 6) then 'Tu choi phe duyet' end) as TuChoiPheDuyet

from

(select MSISDN, AGENT, code, as_name, STATUS_NEW, USER_CCBS, ACTION_DATE, LOAI DESCRIPTION from

(select a.MSISDN, a.AGENT, c.code, c.as_name, a.STATUS_NEW, b.USER_CCBS, a.ACTION_DATE, c.LOAI,a.DESCRIPTION,

row_number () over (partition by a.MSISDN order by a.ACTION_DATE desc) num

from OCDM_SYS.LOG_CHECK_ITEL a

left join OCDM_STAGE.ITC_SUBSCRIBERS b on a.MSISDN = b.msisdn

left join userccbs c on b.USER_CCBS = c.code

where a.action_date >= '15-sep-22' and a.action_date < '29-sep-22'

and b.USER_CCBS <> 'dktt_itc' and c.LOAI = 'Kênh NPP') where num = 1)

group by as_name

order by TenDaiLy

On Windows its ok but on Mac m1 this query can't run :(

Error report is :
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected