IBM Support

webMethods Knowlegebase : Is there a limit to the number of users in a task assignment list? Task Assignment fails because of a large ASSIGNED_TO list (1799036)

Troubleshooting


Problem

Task Assignment fails with below error whenever the assignment list is larger than normal:

"SOAPException( Server.userException: com.webmethods.portal.bizPolicy.BizException: [POP.001.0002] A "java.sql.SQLException" occurred with the Message "[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "MWS_INTERNAL"."T_TASK"."ASSIGNED_TO" (actual: 1007, maximum: 1000)"

In another case, they see the following:

"java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_T_TASK_INBOX'. Cannot insert duplicate key in object 'dbo.T_TASK_INBOX'. The duplicate key value is (896799, 1098922, 1, 11259)."

Have about 75 members.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAWP1J","label":"IBM webMethods BPM"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Task Engine (WTN)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Windows Server 2012"}],"Version":"9.9"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 March 2025

UID

ibm17197669

Page Feedback