SQL Error when creating a new table: Unknown system variable 'sql_generate_invisible_primary_key'"

JennyBell
Tera Contributor

Hello!

Currently on Yokohama Patch 1 (did not experience this issue in Washington - we skipped Xanadu)

 

When creating a new table I am getting this error: "Error Message

(conn=14409691) Unknown system variable 'sql_generate_invisible_primary_key'"
 
Each time I create a table I get an error. Table creates, but this is super annoying.   I've tried using scoped applications and Global. I've tested creating tables in Edge (preferred) and Chrome - nothing has resolved this error.
 
Troubleshooting completed: I've reviewed and tested the solutions in this thread, but nothing worked. Article data 3/2025   SQL error when creating a new table - ServiceNow Community
 
Any thoughts?
5 REPLIES 5

Richard Zheng
ServiceNow Employee
ServiceNow Employee

Can confirm this issue has been fixed in Xanadu Patch 9, Yokohama Patch 4 and Zurich onward.