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

[JennyBell]

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?

[TomoyaN]

Hi,
I also got the same message. 

The version is  glide-xanadu-07-02-2024__patch7a-03-19-2025.

[Maheshwari Mano]

yes same error for me in glide-xanadu-07-02-2024__patch7a-03-19-2025

[MahalakshmiB930]

Hi , 

while creating a new table i got an error message saying " (conn=509466) Unknown system variable 'sql_generate_invisible_primary_key' " ! Is that ok to ignore that error or do we need to fix something before deploying ?? Any response is much appreciated!!

[Maheshwari Mano]

Hi @MahalakshmiB930 ,

Please try to do a patch upgrade to Xanadu Patch 9 and Yokohama Patch 4.

Thanks,

Maheshwari