Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

PrevPrev Go to previous topic
NextNext Go to next topic
Forums Document Exchange Lite Installation and Activation Issues
Last Post 03/28/2007 6:24 AM by  M@
Object reference not set to an instance of an object
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
M@
New Member
New Member
Posts:6


--
03/19/2007 10:34 PM

    Hello,

    New user of DMX and just got the installation and activation complete. Now trying to do anything in the module generates the very detailed "Object reference not set to an instance of an object".  i.e. add new folder, add file, etc.  Can traverse 'Options' menu wihout error, but unable to import. Below are the 2 exceptions thrown that show in the logs at every attempt to use the module.

    Environment: DNN 4.4.1, DMX 3.4.8(NET2).  Nearly fresh DNN installation.  Hosted server with 1&1.com.  Trust level forced to 'medium' by provider. Logged into DNN as host.  No access to console.

    I am a DMX newbie but have tried to look at all the doc, faq's, and forums for answers.  Alas i am left with asking for assistance here.  Let me know if anyone can help or suggest additional detail to assist in troubleshooting.

    At this point i am flailing and would rather wait for some logical troubleshooting tips so as to avoid creating further issues.

    Thanks, M@

     

     

     

    3/19/2007 4:06:33 PM   Page Load Exception   host     AssemblyVersion: 04.04.01; PortalID: 0; PortalNa ...
    AssemblyVersion: 04.04.01
    PortalID: 0
    PortalName: xxx
    UserID: 1
    UserName: host
    ActiveTabID: 71
    ActiveTabName:x RawURL: /OurStuff/Wedding/tabid/71/DMXModule/402/Command/Core_Edit/EntryBaseType/Collection/CollectionId/0/Default.aspx
    AbsoluteURL: /Default.aspx
    AbsoluteURLReferrer: http://mattshive.com/OurS...lection/Default.aspx
    UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: 3178ee1a-820f-4071-9983-e36136cc27b3
    InnerException: Object reference not set to an instance of an object.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: Bring2mind.DNN.Modules.DMX.Controls.AjaxTreeview.d
    StackTrace:
    Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Bring2mind.DNN.Modules.DMX.Controls.AjaxTreeview.d(Object A_0, EventArgs A_1) at System.Web.UI.Control.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
    Source:
    Server Name: NTXPWUS17
      3/19/2007 4:06:30 PM   Module Load Exception   host     ModuleId: 402; ModuleDefId: 99; FriendlyName ...
    ModuleId: 402
    ModuleDefId: 99
    FriendlyName: Workspace
    ModuleControlSource: DesktopModules/Bring2mind/DMX/Dispatch.ascx
    AssemblyVersion: 04.04.01
    PortalID: 0
    PortalName: March Madness 2007
    UserID: 1
    UserName: host
    ActiveTabID: 71
    ActiveTabName: Wedding
    RawURL: /OurStuff/Wedding/tabid/71/DMXModule/402/Command/Core_Edit/EntryBaseType/Collection/CollectionId/0/Default.aspx
    AbsoluteURL: /Default.aspx
    AbsoluteURLReferrer: http://mattshive.com/OurS...lection/Default.aspx
    UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: d46a2f6a-4813-4fce-bb0a-1a316a285342
    InnerException: The stored procedure 'dbo199485657.DMX_GetLatestApprovedEntry' doesn't exist.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Data.SqlClient.SqlCommand.DeriveParameters
    StackTrace:
    Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo199485657.DMX_GetLatestApprovedEntry' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo199485657.DMX_GetLatestApprovedEntry' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.GetLatestApprovedEntry(Int32 EntryId, Int32 PortalId) at Bring2mind.DNN.Modules.DMX.Business.EntriesController.GetLatestApprovedEntry(Int32 EntryId, Int32 PortalId) at Bring2mind.DNN.Modules.DMX.Controls.PortalModuleBase.EntryStatus(Int32 EntryId, Boolean Extensive) at Bring2mind.DNN.Modules.DMX.EditEntry.i(Object A_0, EventArgs A_1) --- End of inner exception stack trace ---
    Source:
    Server Name: NTXPWUS17

     

     

     
    M@
    New Member
    New Member
    Posts:6


    --
    03/20/2007 4:30 AM

    To add a bit of detail here i am using the hosting provider's SQL2005 servers. 

    After looking a bit closer at the exception output, i can confirm that the "DMX_GetLatestApprovedEntry" is NOT present in my SQL database. 

     

    Is this a 'red herring' or do i indeed need to rerun an installation script of some sort to clean this up?

    I have reinstalled the module over top the first installation already with no success.  I have not removed DMX and reinstalled though.

     

    Thanks again,

    M@

     
    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4536


    --
    03/21/2007 9:11 AM
    Did you make sure the connection string is in BOTH places in the web.config and not just the first? It should appear twice. Once under connectionStrings and once under appSettings.

    Peter
    M@
    New Member
    New Member
    Posts:6


    --
    03/23/2007 2:08 AM

    Hi Peter,

    Yes, I can confirm the web.config is proper with the sql connection settings in both places.

    Any assistance appreciated.

    Thanks.
    M@
    New Member
    New Member
    Posts:6


    --
    03/24/2007 9:51 PM
    Hi Peter,
    I am still fighting this. I hhave no idea what to look at next here. The only thing i am left to consider is the SQL database characteristics. I am running 64bit SQL 2005 on a remote server at my host. Can you confirm support for this scenario?
    Thanks,
    M@
    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4536


    --
    03/26/2007 10:17 AM
    Hi Matt,

    That should not be an issue. I use a regular DNN pattern for accessing data. If other modules work, this should work as well. It should run on 2005 and 2000 without any modifications as well. I'm not familiar with 64 bit SQL 2005 but I can't imagine this is incompatible in any way with regular SQL 2005.
    It could be that for some reason the scripts did not run. DMX_GetLatestApprovedEntry SHOULD be there. The DNN installer takes care of running the scripts that are packed in the zip file. The error could be incorrect version control (i.e. DNN thought the DMX was a newer version than it really was) or faulty database connection. The latter should have shown as red errors on the install screen though. Did you install DMX into a clean DNN or did you install it over a DMX Lite?

    Cheers,
    Peter
    M@
    New Member
    New Member
    Posts:6


    --
    03/26/2007 3:55 PM
    Thanks Peter,
    I dumped the list of stored procedures and sorted them on my own and indeed now see the DMX_GetLatestApprovedEntry. The tool that my host provides for SQL administration was not sorting properly! In any case, now that i see it, i do notice an oddity. All of the other "DMX" stored procedures are owned by my dboxxxnnn user. However, the "DMX_GetLatestApprovedEntry" and the "DMX_GetVersionList" are owned by "dbo".

    Can you confirm that the procedure owners are accurate?
    Thanks again,
    M@
    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4536


    --
    03/27/2007 10:42 PM
    No clue. That is your local admin's settings of SQL. It is completely goverened by the web.config. It is not something the module developer influences. I just hand over the SPROC to the installer, that's all. No owner info on that. The db owner is set in the web.config and should remain constant IMO.
    M@
    New Member
    New Member
    Posts:6


    --
    03/28/2007 6:24 AM
    Thanks Peter. I have resolved this issue! If anyone wants the details i am willing to provide, but essentially there were 2 stored procedures installed by DMX that were using the "dbo" account as the sql owner. the other 90 DMX stored procedures were accurately using my host asigned sql account as referenced in the web.config. I am not sure how this is possible, but i found an article on the net detailing how to change the owner. I ran the sql scripts to modify the 2 misbehaving stored procedures and all seems well now.

    Thanks again for you assistance and patience Peter!
    -M@
    You are not authorized to post a reply.

    Forums Document Exchange Lite Installation and Activation Issues
    © 2024 Bring2mind Terms Of UsePrivacy Statement