Getting error while accessing the table on ServiceNow platform.

[RishabhPandey]

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.

[Ankur Bawiskar]

@RishabhPandey 

did you try loading data with only 10 rows?

what's the status of that import set when transformation is complete?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[RishabhPandey]

Hi @Ankur Bawiskar 

I have uploaded only with 2 rows for testing 

Status of import set is Processed.

[Ankur Bawiskar]

@RishabhPandey 

is that table completely empty?

If yes then what happens when you open that table list?

please share which all fields from excel are mapped and share screenshots of your transform map and field maps

[RishabhPandey · Accepted solution]

hi @Ankur Bawiskar 

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