Clarity: PMBOK portlets generate Error 500 message

book

Article ID: 50062

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Description:

We have installed the PMBOK accelerator in our Clarity 12.1 environment using Oracle.

We saw that it contains many portlets that came with its installation. But on trying to see these portlets in action, we are getting the error:

Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Solution:

The application log file shows the following details:

ERROR 2011-11-01 08:28:04,570 [http-2840-8] dal.NSQLClient
(admin:74970508__df03be9:PMBOK_Exec_Portlets) Unable to retrieve NSQL cube.NSQLException was thrown.com.niku.union.persistence.nsql.NSQLException:
com.niku.union.persistence.PersistenceException:
SQL error code: 1762
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01762: vopdrv:
view query block not in FROM

From Oracle, this is an exception error message:

ORA-01762: vopdrv: view query block not in FROM
Cause: This is an internal error message not normally issued.
Action: Contact Oracle Support Services.

RESOLUTION:

Obtain from Oracle a patch for bug 9620994 and have your Database Administrator implement this patch.

Keywords: CLARITYKB, ora-01762

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: