Recommended Connection Shows "An exception occurred while querying the Activity Graph service" on My Profile Page after Upgrading WebCenter (Doc ID 1574393.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading WebCenter Portal from 11.1.1.5.0 to 11.1.1.7.0 when Navigating to
My profile -> Connections, the
Recommended Connection section shows the following:

"An exception occurred while querying the Activity Graph service. Please contact your system administrator."

When going to Activity Graph Schedule and Status page after login and trying to perform a Full Rebuild it shows the following error:

"The Activity Graph work thread is terminating because of a serious error. Error Message: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges"

WC_Utilities-diagnostic.log shows the following exception:

[2013-07-23T18:55:34.260+05:30] [WC_Utilities] [ERROR] [WCS-53048] [oracle.webcenter.activitygraph.ag-control] [tid: ActivityGraph Work Thread] [userId: wlsadmin] [ecid: e3c863034991983c:-54f0586e:1400a4e38c4:-8000-0000000000003801,1:19144] [APP: activitygraph-engines#11.1.1.4.0] Activity Graph work thread is terminating with a serious error.[[
oracle.webcenter.activitygraph.ResultStorageException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

at oracle.webcenter.activitygraph.cfe.similarity.impl.SimilarityStoreScoreAcceptor.close(SimilarityStoreScoreAcceptor.java:91)
at oracle.webcenter.activitygraph.cfe.impl.CollaborativeFilteringEngine.calculateSimilarityScores(CollaborativeFilteringEngine.java:32)
at oracle.webcenter.activitygraph.cfe.impl.CollaborativeFilteringEngine.calculateSimilarityScores(CollaborativeFilteringEngine.java:66)
at oracle.webcenter.activitygraph.cfe.impl.CollaborativeFilteringEngine.calculateSimilarityScores(CollaborativeFilteringEngine.java:80)
at oracle.webcenter.activitygraph.cfe.impl.CollaborativeFilteringEngine.calculateAllSimilarityScores(CollaborativeFilteringEngine.java:94)
at oracle.webcenter.activitygraph.control.ActivityGraphWorkThread.runCFE(ActivityGraphWorkThread.java:363)
at oracle.webcenter.activitygraph.control.ActivityGraphWorkThread.runTask(ActivityGraphWorkThread.java:323)
at oracle.webcenter.activitygraph.control.ActivityGraphWorkThread.run(ActivityGraphWorkThread.java:108)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at oracle.webcenter.activitygraph.util.DB.executeUpdate(DB.java:311)
at oracle.webcenter.activitygraph.util.DB.integerUpdate(DB.java:297)
at oracle.webcenter.activitygraph.tablegen.OracleTableGenerator.createSynonym(OracleTableGenerator.java:95)
at oracle.webcenter.activitygraph.tablegen.OracleTableGenerator.swapSynonym(OracleTableGenerator.java:83)
at oracle.webcenter.activitygraph.tablegen.TableGenerationManager.swapSynonym(TableGenerationManager.java:1056)
at oracle.webcenter.activitygraph.similaritystore.SimilarityStoreManager.swapSimTableSynonym(SimilarityStoreManager.java:58)
at oracle.webcenter.activitygraph.similaritystore.impl.WritingSimilarityStore.createIndicesAndSwapSynonym(WritingSimilarityStore.java:137)
at oracle.webcenter.activitygraph.similaritystore.impl.WritingSimilarityStore.close(WritingSimilarityStore.java:122)
at oracle.webcenter.activitygraph.cfe.similarity.impl.SimilarityStoreScoreAcceptor.close(SimilarityStoreScoreAcceptor.java:88)
... 7 more

]]

 

Steps to Reproduce
==================
1. Upgrade WebCenter Portal from 11.1.1.5.0 to 11.1.1.7.0

2. Navigate to
My profile -> Connections tab

Notice the error under Recommended Connections

3. Access
http://<utilities_host>:<utilities_port>/activitygraph-engines

4. Login

5. Click Start with

Run once now

-> Full Rebuild

selected

6. Notice the error

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