Employee ID not incrementing when trying to create a consultant account

[esinam_g]

Hello

I am encountering an issue where the employee ID is not incrementing anymore when trying to create consultant account

i m using this query

select concat('X',LPAD(COALESCE(max(right(employeeid,length(employeeid)-1))+1,'1'),7,'0')) as ID from users where employeeid is not null and customproperty10='Externe'

however it s getting stuck with the current number.

could you please assist

[rushikeshvartak]

• Does it works from data analyzer ?
• Did you validated logs ?