Uploaded image for project: 'Service Orchestrator'
  1. Service Orchestrator
  2. SO-1605

SO fails on updating Camunda table when DoCreateVfModule for vCPE infra service

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Highest Highest
    • El Alto Release
    • Dublin Release
    • Master branch ONAP on Integration-OOM-Stating-Daily

       

      When vCPE use case does infra service instantiation, it failed at DoCreateVfModule with the following error in bpmn debug.log: 

       

      2019-03-07T17:00:45.811Z|bcfc400d-940c-414f-9e01-e9700f2601d5-1551978035234| o.o.s.b.c.workflow.service.CallbackHandlerService - [SDNC-CALLBACK] Found 1 process(es) waiting for sdnc
      2019-03-07T17:00:45.811Z|bcfc400d-940c-414f-9e01-e9700f2601d5-1551978035234| o.o.s.b.c.workflow.service.CallbackHandlerService - [SDNC-CALLBACK] Running Process[89617d6f-40fa-11e9-8
      2019-03-07T17:00:45.838Z|bcfc400d-940c-414f-9e01-e9700f2601d5| org.camunda.bpm.engine.context - ENGINE-16004 Exception while closing command context: ENGINE-03083 Exception while ex
      ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistori
      ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch ind
      java.sql.BatchUpdateException: (conn=1838) Data too long for column 'TEXT_' at row 1 
      java.sql.SQLDataException: (conn=1838) Data too long for column 'TEXT_' at row 1 
      java.sql.SQLException: Data too long for column 'TEXT_' at row 1 
      Query is: insert into ACT_HI_VARINST ( 
       ID_, 
       PROC_DEF_KEY_, 
       PROC_DEF_ID_, 
       ROOT_PROC_INST_ID_, 
       PROC_INST_ID_, 
       EXECUTION_ID_, 
       ACT_INST_ID_, 
       TENANT_ID_, 
       CASE_DEF_KEY_, 
       CASE_DEF_ID_, 
       CASE_INST_ID_, 
       CASE_EXECUTION_ID_, 
       TASK_ID_, 
       NAME_, 
       REV_, 
       VAR_TYPE_, 
       CREATE_TIME_, 
       REMOVAL_TIME_, 
       BYTEARRAY_ID_, 
       DOUBLE_, 
       LONG_, 
       TEXT_, 
       TEXT2_, 
       STATE_ 
       ) values (
      '8cb5b1d5-40fa-11e9-84c3-0299c2cb62ea', 
       'sdncAdapter', 
       'sdncAdapter:1:c90ce868-40e7-11e9-84c3-0299c2cb62ea', 
       '7c221218-40fa-11e9-84c3-0299c2cb62ea', 
       '89617d6f-40fa-11e9-84c3-0299c2cb62ea', 
       '89617d6f-40fa-11e9-84c3-0299c2cb62ea', 
       '89617d6f-40fa-11e9-84c3-0299c2cb62ea', 
       <null>, 
       <null>, 
       <null>, 
       <null>, 
       <null>, 
       <null>, 
       'sdncAdapterCallbackRequest', 
       0, 
       'string', 
       '2019-03-07 17:00:45.823', 
       <null>, 
       <null>, 
       <null>, 
       <null>... 
      '. Flush summary: 
       [ 
       INSERT HistoricVariableInstanceEntity[8cb5b1d5-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricJobLogEventEntity[8cb69c3d-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricJobLogEventEntity[8cb6c34f-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb58ac4-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb5b1d6-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb5b1d7-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb62708-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb64e1a-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb64e1b-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricVariableUpdateEventEntity[8cb6752c-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT HistoricActivityInstanceEventEntity[eEndEventSubprocess:8cb64e19-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT VariableInstanceEntity[8cb5b1d5-40fa-11e9-84c3-0299c2cb62ea] 
       INSERT MessageEntity[8cb6c34e-40fa-11e9-84c3-0299c2cb62ea] 
       DELETE EventSubscriptionEntity[8969e22f-40fa-11e9-84c3-0299c2cb62ea] 
       DELETE TimerEntity[8969bb18-40fa-11e9-84c3-0299c2cb62ea] 
       UPDATE VariableInstanceEntity[89617d71-40fa-11e9-84c3-0299c2cb62ea] 
       UPDATE VariableInstanceEntity[896415ac-40fa-11e9-84c3-0299c2cb62ea] 
       UPDATE ExecutionEntity[89617d6f-40fa-11e9-84c3-0299c2cb62ea] 
       DELETE ExecutionEntity[8969e22e-40fa-11e9-84c3-0299c2cb62ea] 
       DELETE ExecutionEntity[89696cf6-40fa-11e9-84c3-0299c2cb62ea] 
       UPDATE HistoricActivityInstanceEventEntity[IntermediateCatchEvent:8969e230-40fa-11e9-84c3-0299c2cb62ea] 
       UPDATE HistoricActivityInstanceEventEntity[SubProcess:89696cf7-40fa-11e9-84c3-0299c2cb62ea] 
      ]
      

       

       

        1. BPMN.debug.log
          4.26 MB
        2. bpmn-debug.log
          1.60 MB

            stevesmokowski stevesmokowski
            xuyang11 xuyang11
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: