SolarWinds IP Address Manager version 4.3 HotFix 1
This Hotfix addresses issues where the DNS Mismatch resource, which is present in the IPAM summary page, is not working correctly. This happens when the resource needs to populate a large numer of DNS Mismatch records.
Applicable Versions: This HotFix is applicable to IPAM 4.3.
This Hotfix modifies the IPAM.core.xml file in C:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\
Notes:
- Save a copy of the original IPAM.core.xml file as a backup file, in case you need to rollback later.
- You must have administrator rights in SQL Management Studio to apply this Hotfix.
Warning:
- SolarWinds strongly recommends that you only edit the IPAM.core.xml file as instructed. Any additional modifications to the IPAM.core.xml file may result in system performance issues or may create an error state.
To install this Hotfix:
- Run the IPAM_4.3_HotFix.exe installer and extract it to a temporary folder.
- Open the IPAM_DNSMismatch.sql in SQL Management Studio and then click the Execute button.
- Open the Table_val_DNS_Mismatch.sql in SQL Management Studio and then click the Execute button.
- Stop all Orion services by using the Orion Service Manager.
- Go to the location C:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\, and look for the IPAM.core.xml file.
Note: Save a copy of the original IPAM.core.xml file as a backup file, in case you need to rollback later. - Open IPAM.core.xml and find the string “<storage name="dbo.IPAM_DNSMismatch" type="Table" provider="Orion">
- Add the following line before “</storage>” tag
<definingQuery>
select * FROM dbo.IPAM_dnsMismatch2()
</definingQuery> - Verify that your XML file looks like the following:
<storage name="dbo.IPAM_DNSMismatch" type="Table" provider="Orion">
<property name="DNSServer" type="nvarchar" />
<property name="DNSZone" type="nvarchar" />
<property name="ClientHostName" type="nvarchar" />
<property name="ForwardZoneIPAddress" type="varchar" />
<property name="ReverseZoneIPAddress" type="nvarchar" />
<property name="NodeId" type="int" />
<property name="ReverseZoneIPAddressN" type="uniqueidentifier" />
<property name="ForwardZoneIPAddressN" type="uniqueidentifier" />
<property name="DnsZoneId" type="int" />
<property name="DnsZoneGroupId" type="int" />
<property name="ForwardIPNodeID" type="int" />
<property name="ReverseIPNodeID" type="int" />
<definingQuery>
select * FROM dbo.IPAM_dnsMismatch2()
</definingQuery>
</storage> - Save the file and then click Exit.
Notes:
- Restart Orion services and launch IPAM Console.
- When this Hotfix is applied correctly, the DNS Mismatch resource of IPAM summary page displays all the mismatch records without any issues.
To uninstall this Hotfix:
- Go to the location C:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\.
- Replace the IPAM.core.xml file with the backup file you saved before applying the Hotfix.
For more information, contact Technical Support at www.solarwinds.net/support.