How can I Remove ML Checks at database level?

(0) Share

Report

Posted on by Nelsona

537

Hello,

I upgraded a client from Version 9 to 2010 R2, and it turns out they had ML Checks installed at one point and now want to enable it again. The issue is that when I re-add the module it tells me it is on a version that cannot be upgraded.

So my questions are: Can I remove ML Checks from the Dynamics database to then reinstall it? If so, which tables do I have to affect and what do I need to remove?

I will deeply appreciate the assistance, since it's been a long project and I'm at wit's end.

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

We had a similar issue with another module just recently. First, you will need to get the product id for ML Checks. This can be located in the Dynamics.set file. Then run these update statements for the product id in question. Replace xxxx with your product id. This fixed our issue.

update dynamics..db_upgrade

set db_veroldmajor = 0, db_veroldminor = 0, db_veroldbuild = 0, db_status = 0

where prodid = xxxx

update DYNAMICS..DB_Upgrade

set db_verMajor = 0, db_verBuild = 0

where prodid = xxxx

update DYNAMICS..DU000020

set versionMajor = 0, versionMinor = 0, versionBuild = 0

where PRODID = xxxx

Was this reply helpful? Yes No