This discussion is archived
1 Reply Latest reply: Sep 13, 2013 6:32 AM by ChrisJenkins RSS

Timesten error

Currently Being Moderated




Facing timesten error while  starting cache agent


ttadmin -cachestart dsn_name


*** [TimesTen][TimesTen ODBC Driver][TimesTen]TT0848: Recovery failed on 2 set(s) of data store files; the TimesTen user error log has more information -- file "db.c", lineno 10491, procedure "sbDbConnect"

*** ODBC Error = 08001, TimesTen Error = 848


Please help

  • 1. Re: Timesten error
    ChrisJenkins Guru
    Currently Being Moderated

    There was a problem recovering the Timesten database. The most common cause for this is that the database checkpoint files or (more commonly) transaction log files have been damaged or corrupted. For example sometimes people manually delete or move transaction log files if they are running low on disk space (which is an extremely bad idea of course).


    You need to look in the daemon log files (the field ttmesg.log and tterrors.log located in <tt_install_dir>/info) and see the exact messages produced when you try and startup this TimesTen database (which is happening implicitly when you start the cache agent). Those messages will give you more details on the cause. Depending on what they say it is possible that this database is now unrecoverable.




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