During an upgrade of a Colio database to version 10 on Consulting D I received the following error: Change tracking is on; switch change tracking off in "B1 Analytic on IMCE 1.0". and it referenced Note: 1663948.
The note from SAP was not helpful but this thread was: https://answers.sap.com/questions/9318362/index.html
Running this query against the Colio database identified the affected tables:
SELECT s.name as Schema_name, t.name AS Table_name, tr.*
FROM sys.change_tracking_tables tr
INNER JOIN sys.tables t on t.object_id = tr.object_id
INNER JOIN sys.schemas s on s.schema_id = t.schema_id
This query fixed them:
EXEC sp_msforeachtable "ALTER TABLE ? DISABLE CHANGE_TRACKING"
, @whereand=" and exists (
select null
from sys.change_tracking_tables ctt
where ctt.object_id = o.id
)
"
go
declare @sql varchar(100)
set @sql='alter database '+quotename(db_name())+' SET CHANGE_TRACKING = OFF';
exec(@sql)
Comments
0 comments
Please sign in to leave a comment.