Database Not Open? 
Author Message
 Database Not Open?

I'm serving several FMPro 5 databases on the web running FMPro 5 Unlimited
on a dedicated Win2k workstation machine. From time to time the web service
just stops working for one or more of the db's and delivers a Database Not
Open error message instead. This generally impacts only one of the active
databases, while the others continue to run correctly. When I check that db,
however, everything seems to be just fine in the FMPro client, I can search
or sort normally, speed is fine, but nothing I do seems to correct the
problem with the web service. The only fix is to close and then reopen the
problematic database - that always works. All the other databases remain
open and continue to work correctly throughout.

Sometimes the problem seems to occur when a web visitor runs a search that
produces zero hits - but not always. The db's range in size from 16,000
records (35Mb) down to 1600 records (10 Mb). When they're working correctly,
and you run a search on a fully indexed field, results are virtually
instantaneous.

I'm completely stumped as to why this is happening, and haven't seen
anything like it mentioned here or on any FM site. If it weren't for this
problem FM would be gold for me.

Version/architecture info: I am currently hosting these dbs on a separate
Win 2k Server machine running FMPro 5 Server - staff access the db's via
TCP/IP access using FMPro 5 clients, as does the FMPro 5 Unlimited web
server client. But I get the same problem even running a local copy of the
db's on the web server machine. I also used to get it using FMPro 4.0/4.1,
with or without hosting via FMPro 3.0 Server. Same with Win2k vs NT 4.0 -
I've had the same problem with both. I

I'm also currently using a default 'no password' password that limits access
to browse only - staff force open the password form at File Open using
ctrl-shift and then enter a full-access password at that point - the web
server client copy is opened the same way. But this problem also predates
our use of that system!

At present all web service is search and display only - no edits or new
record adds. The web pages were created initially using Home Page 3.0, but
have been extensibly customized - there are multiple web versions running
off of one or two of the databases.

Any ideas????
Thanks,
Ric Marshall



Mon, 18 Aug 2003 20:12:06 GMT
 Database Not Open?

Hi Ric

I have seen this "database not open" error several times on Macs running
FMU5 and Webstar. In some cases the problem was solved by degrading from
Webstar 4.3 to 4.0.But not on all Macs. The error also occured randomly,
even when nobody was making queries to the web engine. I have reported this
error to FileMaker and it is currently looked at in engeneering. I will post
the answer in the news group.. it might also be a known issue on the PC.

Allan


Quote:
> I'm serving several FMPro 5 databases on the web running FMPro 5 Unlimited
> on a dedicated Win2k workstation machine. From time to time the web
service
> just stops working for one or more of the db's and delivers a Database Not
> Open error message instead. This generally impacts only one of the active
> databases, while the others continue to run correctly. When I check that
db,
> however, everything seems to be just fine in the FMPro client, I can
search
> or sort normally, speed is fine, but nothing I do seems to correct the
> problem with the web service. The only fix is to close and then reopen the
> problematic database - that always works. All the other databases remain
> open and continue to work correctly throughout.

> Sometimes the problem seems to occur when a web visitor runs a search that
> produces zero hits - but not always. The db's range in size from 16,000
> records (35Mb) down to 1600 records (10 Mb). When they're working
correctly,
> and you run a search on a fully indexed field, results are virtually
> instantaneous.

> I'm completely stumped as to why this is happening, and haven't seen
> anything like it mentioned here or on any FM site. If it weren't for this
> problem FM would be gold for me.

> Version/architecture info: I am currently hosting these dbs on a separate
> Win 2k Server machine running FMPro 5 Server - staff access the db's via
> TCP/IP access using FMPro 5 clients, as does the FMPro 5 Unlimited web
> server client. But I get the same problem even running a local copy of the
> db's on the web server machine. I also used to get it using FMPro 4.0/4.1,
> with or without hosting via FMPro 3.0 Server. Same with Win2k vs NT 4.0 -
> I've had the same problem with both. I

> I'm also currently using a default 'no password' password that limits
access
> to browse only - staff force open the password form at File Open using
> ctrl-shift and then enter a full-access password at that point - the web
> server client copy is opened the same way. But this problem also predates
> our use of that system!

> At present all web service is search and display only - no edits or new
> record adds. The web pages were created initially using Home Page 3.0, but
> have been extensibly customized - there are multiple web versions running
> off of one or two of the databases.

> Any ideas????
> Thanks,
> Ric Marshall




Tue, 19 Aug 2003 05:32:05 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ORA-01219: database not open: queries allowed on fixed tables/views only

2. Web error message "database not open"

3. Help Win 2000 Database Not Open

4. Databases not open?

5. Database Not Open

6. "Database not open" in Web Comp

7. Database Not Open

8. Database not opened

9. Web 'Database not open' but it is !

10. "Database not open" ??? FMPro Web Gurus?

11. Repost: Web Companion failures - 'Database Not Open'???


 
Powered by phpBB® Forum Software