Re: iSphere source file search

On Oct 5, 2021, at 12:55 PM, Tools/400 <thomas.raddatz@xxxxxxxxxxx> wrote:

Hi Matt,

So it worked after having changed the ini file, yesterday? And it is broken again, today? Strange!

The point is, that iSphere did first get a JDBC connection and could create a JDBC statement but could not execute it (SearchElement.java:150).

The other errors at SearchElement.java:149 must be a result of the first error that resetted (I assume closed) the connection.

Did you already try (testwise) a new workspace with a new connection? If not, may you try that?

Thomas.

Am 05.10.2021 um 14:47 schrieb Matt Hopkins:
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
--

--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com