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

AshishKM
Kilo Patron
Kilo Patron

Hi @ShavkatM , 

If the tables are working good, and system showing this GIPK error while creating the new table without primary key, and system automatically generates a primary key for the table when this feature [sql_generate_invisible_primary_key]  is enabled.  

 

-Thannks,

AshishKM


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

This worked for me. When i selected Auto number and save it. the error has not appeared. thankyou for clarifying!!.

Vishal Jaswal
Giga Sage

Hello @ShavkatM 

I was able to reproduce this issue by not making any change rather just creating a Table (System Definition > Tables)

vishal_jaswal_0-1741114315226.png
So, I opened System Definition > Tables & Columns and then click the Create Table button/tab (extreme top left corner) and created one dummy table. Now, since this I am using the above way to create Table (System Definition > Tables) and the error message stopped.

 


Hope that helps!

Vishal Jaswal
Giga Sage

Hello @ShavkatM 

I tried below in Background script and since then I haven't faced this issue:

gs.invalidateCache();

VishalJaswal_0-1742491454934.png

 


Hope that helps!