Some connections shows error "Component: Result Cache Message: ORA-00904: : invalid identifier in table resultCacheStatus:
Message: ORA-00904: : invalid identifier in table resultCacheStatus"
Component: Result Cache
Message:
ORA-00904: : invalid identifier
in table resultCacheStatus
Details:
Call stack:
00978FF6 (Spotlight.00577FF6) 9.5.1.555
009809FF (Spotlight.0057F9FF) 9.5.1.555
009B4B8E (Spotlight.005B3B8E) 9.5.1.555
009FE6E5 (Spotlight.005FD6E5) 9.5.1.555
009FE994 (Spotlight.005FD994) 9.5.1.555
01218F51 (Spotlight.00E17F51) 9.5.1.555
012193E6 (Spotlight.00E183E6) 9.5.1.555
0121930C (Spotlight.00E1830C) 9.5.1.555
0090D38D (Spotlight.0050C38D) 9.5.1.555
0090D20B (Spotlight.0050C20B) 9.5.1.555
00906C42 (Spotlight.00505C42) 9.5.1.555
0090C520 (Spotlight.0050B520) 9.5.1.555
0090C14E (Spotlight.0050B14E) 9.5.1.555
00975156 (Spotlight.00574156) 9.5.1.555
0090F89D (Spotlight.0050E89D) 9.5.1.555
0090ACC6 (Spotlight.00509CC6) 9.5.1.555
0162098B (Spotlight.0121F98B) 9.5.1.555
0162365E (Spotlight.0122265E) 9.5.1.555
01622C80 (Spotlight.01221C80) 9.5.1.555
00969337 (Spotlight.00568337) 9.5.1.555
008FDB67 (Spotlight.004FCB67) 9.5.1.555
01651C6B (Spotlight.01250C6B) 9.5.1.555
006C8A27 (Spotlight.002C7A27) 9.5.1.555
006C9D96 (Spotlight.002C8D96) 9.5.1.555
005A807D (Spotlight.001A707D) 9.5.1.555
005A7327 (Spotlight.001A6327) 9.5.1.555
005AB92D (Spotlight.001AA92D) 9.5.1.555
Check whether the Spotlight user has the following privilege for those dbs displaying errors for the "ResultCache" Home Page controls
grant execute on sys.dbms_result_cache to <username>;
Also check if the user has “dba” role granted to them.
