Wednesday, November 26, 2014

Attempt to connect to a data store that has been manually unloaded from R AM

Timesten in-memory Database :-

ttisql DSN_NAME

ttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.
connect "DSN=DSN_NAME";
707: Attempt to connect to a data store that has been manually unloaded from R
AM

The command failed.

This should be easy to resolve. A TimesTen datastore (physical database), which is what a DSN points at, has a property called its 'ramPolicy' The default value for this is inUse which means that TimesTen will load the datastore into memory whenever it is being used.

Solution :

ttAdmin -ramload DSN_NAME


Reference :-
1- Oracle OTN Forum here

Cheers

Osama ....

No comments:

Post a Comment