6 Replies Latest reply on May 27, 2010 7:01 AM by NTeam

    Get this error duing install

      Open ticket: #155171

      Error message:

      Database configuration failed:
       •  A .NET Framework error occurred during execution of user-defined routine or aggregate "NPM_InstallUpdateDB":
      System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_NPM_NV_WL_INTERFACES_DETAIL_NPM_NV_WL_APS_DETAIL". The conflict occurred in database "NetPerfMon", table "dbo.NPM_NV_WL_APS_DETAIL".
      System.Data.SqlClient.SqlException:
         at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
         at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
         at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
         at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages)
         at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
         at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
         at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
         at SolarWinds.NPM.SQL.Classes.SPUtils.ExecuteSqlCommand(String sqlCommand, SqlConnection conn)
         at SolarWinds.NPM.SQL.Classes.SPUtils.ExecuteSqlScript(String script, SqlConnection conn)
         at StoredProcedures.NPM_InstallUpdateDB()

        • Re: Get this error duing install

          Thanks for this, laser. I've marked this for the PM to see.

          Would you mind posting the resolution to thwack when you get one?

          Thx,

          M

          • Re: Get this error duing install
            bshopp

            Dev is looking into this currently

              • Re: Get this error duing install
                r0berth1

                I am getting the message that Config Wizard could not add column to the node table.

                  • Re: Get this error duing install
                    chris.smouse

                    r0berth1 - are you also getting the error that lasher ran into?  What's the error message you're seeing - which column is it complaining about?

                      • Re: Get this error duing install
                        r0berth1

                        No I was not getting that error. Entity Type could not be added to the Nodes table.

                          • Re: Get this error duing install
                            NTeam

                            i get the below on my install of NPM 10

                            Case #164416

                            Database configuration failed:
                             •  A .NET Framework error occurred during execution of user-defined routine or aggregate "NPM_InstallUpdateDB":
                            System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_NPM_NV_WL_APS_DETAIL_NPM_NV_WL_CONTROLLERS_DETAIL". The conflict occurred in database "netperfmon", table "dbo.NPM_NV_WL_CONTROLLERS_DETAIL".
                            System.Data.SqlClient.SqlException:
                               at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
                               at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
                               at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
                               at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages)
                               at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
                               at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
                               at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
                               at SolarWinds.NPM.SQL.Classes.SPUtils.ExecuteSqlCommand(String sqlCommand, SqlConnection conn)
                               at SolarWinds.NPM.SQL.Classes.SPUtils.ExecuteSqlScript(String script, SqlConnection conn)
                               at StoredProcedures.NPM_InstallUpdateDB()