Can't deploy model: Value too long for column "RESOURCE_ VARCHAR(255)"

Camunda 8 Topics Discussion & Questions
1

Hello. I can’t deploy a model because this error:

Value too long for column "RESOURCE_ VARCHAR(255)": "STRINGDECODE('<?xml version=\""1.0\"" encoding=\""UTF-8\""?>\n<bpmn:definitions xmlns:bpmn=\""http://www.omg.org/spec/BPMN/20100524/M... (8462)"; SQL statement:

INSERT INTO WORKFLOW (ID_, KEY_, BPMN_PROCESS_ID_, VERSION_, RESOURCE_, TIMESTAMP_) VALUES ('31a36382-40a4-4731-abc0-efa79c4cb284', 3270132, 'MainDocumentProcess', 6, '<?xml version="1.0" encoding="UTF-8"?>

<bpmn:definitions xmlns:bpmn="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:dc="http://www.omg.org/spec/DD/20100524/DC" xmlns:zeebe="http://camunda.org/schema/zeebe/1.0" id="Definitions_0wszq4u" targetNamespace="http://bpmn.io/schema/bpmn" exporter="Zeebe Modeler" exporterVersion="0.3.0">

Is this an error?
versions:

Zeebe-Client: (v0.14.0)
17:23:40.812 [] [main] INFO  io.zeebe.broker.system - Version: 0.14.0
2

Hi @slava.aleferov,

this issue is caused by the Zeebe Simple Monitor exporter - see the related issue.

We should fix it by increasing the column size and change the type to CLOB.

Best regards,
Philipp

3

I see, thanks!

4

Quick question: Did you change the database (connection) of the simple monitor? Do you run it into Docker?

I can’t reprocess this issue locally. It seems that only few people run into this.

5

I didn’t change the database before, but I change RESOURCE_ type to VARCHAR2 now and it’s work.
And I don’t run it into Docker. I can attach the model, or do anything else.

6