• 2/11/2008 4:57:28 PM -> Deploying meta-data for database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:28 PM -> Ensuring Filegroups exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:29 PM -> The datafile 'Generic_14_0_Dosrun' was created successfully. X 2/11/2008 4:57:29 PM -> Dropping datafile 'Generic_11_1_dosrun_Data' failed. X 2/11/2008 4:57:29 PM -> FailedOperationException X 2/11/2008 4:57:29 PM -> Drop failed for DataFile 'Generic_11_1_dosrun_Data'. X 2/11/2008 4:57:29 PM -> ExecutionFailureException X 2/11/2008 4:57:29 PM -> An exception occurred while executing a Transact-SQL statement or batch. X 2/11/2008 4:57:29 PM -> SqlException X 2/11/2008 4:57:29 PM -> The primary data or log file cannot be removed from a database. X 2/11/2008 4:57:29 PM -> X 2/11/2008 4:57:29 PM -> Source : Microsoft.SqlServer.Smo X 2/11/2008 4:57:29 PM -> X 2/11/2008 4:57:29 PM -> Stack Trace: X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImplWorker(Urn& urn) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl() X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.DatabaseFile.Drop() X 2/11/2008 4:57:29 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DropSmoObject(IDroppable ObjectToDrop, String ObjectName, DBEObjectType ObjectType) X 2/11/2008 4:57:29 PM -> X 2/11/2008 4:57:29 PM -> Dropping datafile 'Master_14_Dosrun' failed. X 2/11/2008 4:57:29 PM -> FailedOperationException X 2/11/2008 4:57:29 PM -> Drop failed for DataFile 'Master_14_Dosrun'. X 2/11/2008 4:57:29 PM -> ExecutionFailureException X 2/11/2008 4:57:29 PM -> An exception occurred while executing a Transact-SQL statement or batch. X 2/11/2008 4:57:29 PM -> SqlException X 2/11/2008 4:57:29 PM -> The file 'Master_14_Dosrun' cannot be removed because it is not empty. X 2/11/2008 4:57:29 PM -> X 2/11/2008 4:57:29 PM -> Source : Microsoft.SqlServer.Smo X 2/11/2008 4:57:29 PM -> X 2/11/2008 4:57:29 PM -> Stack Trace: X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 2/11/2008 4:57:29 PM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImplWorker(Urn& urn) X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl() X 2/11/2008 4:57:29 PM -> at Microsoft.SqlServer.Management.Smo.DatabaseFile.Drop() X 2/11/2008 4:57:29 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DropSmoObject(IDroppable ObjectToDrop, String ObjectName, DBEObjectType ObjectType) X 2/11/2008 4:57:29 PM -> • 2/11/2008 4:57:29 PM -> Filegroup verification complete. • 2/11/2008 4:57:29 PM -> Ensuring Tables exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:30 PM -> The table 'Sample' was created successfully. • 2/11/2008 4:57:31 PM -> The table 'SampleChild' was created successfully. • 2/11/2008 4:57:31 PM -> Table verification complete. • 2/11/2008 4:57:31 PM -> Dropping unneeded filegroups for 'Generic_14_0_Dosrun' • 2/11/2008 4:57:31 PM -> Unneeded filegroups dropped on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:31 PM -> Ensuring Views exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:31 PM -> The view 'AP_Vendor' was successfully dropped. • 2/11/2008 4:57:31 PM -> The view 'AR_Aging' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'AR_CurrencyRate' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'AR_CustAddress' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'AR_Customer' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'AR_CustomerHist' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'AR_JobInvoice' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'AR_PrepayHeader' was successfully dropped. • 2/11/2008 4:57:32 PM -> The view 'Est_Activity' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_Carton' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_Coverage' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_PackParam' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_PackProfile' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_Paper' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_PaperColor' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_PaperSize' was successfully dropped. • 2/11/2008 4:57:33 PM -> The view 'Est_PaperSubCat' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_PapSubCatID' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_Personnel' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_Press' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_PrintProc' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_PrintSpec' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_ProccessDtl' was successfully dropped. • 2/11/2008 4:57:34 PM -> The view 'Est_Process' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'Est_ProductProc' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'Est_ProductType' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'Est_ReportLink' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'GL_Company' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'GL_Plant' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'Job_AddlSpec1' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'Job_AddlSpec2' was successfully dropped. • 2/11/2008 4:57:35 PM -> The view 'Job_BindStyle' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_BuyoutDtl' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_BuyoutHdr' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_BuyoutVendor' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_CartonResults' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_CompanyPlant' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_ComponentHdr' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_Hdr' was successfully dropped. • 2/11/2008 4:57:36 PM -> The view 'Job_InkColor' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_InvoiceHdr' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_Markup' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_Modifier' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_Process' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_ProduceHdr' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_Section' was successfully dropped. • 2/11/2008 4:57:37 PM -> The view 'Job_SkidResults' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_SubSecSide' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_SubSecSig' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_SubSecSpec' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_SubSection' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_SubSecWaste' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_Version' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Job_VersionLink' was successfully dropped. • 2/11/2008 4:57:38 PM -> The view 'Qte_Invoice' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Sec_CompanyLogon' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Sec_Group' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Sec_Role' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Sec_UserCompPlntROV' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Ship_Method' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Spec_Plate' was successfully dropped. • 2/11/2008 4:57:39 PM -> The view 'Stk_Item' was successfully dropped. • 2/11/2008 4:57:40 PM -> The view 'Sys_Setting' was successfully dropped. • 2/11/2008 4:57:40 PM -> The view 'Sys_SystemSetup' was successfully dropped. • 2/11/2008 4:57:40 PM -> The view 'Sys_User' was successfully dropped. • 2/11/2008 4:57:40 PM -> View verification complete. • 2/11/2008 4:57:40 PM -> Ensuring Indexes exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:41 PM -> The index 'PK_Sample' was created successfully. • 2/11/2008 4:57:41 PM -> The index 'PK_SampleChild' was created successfully. • 2/11/2008 4:57:41 PM -> Index verification complete. • 2/11/2008 4:57:41 PM -> Ensuring Foreign Keys exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:41 PM -> The relationship 'Fk_Sample_SampleChild' was created successfully. • 2/11/2008 4:57:41 PM -> Foreign Key verification complete. • 2/11/2008 4:57:41 PM -> Ensuring Assemblies exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:41 PM -> Assembly verification complete. • 2/11/2008 4:57:41 PM -> Ensuring Stored Procedures exist on database 'Generic_14_0_Dosrun' • 2/11/2008 4:57:41 PM -> Stored Procedure verification complete. • 2/11/2008 4:57:41 PM -> Finished verifying databases on server. • 2/11/2008 4:57:41 PM -> The meta data conversion to the SQL Server has been completed.