Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

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?

Find more posts tagged with

Accepted answers

All comments

chris.lapoint

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

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

Hi,

what's your collation schema? I would say, that you have CASE SENSITIVE and that's probably the problem.

thanks

chris.lapoint

Correct, and we don't support CASE SENSITIVE DB configurations at this point.