技术文章 - CS379937

在 Servigistics Intellicus (Intellicus) 中配置数据库 (DB) 连接后出现错误:“无法创建连接。无法连接到数据库”

已修改: 06-Jun-2023   


注意:本文已使用机器翻译软件翻译,以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意, PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情,请单击 此处
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • 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]
      
这是文章 379937 的 PDF 版本,可能已过期。最新版本 CS379937