SQL error when creating a new table

ShavkatM
Tera Contributor

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

(conn=74767) Unknown system variable 'sql_generate_invisible_primary_key'"
 
The table seems to be working fine. But it happens every time when new table is created. It is scoped applications. The instance is updated to Xanadu, I've tested in Edge and Chrome. 
 
6 REPLIES 6

This worked for me. I just had to do it in Global instead of in my scoped application, but I haven't seen the error since running this background script - so thanks! 🙂

Richard Zheng
ServiceNow Employee
ServiceNow Employee

Reposting same answer from the more recent community post:

https://www.servicenow.com/community/upgrades-and-patching-forum/sql-error-when-creating-a-new-table...

 

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