Syntax Error or Access Rule Violation detected by database

[snowtech1]

Hello,

Had this error message on a list view, during filter by keywords and state on kb_knowledge.

''Syntax Error or Access Rule Violation detected by database (Table 'xyz_1.ts_c_26_TS_MARKER' doesn't exist)''

Log statement:

FAILED TRYING TO EXECUTE ON CONNECTION 13: SELECT count(distinct(ts_document0.number)) AS recordcount FROM ((kb_knowledge kb_knowledge0 INNER JOIN ts_document ts_document0 ON kb_knowledge0.`sys_id` = ts_document0.`document_id` ) INNER JOIN ts_c_26_TS_MARKER ts_c_26_TS_MARKER0 ON ts_document0.`number` = ts_c_26_TS_MARKER0.`document_number` ) WHERE kb_knowledge0.`workflow_state` = 'published' AND 0 = 1

Syntax Error or Access Rule Violation detected by database (Table 'xyz_1.ts_c_26_TS_MARKER' doesn't exist)

: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION 13: SELECT count(distinct(ts_document0.number)) AS recordcount FROM ((kb_knowledge kb_knowledge0 INNER JOIN ts_document ts_document0 ON kb_knowledge0.`sys_id` = ts_document0.`document_id` ) INNER JOIN ts_c_26_TS_MARKER ts_c_26_TS_MARKER0 ON ts_document0.`number` = ts_c_26_TS_MARKER0.`document_number` ) WHERE kb_knowledge0.`workflow_state` = 'published' AND 0 = 1

Syntax Error or Access Rule Violation detected by database (Table 'xyzw_1.ts_c_26_TS_MARKER' doesn't exist)

: com.glide.db.DBIError.wrapAndThrow(DBIError.java:105)

com.glide.db.DBIError.handleException(DBIError.java:66)

com.glide.db.DBI.executeStatement(DBI.java:798)

com.glide.db.DBI.executeStatement(DBI.java:766)

com.glide.db.DBQuery.executeAsResultSet0(DBQuery.java:291)

com.glide.db.DBQuery.executeAsResultSet0(DBQuery.java:266)

com.glide.db.DBQuery.executeAsResultSet(DBQuery.java:219)

com.glide.db.access.DBTable.query(DBTable.java:92)

com.glide.db.DBAggregateUtil.count(DBAggregateUtil.java:209)

com.glide.script.GlideAggregate.getTotalRecordCount(GlideAggregate.java:840)

com.glide.script.GlideAggregate.getTotalFromAggregates(GlideAggregate.java:684)

com.glide.list_v2.ListRecordGroupedTag.setGrandTotalRows(ListRecordGroupedTag.java:149)

com.glide.list_v2.ListRecordGroupedTag.setRowCounts(ListRecordGroupedTag.java:145)

com.glide.list_v2.ListRecordDefaultTag.doTag(ListRecordDefaultTag.java:83)

org.apache.commons.jelly.impl.TagScript.run(TagScript.java:299)

org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146)

org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:232)

org.apache.commons.jelly.impl.StaticTag.doTag(StaticTag.java:111)

org.apache.commons.jelly.impl.StaticTagScript.run(StaticTagScript.java:94)

org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146)

org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:232)

org.apache.commons.jelly.impl.StaticTag.doTag(StaticTag.java:111)

org.apache.commons.jelly.impl.StaticTagScript.run(StaticTagScript.java:94)

org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146)

org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:232)

org.apache.commons.jelly.impl.StaticTag.doTag(StaticTag.java:111)

org.apache.commons.jelly.impl.StaticTagScript.run(StaticTagScript.java:94)

org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146)

org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:232)

org.apache.commons.jelly.tags.core.JellyTag.doTag(JellyTag.java:84)

org.apache.commons.jelly.impl.TagScript.run(TagScript.java:299)

com.glide.ui.jelly.GlideJellyContext.run(GlideJellyContext.java:600)

com.glide.ui.jelly.GlideJellyContext.executeCompiledScript(GlideJellyContext.java:802)

com.glide.ui.jelly.GlideJellyContext.runScript(GlideJellyContext.java:664)

com.glide.ui.jelly.GlideJellyContext.runScript(GlideJellyContext.java:622)

com.glide.ui.GlideFormPhase2.generate(GlideFormPhase2.java:49)

com.glide.ui.GlideForm.generatePopulatedForm(GlideForm.java:637)

com.glide.ui.GlideForm.generatePopulatedForm(GlideForm.java:623)

com.glide.ui.GlideForm.populateForm(GlideForm.java:617)

com.glide.ui.GlideForm.getRenderedPage(GlideForm.java:190)

com.glide.ui.NavigationTransaction.writeOutput(NavigationTransaction.java:156)

com.glide.ui.NavigationTransaction.process(NavigationTransaction.java:127)

com.glide.ui.GlideServletUITransaction.process(GlideServletUITransaction.java:85)

com.glide.processors.Processor.runProcessor(Processor.java:413)

com.glide.processors.Processor.processTransaction(Processor.java:203)

com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:146)

com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:36)

com.glide.ui.GlideServlet$1.run(GlideServlet.java:414)

java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

java.lang.Thread.run(Thread.java:682)

Does anyone know what this is?

Thanks in advance.

[sergiu_panaite]

Is the error reproducible?

There should be no tables in the instance under the form "ts_c_26_TS_MARKER", but "ts_c_26_X" where X can be in the range (0..9). If it was a one time off, I assume it was a cache issue, if it can be reproduced on demand, I would suggest an incident with ServiceNow support.

Regards,

[snowtech1]

Thank you for the reply.

It was reproducible only on that day.

Must have been a cache issue.

[Joe Dames]

I had the same issue that seems to have been caused by a reference field dictionary record that referenced the Task table. It seems that the reference choice lookup was formatting the value for the Task table as 'Task' with a capital 'T'; in a case-sensitive query, that table is not found! Submitted a HI ticket to resolve it.

[snowtech1]

Thank you for the reply.

Could you please elaborate more on the reference choice lookup.

Are we talking about the entries on the 'sys_dictionary' table?