Account Path error when creating new Accounts

[Gopal14]

Hi Team,

when creating New Account, receiving an error "

java.sql.BatchUpdateException: (conn=1570641) Duplicate entry '!!!;' for key 'account_path' ".

when checking in the list view of Accounts table, with this same account_path already one record is there,

in system property "com.snc.cs_base.last.generated.code.tree.path" also same account_path is showing

 Any help?

[Kieran Anson · Accepted solution]

This can occur if accounts are brought via XML records from a lower environment, or created via transform map(s) and business rules are disabled. 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0783732

As your current account code is !!!; change the property to !!!< which is the next in the sequence. If that code is also taken (check the account table first) then keep cycling up the sequence of the following characters

"!#$&()*+,-.0123456789:;<?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]`}|{~"

e.g

!!!<

!!!?

!!!@

!!!A

!!!B