Resolution:

Description:
============
Workflow execution throws unique key constraint violation or duplicate key exception on PROCESSLOG table while workflow is running at certain activities.

Environment:
===========
TIBCO Collaborative Information Manager (CIM) All (so far)

Symptoms:
========
Workflow execution throws unique key constraint violation or duplicate key exception on PROCESSLOG table at certain activities.

For Microsoft SQL SERVER: "com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'XPKPROCESSLOG'. Cannot insert duplicate key in object 'dbo.PROCESSLOG'"

For Oracle: "java.sql.SQLException: ORA-00001: unique constraint (CIMADM.XPKPROCESSLOG) violated"

Cause:
=====
This occurs when the text in the &ltDescription lang="en"></Description> node of a workflow activity exceeds 80 characters.

Resolution:
==========
The resolution for this issue/error is to limit the number of characters in the &ltDescription lang="en"></Description> node of all the workflow activities to less than 80 characters.

Attachments:
===========
None

References:
==========
None

Unique key constraint violation or duplicate key exception thrown on PROCESSLOG table while workflow is running.