Internal Server Error on Journal Migration

Sep 15, 2012 at 7:25 PM

I got through the first steps and on the final Journal Migration step I got an immediate "Internal Server Error". I don't see anything in the DNN Event Viewer, but this is in my Server Event Log.

Event Type:    Warning
Event Source:    ASP.NET 2.0.50727.0
Event Category:    Web Event
Event ID:    1309
Date:        9/15/2012
Time:        1:20:40 PM
User:        N/A
Computer:    DNPSERVER01
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/15/2012 1:20:40 PM
Event time (UTC): 9/15/2012 6:20:40 PM
Event ID: 3289b2ae952a496a9989f1f592875153
Event sequence: 163
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/w3svc/777849497/root-6-129922053582466117
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\HostingSpaces\homeschoolcommunity\homeschoolcommunity.com\wwwroot\
    Machine name: DNPSERVER01
 
Process information:
    Process ID: 4208
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: NullReferenceException
    Exception message: Object reference not set to an instance of an object.
 
Request information:
    Request URL: http://www.homeschoolcommunity.com/DesktopModules/ActiveSocialMigrator/API/JournalService.ashx/ConvertJournal
    Request path: /DesktopModules/ActiveSocialMigrator/API/JournalService.ashx/ConvertJournal
    User host address:
    User: host
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at DotNetNuke.Modules.ActiveSocialMigrator.Services.JournalServiceController.ConvertJournal(String JournalTypes)
   at lambda_method(ExecutionScope , ControllerBase , Object[] )
   at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
   at System.Web.Mvc.Controller.ExecuteCore()
   at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
   at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)
   at System.Web.Mvc.MvcHandler.<>c__DisplayClass8.<BeginProcessRequest>b__4()
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 

Sep 16, 2012 at 7:17 AM

Cliff,

I had a similar kind of error, but I got this already at the first stage of the migration. I created an issue for this in the issue tracker. Sorry to say, but I am really glad I am not only one who receives this error.

Sep 18, 2012 at 3:58 PM

I just went ahead and rolled back for now. Do you think there will be a response to the issues that are being raised anytime soon, or can we expect to wait another week until you have some spare time to work on this since it obviously isn't a priority for anyone at DNN Corp.

Sep 20, 2012 at 10:08 PM

I am curious as to why the ProfileID, GroupID and JournalTypeID are all hardcoded to -1. Am I missing something here?

This is the JournalDB.cs code.

public List JournalList(int PortalId, int UserId, int ProfileId, int GroupId, int JournalTypeId, int RowIndex, int MaxRows, string FilterTypes, int JournalMode, string JournalQuery)

This is the JournalServices.cs code where you can see the three items I mentioned above being hardcoded to -1.

try {
                jitems = journalDB.JournalList(PortalSettings.PortalId, PortalSettings.UserId, -1, -1, -1, 0, 20, string.Empty, 2, string.Empty);
                if (jitems.Count > 0) {
                    journalCount = jitems[0].ItemCount;
                }
            } catch (Exception ex) {

Coordinator
Sep 27, 2012 at 6:58 AM

Those entries are using -1 so that the DB call will return all entries and not just items based on a particular UserId or GroupId

Sep 27, 2012 at 3:22 PM

Would it be beneficial for you to take a quick look at my journal table? I can put it in Excel and email you a copy. It's only 477 records.