Nope, not it. 40 + 10 (no ODBC) set to 100 for the -n (25 servers, broker
never really goes past 14 of these). Not an issue. Besides, why would it
have happened at 1:00am when I don't have any users at work or logged in,
just the 10 DC stations.
-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Thursday, October 02, 2003 11:23 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Mike
In PET have you compared the default config of both you training and
production databases for Max Users and Max Servers. I know when I upgraded
to Version 6 I had done all the math and I would up having to call Tech
Support and Virginia led me through some NEW MATH ?? to figure users and
servers. I have 69 users + 12 data collection licenses. I'm set at 124 users
and 56 servers. This is like 50 % higher than the calc's by the book.
Cliff Drumeller
Information Technology Manager
Mass Precision Sheetmetal
408 954-0200 ex 217
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Thursday, October 02, 2003 9:07 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Wasn't running backup at 1:00 pm when second time it locked. Backup does
not include the database folder, backup is caught with Probkup and stored
elsewhere and tape backs that up. I have look at everything obvious and not
so obvious over and over again. I've checked drive space and only 33% used,
checked for temp files, checked for viruses, checked for unusual processes
running, checked for locked/write mode files, checked network traffic,
pinged servers and the database, checked wires, etc. I have a whole list of
things to walk through and check when a problem arises and I can usually
find the problem. This one has me stumped. I've thought that it maybe one
of the CPU's, RAM or HardDrives going bad, but I would think that it would
also effect the training database which is on the same server and same
mapped network drive (just different subfolder) which it didn't effect, but
this is still something I will watch since the server is 4+yrs old. It is
not a hardware switch issue because with Vantage installed on the server
itself, I could not connect. I'm leaning toward one of the hidden tables in
the database that progress uses and populates once a connection is requested
(_Connect, _MyConnection, _Users, etc). I'm thinking if something could
have locked one of these records/tables and prevented another record from
being created, thus not allowing any more connections to the database. I've
been searching through the Progress website for hours and haven't found
anything yet that could match this problem, and Epicor support is any help
(as usual). Sat on a tech support call for almost an hour (30 minutes just
to get someone to answer the phone) last night with the only suggestion to
try a different pc or a different vtg file, duh! if you listen to me, I'm
way past those steps. Then support tells me to e-mail a couple files over
to them. The address I got doesn't go through and if I try to send it to
support, the file sizes are too big. Plus after I hung up, I realized they
never gave me an incident number!
Well enough @!#%
It's 11:00 and Vantage is still accessible (knock on wood).
Mike
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, October 02, 2003 10:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Check for the obvious, Does your backup tape run at 1:00am? Is it hitting
your live database?
Patrick Winter
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Thursday, October 02, 2003 10:03 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] HELP! Can no longer connect to database......
No this is really weird. I shut down and rebooted the server before I left
last night and it is still running fine (knock on wood). The thing is that
once the database gets locked, nothing can connect to it (vantage, data
dictionary, Report builder, results, procedure editor.) I can load any of
these up without a database connection fine and then try connecting to the
database from the file menu and it just hangs. I tried running from
different VTG files, using long command lines, etc. nothing worked. So far,
the only pattern I've found is that both lock ups occurred at 1:00 am and
1:00 pm (I can tell this based upon a AutoRpts reporting log - don't see
anything in either the vantage.lg or NT event viewer that points this out.).
Now I know this is getting far fetched, but yesterday being Oct 1, would
give me a date/time of 10010100. I'm wondering if something that was
running (a custom application) and checking dates/time saw this binary
number and cause a glitch with the database and or the _Connect table.
Unless this happens again today (or on a day other than 1's and 0's) to void
this possible theory, I don't have anything else I can think of. The only
fix that worked is the down (complete power off) the server.
Starting/Stopping the database in Progress Explorer did not work. Nothing
new has been added or changed for almost a year on the network (other than
the slow daily growth of the database, currently at 1.35 gig).
Mike
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 02, 2003 9:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Had something like this once when we went live after having some users use a
test database on another server. If I recall correctly when we went live I
did not change the HOSTS file and it was pointing to both servers and these
clients were really really slow. Once I set the client to reference only
one server and uninstalled/reinstalled the client software it ran much
faster. Not saying it is the same but could the HOST name being used by the
clients have gotten changed - whether on the client or in the vantage.vtg.
Another related thought....I use static IP addresses mapped to a Host name
but in a DHCP environment could something not be connecting the name to the
right IP address? Something to do with leases? Just a wild stab.
-Todd C.
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, October 01, 2003 4:07 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] HELP! Can no longer connect to database......
This is the second time today that this has happened. I have several users
already in Vantage now and they are functioning fine. Anyone else who is
now trying to connect, they just hang forever with no errors or anything,
Ctrl-Alt-Del to see Progress [Not Responding]. To fix it this morning I had
to have everyone log out and then reboot the server. I have checked and
re-checked the NT Server Manager files in use to see if someone has the
Vantage.INI or other files locked in write mode but nothing. I can connect
to the training database without any problems. I have even tried starting
report builder without any database connection, once its started, I would
try to connect to the database and then it just sits there and hangs. I've
left it for 45 minutes and still no connection. I've gone through the
Windows NT event viewer looking for any errors and have gone through the
vantage.lg file. I haven't found anything. Has this happened to anyone
else before? Any ideas what to look for or check?
Mike
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=256694.4002236.5216697.1261774/D=egroupweb/S=17050071
83:HM/A=1784493/R=0/id=noscript/SIG=11q7p9e7k/*http://webevents.yahoo.com/un
iversal/intolerablecruelty/>
<http://us.adserver.yahoo.com/l?M=256694.4002236.5216697.1261774/D=egroupmai
l/S=:HM/A=1784493/rand=277259041>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
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]
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
never really goes past 14 of these). Not an issue. Besides, why would it
have happened at 1:00am when I don't have any users at work or logged in,
just the 10 DC stations.
-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Thursday, October 02, 2003 11:23 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Mike
In PET have you compared the default config of both you training and
production databases for Max Users and Max Servers. I know when I upgraded
to Version 6 I had done all the math and I would up having to call Tech
Support and Virginia led me through some NEW MATH ?? to figure users and
servers. I have 69 users + 12 data collection licenses. I'm set at 124 users
and 56 servers. This is like 50 % higher than the calc's by the book.
Cliff Drumeller
Information Technology Manager
Mass Precision Sheetmetal
408 954-0200 ex 217
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Thursday, October 02, 2003 9:07 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Wasn't running backup at 1:00 pm when second time it locked. Backup does
not include the database folder, backup is caught with Probkup and stored
elsewhere and tape backs that up. I have look at everything obvious and not
so obvious over and over again. I've checked drive space and only 33% used,
checked for temp files, checked for viruses, checked for unusual processes
running, checked for locked/write mode files, checked network traffic,
pinged servers and the database, checked wires, etc. I have a whole list of
things to walk through and check when a problem arises and I can usually
find the problem. This one has me stumped. I've thought that it maybe one
of the CPU's, RAM or HardDrives going bad, but I would think that it would
also effect the training database which is on the same server and same
mapped network drive (just different subfolder) which it didn't effect, but
this is still something I will watch since the server is 4+yrs old. It is
not a hardware switch issue because with Vantage installed on the server
itself, I could not connect. I'm leaning toward one of the hidden tables in
the database that progress uses and populates once a connection is requested
(_Connect, _MyConnection, _Users, etc). I'm thinking if something could
have locked one of these records/tables and prevented another record from
being created, thus not allowing any more connections to the database. I've
been searching through the Progress website for hours and haven't found
anything yet that could match this problem, and Epicor support is any help
(as usual). Sat on a tech support call for almost an hour (30 minutes just
to get someone to answer the phone) last night with the only suggestion to
try a different pc or a different vtg file, duh! if you listen to me, I'm
way past those steps. Then support tells me to e-mail a couple files over
to them. The address I got doesn't go through and if I try to send it to
support, the file sizes are too big. Plus after I hung up, I realized they
never gave me an incident number!
Well enough @!#%
It's 11:00 and Vantage is still accessible (knock on wood).
Mike
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, October 02, 2003 10:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Check for the obvious, Does your backup tape run at 1:00am? Is it hitting
your live database?
Patrick Winter
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Thursday, October 02, 2003 10:03 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] HELP! Can no longer connect to database......
No this is really weird. I shut down and rebooted the server before I left
last night and it is still running fine (knock on wood). The thing is that
once the database gets locked, nothing can connect to it (vantage, data
dictionary, Report builder, results, procedure editor.) I can load any of
these up without a database connection fine and then try connecting to the
database from the file menu and it just hangs. I tried running from
different VTG files, using long command lines, etc. nothing worked. So far,
the only pattern I've found is that both lock ups occurred at 1:00 am and
1:00 pm (I can tell this based upon a AutoRpts reporting log - don't see
anything in either the vantage.lg or NT event viewer that points this out.).
Now I know this is getting far fetched, but yesterday being Oct 1, would
give me a date/time of 10010100. I'm wondering if something that was
running (a custom application) and checking dates/time saw this binary
number and cause a glitch with the database and or the _Connect table.
Unless this happens again today (or on a day other than 1's and 0's) to void
this possible theory, I don't have anything else I can think of. The only
fix that worked is the down (complete power off) the server.
Starting/Stopping the database in Progress Explorer did not work. Nothing
new has been added or changed for almost a year on the network (other than
the slow daily growth of the database, currently at 1.35 gig).
Mike
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 02, 2003 9:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] HELP! Can no longer connect to database......
Had something like this once when we went live after having some users use a
test database on another server. If I recall correctly when we went live I
did not change the HOSTS file and it was pointing to both servers and these
clients were really really slow. Once I set the client to reference only
one server and uninstalled/reinstalled the client software it ran much
faster. Not saying it is the same but could the HOST name being used by the
clients have gotten changed - whether on the client or in the vantage.vtg.
Another related thought....I use static IP addresses mapped to a Host name
but in a DHCP environment could something not be connecting the name to the
right IP address? Something to do with leases? Just a wild stab.
-Todd C.
-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, October 01, 2003 4:07 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] HELP! Can no longer connect to database......
This is the second time today that this has happened. I have several users
already in Vantage now and they are functioning fine. Anyone else who is
now trying to connect, they just hang forever with no errors or anything,
Ctrl-Alt-Del to see Progress [Not Responding]. To fix it this morning I had
to have everyone log out and then reboot the server. I have checked and
re-checked the NT Server Manager files in use to see if someone has the
Vantage.INI or other files locked in write mode but nothing. I can connect
to the training database without any problems. I have even tried starting
report builder without any database connection, once its started, I would
try to connect to the database and then it just sits there and hangs. I've
left it for 45 minutes and still no connection. I've gone through the
Windows NT event viewer looking for any errors and have gone through the
vantage.lg file. I haven't found anything. Has this happened to anyone
else before? Any ideas what to look for or check?
Mike
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=256694.4002236.5216697.1261774/D=egroupweb/S=17050071
83:HM/A=1784493/R=0/id=noscript/SIG=11q7p9e7k/*http://webevents.yahoo.com/un
iversal/intolerablecruelty/>
<http://us.adserver.yahoo.com/l?M=256694.4002236.5216697.1261774/D=egroupmai
l/S=:HM/A=1784493/rand=277259041>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
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]
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/