Database down

system · October 21, 2004, 2:07pm

I believe there is an unload/re-load type process that decomposes the tables into files and then loads them into a new database. With most DB's this is the traditional way to "compress" and restructure them. If I recall from doing it once (in the 4.0 to 5.0 upgrade?) it can take a fair bit of time. (days?) for large databases. Also, there is not much "deleting" available in Vantage, anything with a reference to it tends to stay there forever. But reloading could make thing run a bit faster.
-Todd C.

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, October 21, 2004 12:56 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Database down

For any of you still on 3.0 or 4.0, I just confirmed that those Vantage
versions using Progress prior to 9.1c will not allow file sizes of over 2.0
GB.

Now my next question. I will have time to upgrade (sooner than later) but
are progress db's like Exchange DB, once expanded they stay that size?
Will they shrink if non-used data is deleted? Can they be compressed, or
reduced?

TIA.

Jim Moore

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, October 21, 2004 12:34 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

Cliff,
Thanks. From the looks of an earlier post, it looks like I had better rush
up my upgrade to 6.1 and 8.0. From what I just read in another post, 4.0
will not allow db files over 2.0 GB. If I understand that post correctly,
releases prior to 9.1C will not go above 2.0 GB. I guess it is good I got
an early warning!

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Thursday, October 21, 2004 12:22 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

Jim
I on W2K Vantage 6.0 - my database is 4.7 GB. Not an OS problem.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129kaacui/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1098467742/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=407387257>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

system · October 21, 2004, 11:40am

Been trying to get thru Vantage Tech support for 30 minutes and no one will
answer the phone

Any ideas what is going on with my 5.2 database?

10:32:17 SRV 2: SYSTEM ERROR: Attempted to exceed maximum size on file
E:\Epic52\Vantage\Db\vantage.d1. (9452)

10:32:17 SRV 2: SYSTEM ERROR: Unable to extend database within area
Schema Area. (8897)

[Non-text portions of this message have been removed]

system · October 21, 2004, 11:49am

I would guess you have reached the 2 GB db file size limitation. I
cannot advise on extending it. Maybe someone else can. Otherwise you
should stay on hold with support until you get someone.

-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Thursday, October 21, 2004 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Database down

Been trying to get thru Vantage Tech support for 30 minutes and no one
will answer the phone

Any ideas what is going on with my 5.2 database?

10:32:17 SRV 2: SYSTEM ERROR: Attempted to exceed maximum size on
file
E:\Epic52\Vantage\Db\vantage.d1. (9452)

10:32:17 SRV 2: SYSTEM ERROR: Unable to extend database within area
Schema Area. (8897)

[Non-text portions of this message have been removed]

------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

system · October 21, 2004, 11:50am

Seems the database reaching OS's file size limitation.
Did you extend your database?

system · October 21, 2004, 11:53am

I thought I did
How do you do that

system · October 21, 2004, 11:59am

we extended our db a couple of weeks ago, I think it was pretty easy.

Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...

-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Thursday, October 21, 2004 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Database down

Been trying to get thru Vantage Tech support for 30 minutes and no one will
answer the phone

Any ideas what is going on with my 5.2 database?

10:32:17 SRV 2: SYSTEM ERROR: Attempted to exceed maximum size on file
E:\Epic52\Vantage\Db\vantage.d1. (9452)

10:32:17 SRV 2: SYSTEM ERROR: Unable to extend database within area
Schema Area. (8897)

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129p39aks/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1098459620/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=773748479>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).

[Non-text portions of this message have been removed]

system · October 21, 2004, 12:04pm

Seems the database reaching OS's file size limitation.
Did you extend your database?

system · October 21, 2004, 12:04pm

I did last couple months. Michael sent me the instruction.

system · October 21, 2004, 12:16pm

What is the file size limit for W2K Server using NTFS, it's way above 2 GB,
correct?
That's what I have and was wondering? Still on Vantage 4.0 also, in case
that matters.
I just want to head off the same problem if I'm close to the limit. I'm at
1.5 GB now.

Thanks,
Jim Moore

-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Thursday, October 21, 2004 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Database down

Seems the database reaching OS's file size limitation.
Did you extend your database?

system · October 21, 2004, 12:27pm

