When trying to query FileNet with below query
SELECT d.To,d.Cc,d.[From],d.Subject,d.[ReceivedOn],d.[SentOn],d.DocumentTitle,d.MimeType,d.StorageLocation,d.ContentSize,d.DateContentLastAccessed,d.Creator,d.LastModifier,d.DateLastModified,d.Name,d.Id,d.DateCreated FROM Document d WHERE [ICCFrom] LIKE '%[email protected]%' AND [ICCMailDate] > 20210101T235959Z
String query ="Above query statement";
SearchSQL sql = new SearchSQL(query);
SearchScope scope = new SearchScope(objectStore);
IndependentObjectSet s = scope.fetchObjects(sql, pageSize, null, true); > // Get the page iterator PageIterator iterator = s.pageIterator();
I am getting the below error log.
[INFO ] 2021-05-06 10.04.19.856 [Thread-158] [1571783] filenet_error.api.com.filenet.apiimpl.util.SessionHandle 177- An exception has occurred while processing an executeSearch request. The search request is being retried(1) of (1) times. javax.net.ssl.SSLException: Connection reset at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_272] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_272]
Caused by: javax.net.ssl.SSLException: Connection reset at sun.security.ssl.Alert.createSSLException(Alert.java:127) ~[?:1.8.0_272]
Suppressed: java.net.SocketException: Broken pipe (Write failed) at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_272]
[DEBUG] 2021-05-06 10.04.19.858 [Thread-158] [1571783] filenet_tracing.api.detail.com.filenet.apiimpl.util.SessionHandle 180- com.filenet.api.exception.EngineRuntimeException: FNRCT0042E: TRANSPORT_WSI_NETWORK_ERROR: A network error occurred when processing a Web service request or response. See the nested exception for specific details. See full stack trace for details. Message: Connection reset Duration 300,265 milliseconds.
Below is the java code I used to get instances of Objectstore.
// Get the connection
Connection conn = Factory.Connection.getConnection(uri);
// Get the user context
UserContext uc = UserContext.get();
uc.pushSubject(UserContext.createSubject(conn, username, password, getJAASStanzaName(configuration)));
// Get the default domain
Domain domain = Factory.Domain.getInstance(conn, null);
// Get an object store
objectStore = Factory.ObjectStore.fetchInstance(domain, configuration.getConfiguration(Configuration.OBJECT_STORE_NAME), null);`
can anyone help me solve the issue.?
link to doc Creating a Runtime Configuration