I was configure management reporter, after data mart connetion informations nex .......
An error occurred while configuring SQL change tracking. Check your deployment log for details.
4/3/2013 1:00:31 PM - Displaying user object picker for user account selection.
4/3/2013 1:02:06 PM - Validating user dvargas, domain ENINT, and password.
4/3/2013 1:02:06 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:02:06 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:02:06 PM - Checking whether current user has SQL role sysadmin
4/3/2013 1:02:06 PM - Checking Management Reporter database to determine if it needs to be updated.
4/3/2013 1:02:06 PM - Current database schema version: 2.1.1032; deployment package schema version: 2.1.1032.3; update required: True
4/3/2013 1:02:06 PM - Checking port 4712 against ports with active TCP listeners.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:06 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:06 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:06 PM - Change tracking was configured successfully.
4/3/2013 1:02:06 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking was configured successfully.
4/3/2013 1:02:07 PM - Verifying provided credentials for change tracking...
4/3/2013 1:02:07 PM - Credentials for user sa were successfully verified.
4/3/2013 1:02:07 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:02:07 PM - Change tracking is being enabled by running the following SQL script:
ALTER TABLE [dbo].[MC40000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY40101] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY40100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY00300] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL40000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[MC00200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00102] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL40200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00201] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10001] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL32000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL20000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL30000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL12000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL12001] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10101] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)
4/3/2013 1:02:07 PM - An error occurred while configuring SQL change tracking. The error message is as follows: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.MC40000" because it does not exist or you do not have permissions.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.GP.DataMart.GPChangeTrackingConfigurationTool.OpenConnectionAndExecuteScalar(String sqlToExecute, ConfiguredCredential configuredCredential, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.ChangeTrackingConfigurationTool.ExecuteScalar(String sqlToExecute, Boolean suppressSqlSecurityExceptions, ConfiguredCredential configuredCredential, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.ChangeTrackingConfigurationTool.ConfigureChangeTracking(IEnumerable`1 tablesToEnableTrackingOn)
4/3/2013 1:02:08 PM - Checking whether database DDM exists
4/3/2013 1:02:08 PM - Checking SQL Server version; result: 10.50.2550.0
4/3/2013 1:02:08 PM - Checking whether current user has SQL role sysadmin
4/3/2013 1:02:08 PM - Validating user dvargas, domain ENINT, and password.
4/3/2013 1:02:08 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:02:08 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:03:34 PM - Validating user dvargas, domain ENINT, and password.
4/3/2013 1:03:35 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:03:35 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:03:35 PM - Checking whether current user has SQL role sysadmin
4/3/2013 1:03:35 PM - Checking Management Reporter database to determine if it needs to be updated.
4/3/2013 1:03:35 PM - Current database schema version: 2.1.1032; deployment package schema version: 2.1.1032.3; update required: True
4/3/2013 1:03:35 PM - Checking port 4712 against ports with active TCP listeners.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking was configured successfully.
4/3/2013 1:03:35 PM - Verifying provided credentials for change tracking...
4/3/2013 1:03:35 PM - Credentials for user sa were successfully verified.
4/3/2013 1:03:35 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:03:35 PM - Change tracking is being enabled by running the following SQL script:
ALTER TABLE [dbo].[MC40000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY40101] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY40100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY00300] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL40000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[MC00200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00102] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL40200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00201] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10001] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL32000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL20000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL30000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL12000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL12001] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10101] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)
4/3/2013 1:03:35 PM - An error occurred while configuring SQL change tracking. The error message is as follows: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.MC40000" because it does not exist or you do not have permissions.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.GP.DataMart.GPChangeTrackingConfigurationTool.OpenConnectionAndExecuteScalar(String sqlToExecute, ConfiguredCredential configuredCredential, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.ChangeTrackingConfigurationTool.ExecuteScalar(String sqlToExecute, Boolean suppressSqlSecurityExceptions, ConfiguredCredential configuredCredential, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.ChangeTrackingConfigurationTool.ConfigureChangeTracking(IEnumerable`1 tablesToEnableTrackingOn)
4/3/2013 1:07:47 PM - Checking whether database DDM exists
4/3/2013 1:07:47 PM - Checking SQL Server version; result: 10.50.2550.0
4/3/2013 1:07:47 PM - Checking whether current user has SQL role sysadmin
4/3/2013 1:07:47 PM - Validating user dvargas, domain ENINT, and password.
4/3/2013 1:07:48 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:07:48 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:09:54 PM - Validating user dvargas, domain ENINT, and password.
4/3/2013 1:09:54 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:09:54 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:09:54 PM - Checking whether current user has SQL role sysadmin
4/3/2013 1:09:54 PM - Checking Management Reporter database to determine if it needs to be updated.
4/3/2013 1:09:54 PM - Current database schema version: 2.1.1032; deployment package schema version: 2.1.1032.3; update required: True
4/3/2013 1:09:54 PM - Checking port 4712 against ports with active TCP listeners.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking was configured successfully.
4/3/2013 1:09:54 PM - Verifying provided credentials for change tracking...
4/3/2013 1:09:54 PM - Credentials for user sa were successfully verified.
4/3/2013 1:09:54 PM - Change tracking configuration is beginning. If any changes are needed in the target ERP database, they will be listed below.
4/3/2013 1:09:54 PM - Change tracking is being enabled by running the following SQL script:
ALTER TABLE [dbo].[MC40000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY40101] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY40100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[SY00300] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL40000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[MC00200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00102] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL40200] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10100] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL00201] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10001] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL32000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL20000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL30000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL12000] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL12001] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)ALTER TABLE [dbo].[GL10101] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)
4/3/2013 1:09:54 PM - An error occurred while configuring SQL change tracking. The error message is as follows: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.MC40000" because it does not exist or you do not have permissions.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.GP.DataMart.GPChangeTrackingConfigurationTool.OpenConnectionAndExecuteScalar(String sqlToExecute, ConfiguredCredential configuredCredential, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.ChangeTrackingConfigurationTool.ExecuteScalar(String sqlToExecute, Boolean suppressSqlSecurityExceptions, ConfiguredCredential configuredCredential, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.ChangeTrackingConfigurationTool.ConfigureChangeTracking(IEnumerable`1 tablesToEnableTrackingOn)
4/3/2013 1:10:48 PM - Checking whether database DDM exists
4/3/2013 1:10:48 PM - Checking SQL Server version; result: 10.50.2550.0
4/3/2013 1:10:48 PM - Checking whether current user has SQL role sysadmin
4/3/2013 1:10:48 PM - Validating user dvargas, domain ENINT, and password.
4/3/2013 1:10:48 PM - Verifying SQL connection while impersonating ENINT\dvargas
4/3/2013 1:10:48 PM - Verifying SQL connection while impersonating ENINT\dvargas