CODEWITHSUNDEEP
biztalkbiztalk-2013r2
jgpadilla04
jgpadilla04

Reputation: 95

BizTalk 2013 R2 CU 5 Installation

I am planning to install CU 5 for BizTalk 2013 R2. I cannot find any reviews online so I wanted to have your feedback if there are issues installing the CU 5. I am using BizTalk 2013 R2 and I haven't installed any CU updates thus far.

Link of CU upgrade - Cumulative Update package 5 for BizTalk Server 2013 R2

Upvotes: 0

Views: 720

Answers (2)

Jeroen Maes
Jeroen Maes

Reputation: 673

There is an issue with BizTalk 2013R2 CU5 when you install it without the required SQL admin rights (the installer doesn't notify about this the way it should according to my opinion).

At the end of the installation, the installer will tell you it failed completing some post-installer steps. In the installer log file you will find a reference to the missing SQL rights.

SELECT permission was denied...

When you try to open the BizTalk Admin Console, you will encouter a 'Could not find stored procedure ops_ClearOperationsProgress' exception.

Could not find stored procedure ‘ops_ClearOperationsProgress’

The only way to recover from this is doing a database restore of the management database.

I wrote a blog post about this here.

Upvotes: 1

DTRT
DTRT

Reputation: 11040

You should install all BizTalk CU's during regular maintenance.

It's a good idea to treat them like any other app update, meaning apply to DEV, then TEST, then PROD, applying all you regular test procedures along the way.

For clarity, all BizTalk Server CU's are cumulative so CU5 will include all updates and patches from 1-4 as well.

Upvotes: 1

Related Questions