Advanced Work Assignment not Working. Work Item State is Queued

[Rohit Singh]

I have created a Channel, Queues, Assignment Eligibility and then mapped with Assignment Rules (Most Capacity) in incident table. I have just checked for auto assignment. However my incidents are not being assigned to the group and assigned to. Under work item the state is Queued. The queue name is correctly showing for my incident but not getting auto assigned as per the capacity. Please refer the snip for Work Item. 

Please help in fixing the issue.

[charles2024]

Stuck one this also. 

[nick442]

We had this issue. ServiceNow support ended up having to run a script to fix this

Below is from our ticket:

Thank you very much for your time on the call. We see that there is no database view available for the request item service channel, which can cause the expected behavior to fail.
That said, it is possible to run a background script in the instance to check & confirm if there are any issues with this, and, if any are found, the issues will also be corrected by the script.
The script checks the database view table (sys_db_view) for the problematic service channel and inserts a new record if missing.
Additionally, it will check the where_clause and variable_prefix values on the database view record and correct them.
If possible, I would like to test this by running this script to correct any issues, if they are present. Once the script has been executed, I will test and confirm the behavior again.
In order to run this, though, I will need to create a change request for the test instance.