AnsweredAssumed Answered

Jasper Reports Failing - ORA-00904: "DWH_INV_SECURITY_V"."USER_UID": invalid identifier

Question asked by Kumu002 on Mar 3, 2016
Latest reply on Mar 5, 2016 by Kumu002

Recently I observed jasper reports failing with security column error as given below. The user_uid column is missing from table DWH_INV_SECURITY_V in PPM_DWH schema.

I'm not sure how this column gets created, I tried to reset parameters that did not help. Do I need to re import contents ?

 

 

Exception calling JRDataSource.next() for query  select * from ( select "DWH_INV_INVESTMENT"."INVESTMENT_NAME" as "DWH_INV_INVESTMENT_INVESTME1",

"DWH_INV_INVESTMENT"."INVESTMENT_MANAGER" as "DWH_INV_INVESTMENT_INVESTMENT_"

from "PPM_DWH"."DWH_INV_INVESTMENT" "DWH_INV_INVESTMENT"

inner join "PPM_DWH"."DWH_INV_SECURITY_V" "DWH_INV_SECURITY_V" on ("DWH_INV_INVESTMENT"."INVESTMENT_KEY" = "DWH_INV_SECURITY_V"."INVESTMENT_KEY")

where ("DWH_INV_SECURITY_V"."USER_UID" = 'admin') and "DWH_INV_INVESTMENT"."INVESTMENT_TYPE_KEY" = 'project' and "DWH_INV_INVESTMENT"."INVESTMENT_TYPE_KEY" = 'project'

group by "DWH_INV_INVESTMENT"."INVESTMENT_MANAGER", "DWH_INV_INVESTMENT"."INVESTMENT_NAME"

order by "DWH_INV_INVESTMENT_INVESTMENT_", "DWH_INV_INVESTMENT_INVESTME1"

) where ROWNUM <= 1000

 

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "DWH_INV_SECURITY_V"."USER_UID": invalid identifier

Outcomes