1 Reply Latest reply on Sep 13, 2013 1:32 PM by ChrisJenkins-Oracle

    Timesten error





      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

          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.