Operational Defect Database
BugZero updated this defect 46 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
VMware | 97458
Smarts NCM: NCM Smarts Adapter is not able to use Explicit Rules for use with IP domains
Last update date:
4/3/2024
Affected products:
Smart Assurance - SMARTS
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Symptoms
NCM Smarts Adapter is not able to use Explicit Rules for use with IP domains. The catalina.log file shows the following errors: The logs show issues in handling a NULL value Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "MAPPING_EXCLUSIONS_ID"; SQL statement: insert into mapping_rule (mapping_rules_id, rules_idx, rule_id) values (?, ?, ?) [23502-210]
Purpose
To provide steps to resolve this issue with the NCM Smarts Adapter when trying to synchronize with the Smarts IP domains and use Explicit Rules for discovering devices from Smarts IP domains into NCM Networks.
Cause
The h2 Mapping Rules is not able to handle a NULL value.
Impact / Risks
High, The NCM Smarts adapter will work with the TSM domain only as it applies default rules.
Resolution
Follow the workaround provided as there is no ETA for a fix in NCM NCM Smarts Adapter.
Workaround
To access the h2 console For NCM version 10.1.13 Open $VOYENCE_HOME/NCMSmartsAdapter/webapps/NCMSmartsAdapter-10.1.13.0/WEBINF/classes/application.propertiesAdd these two spring.h2 lines at the end of the file, after the following line: environments.production.dataSource.properties.defaultTransactionIsolation=2spring.h2.console.enabled=truespring.h2.console.settings.web-allow-others=trueSave the file.Restart the NCMSmartsAdapter service.Skip to Part II: In Your Web Browser For NCM versions 10.1.1. through 10.1.11First step is to update the NCM Smarts adapter application.yml file source /etc/voyence.conf Find the application yml file. In this example NCM version 10.1.11 was used.If your version is older then use the version info of your NCM installation.Navigate to the $VOYENCE_HOME/NCMSmartsAdapter/webapps directory and review the NCMSmartsAdapter directory name and use this path for the commands below.$VOYENCE_HOME/NCMSmartsAdapter/webapps/NCMSmartsAdapter-10.1.11.0/WEB-INF/classes/application.yml Under the spring heading insert the h2; and the lines below.spring: h2: console: enabled: true settings: web-allow-others: trueSave the file.Restart the NCMSmartsAdapter service. Part II: In Your Web Browser http://IP of the AS Server:11843/NCMSmartsAdapter-10.1.11.0 (or your version) /h2-consoleThe user is SA and the password is blank.You will need to type in the JDBC URL as shown above.Test Connection, if successful, then click Connect.Please Note: This assumes you have installed NCM in the default path. If not use the command line interface on your AS server to find the correct path to NCMSmartsAdapter./prodDB Once connected you will see a screen that shows fields in the h2-console. See screenshot below. In the SQL Statement window, type the line below ALTER TABLE MAPPING_RULE ALTER COLUMN MAPPING_EXCLUSIONS_ID BIGINT NULL Click Run The results should be as shown in the screen shot above: The command above Update Count: 0 (1 ms) To check this in the left side pane, Click on the + next to MAPPING_RULE Then click MAPPING_EXCLUSIONS_ID and you should see BIGINT with a NULL entry Restart the NCMSmartsAdapter service.
Related Information
See KB article https://kb.vmware.com/s/article/93926?lang=en_US as this KB article has the details for fixing the issue with SAM Binary limitation of 255. Which prevents the NCM Smarts Adapter from reading larger Smarts environments from the Smarts broker.
