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?
Thanks.
