Monday, February 1, 2016

MSCRM 2015 – the specified database has a later version

In certain case, you want to repair CRM application, but If you installed Rollup then uninstalled it, the following error will be prompted to you if you tried to repair CRM “the specified database has a later version”.

This happens because CRM sees a later version. If we query to see the versions, the following will be shown

Query applied:
SELECT buildversion,*
FROM   configurationmetadata
ORDER  BY configurationmetadata.buildversion DESC 

But I know that i uninstalled Rollup 0.1 and 0.2, so the current version for CRM would be 7.0.0.3543.
So, we need to make the other two older than 7.0.0.3543 by applying the following query

UPDATE configurationmetadata
SET    buildversion = '6.0.0.0'
WHERE  buildversion = '7.0.2.53' OR buildversion = '7.0.1.129' 


Finally, if you start the repairing now, everything should be fine

No comments:

Post a Comment