000029614 - Archer Installation failure due to Collation settings - 'An error occurred at step 6 of script'

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000029614
Applies ToArcher 5.x
IssueArcher Installation will fail at executing scripts when server level or DB level collation is set to 'Turkish_CI_AS' as installer won't be able to create any stored procedures.
Error Log : 
Set log directory C:\Program Files\RSA Archer\Logs\
Updating database 
Loading database script resources
SetupUtils.Database.SqlException: An error occurred at step 6 of script 5.5.20000.1009.sql (length=5159, max=3301) ---> System.Data.SqlClient.SqlException: Must declare the scalar variable "@userid".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SetupUtils.Database.ScriptExecutor.ExecuteCommand(String scriptName, String cmdText, Int32 step)
   --- End of inner exception stack trace ---
   at Archer.Installer.Pages.PerformInstallationPage.InstallDatabase(Operation dbOp, String connectionString, String instanceName, Boolean allowSkipOnError)
   at Archer.Installer.Pages.DBOperationHandler.Execute()
   at Archer.Installer.Pages.PerformInstallationPage.OnWizardNext(WizardPageEventArgs e)
ResolutionChange both server level and Database(Instance and Config) Level collation to 'SQL_Latin1_General_CP1_CI_AS' and start install.
To change server level collation :