Hi Saurabh,
Thanks. The resolution given to change the TLS version to 1.0 works and worker role is able to create the necessary stored procedures.
Will I be able to deploy this tool as cloud service (extended support) instead of cloud service (classic) which is going to be deprecated in Aug 2024?
Br,
Zaman
Split-merge tool error. MSDN resolution does not help
Hi,
We would want to move shardlets from one database to another and would like to use split-merge tool. We were able to successfully deploy the split-merge tool using cloud service (classic) as mentioned here: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-configure-deploy-split-and-merge
We are facing the following issue: [Exception] System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbo.InsertRequest'.
And the resolution you have provided in the same MSDN web page "In this case, check your configuration file, in particular the setting for WorkerRoleSynchronizationStorageAccountConnectionString. This error typically indicates that the worker role could not successfully initialize the metadata database on first use." does not work. I literally copy and paste the storage account connection string from Azure portal, so the connection string is not a problem.
Moreover, I see that the split-merge tool does not create any such stored procedure on start, nor can I find this stored procedure in the elastic scale library source code.
Can you please help?
At least can you please list the sequence of elastic scale client library method calls that we need to move a shardlet from one database to another.
-
Zaman Bakshi 101 Reputation points
2021-09-20T07:43:08.557+00:00
1 additional answer
Sort by: Most helpful
-
Saurabh Sharma 23,751 Reputation points Microsoft Employee
2021-08-18T22:52:50.043+00:00 Hi @Zaman Bakshi ,
Thanks for using Microsoft Q&A !!
You can find[dbo].[InsertRequest]
stored procedure in your Elastic Scale Metadata database which you have configured in theServiceConfiguration.cscfg
file under<Setting name="ElasticScaleMetadata"
settings. (Please find below the screenshot)ServiceConfiguration.cscfg
Config Database
Can you please check if your metadata database has the stored procedure created ?
I have tested in my environment using the steps mentioned in the document and I could see Shardlet Move has completed successfully for me.
Thanks
Saurabh