ICM links: Troubleshooting error "DGL5133A: Adding or deleting links failed" with "SQL RC = 100"

Technote (FAQ)


Question

Error "DGL5133A: Adding or deleting links failed" with an Ext/SQL Return Code "100" (usually listed as "[LS RC = 7015, SQL RC = 100]" when a link or folder content relationship was removed that was either already deleted or never created.

Cause

When a user submits the same link more than once to be broken / deleted,
the following generic error is returned simply reporting that adding or removing links failed.

Error
Exception Name: DKUsageError
  Exception ID: 5133
    Error Text: DGL5133A: Adding or deleting links failed.  Library server detected an unexpected SQL error.;  ICM7015: During an SQL operation in the library server, an unexpected error occurred.  For details on the error, from a DB2 command prompt enter DB2 ? SQLnnnn.  (STATE) : [LS RC = 7015, SQL RC = 100]

     File Name: PLinkCRUDICM.cpp
      Function: PLinkCRUDICM::performLinkingOrUnlinking
   Line Number: 484

     File Name: PLinkCRUDICM.cpp
      Function: PLinkCRUDICM::performLinkingOrUnlinking
   Line Number: 510

This error occurs in the following cases:

  • The user saves updates to an existing item that had links or folder contents removed that were already removed by the same or different user. The link information in this item was stale and no longer valid since it was modified by another user.
  • The user saves updates to an existing item that had links or folder contents removed that were never created in the connected datastore.
  • The user had multiple copies of the same items in memory and performed the same remove actions on more than one without refreshing the link information in the others after changes.
  • The user requested to explicitly break a link that was already removed by the same or different user.
      Related Methods
      DKDatastoreExtICM::removeLink()
      DKLinkCollectionICM::removeMember()
      DKLinkCollectionICM::removeAllMembers()
  • The user requested to explicitly break a link that was never created in the connected datastore.
      Related Methods
      DKDatastoreExtICM::removeLink()
      DKLinkCollectionICM::removeMember()
      DKLinkCollectionICM::removeAllMembers()
  • The user requested to explicitly remove a folder content relationship that was already removed by the same or different user.
      Related Methods
      DKDatastoreExtICM::removeFromFolder()
      DKFolder::removeMember()
      DKFolder::removeAllMembers())
  • The user requested to explicitly remove a folder content relationship that was never created in the connected datastore.
      Related Methods
      DKDatastoreExtICM::removeFromFolder()
      DKFolder::removeMember()
      DKFolder::removeAllMembers())

Answer

When the error ID is the value of constant DKMessageIdICM::DK_ICM_MSG_LINKUNLINK_FAILED_RC_UNEXPECTED_SQL_ERROR (5133), parse the error state information or message text for an SQL return code of 100. This error typically appears as text "[LS RC = 7015, SQL RC = 100]" in the error state available through the DKException object and in the message text itself. This format is not guaranteed and location of the information can vary from Java to C++. It is best to parse the message text for "100" to determine if the usage error scenarios identified above are the likely cause.


Until a more precise error message is returned by this scenario, use the following text when you detect this case.

Suggested Text
Cannot remove a link that does not exist. The server received a request to delete one or more link relationships. At least one of the removed links does not currently exist in the server. It was either already deleted or never created.


Cross reference information
Segment Product Component Platform Version Edition
Enterprise Content Management Content Manager Usage AIX, Linux, Solaris, UNIX, Windows 2000, Windows NT, Windows XP 8.1, 8.2

Document information


More support for:

Content Manager
DB2 Information Integrator for Content

Software version:

8.1, 8.2

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1163528

Modified date:

2004-03-17

Translate my page

Content navigation