Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

#825059
Hi,
I have a big process having almost 500+ variables. I want to create a Report table for the same but If I try to add all variables into report table it throws error after 255 column saying "Max column size reached" So tried creating multiple report tables having up to 150+ columns each but then started throwing error saying "Row size too large"

Image

I have 87 columns (each with VARCHAR 255) and with 3 default columns but it is still throwing above error.
I don't know how it works but if I multiply 255*93 gives up to 23000 then Why it is throwing error for above 65535.

Please any solution its urgent
#825117
The table definition will have to be changed in the database so it can hold more information. I don't recall off the top of my head where this information is stored in the database. I will look at the database tomorrow and see if I can figure it out.
#825135
I can't find the database table where this information is stored. I recommend that you use two separate Report Tables to export the variables from the process.
#825139
That is what I'm doing I have 500+ variables so i decided lets make 4 tables with 100+ variables each but it is also throwing error for 90 variables so I'll have to make 6 report tables but that's gonna increase the maintenance and confusion for me.

Ok let's see
#825140
By the way 65535 is the max size of the varchar and text fields in MySQL, but I can't find a single field of that size in the ProcessMaker database schema, so it is really confusing where this is being stored.
At any rate, you should file a bug report about it at http://bugs.processmaker.com, because it can probably be fixed by changing the table definition, if we know which field needs to be changed.
#825154
It is not a single field which is causing this issue, It is the combined sum of all columns in a row.

But actually as I said in my first message i have 90 columns of 255 varchar so its only 23000 then why it is showing error for 65535 :(
#825158
rohitambre wrote:It is not a single field which is causing this issue, It is the combined sum of all columns in a row.

But actually as I said in my first message i have 90 columns of 255 varchar so its only 23000 then why it is showing error for 65535 :(
If this error appears when you try to save the definition of your Report Table, it is trying to serialize all the information about those 90 variables (not the values in the variables, but the properties that describe those variables) and write all that information to a single field in the database, which is why you get that error, because all that information is greater than 65535 bytes. If you have fewer variables in your Report Table it should work.

You need to file a bug report about this.
Amosbatto, PMUsers.com is down.

I get the same error message when trying to access[…]

Grid Attachment + Email Attachment

Hi, Please check this post: https://forum.process[…]

ID de Archivo en Grilla

Hi, You can use multipleFile in your grid, then se[…]

Problema Zona horaria

Hi, Change the timezone config in the "/opt/p[…]