This content has been marked as final. Show 3 replies
As the TT instance admin user, can you do
select cgname, cgowner, cgid from sys.cache_group where cgid = #####
where cgid is the number returned in the error e.g 7284. Do this before you alter the cachegroup state (ie when it should return a valid row) and then after the error is reported.
The CGID should not change because you change the state of the cachegroup and its entry should not be removed from sys.cache_group. The REFRESH_STATE column will show Y or N depending whether it is on or off.
I met another error when call ttcacheautorefresh as following:
6003: Lock request denied because of time-out
Details: Tran 6.32826333 (pid 9264) wants IS lock on table SYS.CACHE_GROUP. But tran 1.18571354 (pid 29574) has it in X (request was X). Holder SQL (alter cache group <cachegroup_name> set autorefresh state on)
8227: Cache group <user_name>.<cachegroup_name> not found