Installation Error

Aug 26, 2009 at 1:59 PM

Hi,

         I got an error in installation of Malevich.


The installer is ready to configure your system.

The following installation parameters have been selected:
  Installation directory: CodeReview
  SQL server instance: localhost
    (A new database will be created.)
  Web site: http://SERVER-1/Malevich
  Web site path: CodeReview\Web
  Review client share: \\SERVER-1\reviewclient
  Review client path: CodeReview\client
  Notifier path: CodeReview\notifier
    (The mailer will not be configured.)
   Unix utils: will be installed in CodeReview\unxutils

Do you want me to start installation with the above parameters? (Yes/No): Yes

Installing the database.
  Creating the database.
Running CREATE DATABASE [CodeReview] ON PRIMARY (NAME = N'CodeReview', FILENAME
= 'CodeReview\CodeReview.mdf', SIZE = 393216KB, FILEGROWTH = 131072KB) LOG ON (N
AME = N'CodeReview_log', FILENAME = 'CodeReview\CodeReview_log.ldf', SIZE = 1310
72KB, FILEGROWTH = 16384KB)
System.Data.SqlClient.SqlException: A file activation error occurred. The physic
al file name 'CodeReview\CodeReview.mdf' may be incorrect. Diagnose and correct
additional errors, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check relat
ed errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Installer.Program.CreateDatabase(InstallParameters installParams)
Could not create the database.
Press any key to exit...

 

Please help me to solve this Problem.

Aug 27, 2009 at 6:39 PM

That makes two of us. :)

 

Aug 27, 2009 at 10:08 PM

Here goes my 2 cents:

The above presented error is a SQL issue. I'm thinking the problem might be that the installer doesn't use a full path when defining both FILENAME = 'CodeReview\CodeReview.mdf' and FILENAME = 'CodeReview\CodeReview_log.ldf'. So that means that when you where asked to input the base directory you didn't input a full path.

Example:

The base directory for Malevich will contain the web site, the backup of
the code review database, the notifier program, and the database itself
(it it has not been created already).
Please enter the name of the base directory: c:\MyProject

This will solve your issue. Of course, it would also be nice to have the installer give you a default full path in case none is given. Something like

installParams.InstallTarget = Path.Combine(Directory.GetCurrentDirectory(), installParams.InstallTarget);

 

Anyways, I hope this helps.

Cheers,

Aug 28, 2009 at 6:26 AM

Hi,

Thanks for help.

 

I try to your solution but problem still continue like this.

The base directory for Malevich will contain the web site, the backup of
the code review database, the notifier program, and the database itself
(it it has not been created already).
Please enter the name of the base directory: C:\Program Files\Malevich Project\M
alevich Code Review System\Code

Malevich would be installed as an application in the default web site.
By default, the web site will be addressable as http://SERVER-1/Malevich
Would you like to change the path under the default web site? (Yes/No): No

While Malevich mail notifier can be used with both SMTP and Exchange Web
Services 2007, this program only supports SMTP server-based installation.
You can chose to defer mailer configuration until later and do it by hand
if you prefer to use EWS 2007. However, you would then miss on automatic
configuration and verification that this program provides.

Would you like to skip configuring mail notifier? (Yes/No): Yes


The installer is ready to configure your system.

The following installation parameters have been selected:
  Installation directory: C:\Program Files\Malevich Project\Malevich Code Review
 System\Code
  SQL server instance: localhost
    (A new database will be created.)
  Web site: http://SERVER-1/Malevich
  Web site path: C:\Program Files\Malevich Project\Malevich Code Review System\C
ode\Web
  Review client share: \\SERVER-1\reviewclient
  Review client path: C:\Program Files\Malevich Project\Malevich Code Review Sys
tem\Code\client
  Notifier path: C:\Program Files\Malevich Project\Malevich Code Review System\C
ode\notifier
    (The mailer will not be configured.)
   Unix utils: will be installed in C:\Program Files\Malevich Project\Malevich C
ode Review System\Code\unxutils

Do you want me to start installation with the above parameters? (Yes/No): Yes

Installing the database.
  Creating the database.
Running CREATE DATABASE [CodeReview] ON PRIMARY (NAME = N'CodeReview', FILENAME
= 'C:\Program Files\Malevich Project\Malevich Code Review System\Code\CodeReview
.mdf', SIZE = 393216KB, FILEGROWTH = 131072KB) LOG ON (NAME = N'CodeReview_log',
 FILENAME = 'C:\Program Files\Malevich Project\Malevich Code Review System\Code\
CodeReview_log.ldf', SIZE = 131072KB, FILEGROWTH = 16384KB)
System.Data.SqlClient.SqlException: CREATE FILE encountered operating system err
or 5(Access is denied.) while attempting to open or create the physical file 'C:
\Program Files\Malevich Project\Malevich Code Review System\Code\CodeReview.mdf'
.
CREATE DATABASE failed. Some file names listed could not be created. Check relat
ed errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Installer.Program.CreateDatabase(InstallParameters installParams)
Could not create the database.
Press any key to exit...

 

Please Please.. let me know all possible issue which cause this error

 

Thanks agian

i am waiting your response

Sep 3, 2009 at 12:11 PM

hi,

 

I reinstall win2k8 & install all updates of it & after that i install SQL2k8 as say in installation guide.

At last i install malevich setup & run malevich configure

& it's work...............

Coordinator
Sep 11, 2009 at 4:57 PM

You need to supply fully qualified path for Malevich base directory: "c:\codereview", not "codereview"

 

Sep 29, 2009 at 12:07 AM

Hi, i've tried to install but i'm facing the following error:

Running ALTER DATABASE [CodeReview] SET AUTO_UPDATE_STATISTICS ON
Running ALTER DATABASE [CodeReview] SET CURSOR_CLOSE_ON_COMMIT OFF
Running ALTER DATABASE [CodeReview] SET CURSOR_DEFAULT GLOBAL
Running ALTER DATABASE [CodeReview] SET CONCAT_NULL_YIELDS_NULL OFF
Running ALTER DATABASE [CodeReview] SET NUMERIC_ROUNDABORT OFF
Running ALTER DATABASE [CodeReview] SET QUOTED_IDENTIFIER OFF
Running ALTER DATABASE [CodeReview] SET RECURSIVE_TRIGGERS OFF
Running ALTER DATABASE [CodeReview] SET DISABLE_BROKER
Running ALTER DATABASE [CodeReview] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
Running ALTER DATABASE [CodeReview] SET DATE_CORRELATION_OPTIMIZATION OFF
Running ALTER DATABASE [CodeReview] SET PARAMETERIZATION SIMPLE
Running ALTER DATABASE [CodeReview] SET READ_WRITE
Running ALTER DATABASE [CodeReview] SET RECOVERY FULL
Running ALTER DATABASE [CodeReview] SET MULTI_USER
Running ALTER DATABASE [CodeReview] SET PAGE_VERIFY CHECKSUM
Running USE [CodeReview];IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is
_default=1 AND name = N'PRIMARY') ALTER DATABASE [CodeReview] MODIFY FILEGROUP [
PRIMARY] DEFAULT
Deploying the metadata:
Deployment has returned an error status:
*** TSD01268 .Net SqlClient Data Provider: Msg 5030, Level 16, State 2, Line
1 The database could not be exclusively locked to perform the operation.
*** TSD01268 .Net SqlClient Data Provider: Msg 5072, Level 16, State 1, Line
1 ALTER DATABASE failed. The default collation of database 'CodeReview' cannot b
e set to SQL_Latin1_General_CP1_CI_AS.

The rest of the output:
TSD00566 Deployment script generated to:
C:\Program Files\Malevich Project\Malevich Code Review System\$(TargetFileName).
txt

TSD01268 An error occurred while the batch was being executed.

Failed to deploy the metadata.

I found a workaround but i'm not able to apply/test it:

ALTER DATABASE <database_name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE <database_name> COLLATE <target_collation_name e.g. SQL_Latin1_General_CP1_CI_AS>
ALTER DATABASE <database_name> SET MULTI_USER

Since the installer exists and when i run it again the process starts from scratch.

Any help?

Thanks in Advance

Henrique Coelho

Coordinator
Sep 29, 2009 at 7:34 AM

Hi, Henrique,

The installer doesn't handle non-latin databases too well yet. The simplest workaround is to install an instance of SQL server with the latin code page as the default database collation (note that multiple instances of SQL can exist on the server, so you can easily have a dedicated instance for Malevich.

Another (possible) workaround is to create a database by hand and set its collation to Latin, just like you do above. When the database exists, the setup simply upgrades it, and so since the existing database would have the latin collation, everything should work.

Please let me know if it helps!

Sergey

Sep 30, 2009 at 1:46 AM

Hi Sergey,

Thanks for your short answer.

I resolved the problem doing by your second method (deploy the malevich using VS) and it works very good. I'm already playing with the tool and it works fine.

One more time thanks :)

Henrique Coelho