SES Crawler Is Getting Stuck When Querying The People/Users inside LDAP/OID and Generating "org.eclipse.persistence.exceptions.DatabaseException" and "java.lang.NullPointerException" (Doc ID 1386922.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.4.0 to 11.1.1.5.4 [Release 11g]
Information in this document applies to any platform.

Symptoms

WebCenter uses SES and LDAP/OID as backend.
There are performance issues with the SES crawler for Webcenter Spaces, and the crawl fails with the following error messages:

WC_Spaces.out:
 
<Sep 16, 2011 11:17:02 AM EST> <Warning> <oracle.webcenter.framework.service> 
 <BEA-000000> <2011-09-16 11:17:02.365--UnitOfWork(455161072)--Exception 
 [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): 
 org.eclipse.persistence.exceptions.DatabaseException 
 Internal Exception: java.sql.SQLException: Statement has already been closed 
Error Code: 0 
 Query: ReadAllQuery(name="JpaActorDetailImpl.findActorDetailByActorIDOrName" 
 referenceClass=JpaActorDetailImpl sql="SELECT * FROM (SELECT /*+ FIRST_ROWS 
 */ a.*, ROWNUM rnum  FROM (SELECT ACTIVITY_ACTOR_DETAIL_ID AS a1, EMAIL AS 
 a2, STATUS AS a3, ACTOR_ID AS a4, DEPARTMENT AS a5, MANAGER_ID AS a6, 
 UPDATED_ON AS a7, DISPLAY_NAME AS a8, ACTOR_NAME AS a9, JOB_TITLE AS a10, 
 VERSION AS a11 FROM WC_AS_ACTOR_DETAIL WHERE ((ACTOR_ID = ?) OR (ACTOR_NAME = 
 ?))) a WHERE ROWNUM <= ?) WHERE rnum > ?")
 
WC_Spaces-diagnostics.log:

[2011-09-16T10:56:46.566+10:00] [WC_Spaces] [TRACE:32] [] 
 [oracle.webcenter.peopleconnections.profile.model.crawler.ProfileServiceCrawle 
 r] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default 
 (self-tuning)'] [userId: wcsuser] [ecid: 
 004fGHEUu9ZF4EO5Qjx0id00014t000PAD,0:1] [SRC_CLASS: 
 oracle.webcenter.peopleconnections.profile.model.crawler.ProfileServiceCrawler 
 ] [APP: webcenter#11.1.1.4.0] [SRC_METHOD: populateActivityStreamingTable] 
 [URI: /rsscrawl] [[ 
 java.lang.NullPointerException 
 at  
 org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMe 
 chanism.prepareBatchStatements(ParameterizedSQLBatchWritingMechanism.java:184) 
 . 
 at 
 org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMe 
 chanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:13 
 8) 
at 
 org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMe 
 chanism.appendCall(ParameterizedSQLBatchWritingMechanism.java:83) 
 at 
 org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteC 
 all(DatabaseAccessor.java:560) 
 at 
 org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(D 
 atabaseAccessor.java:526) 
 at 
 org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(Abstract 
 Session.java:980) 
 at 
 org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeC 
 all(DatasourceCallQueryMechanism.java:206) 
 at 
 org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeC 
 all(DatasourceCallQueryMechanism.java:192) 
 at 
 org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.updateOb 
 ject(DatasourceCallQueryMechanism.java:747) 
 at 
 org.eclipse.persistence.internal.queries.StatementQueryMechanism.updateObject( 
 StatementQueryMechanism.java:430) 
 at 
 org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.updateObjectFo 
 rWriteWithChangeSet(DatabaseQueryMechanism.java:1144)
 
 
 
 
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms