Article - CS379937
Error: "Failed to create connection. Failed to connect to database" after configuring database (DB) connections in Servigistics Intellicus (Intellicus)
Modified: 06-Jun-2023
Applies To
- Servigistics Intellicus 19.1 N/A
Description
- Intellicus is not up after configuring DB connections
- Error message in ReportEngine.log
- 19695377:Failed to create connection. Failed to connect to database
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host XXX, port YYY has failed. Error: Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall. -
17635778:Failed to create connection. Failed to connect to database com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'svc_SPM_Servi_prdc130usaf_spmc130_Intellicus'. ClientConnectionId:38844662-80cd-4292-88f6-1efe2f345600 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232) ~[?:?] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:291) ~[?:?] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:111) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4376) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3188) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:61) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3151) ~[?:?] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1973) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1616) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1447) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:788) ~[?:?] at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1187) ~[?:?] at com.impetus.interaj.dataprovider.connection.DBConnection.createConnection(DBConnection.java:362) [?:?] at com.impetus.interaj.dataprovider.connection.DBConnection.connect(DBConnection.java:535) [?:?] at com.impetus.interaj.dataprovider.connection.DataSourceConnection.<init>(DataSourceConnection.java:127) [?:?] at com.impetus.interaj.dataprovider.connection.DBConnection.<init>(DBConnection.java:137) [?:?] at com.impetus.interaj.dataprovider.connection.SourceConnection.getInstance(SourceConnection.java:423) [?:?] at com.impetus.interaj.dataprovider.connection.SourceConnection$ConnectionCreatorWrapper.getInstance(SourceConnection.java:565) [?:?] at com.impetus.interaj.dataprovider.connection.ConnectionPool.getNewConnection(ConnectionPool.java:743) [?:?] at com.impetus.interaj.dataprovider.connection.DBConnectionPool.populatePoolBatch(DBConnectionPool.java:171) [?:?] at com.impetus.interaj.dataprovider.connection.ConnectionPool.initialize(ConnectionPool.java:321) [?:?] at com.impetus.interaj.dataprovider.connection.DBConnectionPool.initialize(DBConnectionPool.java:80) [?:?] at com.impetus.interaj.dataprovider.connection.ConnectionPoolContainer.reInitialize(ConnectionPoolContainer.java:956) [?:?] at com.impetus.interaj.dataprovider.connection.ConnectionPoolContainer.getConnectionProductName(ConnectionPoolContainer.java:1684) [?:?] at com.impetus.interaj.dataprovider.connection.ConnectionManager.getConnectionProductName(ConnectionManager.java:9471) [?:?] at com.impetus.interaj.dataprovider.DataProviderFactory.getRDBMSDataProvider(DataProviderFactory.java:536) [?:?] at com.impetus.interaj.dataprovider.DataProviderFactory.getRDBMSDataProviderForRepository(DataProviderFactory.java:495) [?:?] at com.impetus.interaj.dataprovider.DataProviderFactory.getRDBMSDataProviderForRepository(DataProviderFactory.java:445) [?:?] at com.impetus.interaj.dataprovider.DataProviderFactory.getRDBMSDataProviderForRepository(DataProviderFactory.java:439) [?:?] at com.impetus.interaj.security.SystemProperties.getSystemProperty(SystemProperties.java:176) [?:?] at com.impetus.interaj.globals.RequestInfo.getResponseMetaDataXML(RequestInfo.java:1730) [?:?] at com.impetus.interaj.providers.RequestManager.sendResponse(RequestManager.java:6329) [?:?] at com.impetus.interaj.providers.RequestManager.dispatchToPingHandler(RequestManager.java:3814) [?:?] at com.impetus.interaj.providers.RequestManager.runRequest(RequestManager.java:900) [?:?] at com.impetus.interaj.reportengine.RequestBroker.runRequest(RequestBroker.java:172) [?:?] at com.impetus.interaj.networkserver.Session.runSession(Session.java:129) [?:?] at com.impetus.interaj.networkserver.Session.startSession(Session.java:86) [?:?] at com.impetus.interaj.networkserver.WorkerThread.run(WorkerThread.java:173) [?:?] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131] Mon, 24 Oct 2022 21:53:48,105 CDT [SERVICE Thread 1] : 17635778:Report server could not write to socket. Apparently there is some network problem or client program has timed out or closed. If this error persists, contact your network administrator java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_131] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) ~[?:1.8.0_131] at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_131] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[?:1.8.0_131] at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[?:1.8.0_131] at java.io.DataOutputStream.flush(DataOutputStream.java:123) ~[?:1.8.0_131] at com.impetus.interaj.networkserver.NetworkIO.writeResponseBytes(NetworkIO.java:574) [?:?] at com.impetus.interaj.networkserver.NetworkIO.sendResponseMessage(NetworkIO.java:632) [?:?] at com.impetus.interaj.providers.RequestManager.sendResponse(RequestManager.java:6348) [?:?] at com.impetus.interaj.providers.RequestManager.dispatchToPingHandler(RequestManager.java:3814) [?:?] at com.impetus.interaj.providers.RequestManager.runRequest(RequestManager.java:900) [?:?] at com.impetus.interaj.reportengine.RequestBroker.runRequest(RequestBroker.java:172) [?:?] at com.impetus.interaj.networkserver.Session.runSession(Session.java:129) [?:?] at com.impetus.interaj.networkserver.Session.startSession(Session.java:86) [?:?] at com.impetus.interaj.networkserver.WorkerThread.run(WorkerThread.java:173) [?:?] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
- 19695377:Failed to create connection. Failed to connect to database
This is a printer-friendly version of Article 379937 and may be out of date. For the latest version click CS379937