Error Get Next Item in Work Queue
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-10-18 12:18 AM
Hi all,
Hope your're doing well
I have an issue regarding Work Queues. When I use the action "Get Next Item" I'm getting the following error:
"Internal: error 547, level 16, state 1, procedure -, line 17, message: the INSERT statement conflicted withthe FOREIGN KEY constraint 'FK_CaseLock_Session'. The conflic occurred in database "DB_NAME", table "dbo.BPASession", column 'sessionid'"
Any ideas about solve this?
Thanks and regards
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-10-18 04:33 PM
Could be that the total number of work queue items is making the DB very full. Try deleting old items - you can do this manually via contol room or you can create a simple process that uses the WQ object.
