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
Release : 16.1.1
Disabling the ANSI join feature which was a temporary workaround for DE65166
Enabling After ANSI JOIN via the clarity toggle command:
admin toggle-feature S207096_ANSI_JOIN 1