SQL error when creating a new table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2025 10:21 AM
When creating a new table I am getting this error: "Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2025 10:32 AM - edited 03-04-2025 10:32 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2025 02:17 PM
This worked for me. When i selected Auto number and save it. the error has not appeared. thankyou for clarifying!!.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2025 10:55 AM
Hello @ShavkatM
I was able to reproduce this issue by not making any change rather just creating a Table (System Definition > Tables)
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2025 10:24 AM - edited 03-20-2025 10:25 AM
Hello @ShavkatM
I tried below in Background script and since then I haven't faced this issue:
gs.invalidateCache();
Hope that helps!