技术文章 - CS379937
在 Servigistics Intellicus (Intellicus) 中配置数据库 (DB) 连接后出现错误:“无法创建连接。无法连接到数据库”
已修改: 06-Jun-2023
适用于
- Servigistics Intellicus 19.1 N/A
说明
- 配置数据库连接后 Intellicus 未启动
- ReportEngine.log 中的错误消息
- 19695377:无法创建连接。连接数据库失败
com.microsoft.sqlserver.jdbc.SQLServerException:与主机 XXX、端口 YYY 的 TCP/IP 连接失败。错误:连接超时:没有更多信息。验证连接属性。确保 SQL Server 实例正在主机上运行并在端口上接受 TCP/IP 连接。确保与该端口的 TCP 连接未被防火墙阻止。 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:无法创建连接。连接数据库失败
这是文章 379937 的 PDF 版本,可能已过期。最新版本 CS379937