Share
ReportAn error occurred while configuring SQL change tracking. Check your deployment log for details
*This post is locked for comments
You’re offline. This is a read only version of the page.
An error occurred while configuring SQL change tracking. Check your deployment log for details
*This post is locked for comments
Silly question - I take it you've verified the MC40000 table exists in the company database and how were you logged into the system when executing this command? Your logged in user has access in SQL to the company database correct?
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
Where were you at in the install process when this error occurred?
All responses (
Answers (
