we are using integrity 10.7 version, and we have an issue with Deploy targets. In Windchill RV&S they are showing as offline, but the servers are up and running and the source code server & MKS agent in deploy servers also running. we tried restart services in source code server, but the issue not resolved. In server.log we found the following error.
2024-05-17 14:42:35,649 ERROR [mksis.IntegrityServer] * * * * ERROR * * * * (0):
----------------------------------------------------
Database COR089_MKSIntegritySrc must be configured with 'transform noise words' set to the value 1
Attempt to execute
exec sp_configure 'show advanced options', 1
failed with the error: User does not have permission to perform this action.
This is probably due to missing the permission ALTER SETTINGS.
Either grant the permission and restart the Integrity Server,
or configure manually by executing the following sql:
exec sp_configure 'show advanced options', 1;
GO
reconfigure
exec sp_configure 'transform noise words', 1;
GO
exec sp_configure 'show advanced options', 0;
reconfigure
If you proceed anyway, various operations may be incorrect.
----------------------------------------------------
2024-05-17 14:42:35,649 ERROR [mksis.IntegrityServer] * * * * ERROR * * * * (0): Unable to use database. Please fix the problems and restart
ERROR [mksis.IntegrityServer] * * * * ERROR * * * * (0): Unable to obtain a database connection: Error connecting to database. Could not create connection; - nested throwable: (java.sql.SQLException: Network error IOException: Connection refused: connect)
