• 4/9/2008 10:31:08 AM -> Deploying meta-data for database 'RAMS_Security_Test' • 4/9/2008 10:31:12 AM -> The database 'RAMS_Security_Test' was created successfully. • 4/9/2008 10:31:12 AM -> Ensuring Filegroups exist on database 'RAMS_Security_Test' • 4/9/2008 10:31:12 AM -> Filegroup verification complete. • 4/9/2008 10:31:12 AM -> Ensuring Tables exist on database 'RAMS_Security_Test' • 4/9/2008 10:31:12 AM -> The table 'SecProjectRole' was created successfully. • 4/9/2008 10:31:12 AM -> The table 'SecUserProjectAccess' was created successfully. • 4/9/2008 10:31:12 AM -> The table 'SecUserProjectDefault' was created successfully. • 4/9/2008 10:31:12 AM -> The table 'SecUserProjectRole' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSAuditDataActions' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSAuditDataFields' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSAuditEvents' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSPermissions' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSPreferences' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSRestrictionItems' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSRestrictions' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSRoles' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSRolesXPermissions' was created successfully. • 4/9/2008 10:31:13 AM -> The table 'SFSUsers' was created successfully. • 4/9/2008 10:31:14 AM -> The table 'SFSUsersXPermissions' was created successfully. • 4/9/2008 10:31:14 AM -> The table 'SFSUsersXRoles' was created successfully. • 4/9/2008 10:31:14 AM -> Table verification complete. • 4/9/2008 10:31:14 AM -> Dropping unneeded filegroups for 'RAMS_Security_Test' • 4/9/2008 10:31:14 AM -> Unneeded filegroups dropped on database 'RAMS_Security_Test' • 4/9/2008 10:31:14 AM -> Ensuring Indexes exist on database 'RAMS_Security_Test' • 4/9/2008 10:31:14 AM -> The index 'PK_SecProjectRole' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SecUserProjectAccess' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SecUserProjectDefault' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SecUserProjectRole' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSAuditDataActions' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSAuditDataFields' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSAuditEvents' was created successfully. X 4/9/2008 10:31:14 AM -> Creating index 'PK_SFSAuditDataActions' failed. X 4/9/2008 10:31:14 AM -> FailedOperationException X 4/9/2008 10:31:14 AM -> ExecuteNonQuery failed for Database 'RAMS_Security_Test'. X 4/9/2008 10:31:14 AM -> ExecutionFailureException X 4/9/2008 10:31:14 AM -> An exception occurred while executing a Transact-SQL statement or batch. X 4/9/2008 10:31:14 AM -> SqlException X 4/9/2008 10:31:14 AM -> Table 'SFSAuditDataActions' already has a primary key defined on it. X 4/9/2008 10:31:14 AM -> Could not create constraint. See previous errors. X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Source : Microsoft.SqlServer.Smo X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Stack Trace: X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand) X 4/9/2008 10:31:14 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateIndexOnServer(Index Idx) X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Creating index 'PK_SFSAuditDataFields' failed. X 4/9/2008 10:31:14 AM -> FailedOperationException X 4/9/2008 10:31:14 AM -> ExecuteNonQuery failed for Database 'RAMS_Security_Test'. X 4/9/2008 10:31:14 AM -> ExecutionFailureException X 4/9/2008 10:31:14 AM -> An exception occurred while executing a Transact-SQL statement or batch. X 4/9/2008 10:31:14 AM -> SqlException X 4/9/2008 10:31:14 AM -> Table 'SFSAuditDataFields' already has a primary key defined on it. X 4/9/2008 10:31:14 AM -> Could not create constraint. See previous errors. X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Source : Microsoft.SqlServer.Smo X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Stack Trace: X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand) X 4/9/2008 10:31:14 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateIndexOnServer(Index Idx) X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Creating index 'PK_SFSAuditEvents' failed. X 4/9/2008 10:31:14 AM -> FailedOperationException X 4/9/2008 10:31:14 AM -> ExecuteNonQuery failed for Database 'RAMS_Security_Test'. X 4/9/2008 10:31:14 AM -> ExecutionFailureException X 4/9/2008 10:31:14 AM -> An exception occurred while executing a Transact-SQL statement or batch. X 4/9/2008 10:31:14 AM -> SqlException X 4/9/2008 10:31:14 AM -> Table 'SFSAuditEvents' already has a primary key defined on it. X 4/9/2008 10:31:14 AM -> Could not create constraint. See previous errors. X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Source : Microsoft.SqlServer.Smo X 4/9/2008 10:31:14 AM -> X 4/9/2008 10:31:14 AM -> Stack Trace: X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 4/9/2008 10:31:14 AM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:14 AM -> at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand) X 4/9/2008 10:31:14 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateIndexOnServer(Index Idx) X 4/9/2008 10:31:14 AM -> • 4/9/2008 10:31:14 AM -> The index 'PK_SFSPermissions' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSPreferences' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSRestrictionItems' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSRestrictions' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSRoles' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSRolesXPermissions' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSUsers' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSUsersXPermissions' was created successfully. • 4/9/2008 10:31:14 AM -> The index 'PK_SFSUsersXRoles' was created successfully. • 4/9/2008 10:31:14 AM -> Index verification complete. • 4/9/2008 10:31:14 AM -> Ensuring Foreign Keys exist on database 'RAMS_Security_Test' • 4/9/2008 10:31:14 AM -> The relationship 'FK_SFSAuditDataActions_SFSAuditDataFields' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSRestrictions_SFSRestrictionItems' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSPermissions_SFSRolesXPermissions' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSRoles_SFSRolesXPermissions' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSPermissions_SFSUsersXPermissions' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSUsers_SFSUsersXPermissions' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSRoles_SFSUsersXRoles' was created successfully. • 4/9/2008 10:31:15 AM -> The relationship 'FK_SFSUsers_SFSUsersXRoles' was created successfully. • 4/9/2008 10:31:15 AM -> Foreign Key verification complete. • 4/9/2008 10:31:15 AM -> Ensuring Views, Stored Procedures, and UDFs exist on database 'RAMS_Security_Test' X 4/9/2008 10:31:15 AM -> Creating view 'SecUserPermissionInfo' failed. X 4/9/2008 10:31:15 AM -> FailedOperationException X 4/9/2008 10:31:15 AM -> Create failed for View 'dbo.SecUserPermissionInfo'. X 4/9/2008 10:31:15 AM -> ExecutionFailureException X 4/9/2008 10:31:15 AM -> An exception occurred while executing a Transact-SQL statement or batch. X 4/9/2008 10:31:15 AM -> SqlException X 4/9/2008 10:31:15 AM -> Invalid object name 'SFSUserPermissionInfo'. X 4/9/2008 10:31:15 AM -> Invalid object name 'SFSUserRolePermissionInfo'. X 4/9/2008 10:31:15 AM -> X 4/9/2008 10:31:15 AM -> Source : Microsoft.SqlServer.Smo X 4/9/2008 10:31:15 AM -> X 4/9/2008 10:31:15 AM -> Stack Trace: X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so) X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() X 4/9/2008 10:31:15 AM -> at Microsoft.SqlServer.Management.Smo.View.Create() X 4/9/2008 10:31:15 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging) X 4/9/2008 10:31:15 AM -> X 4/9/2008 10:31:15 AM -> An error occurred while deploying the meta-data to the server. X 4/9/2008 10:31:15 AM -> SqlException X 4/9/2008 10:31:15 AM -> Object is invalid. Extended properties are not permitted on 'dbo.SecUserPermissionInfo', or the object does not exist. X 4/9/2008 10:31:15 AM -> X 4/9/2008 10:31:15 AM -> Source : .Net SqlClient Data Provider X 4/9/2008 10:31:15 AM -> X 4/9/2008 10:31:15 AM -> Stack Trace: X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 4/9/2008 10:31:15 AM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 4/9/2008 10:31:15 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.SetPriorityOnObject(String databaseName, String schemaName, String objectType, String objectName, Int32 priority) X 4/9/2008 10:31:15 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployViewsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority) X 4/9/2008 10:31:15 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureViewsSprocsUdfs(Database parent, DatabaseInfo dbInfo) X 4/9/2008 10:31:15 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases() X 4/9/2008 10:31:15 AM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread() X 4/9/2008 10:31:15 AM ->