GrailsFlow

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s: 0.9.3
• Component/s: None
• Labels:

  None

If we create workflow where one Node will have transition to self, and during workflow execution we should move by this transition some times we can get UncategorizedSQLException (see attached log).
The reason of this problem is the updateNodeSequence from ProcessManagerService.

public def updateNodeSequence(fromNode, toNode, eventID) {
        def nextAssigneeToString = ''
        toNode.owners?.each() {
          if (nextAssigneeToString != '') {
            nextAssigneeToString += ","
          }
          nextAssigneeToString += it.ownerID
        }

        new ProcessNodeSequence(processID: fromNode.processID, fromNodeID: fromNode.nodeID,
            toNodeID: toNode.nodeID, eventID: eventID, startedFromDate: fromNode.startedOn,
            startedToDate: toNode.startedOn, caller: toNode.caller, owners: nextAssigneeToString)
          .save()
    }

As you can see nextAssigneeToString is increased each executed time. Ad it can lead to string more that 256 characters (length into DataBase schema). As quick solution we offer to add check by length of nextAssigneeToString and don't increase it in case of more that 256 characters.

This problem is specify only for branch: rel_20090330

1. 

   log.txt

   11/Aug/09 1:29 PM

   63 kB

   Staskov, Ivan

• Assignee:

  Czeranka, Norbert

  Reporter:

  Staskov, Ivan

• Created:

  11/Aug/09 1:27 PM

  Updated:

  04/Sep/09 3:08 PM

  Resolved:

  04/Sep/09 2:45 PM