Oracle SQL Error when opening staffing page
search cancel

Oracle SQL Error when opening staffing page

book

Article ID: 261315

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Post upgrade of 16.1.0 to 16.1.1 on Oracle 19. We noticed an error in app-ca.log after clicking on MUX Staffing page. There has been no entries anymore and the app-ca.log shows error on sql querie which is running behind.

ERROR DATE ,902 [http-nio-8081-exec-14] odata.EntitiesResponseImpl (clarity:admin:7485068__F3AC57F1-EAC5-4225-A395-DA9A63D4CD4F:PPM_REST_API) Exception reading objects: inv
com.niku.union.persistence.PersistenceException: 
SQL error code: 904
Error message: ORA-00904: "TEAM____PRTEAM"."PRID": invalid identifier

Environment

Release : 16.1.1

Cause

Disabling the ANSI join feature which was a temporary workaround for DE65166

Resolution

Enabling After ANSI JOIN via the clarity toggle command:

admin toggle-feature S207096_ANSI_JOIN 1