Roy,

<< Just thinking: if the config was in-memory and the PC not shut down it might >>

Yes, it's possible, but not likely because if Adam is running JOBs then he has to be using C/S and it's not likely that someone is using in-memory configuration files with a server (I don't even know if that is possible, if it is I don't know how to set it). Anyway, if by change that's what happened it's still using 2 different config files as we said before.

--
Fernando Dias
[Team Elevate]

Fernando

>Yes, it's possible, but not likely because if Adam is running JOBs then he has to be using C/S and it's not likely that someone is using in-memory configuration files with a server (I don't even know if that is possible, if it is I don't know how to set it).

Neither do I

>Anyway, if by change that's what happened it's still using 2 different config files as we said before.

Dead right but I'm just trying to come up with weird scenarios that would account for data hanging around.

Roy

I am accessing a remote server on an Amazon cloud machine.

My EDBMgr connects via the EDBSRVR on this machine, and runs the statement. This statement does not find the STORE.

A JOB, being run by the same instance of EDBSRVR on the same machine (there is only 1 instance of EDBSRVR on this machine) does find the STORE.

I am confused as to how this situation could be accessing 2 config files.

Adam,

Now I am confused
So tell me, there are 2 EDB servers running; one on a remote computer and
another in your local computer, is that right?

--
Fernando Dias
[Team Elevate]

Adam

>I am accessing a remote server on an Amazon cloud machine.
>
>My EDBMgr connects via the EDBSRVR on this machine, and runs the statement. This statement does not find the STORE.
>
>A JOB, being run by the same instance of EDBSRVR on the same machine (there is only 1 instance of EDBSRVR on this machine) does find the STORE.
>
>I am confused as to how this situation could be accessing 2 config files.

I'd check Amazon's Ts&Cs to see if they guarantee to only hold one copy of your data and serve that up to you on request or if there are multiple copies that they are all fully synced.

Never having used the cloud I have no idea if its possible for them to be supplying different data to two different instances of software but I wouldn't be surprised.

Roy Lambert [Team Elevate]

>>So tell me, there are 2 EDB servers running; one on a remote computer and
>>another in your local computer, is that right?

No. I am not running anything local at all. I am accessing a cloud computer through a single instance of EDBSRVR running on the cloud. This instance is running the JOBs, or being accessed by me through EDBMgr.

The problem seems to have stopped ... I still think it probably had something to do with EDB holding on to lists of STORES which had previously been deleted ... but I can't say for sure.

Adam,

I have been thinking, even if you don't have a local EDB server running you could have a that "ghost" store configured as a remote store in your local configuration file at some point... Does that make sense to you?

A *remote store* in your local session might be the same store that is considered a *local store* for your remote session.
I'm not saying it's your case, I'm saying I have done it a few times .

--
Fernando Dias
[Team Elevate]

Adam,

<< The problem seems to have stopped ... I still think it probably had
something to do with EDB holding on to lists of STORES which had previously
been deleted ... but I can't say for sure. >>

While it's always possible that there's a bug, EDB deals with stores in the
same way as databases.  Before accessing such a table, EDB does a quick read
of the configuration file header to determine if the configuration has
changed at all, and if so, it recreates the list used by the system
information queries on the Stores table.

I'll check it out, though and see if I can replicate it here.

Tim Young
Elevate Software
www.elevatesoft.com

Adam,

I checked out this issue in detail by creating the following job that ran
every 4 minutes:

BEGIN
DECLARE StoreCrsr CURSOR FOR StoreStmt;
DECLARE StoreName VARCHAR DEFAULT '';
PREPARE StoreStmt FROM
' SELECT
Name
FROM Configuration."Stores" ';

OPEN StoreCrsr;
FETCH FIRST FROM StoreCrsr ('Name') INTO StoreName;
WHILE NOT EOF(StoreCrsr) DO
 EXECUTE IMMEDIATE 'BACKUP DATABASE TestStore AS "TestStore" TO STORE
'+QUOTEDSTR(StoreName,'"')+' INCLUDE CATALOG';
 FETCH NEXT FROM StoreCrsr ('Name') INTO StoreName;
 END WHILE;

END

I had one store defined as a remote store, which causes an error when
attempting the above backup.  I then let it run once, error out, and then
deleted the remote store.  I then let it attempt the job execution again (it
will retry every 30 seconds during the scheduled time period) and it ran
fine.  So, I can't duplicate what you're seeing, and would probably say that
you've got a "multiple configuration" or "AWS" issue.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com