Too many columns for table

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
lineamovil
Posts: 201
Joined: Tue Jul 27, 2010 2:17 am
Location: Mexico

Too many columns for table

Post by lineamovil »

Hello! I have a Bussiness Object called "Invoice" and recently I had to add a lot of fields or columns because they were required.

When I try to publish I get this error:
Exception publishing business space version Aware IM Server encountered the following error. Error adding columns for table YYYYY Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storaga overhead, check the manual. You have to change some columns to TEXT or BLOBs.
Im usiong AwareIm Version 8.6 and MySQL 8.2, the computer is Windows Server 2019 and has 64GB RAM

Has anyone find a way to make it work without creating another table (business object)

Thank you for your help!


Image

image
https://ibb.co/vsDwy1V
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Too many columns for table

Post by PointsWell »

MySQL on InnoDb has a limit to table size
Although InnoDB supports row sizes larger than 65,535 bytes internally, MySQL itself imposes a row-size limit of 65,535 for the combined size of all columns. See Section 8.4.7, “Limits on Table Column Count and Row Size”.
lineamovil
Posts: 201
Joined: Tue Jul 27, 2010 2:17 am
Location: Mexico

Re: Too many columns for table

Post by lineamovil »

Thank you!
I understand that AwareIM only works on Innodb. Right?

Or the solution would be to change it to myisam? Would it affect a working application and the data stored?

Thank you for your advise
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Too many columns for table

Post by PointsWell »

I don't know the answer to that question. If it is truly n-tier compliant it shouldn't make a difference how MySQL is storing the data behind the RDBMS.

Might require you to test or reach out to Vlad.
chris__29
Posts: 20
Joined: Wed Dec 15, 2021 11:44 pm
Location: Australia

Re: Too many columns for table

Post by chris__29 »

In my.ini place the following in as the last line. We had this problem some time ago.

Code: Select all

innodb_strict_mode = 0
AwareIM 8.8
MySQL, MSSQL
MS Server
Australia
lineamovil
Posts: 201
Joined: Tue Jul 27, 2010 2:17 am
Location: Mexico

Re: Too many columns for table

Post by lineamovil »

Thank you so much! Real solution here.

thank you!
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
Post Reply