WebCenter Content (WCC) 11g and Secure Enterprise Search (SES) 11g; How to Recover Crawling When the EQ_SYS and EQ_TEST Users Expire

(Doc ID 1439647.1)

Last updated on MAY 19, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When running a crawl from SES to the WebCenter Content server (formerly UCM, Universal Content Management), that crawl may fail. The SES log will show an error such as:

14:48:25:351 INFO main Crawling started at 3/22/12 2:48 PM
14:48:26:428 ERROR main java.sql.SQLException: ORA-28001: the password has expired

14:48:26:531 ERROR main EQG-30050: Could not connect to database: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mydb.us.mycompany.com)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ses1.mydb.us.mycompany.com)))
14:48:26:531 ERROR main ORA-28001: the password has expired
java.sql.SQLException oracle.jdbc.driver.SQLStateMapping:newSQLException:70 oracle.jdbc.driver.DatabaseError:newSQLException:131 oracle.jdbc.driver.DatabaseError:throwSqlException:204 oracle.jdbc.driver.T4CTTIoer:processError:455 oracle.jdbc.driver.T4CTTIoer:processError:406


And if the passwords are not reset correctly the following error may occur:

16:30:08:812 ERROR main EQG-30046: Invalid user name or password for user EQ_TEST
16:30:11:928 ERROR main EQG-30046: Invalid user name or password for user EQ_TEST
16:30:11:929 ERROR main ORA-01017: invalid username/password; logon denied

at oracle.search.crawler.AttributeManager.initConnection(AttributeManager.java:272)
at oracle.search.crawler.WebCrawler.init(WebCrawler.java:730)
at ImtCrawler.run(ImtCrawler.java:1992)
at ImtCrawler.main(ImtCrawler.java:538)

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