2

I have Azure VMs (Iaas) running Sitecore 9 Update 1 and am using Azure SQL as my backend. I deployed the xConnect Shards using the Shard Map Manager and it showed as successful. However, despite doing all the post steps of rebuilding links, indexes, and deploying marketing definitions without error, I keep getting the following error without data showing in Experience Analytics:

2018-07-03 14:19:14.811 -07:00 [Error] XConnect Exception Logger LogAsync() Sitecore.Xdb.Processing.Queue.ProcessingPoolException: Could not find stored procedure 'xdb_processing_pools.InteractionLiveProcessing_AddBatch'. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'xdb_processing_pools.InteractionLiveProcessing_AddBatch'.

Improve this question
3
  • 2
    I would start with obvious does xconnect have the correct connection strings for the processing pools db? Have you verified that your Processing.Pools database has a stored procedure called "xdb_processing_pools.InteractionLiveProcessing_AddBatch"?
    – JKerny
    Commented Jul 4, 2018 at 5:42
  • Can you check permissions for user which you have specified in ConnectionStrings.config? Probably this is "poolsuser". Check whether this user has Execute and Connect permissions for that database. Try to login through SSMS as this user to see what effective access it has.
    – Peter Procházka
    Commented Jul 4, 2018 at 9:21
  • Poolsuser has connect and execute, and the connectionStrings are correct. However, the stored procedures do look completely different than my on-prem build. I will investigate further.
    – Kode
    Commented Jul 5, 2018 at 14:14

1 Answer 1

Reset to default
1

The issue was the Pools database lacking the stored procedures. A re-import of the pools database bacpac to Azure SQL fixed the issue.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.