1 Reply Latest reply on May 30, 2012 3:38 PM by Asad Rauf

    Data too long for column 'processInstanceByteArray'

    Asad Rauf Newbie

      I searched the forums but couldn't find this exact issue anywhere. I had a working process with a single task and modified it to add a human task. After deploying this change I keep getting the above error. I have changed the type of processInstanceByteArray to longblob but I continue to see this error. I am using mysql database. I would appreciate any help. Please let me know if I can give more info on this.

        • 1. Re: Data too long for column 'processInstanceByteArray'
          Asad Rauf Newbie

          I am posting my bpmn process for more info:

           

           

          <?xml version="1.0" encoding="UTF-8"?>

          <definitions id="Definition"

                       targetNamespace="http://www.jboss.org/drools"

                       typeLanguage="http://www.java.com/javaTypes"

                       expressionLanguage="http://www.mvel.org/2.0"

                       xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL"

                       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                       xsi:schemaLocation="http://www.omg.org/spec/BPMN/20100524/MODEL BPMN20.xsd"

                       xmlns:g="http://www.jboss.org/drools/flow/gpd"

                       xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI"

                       xmlns:dc="http://www.omg.org/spec/DD/20100524/DC"

                       xmlns:di="http://www.omg.org/spec/DD/20100524/DI"

                       xmlns:tns="http://www.jboss.org/drools">

            <itemDefinition id="_permissionRequestItem" structureRef="com.google.partnerservices.simba.bo.PermissionRequestItem" />

           

           

            <process processType="Private" isExecutable="true" id="com.google.simba.permissionRequest" name="PermissionRequest" tns:packageName="defaultPackage" >

           

           

              <!-- process variables -->

              <property id="approver" itemSubjectRef="_approverItem"/>

              <property id="description" itemSubjectRef="_descriptionItem"/>

              <property id="permissionRequestItems" itemSubjectRef="_permissionRequestItem"/>   

              <property id="actor" itemSubjectRef="_actor"/>

           

           

              <!-- nodes -->

              <startEvent id="_1" name="Start" />

              <task id="_2" name="Send Permission Request" tns:taskName="sendPermissionRequest" >

                <ioSpecification>

                  <dataInput id="approver" name="approver" />

                  <dataInput id="description" name="description" />

                  <dataInput id="permissionRequestItems" name="permissionRequestItems" />

                  <dataOutput id="actorId" name="actorId" />

                  <inputSet>

                    <dataInputRefs>approver</dataInputRefs>

                    <dataInputRefs>description</dataInputRefs>

                    <dataInputRefs>permissionRequestItems</dataInputRefs>

                  </inputSet>

                  <outputSet>

                    <dataOutputRefs>actorId</dataOutputRefs>

                  </outputSet>

                </ioSpecification>

                <dataInputAssociation>

                  <sourceRef>approver</sourceRef>

                  <targetRef>approver</targetRef>

                </dataInputAssociation>

                <dataInputAssociation>

                  <sourceRef>description</sourceRef>

                  <targetRef>description</targetRef>

                </dataInputAssociation>

                <dataInputAssociation>

                  <sourceRef>permissionRequestItems</sourceRef>

                  <targetRef>permissionRequestItems</targetRef>

                </dataInputAssociation>

                <dataOutputAssociation>

                  <sourceRef>actorId</sourceRef>

                  <targetRef>actor</targetRef>

                </dataOutputAssociation>

              </task>

           

           

          <userTask id="_4" name="Manager Approval" >

                <ioSpecification>

                  <dataInput id="_4_SkippableInput" name="Skippable" />

                  <dataInput id="_4_TaskNameInput" name="TaskName" />

                  <dataInput id="ActorId" name="ActorId" />

                  <inputSet>

                    <dataInputRefs>_4_SkippableInput</dataInputRefs>

                    <dataInputRefs>_4_TaskNameInput</dataInputRefs>

                    <dataInputRefs>ActorId</dataInputRefs>

                  </inputSet>

                  <outputSet>

                  </outputSet>

                </ioSpecification>

                <dataInputAssociation>

                  <targetRef>_4_SkippableInput</targetRef>

                  <assignment>

                    <from xsi:type="tFormalExpression">false</from>

                    <to xsi:type="tFormalExpression">_4_SkippableInput</to>

                  </assignment>

                </dataInputAssociation>

                <dataInputAssociation>

                  <targetRef>_4_TaskNameInput</targetRef>

                  <assignment>

                    <from xsi:type="tFormalExpression">Manager Decision</from>

                    <to xsi:type="tFormalExpression">_4_TaskNameInput</to>

                  </assignment>

                </dataInputAssociation>

                <dataInputAssociation>

                  <sourceRef>actor</sourceRef>

                  <targetRef>ActorId</targetRef>

                </dataInputAssociation>

                <potentialOwner>

                  <resourceAssignmentExpression>

                    <formalExpression></formalExpression>

                  </resourceAssignmentExpression>

                </potentialOwner>

              </userTask>

           

           

              <endEvent id="_7" name="End" >

                  <terminateEventDefinition/>

              </endEvent>

           

           

              <!-- connections -->

              <sequenceFlow id="_1-_2" sourceRef="_1" targetRef="_2" />

              <sequenceFlow id="_2-_4" sourceRef="_2" targetRef="_4" />

              <sequenceFlow id="_4-_7" sourceRef="_4" targetRef="_7" />

           

           

            </process>

           

           

            <bpmndi:BPMNDiagram>

              <bpmndi:BPMNPlane bpmnElement="com.google.simba.permissionRequest" >

                <bpmndi:BPMNShape bpmnElement="_1" >

                  <dc:Bounds x="404" y="23" width="48" height="48" />

                </bpmndi:BPMNShape>

                <bpmndi:BPMNShape bpmnElement="_2" >

                  <dc:Bounds x="309" y="231" width="248" height="48" />

                </bpmndi:BPMNShape>

                <bpmndi:BPMNShape bpmnElement="_4" >

                  <dc:Bounds x="319" y="399" width="246" height="48" />

                </bpmndi:BPMNShape>

                <bpmndi:BPMNShape bpmnElement="_7" >

                  <dc:Bounds x="420" y="619" width="48" height="48" />

                </bpmndi:BPMNShape>

                <bpmndi:BPMNEdge bpmnElement="_1-_2" >

                  <di:waypoint x="428" y="47" />

                  <di:waypoint x="433" y="255" />

                </bpmndi:BPMNEdge>

                <bpmndi:BPMNEdge bpmnElement="_2-_4" >

                  <di:waypoint x="433" y="255" />

                  <di:waypoint x="442" y="423" />

                </bpmndi:BPMNEdge>

                <bpmndi:BPMNEdge bpmnElement="_4-_7" >

                  <di:waypoint x="442" y="423" />

                  <di:waypoint x="444" y="643" />

                </bpmndi:BPMNEdge>

              </bpmndi:BPMNPlane>

            </bpmndi:BPMNDiagram>

           

           

          </definitions>

           

           

          The error does not occur if I remove the user task named 'Manager Approval'. I would appreciate any help in understanding what the cause of this is.