Syntax Error or Access Rule Violation detected by database (Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs) Syntax Error or Access Rule Violation detect

[Shivam Alaspur1]

java.sql.SQLException: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION glide.30 (connpid=1592451): ALTER TABLE tmp_x993993595t ADD `u_sp_vlp_flag` VARCHAR(40) /* raiprod015, gs:glide.scheduler.worker.5, tx:90d061d4472d99503f019573636d43d7 */ 
Syntax Error or Access Rule Violation detected by database ((conn=1592451) Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs). 

Do we have any Solution rather then raising a higher priority ticket?

[Aman Kumar S]

Hi @Shivam Alaspure ,

Refer to below link for similar requirement:

Syntax Error or Access Rule Violation detected by databas

Row size too large (> 8126) - Working with string heavy requirements

Feel free to mark correct, if your issue has been resolved, so it ends up in solved queue.

Will be helpful for others looking for the similar query.