Microsoft BizTalk 2016 Sample Visual Studio C# application "Loans Processing Using Business Rules" fails by an exception "Microsoft.RuleEngine.RuleEngineDeploymentDBConfigurationMismatchException" RRS feed

  • Question

  • I installed Microsoft BizTalk 2016 on my Windows 10 computer. Thereafter, I was trying to run a sample Microsoft Visual Studio C# application “Loans Processing Using Business Rules” (URL: https://docs.microsoft.com/en-us/biztalk/core/loans-processing-using-business-rules-biztalk-server-sample), all goes well but fails at the following statement when trying to deploy the ruleset:


                   dd.Deploy(new RuleSetInfo(ruleset.Name, ruleset.CurrentVersion.MajorRevision, ruleset.CurrentVersion.MinorRevision));



    The scenario of the exception is shown in the screenshot file DBConfigurationMismatchException.jpg in the in the uploaded package zip file LoadProcessorIssuePackage.zip (URL: https://onedrive.live.com/?id=8FFA4A1C66CFCED9%21517&cid=8FFA4A1C66CFCED9). The full list of C# source codes is shown in the program file WriteToBRL.cs, and the detailed error message is shown in the text file RuleEngineDeploymentDBConfigurationMismatchException.txt in the upload package.


    After googling, I got some posts (e.g., http://biztalk.stottcreations.com/2011/02/error_message_the_database_quot-biztalkruleenginedbquot_associated_with_the_deployment_driver/, https://www.biztalk-server-tutorial.com/2013/07/19/error-the-database-biztalkruleenginedb-associated-with-the-deployment-driver-does-not-match-the-database-specified-during-product-configuration/, https://social.msdn.microsoft.com/Forums/en-US/fbad182d-5927-449e-b0f4-02f315a71b52/deployment-of-rule-fails-with-ms-bre-only-installation?forum=biztalkgeneral, etc.). They have mentioned two configuration points: 1) Set the values of the two registry keys DeploymentDriverAssembly and DeploymentDriverClass in Registry Editor; 2) Set the values of two columns [RuleEngineDBServerName] and [RuleEngineDBName]  in the Table [adm_Group]. I followed up and set the two registry keys (see the attached screenshot files Registry_Key_DeploymentDriverAssembly.jpg and Registry_Key_DeploymentDriverClass.jpg in the uploaded package), as well as set the two columns in the Table [adm_Group] of the SQL Server database [BizTalkMgmtDb] properly (see the screenshot file adm_Group_table_settings.jpg in the upload package).


    However, there is no help. The issue still persists there. Can anybody give me more ideas or solutions on this issue?



    Saturday, October 17, 2020 3:52 PM

All replies