Product: TIBCO Spotfire®
Not able to see the node under 'Untrusted nodes' tab.
In Spotfire version 7.5 and higher, after installation of Spotfire server and Node manager, the Spotfire Server and the Node manager services are started up but you can't see the node under 'Untrusted nodes' to trust.
Below errors message appears multiple times in the server.log file.
Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_NODES_SITE_ID". The conflict occurred in database "<DB name>", table "dbo.SITES", column 'SITE_ID'.
>> Check if any invalid node is listed in the Spotfire database by running the below command, refer below screenshot.
<Spotfire Server Install>\tomcat\bin\config list-nodes
>> If you see any nodes which are invalid (Has Valid = No) you can delete the nodes by using the 'config delete-node' command.
<Spotfire Server Install>\tomcat\bin\config delete-node --id=<id of the node that should be deleted>
>> Restart the Spotfire Server service and Node Manager service. Manual link: