Upgrade to Version 10.0 Error: Change tracking is on; switch change tracking off in "B1 Analytic on IMCE 1.0"

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)