- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2025 05:35 AM
I have imported the data into the cmdb_ci_netgear table via excel file using the import sets and transform map.
Here, workflow is involved which automates the transformation of the data and inserts the data into specific table as per the selection of table by user from service catalog form.
But after attaching the file and selecting the table, the import set is also processed successfully but i m unable to access the table, the table is popping error:
"Syntax Error or Access Rule Violation detected by database ((conn=1639246) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'null WHERE cmdb0.`sys_class_path` LIKE '/!!/!2/!!%' ORDER BY cmdb0.`sys_updat...' at line 1) ".
Can you please help me to fix this issue and make the table back to normal.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2025 06:17 AM
The issue is resolved. it is actually some issue in Xanadu upgrade as it was sorted out by updated field. As soon as i removed the sorted by updated, it was back to normal. This issue will be fixed in Xanadu patch 4 update.
Thank you for your time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2025 06:42 AM
Please mark your own response as correct and close the thread.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader