I am trying to get the Test Automation working, but I am getting few issues with the installation.
Server details:
Windows - 7
SQL Server - 2008
Steps follwoed:
1. I have restored the TestAutomation.bak as a Automation database on the server.
2. Ran the Database Manager.exe with server name, Databasename and username, the database is updated.
3. It has created two files DBManagerlog and TestAutomation.exe.config file.
4. The DBManager log has so many erros
5. When the Test Automation.exe is run, it is crashing.
DBManager log:
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() User, group, or role 'AutomationUser' already exists in the current database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Input string was not in a correct format.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.
(
id int NOT NULL IDENTITY (1, 1),
Name varchar(75) NOT NULL,
IsActive bit NOT NULL
) ON ] There is already an object named 'Privilege' in the database.
Error updating database: Error in attributeExists() [ALTER TABLE dbo. ADD CONSTRAINT DEFAULT 1 FOR IsActive] Index was outside the bounds of the array.
Error updating database: Error in attributeExists() [ALTER TABLE dbo. ADD CONSTRAINT PRIMARY KEY CLUSTERED (id) ON ] Index was outside the bounds of the array.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.TestUser_Privilege
(
id int NOT NULL IDENTITY (1, 1),
TestUser_FK int NOT NULL,
Privilege_FK int NOT NULL
) ON ] There is already an object named 'TestUser_Privilege' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.TestUser_Project
(
id int NOT NULL IDENTITY (1, 1),
Project_fk int NOT NULL,
TestUser_fk int NOT NULL
) ON ] There is already an object named 'TestUser_Project' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'EmailAddress' in table 'dbo.TestUser' is specified more than once.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'EmailServer' in table 'dbo.Settings' is specified more than once.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'EmailLogin' in table 'dbo.Settings' is specified more than once.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'TestUser_fk' in table 'dbo.Defect' is specified more than once.
Error updating database: Error in entryExists(): A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.SystemCategory
(
id int NOT NULL IDENTITY (1, 1),
Name varchar(75) NOT NULL,
IsActive bit NOT NULL
) ON ] There is already an object named 'SystemCategory' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.SystemValue
(
id int NOT NULL IDENTITY (1, 1),
SystemCategory_FK int NOT NULL,
Name varchar(75) NOT NULL,
IsActive bit NOT NULL
) ON ] There is already an object named 'SystemValue' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'Severity_SV_FK' in table 'dbo.Defect' is specified more than once.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I am trying to get the Test Automation working, but I am getting few issues with the installation.
Server details:
Windows - 7
SQL Server - 2008
Steps follwoed:
1. I have restored the TestAutomation.bak as a Automation database on the server.
2. Ran the Database Manager.exe with server name, Databasename and username, the database is updated.
3. It has created two files DBManagerlog and TestAutomation.exe.config file.
4. The DBManager log has so many erros
5. When the Test Automation.exe is run, it is crashing.
DBManager log:
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() User, group, or role 'AutomationUser' already exists in the current database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Input string was not in a correct format.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.
(
id int NOT NULL IDENTITY (1, 1),
Name varchar(75) NOT NULL,
IsActive bit NOT NULL
) ON ] There is already an object named 'Privilege' in the database.
Error updating database: Error in attributeExists() [ALTER TABLE dbo. ADD CONSTRAINT DEFAULT 1 FOR IsActive] Index was outside the bounds of the array.
Error updating database: Error in attributeExists() [ALTER TABLE dbo. ADD CONSTRAINT PRIMARY KEY CLUSTERED (id) ON ] Index was outside the bounds of the array.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.TestUser_Privilege
(
id int NOT NULL IDENTITY (1, 1),
TestUser_FK int NOT NULL,
Privilege_FK int NOT NULL
) ON ] There is already an object named 'TestUser_Privilege' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.TestUser_Project
(
id int NOT NULL IDENTITY (1, 1),
Project_fk int NOT NULL,
TestUser_fk int NOT NULL
) ON ] There is already an object named 'TestUser_Project' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'EmailAddress' in table 'dbo.TestUser' is specified more than once.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'EmailServer' in table 'dbo.Settings' is specified more than once.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'EmailLogin' in table 'dbo.Settings' is specified more than once.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'TestUser_fk' in table 'dbo.Defect' is specified more than once.
Error updating database: Error in entryExists(): A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.SystemCategory
(
id int NOT NULL IDENTITY (1, 1),
Name varchar(75) NOT NULL,
IsActive bit NOT NULL
) ON ] There is already an object named 'SystemCategory' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() [CREATE TABLE dbo.SystemValue
(
id int NOT NULL IDENTITY (1, 1),
SystemCategory_FK int NOT NULL,
Name varchar(75) NOT NULL,
IsActive bit NOT NULL
) ON ] There is already an object named 'SystemValue' in the database.
Error updating database: Error in chooseBetweenQueryAndStoredProcedure() Column names in each table must be unique. Column name 'Severity_SV_FK' in table 'dbo.Defect' is specified more than once.
Can you please guide me that I can successfully install the application
Thanks in Advance
Santosh