Syntax Error or Access Rule Violation detected by database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2016 11:36 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2016 02:36 AM
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2016 08:47 AM
Thank you for the reply.
It was reproducible only on that day.
Must have been a cache issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2016 10:13 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2016 10:31 AM
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?