How to add more than 4000 characters

Camunda 7 Topics Discussion & Questions
1

Hi, i want to know how to add more than 4000 characters in camunda fields?

My problem is the next

java.lang.ClassCastException: org.camunda.spin.impl.json.jackson.JacksonJsonNode cannot be cast to java.lang.String
java.lang.ClassCastException: org.camunda.spin.impl.json.jackson.JacksonJsonNode cannot be cast to java.lang.String

ENGINE-16004 Exception while closing command context: ENGINE-03083 Exception while executing Batch Database Operations with message ’

Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricDetailEntity.insertHistoricVariableUpdateEvent (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 1 insert into ACT_HI_DETAIL

(
  ID_,
  TYPE_,
  PROC_DEF_KEY_,
  PROC_DEF_ID_,
  PROC_INST_ID_,
  EXECUTION_ID_,
  ACT_INST_ID_,
  CASE_DEF_KEY_,
  CASE_DEF_ID_,
  CASE_INST_ID_,
  CASE_EXECUTION_ID_,
  TASK_ID_,
  NAME_,
  REV_,
  VAR_INST_ID_,
  VAR_TYPE_,
  TIME_,
  BYTEARRAY_ID_,
  DOUBLE_,
  LONG_,
  TEXT_,
  TEXT2_,
  SEQUENCE_COUNTER_,
  TENANT_ID_,
  OPERATION_ID_
)
values (
  '977036ab-2044-11ea-ab5c-00155d051a02',
  'VariableUpdate',
  'Ordercase',
  'Ordercase:30:4563d725-2043-11ea-bc60-00155d051a02',
  '97700f96-2044-11ea-ab5c-00155d051a02',
  '97700f96-2044-11ea-ab5c-00155d051a02',
  'StartEvent_1:977036a9-2044-11ea-ab5c-00155d051a02',
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  'Cliente',
  0,
  '977036a8-2044-11ea-ab5c-00155d051a02',
  'string',
  '2019-12-16 12:42:35.880000-08'::timestamp,
  NULL,
  NULL,
  NULL,
  '{"accion": "ALTA", "numeroAtencion": "", "compania": "1", "infoCliente": { "telefono": "", "referencia": "8830365-2", "nombre": "Rox", "apellidoPaterno": "MARTINEZ", "apellidoMaterno": " ", "sexo": "", "edad": "", "email": "helgasp@hotmail.com", "claveCategoria": "norm", "fechaAlta": "20191204145354", "razonSocial": "", "tipoDeCliente": "PERSONA", "claveTipoCliente": "1", "iwIdEmpresa": "119" }, "cuentas": { "accion": "ALTA", "idCuenta": "", "fechaUltFact": "", "alias": "CTA PRINCIPA", "nombreFantasia": "", "refCta": "13294345", "cicloFac": "2", "diaInicioPer": "1", "giro": "", "cveGiroCte": "", "formaDePago": { "envio": "WEB", "cveEnvio": "4", "emailEnvio": "", "faxEnvio": "", "tipoDocumento": "BOLETA", "cveTipoDocumento": "B", "formaCobranza": "", "titularTarjeta": "", "tipoTarjeta": "", "numeroTarjeta": "", "fechaVencimiento": "", "nombreCasaComercial": "", "cveCasaComercial": "", "tarjetaComercial": "", "titularCuenta": "", "cuenta": "", "nombreBanco": "", "referenciaTitular": "" }, "domicilioDeFacturacion": { "sam": "0", "subnumero": "", "claveRegion": "", "claveComuna": "", "observaciones": "", "localidad": "" }, "domicilioDeEnvio": { "sam": "0", "subnumero": "", "claveRegion": "", "claveComuna": "", "observaciones": "", "localidad": "" }, "domicilioDeInstalacion": { "accion": "ALTA", "referenciadi": "13294347", "contactos": { "contacto": { "parentesco": "TIT", "nombre": "ELBA LUISA", "apellidoPaterno": "MARTINEZ", "apellidoMaterno": "OJEDA", "email": "helgasp@hotmail.com", "telefonoCasa": "", "telefonoCelular": "", "telefonoOficina": "" } }, "domicilio": { "sam": "163005", "subnumero": "", "claveRegion": "RMS", "region": "REGION METROPOLITANA DE SANTIAGO", "claveProvincia": "STG", "provincia": "SANTIAGO", "claveComuna": "PAG", "comuna": "PEDRO AGUIRRE CERDA", "tipoCalle": "CALLE", "claveTipoCalle": "CLL", "calle": "LAZO", "numero": "2711", "claveAgrupador": "CASA", "tipoAgrupador": "CASA", "tipoIdentificador": "CASA", "claveIdentificador": "CASA", "numeroIdentificador": "1", "hub": "ECT", "nodo": "PAC008", "observaciones": "", "localidad": "" }, "contratos": { "accion": "ALTA", "idContrato": "88303650001", "refContrato": "13294349", "fechaAlta": "2019-12-04", "datosVenta": { "noOrden": "23611698", "idMov": "1", "tipiMov": "1", "claveTipoVenta": "2", "tipoVenta": "TERRENO", "claveAgente": "00004278T1", "vendedor": "VENTA DIRECTA", "claveVendedor": "00004278T1", "fechaMov": "2019-12-04" }, "agendacion": { "claveTipoInstalacion": "N", "fechaEntrega": "05122019", "horaEntrega": "16:00-19:00", "anio": "2019", "mes": "12", "dia": "05", "hora": "16:00-19:00", "min": "00", "observaciones": "", "muestraAgendacion": "", "inst": "Instalacion", "cveHoraEnt": "16-19", "nomContacto": "ELBA LUISA MARTINEZ OJEDA", "telCotnacto": "941153713", "tiempoPromInst": "", "cveAliado": "", "cveTecnico": "11003118T1" }, "combos": { "tecnologia": "HFC", "sku": "1013824", "clave": "1ph1119_02", "grupo": "com_op", "descripcion": "1-Play Hogar BA 50 Mbps WiFi", "accion": "ALTA", "servicio": { "plataforma": "SAC", "tecnologia": "HFC", "tipo": "INT", "servicioPpal": { "servicioBase": { "sku": "1013824", "ticket": "4", "clave": "bah1119_01", "grupo": "int_baan", "descripcion": "Internet 50 Mbps", "accion": "ALTA", "nombre": "Internet 50 Mbps", "datosTecnicos": { "aprovisiona": "S", "tipoEquipoAprov": "Deco", "tipoServicio": "adicional", "tipoApro": "servicio", "tipoAdi": "bolsamin", "idVenta": "0", "idVentaPadre": "0", "idServicio": "1", "idServicioPadre": "0", "idProducto": "236116983004", "idProductoPadre": "0", "cveTipoTel": "", "telsolAnt": "", "tipoFlujo": "datos", "tipoEquipo": "deco", "paqServici": "DOCSIS3_50_5_NAT", "iwisp": "cpe", "iwispmta": "mta", "iwtagcm": "cm", "nombre": "", "iwbandpaq": "", "iwprepago": "", "iwdsfreq": "", "iwcmsid": "safari-lab", "iwprofcrid": "mta-default", "iwhostname": "", "iwispmtacr": "mta", "iwprfcrmid": "EP-Maipu-1", "iwhoexcrid": "TL_200M", "iwfeacrmid": "CfCW", "iwctrcrmid": "DAC6000", "iwdfpdcrid": "TV_BASE", "iwdfcfcrid": "Default", "iwppvstbal": "0", "iwppvbabal": "0", "iwchamap": "BASICO", "iwprocrmid": "TV_PR01", "iwdpipack": "DOCSIS3_50_5_NAT", "iwtagid": "", "iwservicepackage": "1000", "iwservorg": "1000", "fjPorta": "vozprt", "modalidad": "", "fecBajpro": "", "desTipoFlu": "datos: Activacion Banda", "gpoTipoFlu": "catdattec", "tobTipoflu": "catalogo", "desTipoEqu": "Deco", "gpoTipoEqu": "cattipequi", "tobTipoEqu": "catalogo", "desTipoiwp": "TV_PR01: Movie City", "gpoTipoiwp": "catpaqadtv", "tobTipoiwp": "catalogo", "tipodeco": "DCT", "callfeatCode": "" }, "fechaAlta": "2019-12-04" } } }, "equipos": { "equipo": { "accion": "ALTA", "tipoEquipo": "CM", "modelo": "CGA0101", "tipoServicio": "INT", "macAddress": "5C76959A0886", "servicio": { "plataforma": "SAC", "servicioBase": { "sku": "1013824", "ticket": "4", "clave": "bah1119_01", "grupo": "int_baan", "descripcion": "Internet 50 Mbps", "accion": "ALTA", "nombre": "Internet 50 Mbps", "datosTecnicos": { "aprovisiona": "S", "tipoEquipoAprov": "Deco", "tipoServicio": "adicional", "tipoApro": "servicio", "tipoAdi": "bolsamin", "idVenta": "0", "idVentaPadre": "0", "idServicio": "1", "idServicioPadre": "0", "idProducto": "236116983004", "idProductoPadre": "0", "cveTipoTel": "", "telsolAnt": "", "tipoFlujo": "datos", "tipoEquipo": "deco", "paqServici": "DOCSIS3_50_5_NAT", "iwisp": "cpe", "iwispmta": "mta", "iwtagcm": "cm", "nombre": "", "iwbandpaq": "", "iwprepago": "", "iwdsfreq": "", "iwcmsid": "safari-lab", "iwprofcrid": "mta-default", "iwhostname": "", "iwispmtacr": "mta", "iwprfcrmid": "EP-Maipu-1", "iwhoexcrid": "TL_200M", "iwfeacrmid": "CfCW", "iwctrcrmid": "DAC6000", "iwdfpdcrid": "TV_BASE", "iwdfcfcrid": "Default", "iwppvstbal": "0", "iwppvbabal": "0", "iwchamap": "BASICO", "iwprocrmid": "TV_PR01", "iwdpipack": "DOCSIS3_50_5_NAT", "iwtagid": "", "iwservicepackage": "1000", "iwservorg": "1000", "fjPorta": "vozprt", "modalidad": "", "fecBajpro": "", "desTipoFlu": "datos: Activacion Banda", "gpoTipoFlu": "catdattec", "tobTipoflu": "catalogo", "desTipoEqu": "Deco", "gpoTipoEqu": "cattipequi", "tobTipoEqu": "catalogo", "desTipoiwp": "TV_PR01: Movie City", "gpoTipoiwp": "catpaqadtv", "tobTipoiwp": "catalogo", "tipodeco": "DCT", "callfeatCode": "" }, "fechaAlta": "2019-12-04" } }, "actKey": "088303650423611698" } }, "productos": { "producto": { "ticket": "5", "clave": "prvtnho_03", "grupo": "promos", "descripcion": "143 - Descuento de $4000 X 6 Meses", "accion": "ALTA", "nombre": "143 - Descuento de $4000 X 6 Meses", "datosTecnicos": { "aprovisiona": "", "tipoEquipoAprov": "", "tipoServicio": "promo", "tipoApro": "importe", "tipoAdi": "", "idVenta": "0", "idVentaPadre": "0", "idServicio": "0", "idServicioPadre": "0", "idProducto": "0", "idProductoPadre": "0", "cveTipoTel": "", "telsolAnt": "", "tipoFlujo": "proret", "tipoEquipo": "", "paqServici": "IN_BW01", "iwisp": "cpe", "iwispmta": "mta", "iwtagcm": "cm", "nombre": "", "iwbandpaq": "", "iwprepago": "", "iwdsfreq": "", "iwcmsid": "safari-lab", "iwprofcrid": "mta-default", "iwhostname": "", "iwispmtacr": "mta", "iwprfcrmid": "EP-Maipu-1", "iwhoexcrid": "TL_200M", "iwfeacrmid": "CfCW", "iwctrcrmid": "DAC6000", "iwdfpdcrid": "TV_BASE", "iwdfcfcrid": "Default", "iwppvstbal": "0", "iwppvbabal": "0", "iwchamap": "BASICO", "iwprocrmid": "", "iwdpipack": "IN_BW01", "iwtagid": "", "iwservicepackage": "1000", "iwservorg": "1000", "fjPorta": "", "modalidad": "", "fecBajpro": "2020-06-04", "desTipoFlu": "proret: Alta Promocion Importe", "gpoTipoFlu": "catdattec", "tobTipoflu": "catalogo", "desTipoEqu": "", "gpoTipoEqu": "", "tobTipoEqu": "", "desTipoiwp": "Seleccionar...", "gpoTipoiwp": "catpaqadtv", "tobTipoiwp": "catalogo", "tipodeco": "", "callfeatCode": "" }, "fechaAlta": "2019-12-04" }}}}}}}',
  NULL,
  1,
  NULL,
  NULL
) was aborted: ERROR: value too long for type character varying(4000)  Call getNextException to see other errors in the batch.

Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricDetailEntity.insertHistoricVariableUpdateEvent (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 1 insert into ACT_HI_DETAIL

1 Like
2

That is a problem
but please give me some details
with proper context

1 Like
3

Hi @CRA,

you have to send your process variable as an Object to the engine, not as a String.

We can provide more details if you answers Nialls question.

Hope this helps, Ingo

4

hi @Ingo_Richtsmeier @Niall

So i am trying to store a response of api call
like this : connector.getVariable(“response”);

But when the response is greater than 4000 characters , as expected it’s throwing error.

Can you guide how i can store this as object and read it - as the response content will be json content.

5