I do not think it is a os limitation it is a setting in progress that limits
to 2gb then you run a utility to increase over that limit.

Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, October 21, 2004 12:17 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

What is the file size limit for W2K Server using NTFS, it's way above 2 GB,
correct?
That's what I have and was wondering? Still on Vantage 4.0 also, in case
that matters.
I just want to head off the same problem if I'm close to the limit. I'm at
1.5 GB now.

Thanks,
Jim Moore

-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Thursday, October 21, 2004 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Database down

Seems the database reaching OS's file size limitation.
Did you extend your database?

system · October 21, 2004, 12:29pm

You are correct
Vatnage Tech got thru finally
Had to run an extend command on the database
Now I am up and running

Crazy

system · October 21, 2004, 12:37pm

At 12:29 PM 10/21/2004, you wrote:

Anyone have documentation on how to do this that they would share?

-Wayne

[Non-text portions of this message have been removed]

system · October 21, 2004, 1:05pm

it is amazing to me how much I have learned through this forum.

Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...

-----Original Message-----
From: meco_inc_paris [mailto:admin@...]
Sent: Thursday, October 21, 2004 12:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Database down

You are correct
Vatnage Tech got thru finally
Had to run an extend command on the database
Now I am up and running

Crazy

system · October 21, 2004, 1:18pm

Jim
I on W2K Vantage 6.0 - my database is 4.7 GB. Not an OS problem.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

_____

From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, October 21, 2004 9:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

What is the file size limit for W2K Server using NTFS, it's way above 2 GB,
correct?
That's what I have and was wondering? Still on Vantage 4.0 also, in case
that matters.
I just want to head off the same problem if I'm close to the limit. I'm at
1.5 GB now.

Thanks,
Jim Moore

-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Thursday, October 21, 2004 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Database down

Seems the database reaching OS's file size limitation.
Did you extend your database?

system · October 21, 2004, 1:34pm

Cliff,
Thanks. From the looks of an earlier post, it looks like I had better rush
up my upgrade to 6.1 and 8.0.
From what I just read in another post, 4.0 will not allow db files over 2.0
GB. If I understand that post correctly, releases prior to 9.1C will not go
above 2.0 GB. I guess it is good I got an early warning!

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Thursday, October 21, 2004 12:22 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

Jim
I on W2K Vantage 6.0 - my database is 4.7 GB. Not an OS problem.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

_____

From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, October 21, 2004 9:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

What is the file size limit for W2K Server using NTFS, it's way above 2 GB,
correct? That's what I have and was wondering? Still on Vantage 4.0 also, in
case that matters. I just want to head off the same problem if I'm close to
the limit. I'm at 1.5 GB now.

Thanks,
Jim Moore

-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Thursday, October 21, 2004 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Database down

Seems the database reaching OS's file size limitation.
Did you extend your database?

system · October 21, 2004, 1:55pm

For any of you still on 3.0 or 4.0, I just confirmed that those Vantage
versions using Progress prior to 9.1c will not allow file sizes of over 2.0
GB.

Now my next question. I will have time to upgrade (sooner than later) but
are progress db's like Exchange DB, once expanded they stay that size?
Will they shrink if non-used data is deleted? Can they be compressed, or
reduced?

TIA.

Jim Moore

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Thursday, October 21, 2004 12:34 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

Cliff,
Thanks. From the looks of an earlier post, it looks like I had better rush
up my upgrade to 6.1 and 8.0. From what I just read in another post, 4.0
will not allow db files over 2.0 GB. If I understand that post correctly,
releases prior to 9.1C will not go above 2.0 GB. I guess it is good I got
an early warning!

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Thursday, October 21, 2004 12:22 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Database down

Jim
I on W2K Vantage 6.0 - my database is 4.7 GB. Not an OS problem.

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

Topic		Replies	Views
Maximum database file size is 2 GB Yahoo Archive	5	428	September 21, 2001
Unable to extend db Yahoo Archive	1	300	March 24, 2004
Vantage DB size...? Yahoo Archive	5	298	August 26, 2004
Dump and Load? Yahoo Archive	2	285	July 5, 2001
Database maintenance Yahoo Archive	2	303	July 9, 2010

Database down

Related Topics