We receive the following error any time we try to edit a portlet Filter Field in Admin. This is happening for all portlets: existing and custom.
This is happening on the Admin side only. Portlets can still be configured by users.
This is preventing the development and configuration of portlets
com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: ERROR: relation "odf_ca_bc_customer_site" does not exist Position: 399 SQL Text: SELECT Q.SUPPORT_SITE_DB_ID AS SUPPORT_SITE_DB_ID, Q.SUPPORT_SITE_NAME AS SUPPORT_SITE_NAME, Q.SUPPORT_SITE_ID AS SUPPORT_SITE_ID, Q.CLASSIFICATION AS CLASSIFICATION FROM ( SELECT DISTINCT SITE.ID SUPPORT_SITE_DB_ID, SITE.NAME SUPPORT_SITE_NAME, SITE.BC_SUPPORT_SITE_ID SUPPORT_SITE_ID, ACCT_CLASS.NAME CLASSIFICATION FROM ODF_CA_BC_CUSTOMER_SITE SITE JOIN INV_INVESTMENTS ACCT ON ACCT.ID = SITE.BC_ACCOUNT JOIN ODF_CA_BC_ACCOUNTS ODFA ON ODFA.ID = ACCT.ID JOIN ODF_CA_BC_LICENSEE LIC ON LIC.ID = SITE.BC_LICENSEE -- Account Classification -- LEFT JOIN CMN_LOOKUPS_V ACCT_CLASS ON ACCT_CLASS.LOOKUP_CODE = ODFA.BC_ACCOUNT_CLASS AND ACCT_CLASS.LOOKUP_TYPE = 'BC_ACCOUNT_CLASS' AND ACCT_CLASS.LANGUAGE_CODE = 'en' WHERE ? = ACCT.ID ) Q WHERE 1=? and 1=1 and 2 = 2
Release : 15.9
Component : CA PPM SAAS STUDIO
There was an inactive lookup attribute that was referencing old custom object which was deleted. Deleted the attribute and lookup and that fixed the issue.