Copied to clipboard

Flag this post as spam?

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


  • Craig100 1006 posts 2204 karma points c-trib
    Feb 19, 2015 @ 11:31
    Craig100
    0

    SQL Azure compatibility

    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
  • Richard Soeteman 3722 posts 11521 karma points MVP
    Feb 19, 2015 @ 11:58
    Richard Soeteman
    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

  • Craig100 1006 posts 2204 karma points c-trib
    Feb 19, 2015 @ 23:53
    Craig100
    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

  • Craig100 1006 posts 2204 karma points c-trib
    Mar 01, 2015 @ 02:23
    Craig100
    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

  • Richard Soeteman 3722 posts 11521 karma points MVP
    Mar 02, 2015 @ 07:41
    Richard Soeteman
    0

    Hi Craig,

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

    Hope this helps,

    Richard

  • Craig100 1006 posts 2204 karma points c-trib
    Mar 02, 2015 @ 11:49
    Craig100
    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

  • Mike Royle 38 posts 99 karma points
    Jul 17, 2015 @ 14:10
    Mike Royle
    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.

  • Craig100 1006 posts 2204 karma points c-trib
    Jul 17, 2015 @ 14:37
    Craig100
    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

  • Mike Royle 38 posts 99 karma points
    Jul 17, 2015 @ 15:46
    Mike Royle
    0

    Thanks Craig,

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

  • Ben Norman 167 posts 275 karma points
    Mar 23, 2016 @ 06:51
    Ben Norman
    0

    Run the following SQL Statement to fix it.

    ALTER TABLE dbo.UFUserSecurity ADD CONSTRAINT
        PK_UFUserSecurity PRIMARY KEY CLUSTERED 
        (
        [User]
        ) ON [PRIMARY]
    GO
    
  • René Pjengaard 114 posts 674 karma points c-trib
    May 24, 2016 @ 09:18
    René Pjengaard
    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);
    
  • Richard Soeteman 3722 posts 11521 karma points MVP
    May 24, 2016 @ 09:21
    Richard Soeteman
    0

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

Please Sign in or register to post replies

Write your reply to:

Draft