Processing CreateBPAWorkQueueItem has failed System.InvalidOperationException: Sequence contains no matching element

[TimTreharne]

When attempting to approve a submission in interact the message fails to upload to the queue. When looking in the IADA logs I can see the following error:

2021/04/15 09:38:53.873]ERROR THT.WindowsIada.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed

System.InvalidOperationException: Sequence contains no matching element

   at System.Linq.ThrowHelper.ThrowNoMatchException()

   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)

   at THT.IadaLogic.DataAccess.Repository.GetConnectionString(String environmentName)

   at THT.IadaLogic.DataAccess.Repository.GetWorkQueueByName(String name, String environmentName)

   at THT.IadaLogic.BusinessLogic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model)

   at THT.WindowsIada.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage) in C:\agent\_work\224\s\THT.WindowsIada\THT.WindowsIada\Handlers\IadaQueueMessageHandler.cs:line 36

Has anybody seen this error before and know of a fix ?

Thanks
Tim.

------------------------------
Tim Treharne
Platforms
Capgemini
Europe/London
------------------------------

[joefarr]

Hi Tim

Please could you contact support@blueprism.com for help with this issue?

Thanks

------------------------------
Joe Farr
Product Consultant
Blue Prism Limited
------------------------------

[ramprasad.gajula]

Hi All,

I am facing the error after submit the form in Interact.

[14:18:00.4930] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:18:15.1227] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:18:15.1580] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:18:15.2030] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:18:15.2222] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:22:46.7799] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:45:40.7723] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)
[14:46:06.6775] BPC.Iada.Web.Handlers.IadaQueueMessageHandler - Processing CreateBPAWorkQueueItem has failed
System.ArgumentException: Environment name is wrong. No environments were found in the database with name 'BPConnection' =>> at BPC.Iada.Logic.Services.EnvironmentService.Get(String environmentName) =>> at BPC.Iada.Logic.Services.EnvironmentServiceCache.Get(String environmentName) =>> at BPC.Iada.Data.Repositories.RpaDatabaseConnectionFactory.Create(String environmentName, Boolean needColumnEncryption) =>> at BPC.Iada.Data.Repositories.Repository.GetWorkQueueByName(String name, String environmentName) =>> at BPC.Iada.Logic.Services.IadaService.CreateWorkQueueItem(AddToQueueModel model, String keyValue) =>> at BPC.Iada.Web.Handlers.IadaQueueMessageHandler.Handle(ConsumerMessage consumerMessage)


Can you help me to resolve the issue.

------------------------------
Ram Prasad Gajula
Software engineer
EY
Bangalore
+919704497828
------------------------------

[joefarr]

Hi Ram

This may be one you need to contact support@blueprism.com to resolve, but you may want to check a couple of that you have the correct database set up. You can find this in Hub>Settings>Environment Management:

------------------------------
Joe Farr
Product Consultant
Blue Prism Limited
------------------------------