Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Just getting to grips with Azure storage to put a locally developed umb V7.2.1 site up on Azure. Using the Export Date-tier Application in MS SQL Server Management Studio to create a BACPAC file to export to Azure Storage (to then hopefully restore the DB) I get an error on the first stage "Exporting databse" saying:-
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Table Table: [dbo].[SEOChecker_Robots] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Error SQL71564: Table Table: [dbo].[UFUserSecurity] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.
Installing on SQL azure directly will work, but this table is not used in this version yet so you can also delete it.
Umbraco as a service is a different story since deployement is handled differently.
Hope deleting the table works for you for now.
I deleted the table as advised. However, I have an empty UmbracoForms table throwing the same error so have just asked the Forms team if it can be excluded safely : https://our.umbraco.org/forum/umbraco-pro/contour/61535-SQL-Azure-compatibility-Forms
It now seems I have to have the SEOChecker_Robots table or I get SEO_Checker issues in the trace logs. So the question is, Can I just create a clustered index on the table manually with MSSSMS and if so, what do I call the index (the dialogue asks for one)?
Yes you can add it and I don't think the name matters.
Hope this helps,
Thanks Richard, I'll try it. Just waiting now for a response to a similar question from the UmbracoForms guys then I can try again:)
How did you get on with the UmbracoForms table? I'm just working through the same issue and hoping I can just create a clustered index on UFUserSecurity.
I just created a clustered index on the table in the SQL Management Studio. All went well after that. I must say Azure has been a major PITA and I'm kind of regretting using it now. My beefs mainly relate to not being able to restore a DB without creating a whole new one. Makes you wonder what MS were thinking.
I agree - I just had to create a new database. Trying to find a better way to manage this...
Run the following SQL Statement to fix it.
ALTER TABLE dbo.UFUserSecurity ADD CONSTRAINT
PK_UFUserSecurity PRIMARY KEY CLUSTERED
) ON [PRIMARY]
I know this is an old thread, but the solution is to create a clustered index for the table (as Craig ended up doing).
CREATE CLUSTERED INDEX SEOChecker_Robots_Index ON SEOChecker_Robots (NodeId);
Next version will have an Azure specific installer script, that will fix it for once and for all.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted