question 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 in ServiceNow AI Platform forum

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 — Fri, 26 Aug 2022 12:36:23 GMT

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?

Re: 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

Aman Kumar S — Fri, 26 Aug 2022 12:47:22 GMT

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.