This discussion is archived
3 Replies Latest reply: Nov 23, 2012 2:07 AM by jspalmer RSS

Error while refreshing cachegroup

880143 Newbie
Currently Being Moderated
Hi all,
I use Timesten 11.2.1.8, and have a read-only cache-group of a table, state is on.

- When I execute statement to refresh data from Oracle to TimesTen:
call ttcacheautorefresh('<user_name>','<cache_group_name>', 1);
I met error:
*5039: An error occurred while refreshing <cache_group_name>: ftSchedulerGetRefreshStats: cannot find cache group with cgID 7284*

- I searched in Error Messages and SNMP traps, this is Internal Error :(

- P/s: When I alter cachegroup's state from to off, then on, and run 'call ttcacheautorefresh()' it's ???

Can anyone help?

Thanks!
  • 1. Re: Error while refreshing cachegroup
    jspalmer Journeyer
    Currently Being Moderated
    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.
  • 2. Re: Error while refreshing cachegroup
    880143 Newbie
    Currently Being Moderated
    Hi all,
    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

    Any help?

    Thanks
  • 3. Re: Error while refreshing cachegroup
    jspalmer Journeyer
    Currently Being Moderated
    Are you pasting in the actual error text? I need to know whether the error is actually displaying the string

    <user_name>.<cachegroup_name>

    or whether you are substituting this in to hide the actual username and cachegroup name for security purposes. That's fine but we need to be certain.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points