Not able to create a account

[Saib1]

Hi,

From the customer_account table

we are trying to create new account is giving error - Invalid Insert

[Community Alums]

Hello @saib,

I found one article please refer below link,

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

Thanks

[Rajesh Chopade1 · Accepted solution]

Hi @Saib1 

Cause

The customer_account table has three fields that require unique values, one is the account code. This field is creating with a default value that is determined by the last used value. The 'last used' value is stored in the com.snc.cs_base.last.generated.code.tree.path system property. If the property is reset to the original value, it will attempt to create new accounts with an account code that is already in use.

Resolution

Identify the last used value for the account code field on the customer_account table and update the com.snc.cs_base.last.generated.code.tree.path system property with that value.

I hope this will helps you to resolve your issue.

Please mark my answer correct and helpful if it helps you to resolve your issue.

Thank you

Rajesh.

[Shivam_Tripathi]

Hi @Saib1  , We don't encounter such situation , probably there will be issue with the instance ,please refresh it and try creating again with valid useful details.
Shivam.

[Saib1]

@Shivam_Tripathi - Please find the details RCA has given by @Rajesh Chopade1 . It was helpful to resolve my issue