I get the error below when upgrading from DNN 4.0.3 to 4.3.5.

After the upgrade I cannot login. I copied the keys to the new web.config so this should not be the problem. The last error logged in the EventLog is shown at the bottom of this post.

Any suggestions?


System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Applications'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Membership'; column does not allow nulls. UPDATE fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Users'; column does not allow nulls. UPDATE fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Applications'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Membership'; column does not allow nulls. UPDATE fails.
Cannot insert the value NULL into column 'ApplicationId', table 'MyTestDb.dbo.aspnet_Users'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


/* Transfer Users  */
/*******************/

If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
    BEGIN
        --Create Temp Table to hold users
        CREATE TABLE dbo.TransferredUsers (
             [TransferredAppId] [uniqueidentifier] ,
             [Username] [nvarchar] (256) NULL
        )

        --Declare Variables
        DECLARE @PortalID int

        -- Transfer Super Users
        EXECUTE TransferUsersToSameContext N'DotNetNuke', NULL

        --Iterate through Portals to transfer users
        SELECT @PortalID = min(PortalID)
        FROM   dbo.Portals
        WHILE @PortalID IS NOT NULL
        BEGIN

            -- Transfer Portal Users
            EXECUTE TransferUsersToSameContext N'DotNetNuke', @PortalID

            SELECT @PortalID = min(PortalID)
            FROM   dbo.Portals
            WHERE  PortalID > @PortalID
        END

        --Drop temp objects
        DROP TABLE dbo.TransferredUsers
        DROP PROCEDURE dbo.TransferUsersToSameContext
    END


This is the error logged when I try to login:

<ArrayOfAnyType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <anyType xsi:type="LogDetailInfo">
        <name>AssemblyVersion</name>
        <value>04.03.05</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>PortalID</name>
        <value>0</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>PortalName</name>
        <value>Brady &amp; Co.</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>UserID</name>
        <value>-1</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>UserName</name>
        <value />
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>ActiveTabID</name>
        <value>35</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>ActiveTabName</name>
        <value>Home</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>RawURL</name>
        <value>/dnnbrady/Home/tabid/35/ctl/Login/Default.aspx</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>AbsoluteURL</name>
        <value>/dnnbrady/Default.aspx</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>AbsoluteURLReferrer</name>
        <value>http://localhost/dnnbrady/Home/tabid/35/ctl/Login/Default.aspx</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>UserAgent</name>
        <value>Mozilla/5.0 (Windows; U; Windows NT 5.2; en-GB; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>DefaultDataProvider</name>
        <value>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>ExceptionGUID</name>
        <value>d6bf0ce2-df2c-4ed0-9336-36905574f768</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>InnerException</name>
        <value>Object reference not set to an instance of an object.</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>FileName</name>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>FileLineNumber</name>
        <value>0</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>FileColumnNumber</name>
        <value>0</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>Method</name>
        <value>DotNetNuke.Security.Membership.AspNetMembershipProvider.UserLogin</value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>StackTrace</name>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>Message</name>
        <value>
            DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---&gt; System.NullReferenceException: Object reference not set to an instance of an object.
            at DotNetNuke.Security.Membership.AspNetMembershipProvider.UserLogin(Int32 portalId, String username, String password, String verificationCode, UserLoginStatus&amp; loginStatus)
            at DotNetNuke.Entities.Users.UserController.ValidateUser(Int32 portalId, String Username, String Password, String VerificationCode, String PortalName, String IP, UserLoginStatus&amp; loginStatus)
            at DotNetNuke.Modules.Admin.Security.Signin.cmdLogin_Click(Object sender, EventArgs e)
            at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
            at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
            at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
            at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
            at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
            at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
            --- End of inner exception stack trace ---
        </value>
    </anyType>
    <anyType xsi:type="LogDetailInfo">
        <name>Source</name>
    </anyType>
</ArrayOfAnyType>

---