an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > DotShoppingCart Suite > New orders being put on hold and an error about...
Last Post 9/3/2015 1:14:41 PM By lukezy. 2 replies.
9/1/2015 9:54:08 AM
blmtechnologies
Posts: 3
Joined: 8/18/2015
New orders being put on hold and an error about email
Luke,
 
We are getting the following error when we receive a new order.
 
Please advise.
 
Order Processor (OrderConfirmationEmail) failed due to Cannot find the specified user 'owner'. Cannot find the queue 'SqlQueryNotificationService-fa54e3c2-6ba9-478a-8d21-ed63924eafb5', because it does not exist or you do not have permission. Cannot find the service 'SqlQueryNotificationService-fa54e3c2-6ba9-478a-8d21-ed63924eafb5', because it does not exist or you do not have permission. Invalid object name 'SqlQueryNotificationService-fa54e3c2-6ba9-478a-8d21-ed63924eafb5'.. [Delayed - Order Under Review]
 
9/2/2015 9:14:24 AM
blmtechnologies
Posts: 3
Joined: 8/18/2015
Re: New orders being put on hold and an error about email
Ok, I got the errros fixed.
Turns out I have the Service Broker queue with the incorrect Schema. IAs a temporary fix I made the Ecomm user an owner so things are working in general, menaing I am no longer getting any errors.
 
However, now when an order is put into Received, 'Sending order confirmation email'   the Order status info on the main page shows Sneding order complete but an email never acutally is sent.
 
I have several other carts that are working fine.
 
Any ideas?     
9/3/2015 1:14:41 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: New orders being put on hold and an error about email
Take a look at orderpipeline service. Make sure it's ronning and have correctly connection string.
DotShoppingCart Staff