Operational Defect Database
BugZero updated this defect 53 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
VMware | 93926
NCM: NCM Smarts Adapter generates an error and cannot read all of the domains from the Smarts Broker.
Last update date:
3/27/2024
Affected products:
Smart Assurance - SMARTS
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Symptoms
When trying to synchronize the NCM Smarts Adapter to the broker, the client GUI for the NCM Smarts Adapter fails and generates this error.Value too long for column "AVAILABLE_SAMS BINARY(255)
Purpose
To provide a work around for Versions 10.1.11 and older and for 10.1.13.
Cause
"AVAILABLE_SAMS BINARY(255)" is too short to handle a large number Smarts domains as listed in the brcontrol command on the Smarts Broker.
Impact / Risks
High, if there are more characters than 255 the NCM Smarts adapter will not work to sync the Smarts domains to the adapter.
Resolution
Resolution Pending.
Workaround
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.Once connected you will see a screen that shows fields in the h2-console. See screenshot below.Click on the +plus sign on SMARTS_CONFIGURATION Scroll down and click on the +plus sign on AVAILABLE_SAMSIn the right-hand frame for the SQL statement will show a blank box.Type ALTER TABLE SMARTS_CONFIGURATION ALTER COLUMN AVAILABLE_SAMS Binary(4000) Then click Run.Note if the brcontrol output in larger Smarts environments exceeds 4000 binary characters, you will need to increase this number.Restart the NCM Smarts adapter and this will resolve the error and you should be able to proceed with adding the IP domains as described in the NCM Smarts Adapter documentation and delete any non-IP domains.
