Troubleshooting
Problem
When IBM MDM Publisher is connecting to an SSL-enabled SQL Server instance, it cannot validate the server certificate. The SSL certificate of the SQL Server cannot be imported by the MDM Publisher endpoint.
Resolving The Problem
To work around this issue, set the publisher.sqlserver.ssl.trustServerCertificate property in the configuration map to true.
1. Edit the configuration map YAML file.
- For Red Hat OpenShift deployments, edit ${INSTALL_LOC}/mdm-publisher/ibm-publisher-services-prod/templates/publish-config-openshift.yaml.
- For Kubernetes deployments, edit ${INSTALL_LOC}/mdm-publisher/ibm-publisher-services-prod/templates/publish-config-k8s.yaml.
- For Minikube deployments, edit ${INSTALL_LOC}/mdm-publisher/ibm-publisher-services-prod/templates/publish-config-minikube.yaml.
- For Red Hat OpenShift deployments, edit ${INSTALL_LOC}/mdm-publisher/ibm-publisher-services-prod/templates/publish-config-openshift.yaml.
- For Kubernetes deployments, edit ${INSTALL_LOC}/mdm-publisher/ibm-publisher-services-prod/templates/publish-config-k8s.yaml.
- For Minikube deployments, edit ${INSTALL_LOC}/mdm-publisher/ibm-publisher-services-prod/templates/publish-config-minikube.yaml.
2. Add or update the following property:
<property>
<name>publisher.sqlserver.ssl.trustServerCertificate</name>
<value>true</value>
</property>
<name>publisher.sqlserver.ssl.trustServerCertificate</name>
<value>true</value>
</property>
3. Save the configuration map YAML file.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"ARM Category":[{"code":"a8m3p000000LPMoAAO","label":"Product-Related->Publisher"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0.0"}]
Was this topic helpful?
Document Information
Modified date:
27 April 2022
UID
ibm16479389