sql azure compatibility

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Craig100 1136 posts 2523 karma points c-trib

Feb 19, 2015 @ 11:31
0

SQL Azure compatibility

Bugs
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.
 (Microsoft.SqlServer.Dac)
```
The database is an SQL Express 2012 DB.

I'm guessing this must be an issue for Umbraco as a Service as well?

Any advice would be appreciated as this is a show stopper.

Thanks,

Craig
Copy Link
Richard Soeteman 4035 posts 12842 karma points MVP

Feb 19, 2015 @ 11:58

0

Hi Craig,

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.

Best,

Richard

Copy Link
Craig100 1136 posts 2523 karma points c-trib

Feb 19, 2015 @ 23:53

0

Thanks Richard,

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

Rgds,

Craig

Copy Link
Craig100 1136 posts 2523 karma points c-trib

Mar 01, 2015 @ 02:23

0

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)?

Craig

Copy Link
Richard Soeteman 4035 posts 12842 karma points MVP

Mar 02, 2015 @ 07:41

0

Hi Craig,

Yes you can add it and I don't think the name matters.

Hope this helps,

Richard

Copy Link
Craig100 1136 posts 2523 karma points c-trib

Mar 02, 2015 @ 11:49

0

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:)

Craig

Copy Link
Mike Royle 38 posts 99 karma points

Jul 17, 2015 @ 14:10

0

Hi Craig,

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.

Copy Link
Craig100 1136 posts 2523 karma points c-trib

Jul 17, 2015 @ 14:37

0

Hi Mike,

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.

Good luck

Copy Link
Mike Royle 38 posts 99 karma points

Jul 17, 2015 @ 15:46

0

Thanks Craig,

I agree - I just had to create a new database. Trying to find a better way to manage this...

Copy Link
Ben Norman 167 posts 276 karma points

Mar 23, 2016 @ 06:51
0
Run the following SQL Statement to fix it.
```
ALTER TABLE dbo.UFUserSecurity ADD CONSTRAINT
    PK_UFUserSecurity PRIMARY KEY CLUSTERED 
    (
    [User]
    ) ON [PRIMARY]
GO
```
Copy Link
René Pjengaard 117 posts 700 karma points c-trib

May 24, 2016 @ 09:18
0
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);
```
Copy Link
Richard Soeteman 4035 posts 12842 karma points MVP

May 24, 2016 @ 09:21

0

Next version will have an Azure specific installer script, that will fix it for once and for all.

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?