arachnode.net
An Open Source C# web crawler with Lucene.NET search using SQL Server 2008/2012/2014/2016/CE An Open Source C# web crawler with Lucene.NET search using MongoDB/RavenDB/Hadoop
Search the Live Index Does arachnode.net scale? | Download the latest release

Deployment in Azure possible?

rated by 0 users
Not Answered This post has 0 verified answers | 2 Replies | 2 Followers

Top 500 Contributor
1 Posts
risto.matikainen posted on Thu, Jan 19 2017 9:05 AM

Arachnode deployment to Azure (v12) fails with the below text. So there is some functionality not supported in Azure. I wonder if this is a big part of Arachnode or something that could be dealt with?

"

Error SQL72014: .Net SqlClient Data Provider: Msg 40517, Level 16, State 1, Line 4 Keyword or statement option 'unsafe' is not supported in this version of SQL Server.

Error SQL72045: Script execution error.  The executed script:

CREATE ASSEMBLY [Arachnode.Functions]

    AUTHORIZATION [dbo]

    FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300C1D957580000000000000000E00002210B010B0000E200000006000000000000DE010100002000000020010000000010002000000002000004000000000000000400000000000000006001000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000880101005300000000200100B003000000000000000000000000000000000000004001000C000000500001001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000E4E100000020000000E2000000020000000000000000000000000000200000602E72737263000000B0030000002001000004000000E40000000000000000000000000000400000402E72656C6F6300000C0000000040010000020

 (Microsoft.SqlServer.Dac)

"

All Replies

Top 10 Contributor
1,905 Posts

Pardon the delay - I'll be back tomorrow to answer this.

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 10 Contributor
1,905 Posts

The error pertains to Azure not supporting the UNSAFE assembly designation for the Function project.

Specifically, for this: [SqlFunction(DataAccess = DataAccessKind.Read)]

UNSAFE is required for: http://www.sqlservercentral.com/articles/Stairway+Series/112888/

If you don't anticipate needing to fall back to using the non-DB helpers then you can relax these to none, and comment out the XDocument.Load(...); calls.

Every time I have looked at Azure integration I have never been able to make a case for a full-fledged effort.  Why?  $$$!!!

I have very little experience with Azure - however, knowing that AN can utilize all of a computer's resources, at $896 a month (the CHEAP option) you could purchase dedicated hardware (say, two months of Azure $$$ and get DDR4 & an i7-6770K) and spend the $$$ on a nice Fiber/100Mb connection.

Or, https://www.ovh.com/us/sddc/

There really are so many better options than Azure for the amount of compute cycles/disk space AN can/will consume.

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Page 1 of 1 (3 items) | RSS
An Open Source C# web crawler with Lucene.NET search using SQL 2008/2012/CE

copyright 2004-2017, arachnode.net LLC