Getting error in Virtual Agent "Syntax Error or Access Rule Violation detected by database..."

Joan6
Tera Expert

 

We want to implement Virtual Agent but we are getting "Syntax Error or Access Rule Violation detected by database((conn=431755) Table 'xxxxx_1.Task' doesn't exist" this happens when trying to type and search in Virtual agent and AI Search flow will trigger

Joan6_2-1722846568632.png

We already raised this to Now Support initial suggestion was to clone down, we followed but after the installation of plugins without update sets deployed we got the same error occurred. 

Joan6_3-1722846782239.png

And it was detected as PRB1645117, and confirmed that there is no impact at this stage, only alert messages will get displayed. 

 

Joan6_5-1722847242442.png

 

Here is the Flow context where source table is Task table.  Anyone who got the same issue and continue to implement the Virtual Agent? Or do you have any workaround? It's been a month since we opened the ticket and we would like to use VA. Thanks. 

Joan6_6-1722847319549.png

 

 

 

 

1 REPLY 1

Shaqeel
Mega Sage

hi @Joan6 

 

This might help:

https://www.servicenow.com/community/developer-forum/syntax-error-or-access-rule-violation-detected-...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Shaqeel


***********************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful." This action benefits both the community and me.

***********************************************************************************************************************





Regards

Shaqeel