Geo Fence picker on Campus

[mattbaylor]

Used the Geo Fence Picker to define campus and got an error on save.

An exception has occurred. Details of this error can be found below: An error occurred on the Rock RMS site on page: https://rms.woodmenvalley.org:443/page/267?LocationId=17

HttpUnhandledException in System.Web

Message Exception of type 'System.Web.HttpUnhandledException' was thrown.

Stack Trace at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

-TargetInvocationException in mscorlib

Message Exception has been thrown by the target of an invocation.

Stack Trace at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Data.Entity.SqlServer.SqlSpatialServices.GeographyPolygonFromText(String polygonText, Int32 srid) at RockWeb.Blocks.Core.LocationDetail.btnSave_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

--DllNotFoundException in Microsoft.SqlServer.Types

Message Unable to load DLL 'SqlServerSpatial.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Stack Trace at Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoMarshalData g, Boolean& result) at Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoData g) at Microsoft.SqlServer.Types.SqlGeography.ConstructGeographyFromUserInput(GeoData g, Int32 srid) at Microsoft.SqlServer.Types.SqlGeography.GeographyFromText(OpenGisType type, SqlChars taggedText, Int32 srid)

[mattbaylor]

Note, I just discovered I was on beta.1. Will try this on .4 and update.

[mattbaylor]

Confirmed to still be happening on .4

[nairdo]

@mattbaylor I'm not able to replicate this issue, but it looks like you may be missing a DLL. Do you have the "System.Spatial.dll" in your RockWeb/bin folder? Also, what version of SQL Server are you using?

[mattbaylor]

Yes I have System.Spatial.dll on my system. I also just redid the whole install. Last Install I skipped .2 and went straight to .3 before taking .4. I'm getting the same error after a fresh install.

[nairdo]

And what version of SQL Server do you have (and is it 32 or 64 bit)? Check out this thread and let us know if your issue is the same or related: http://stackoverflow.com/questions/14265845/unable-to-load-sqlserverspatial-dll

It will be good to know and get to the bottom of this before Rock 1.0.

[mattbaylor]

It's possible it is the same. SQL Server 2012 64 bit.

Matt

On April 13, 2014 at 2:14:42 PM MDT, nairdo notifications@github.com wrote:And what version of SQL Server do you have (and is it 32 or 64 bit)? Check out this thread and let us know if your issue is the same or related: http://stackoverflow.com/questions/14265845/unable-to-load-sqlserverspatial-dll It will be good to know and get to the bottom of this before Rock 1.0. —Reply to this email directly or view it on GitHub.

[azturner]

@mattbaylor , can you confirm if this is still an issue after 1.0.8. We updated how those dll's are loaded in the 1.0.8 version.

[BelAirIT]

I was experiencing this same exact problem earlier today. After applying the 1.0.8 update it's completely fixed!

[nairdo]

@BelAirIT thanks for the note. We'll give Matt a day or so to confirm that this fixes his system too before we close this issue.