web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / MR Upgrade to CU 14
Microsoft Dynamics AX (Archived)

MR Upgrade to CU 14

(0) ShareShare
ReportReport
Posted on by Reyaz@Alfa 2

Hi

I did upgrade MR from CU 11 to CU 14. Upgrade went successful. Then it prompt for MR DB update that also went fine. Now when MR updating MR datamart, its failed.

i checked windows log 

The encrypted setting, Password, could not be decrypted. Encryption error occured.
Component: Microsoft.Dynamics.Integration.Common.TraceLog


Then i remove Datamart and try to rebuild. Till configuration it goes fine and when it start integration. I check log again and found the same log. Then i check deployment log from configuration console.

Connecting to a mirrored SQL Server instance using the ApplicationIntent ReadOnly connection option is not supported. 

How do i resolve the issues so that my MR start working correctly.

Please reply it promptly as it is urgent.

Thanks

Reyaz Ahamad 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Are you connecting to a mirrored SQL Server instance ?

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 on at

    I have 2 server

    1- Production database.

    2- Mirror of 1 and Database for MR and Data mart.

    So server should connect to 1 as setup was done for connecting DB 1.

  • Community Member Profile Picture
    Community Member on at

    Which technology are you using to replicate your database from Server1 to Server2 ?

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 on at

    Thanks Matt for your response. Please suggest me what could be the reason.

    This is SQL Server 2008 r2 and hosted on one of data center using vmware.

    My MR DB is on server 2 as described above. Same configuration was working fine before upgrade.

  • Community Member Profile Picture
    Community Member on at

    How do you mirror your database

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 on at

    Hi Matt,

    I have to check with my data center how do they mirror database.

    Is this issue relating anything with database mirror. Could you suggest some possibilities of solution.

  • Community Member Profile Picture
    Community Member on at

    Well, my assumption here is that SQL replicates your database using SQL AlwaysOn Availability Group (AG). AG is configured with a Group Listener. The Group Listener redirects incoming connection to whether the primary instance and one of the secondary depending on the application intent.

    In this case, it says: ApplicationIntent ReadOnly connection option is not supported

    It sounds like MR is establishing a connection to SQL through the Group Listener awith the ApplicationIntent ReadOnly parameter and thus redirected to the secondary database, which is not supported.

    Look, I might be plain wrong. But that could help your troubleshooting. First, determine if you are using SQL AlwaysOn Availability Groups or not.

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 on at

    Hi Matt,

    We are not using SQL AlwaysOn Availability group, this feature is not with SQL Server 2008R2.

  • Suggested answer
    Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 on at

    Hi,

    I believe that this is a bug in CU14 or it may not compatible for SQL 2008R2  with mirror configuration.

    I tried all the solution like i moved my MR DB to a fresh instance instead of Mirror instance but it didn't help.

    I tried rebuild of data mart many times .... didn't help

    I tried uninstall and install a fresh MR CU14....did't help.

    I tried to connect with non mirror DB then it worked and running but in case of Mirror db it failed.

    in the last i uninstall CU 14 and install back to CU11, now all is up and running.

    Finally i couldn't get CU14 and i had to move back to CU11.

    So any one who is planning to go for CU 14 i advise to them please double check the compatibility with DB version and mirror cluster.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    The error this customer is receiving can be workaround by:

    1.   Open the MRServiceHost.settings.config file in the MR Service folder

    2.   Add the following key and make sure it’s set to false:

    <add key="SetApplicationIntentReadOnly" value="false" />

    3. Restart MR services

    After these steps are completed they will be able to point the MR integration to a mirrored AX database without that error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans