Well, today I am still getting the connection not found error. I tried all
the 'fixes' again this morning. Nothing seems to be working. Does anyone
have more suggestions?
This is from the .log file:
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:32.145
!MESSAGE *** Source file search, setSearchElements(): Could not insert
search elements into FNDSTRI ***
!STACK 0
java.sql.SQLException: Communication link failure. (Connection reset)
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:610)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:568)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.sendAndReceive(AS400JDBCConnectionImpl.java:3146)
at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1575)
at
com.ibm.as400.access.AS400JDBCStatement.executeUpdate(AS400JDBCStatement.java:2587)
at
biz.isphere.core.sourcefilesearch.SearchElement.setSearchElements(SearchElement.java:150)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.net.SocketException: Connection reset
at
java.net.SocketInputStream.read(SocketInputStream.java:221)
at
java.net.SocketInputStream.read(SocketInputStream.java:152)
at
com.ibm.as400.access.DataStream.readFromStream(DataStream.java:54)
at
com.ibm.as400.access.ClientAccessDataStream.construct(ClientAccessDataStream.java:61)
at
com.ibm.as400.access.AS400ThreadedServer.run(AS400ThreadedServer.java:359)
at java.lang.Thread.run(Thread.java:822)
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:32.152
!MESSAGE *** Source file search, setSearchElements(): Could not insert
search elements into FNDSTRI ***
!STACK 0
java.sql.SQLException: The connection does not exist.
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:436)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.checkOpen(AS400JDBCConnectionImpl.java:502)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:858)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:751)
at
biz.isphere.core.sourcefilesearch.SearchElement.setSearchElements(SearchElement.java:149)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:32.152
!MESSAGE *** Source file search, setSearchElements(): Could not insert
search elements into FNDSTRI ***
!STACK 0
java.sql.SQLException: The connection does not exist.
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:436)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.checkOpen(AS400JDBCConnectionImpl.java:502)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:858)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:751)
at
biz.isphere.core.sourcefilesearch.SearchElement.setSearchElements(SearchElement.java:149)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:32.152
!MESSAGE *** Source file search, setSearchElements(): Could not insert
search elements into FNDSTRI ***
!STACK 0
java.sql.SQLException: The connection does not exist.
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:436)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.checkOpen(AS400JDBCConnectionImpl.java:502)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:858)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:751)
at
biz.isphere.core.sourcefilesearch.SearchElement.setSearchElements(SearchElement.java:149)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:32.152
!MESSAGE *** Source file search, setSearchElements(): Could not insert
search elements into FNDSTRI ***
!STACK 0
java.sql.SQLException: The connection does not exist.
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:436)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.checkOpen(AS400JDBCConnectionImpl.java:502)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:858)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.createStatement(AS400JDBCConnectionImpl.java:751)
at
biz.isphere.core.sourcefilesearch.SearchElement.setSearchElements(SearchElement.java:149)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:34.085
!MESSAGE *** Source file search: Unexpected connection error. ***
!STACK 0
java.sql.SQLException: The connection does not exist.
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:436)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.checkOpen(AS400JDBCConnectionImpl.java:502)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2294)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2083)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2078)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.getStatus(SearchExec.java:320)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:128)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
!ENTRY biz.isphere.core 4 4 2021-10-05 08:32:34.085
!MESSAGE *** Could not cancel host job of source file search ***
!STACK 0
java.sql.SQLException: The connection does not exist.
at
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:887)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:436)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.checkOpen(AS400JDBCConnectionImpl.java:502)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2294)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2083)
at
com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2078)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.cancelJob(SearchExec.java:375)
at
biz.isphere.core.sourcefilesearch.SearchExec$Search.run(SearchExec.java:137)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
On Mon, Oct 4, 2021 at 4:39 PM Matt Hopkins <hopkins15531@xxxxxxxxx> wrote:
Thanks.
The clear cache fix didn’t work, but the ini change did.
Matt Hopkins
On Oct 2, 2021, at 4:11 AM, fhildebrandt@xxxxxxxxxxxxxxx wrote:
Forgot the second link.
https://archive.midrange.com/wdsci-l/202109/msg00038.html
-----Ursprüngliche Nachricht-----
Von: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> Im Auftrag von Matt
Hopkins
Gesendet: Freitag, 1. Oktober 2021 22:30
An: RDi List @ Midrange <wdsci-l@xxxxxxxxxxxxxxxxxx>
Betreff: [WDSCI-L] iSphere source file search
Just today my RDi started getting an error message when I try to do an
iSphere source file search. I am getting “The connection does not exist”.
Everything else seems to work. I download source etc from that system
without any problems, it just appears to be the search having the
connection issue.
Does anyone have any idea why?
I’m on 9.6.0.11 of RDi and 4.1.0r of iSphere. Windows 10.
Matt Hopkins
--
midrange.com
