DNN general exception with GeographicLocation

Issue:

DNN events show the following message:

AbsoluteURL:/DesktopModules/ContentPersonalization/API/GeographicLocation/AreRegionsAvailable 
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke 
 
ExceptionHash:swG+oMnVGWJ4efZgqszUEg== 
Message:Exception has been thrown by the target of an invocation. 
StackTrace: 
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) 
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) 
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) 
at System.Activator.CreateInstance[T]() 
at DotNetNuke.Framework.ServiceLocator`2.InitInstance() 
at System.Lazy`1.CreateValue() 
--- End of stack trace from previous location where exception was thrown --- 
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 
at System.Lazy`1.get_Value() 
at DotNetNuke.Framework.ServiceLocator`2.get_Instance() 
at DotNetNuke.Enterprise.ContentPersonalization.Services.GeographicLocationController.AreRegionsAvailable() 
at lambda_method(Closure , Object , Object[] ) 
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.b__9(Object instance, Object[] methodParameters) 
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments) 
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) 
--- End of stack trace from previous location where exception was thrown --- 
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 
at System.Web.Http.Tracing.ITraceWriterExtensions.d__18`1.MoveNext()

...

Environment:
DNN Version 8.x

Root Cause:

This might happen when you are missing one of the following 3 .dll files: MaxMind.Db.dll or MaxMind.GeoIP.dll or MaxMind.GeoIP2.dll

Resolution:

Always do a backup before making any change.

Download the attached files, and paste them in the root/bin directory.

Confirmation:

GeographicLocation will no longer show any error within the DNN events.

Content Author: Giancarlo Mora