× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WDSCI-L
  3. October 2021

Re: iSphere source file search

Hi Matt,

You should be able to put the ini change back to ist original state, because the problem did not seem to be related to the Java cache issue.

Thomas.

-----Ursprüngliche Nachricht-----
Von: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> Im Auftrag von Matt Hopkins
Gesendet: Dienstag, 5. Oktober 2021 19:39
An: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Betreff: Re: [WDSCI-L] iSphere source file search

I hadn’t done that yet, so, yes, a new workspace fixed the issue. Currently have the ini fix in place. Should I be able to put the ini file back to it’s original state?

Matt Hopkins

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.