Chat users are unable to create an incident from the chat.
1.Enabled the below-listed plugins:
-Connect Support and Service Portal Integration
2. End user initiates chat using Service Portal.
4. Error displayed:
"Unique Key violation detected by database (Duplicate entry 'TASK0020070' for key 'task_U1')".
Any ServiceNow Release using Connect Chat
In customer instance, they had enforced uniqueness on the Task table "Number" field.
From the documentation regarding the unique option:
"Note: While unique indexes ensure data integrity they also prevent any insert involving a duplicate number. This may cause unexpected errors during data entry."
The chat_queue_entry number is inherited from Task. Baseline instances do not have this field flagged, so the default numbering is not an issue.
In out of the box instance, 'Number' field is not set to 'Unique' in Task Table.
Customer did not have Auto numbering defined on chat_queue_entry[ Table: Chat queue entry].
In standard out of the box instance, this is a default behavior.
- Remove the enforced uniqueness on the task Number field to resolve the issue.
- Add a reference for chat into Number Maintenance on chat_queue_entry [ Table: Chat queue entry]
- Go to System Definition > Number Maintenance
- Click New.
- Table: Chat Queue Entry
- Prefix: CHAT
- Number: 10,000
- Number of Digits: 7