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)
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”.
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.