5 Replies Latest reply on Mar 5, 2010 6:24 PM by charly_DF

    Error when install NTA 3.6

    charly_DF

      I´m installing NTA 3.6 module on NPM 9.5.1, but wizard send the next message:

      Database configuration error:

      Error while executing script- Must declare the scalar variable "@Script"  

       

      Some idea?

        • Re: Error when install NTA 3.6
          chris.lapoint

          Do you know if you had an NTA eval or older version of NTA on this machine before?

            • Re: Error when install NTA 3.6
              charly_DF

              It´s a new installation, NPM SLX 9.5.1 and NTA 3.6 with an independent  SQL 2005 Enterprise Server. I found the installation wizard log:


              2010-03-04 00:33:17,218 [1] INFO  ConfigurationProgressScene - Shutting down services ...
              2010-03-04 00:33:17,234 [6] DEBUG ConfigurationProgressScene - Stopping service "NetPerfMonService".
              2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsAlertingEngine".
              2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsSyslogService".
              2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsTrapService".
              2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SWJobSchedulerSvc".
              2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SWJobEngineSvc".
              2010-03-04 00:34:30,515 [6] DEBUG ConfigurationProgressScene - Stopping service "OrionModuleEngine".
              2010-03-04 00:34:30,515 [6] DEBUG ConfigurationProgressScene - Stopping service "SWOrionInformationServicev1".
              2010-03-04 00:34:30,515 [6] DEBUG ConfigurationProgressScene - Stopping service "SWInfoServiceSvc".
              2010-03-04 00:34:30,546 [6] DEBUG ConfigurationProgressScene - Configuring Plugin "NetFlow Traffic Analyzer" - Component "NetFlow Database"
              2010-03-04 00:34:30,546 [1] INFO  ConfigurationProgressScene - Updating Orion database. Processing NetFlowTrafficAnalysis.DBStructure file ...
              2010-03-04 00:34:31,265 [1] INFO  ConfigurationProgressScene - Updating Orion database. Processing NetFlowDatabaseScheme.dbConfig file ...
              2010-03-04 00:34:34,296 [6] ERROR DBConfigProcessor - Error while executing script - Must declare the scalar variable "@Script"..
              2010-03-04 00:34:34,296 [6] ERROR DBConfigProcessor - Failing Sql command:


              CREATE PROCEDURE dbo.swsp_DropRoutineIfExists
                   @routineName varchar(max)
              AS
              BEGIN

              DECLARE @script nvarchar(max)
              SET @script=''

              SELECT @script = @script +' DROP ' + ROUTINE_TYPE + ' ' + ROUTINE_SCHEMA + '.' + ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME=@routineName

              EXEC sp_executesql @Script

              END
              2010-03-04 00:34:34,296 [6] ERROR ConfigurationProgressScene - Error while executing script- Must declare the scalar variable "@Script".
              SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Must declare the scalar variable "@Script".
                 at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
                 at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.Process(IDbConnection connection, ConfigurationProgressDelegate progress, String scriptFile, ConfigurationLogDelegate log)
                 at SolarWinds.ConfigurationWizard.Plugin.Common.ModuleHelper.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log, String dbStructureFile, String dbConfigFile, String initialWebConfigFile)
                 at SolarWinds.ConfigurationWizard.Plugin.NetFlow.NetFlowPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
                 at SolarWinds.ConfigurationWizard.Plugin.NetFlow.NetFlowPlugin.DoConfigure(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
                 at SolarWinds.ConfigurationWizard.Plugin.Common.OrionConfigPlugin.SolarWinds.ConfigurationWizard.Common.IOrionConfigPlugin.DoConfig(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
                 at SolarWinds.ConfigurationWizard.Host.ConfigurationProgressScene.DoConfigForComponent(IOrionConfigHost host, Int32 componentId)
              2010-03-04 00:34:34,453 [1] DEBUG IIS6Configurator - Parsed IIS binding string of ":8090:".  Address is "" and port is "8090"
              2010-03-04 00:34:34,468 [1] DEBUG IISHelper - Detecting if IIS6 is installed: True
              2010-03-04 00:34:34,546 [1] DEBUG SqlHelper - SQL: SELECT TOP 1 NodeID FROM Nodes
              2010-03-04 00:35:06,421 [1] DEBUG SqlHelper - SQL: SELECT TOP 1 NodeID FROM Nodes