Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Upgrade 7.1 db to 9.0

  1. #1
    frios is offline Junior Member
    Join Date
    Jul 2007
    Posts
    7

    Default Upgrade 7.1 db to 9.0

    I am in the process of migrating from 7.1 to 9.0. I have a copy of my 7.1 DB and tried running the Update 7.0 to 8.0.sql script to start upgrading the DB. I get the following stream of errors. Anyone have any ideas what this all means and how to proceed?



    Msg 2714, Level 16, State 3, Procedure ProductEntity, Line 4
    There is already an object named 'ProductEntity' in the database.
    Msg 2714, Level 16, State 3, Procedure EntityMaster, Line 4
    There is already an object named 'EntityMaster' in the database.
    Msg 515, Level 16, State 2, Line 2
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 2
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 2
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 2
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 2
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 2
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 6
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 6
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 4
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 3
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 7
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 8
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 9
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 10
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 11
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 12
    Cannot insert the value NULL into column 'AppConfigID', table 'ASPDotNetStoreFront.dbo.AppConfig'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Msg 515, Level 16, State 2, Line 5
    Cannot insert the value NULL into column 'CreatedOn', table 'ASPDotNetStoreFront.dbo.Topic'; column does not allow nulls. INSERT fails.
    The statement has been terminated.

  2. #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    The AppconfigID field is set to use an identity spec, so it looks like you had it turned off. Go to your sql server managerment studio, open your DB, view the appconfig table in design mode, and make sure that "Identity" is set to yes as shown in the image.

    Name:  identity.jpg
Views: 50
Size:  6.5 KB

    The other error is no big deal, you're getting it because those tables were existing already.