CU5 update

(0) Share

Report

Posted on by Roger Oakes

508

I am applying the CU5 Rollup on all 6 stores and am running into a problem on some of the databases. HQ and the main store worked fine. 2 of the satellite stores are giving an error when I try to upgrade the database from 2.05 to 2.06 (we are running build 2.0.1006). The error is:

An error occurred while attempting to upgrade the database: Invalid object name 'dbo.tr_ComputeQuantity'.

Any ideas anyone??

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Roger Oakes 508 on at

Like (0)

Report

RE: CU5 update

Hi Todd,

Yeah, you got the answer. We ended up calling Microsoft and the tech sent me 3 scripts to add 3 triggers into the database and that fixed it. For some reason when I create a new database and provision it from the template, it no longer adds these triggers. Actually, it appears it removes them because they are in both the blank database and the template.
Suggested answer

ToddB on at

Like (0)

Report

RE: CU5 update

Hi Roger,

If you look in the database do you see a tr_ComputeQuantity trigger on the InventoryTransferLog table?

Thanks, Todd