Get Details error

Yahoo Archive
1
That sounds really strange to me. I am at 5.0 and run resetlic.r 5 times a
day as part of a scheduled task because we have "hung licenses" so often. I
have never had it bother any of our 8 Data Collection licenses. You might
want to have support look into that issue further. It should not affect any
"live" sessions.

Aaron Hoyt
Design Standards

-----Original Message-----
From: Mark Howard [mailto:mhoward@...]
Sent: Tuesday, October 22, 2002 6:48 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Get Details error


If your talking about resetlic.r to clear locks in the dbase .. be carfull.
I used it and it cleared the lock BUT also killed 15 data colection machines
too.



Mark Howard
Financial Controller
------------------------------------------------------
2
We are still running version 3.0 (don't laugh) and now I'm getting 2 errors
when we try to do a get details in Job Management. It processes for about 30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



[Non-text portions of this message have been removed]
3
Check the amount of free space on the machine you are on - I had a similar
problem of getting errors when I would try to print anything. I was getting
terminated from Vantage every 15 minutes or so - it was very frustrating.
Turns out that the drive that my temp file was located on was about maxed
out. As soon as I freed up space (and then moved the temp file to a spacier
drive) the problem pretty much went away. Hope this helps.

Diane Rowberry
Westwood Precision

-----Original Message-----
From: Robinson, Nick [mailto:nrobinson@...]
Sent: Monday, October 21, 2002 2:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Get Details error


We are still running version 3.0 (don't laugh) and now I'm getting 2
errors
when we try to do a get details in Job Management. It processes for about
30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
4
I have a gig of free space on my HD.



-----Original Message-----
From: Diane Rowberry [mailto:diane.rowberry@...]
Sent: Monday, October 21, 2002 4:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Get Details error



Check the amount of free space on the machine you are on - I had a similar
problem of getting errors when I would try to print anything. I was getting
terminated from Vantage every 15 minutes or so - it was very frustrating.
Turns out that the drive that my temp file was located on was about maxed
out. As soon as I freed up space (and then moved the temp file to a spacier
drive) the problem pretty much went away. Hope this helps.

Diane Rowberry
Westwood Precision

-----Original Message-----
From: Robinson, Nick [mailto:nrobinson@...]
Sent: Monday, October 21, 2002 2:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Get Details error


We are still running version 3.0 (don't laugh) and now I'm getting 2
errors
when we try to do a get details in Job Management. It processes for about
30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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.



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






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
83:HM/A=1282639/R=0/*http:/www.verisign.com/cgi-bin/go.cgi?a=b31540107926004
000>



<http://us.adserver.yahoo.com/l?M=237459.2482214.3895589.2146399/D=egroupmai
l/S=:HM/A=1282639/rand=360140831>


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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]
5
At 04:35 PM 10/21/2002 -0500, you wrote:
>We are still running version 3.0 (don't laugh) and now I'm getting 2
>errors when we try to do a get details in Job Management. It processes for
>about 30 seconds then we get "Lock Table overflow, increase -L on server
>(915)" and "Insufficient disk space or write access denied. (291)".

The lock table error was a common thing in 3.0. You need to edit your
global config file, Startup.PF and add a line to specify more locks,
like: -L 20000
I forget what the Progress directory was on 3.0 ... \DLCSrv or
\DLCSrv\Progress ? ... just do a search for the Startup.Pf file. You'll
need to stop & restart the database.

Try correcting that first. The "insufficient disk space" may just be some
side affect of that.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338



[Non-text portions of this message have been removed]
6
I was getting the Lock TAble Overflow error as well. Mine was caused by
ODBC connections that died without giving a command to clear the
transactions from the lock table. I found out that a user wasnt waiting for
MSAccess to finish running a very long query and he was killing the process
via the Task Manager. The only way to fix it for me was to reboot the
server.
Thanks
jeremy leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Robinson, Nick [mailto:nrobinson@...]
Sent: Monday, October 21, 2002 4:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Get Details error


We are still running version 3.0 (don't laugh) and now I'm getting 2 errors
when we try to do a get details in Job Management. It processes for about 30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



[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/
7
In the case of an ODBC connection getting orphaned on the server, there is a "KILL.exe" file that is around somewhere that you can use to kill a process without having to reboot the server, or even restart Vantage.

It worked for me in NT 4.0 Server. I don't know if it would still work for Windows 2000 Server or not. I haven't used it recently.

Troy

----- Original Message -----
From: Leonard, Jeremy
To: 'vantage@yahoogroups.com'
Sent: Monday, October 21, 2002 9:20 PM
Subject: RE: [Vantage] Get Details error


I was getting the Lock TAble Overflow error as well. Mine was caused by
ODBC connections that died without giving a command to clear the
transactions from the lock table. I found out that a user wasnt waiting for
MSAccess to finish running a very long query and he was killing the process
via the Task Manager. The only way to fix it for me was to reboot the
server.
Thanks
jeremy leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Robinson, Nick [mailto:nrobinson@...]
Sent: Monday, October 21, 2002 4:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Get Details error


We are still running version 3.0 (don't laugh) and now I'm getting 2 errors
when we try to do a get details in Job Management. It processes for about 30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



[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/


Yahoo! Groups Sponsor
ADVERTISEMENT





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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
8
If your talking about resetlic.r to clear locks in the dbase .. be carfull.
I used it and it cleared the lock BUT also killed 15 data colection machines
too.



Mark Howard
Financial Controller
------------------------------------------------------
This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential information.
No information within this email can be forwarded via email or verbally
without the consent of the sender.

If not an intended recipient of this email, you must not copy, distribute or

rely upon it and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the sender
and not the views of Jaws Buckets & Attachments.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, October 22, 2002 4:01 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Get Details error


In the case of an ODBC connection getting orphaned on the server, there is a
"KILL.exe" file that is around somewhere that you can use to kill a process
without having to reboot the server, or even restart Vantage.

It worked for me in NT 4.0 Server. I don't know if it would still work for
Windows 2000 Server or not. I haven't used it recently.

Troy

----- Original Message -----
From: Leonard, Jeremy
To: 'vantage@yahoogroups.com'
Sent: Monday, October 21, 2002 9:20 PM
Subject: RE: [Vantage] Get Details error


I was getting the Lock TAble Overflow error as well. Mine was caused by
ODBC connections that died without giving a command to clear the
transactions from the lock table. I found out that a user wasnt waiting
for
MSAccess to finish running a very long query and he was killing the
process
via the Task Manager. The only way to fix it for me was to reboot the
server.
Thanks
jeremy leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Robinson, Nick [mailto:nrobinson@...]
Sent: Monday, October 21, 2002 4:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Get Details error


We are still running version 3.0 (don't laugh) and now I'm getting 2
errors
when we try to do a get details in Job Management. It processes for about
30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



[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/.
<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





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.



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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226671.2053067.3698778.2273195/D=egroupweb/S=17050071
83:HM/A=1232748/R=0/*http://store.yahoo.com/cgi-bin/clink?sharperimage-best+
KFTN2Y+si637.html>

<http://us.adserver.yahoo.com/l?M=226671.2053067.3698778.2273195/D=egroupmai
l/S=:HM/A=1232748/rand=329413702>

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]
9
No, I'm talking about a Windows NT file (command) that kills any process. It asks you for the PID number of the process, and then proceeds to "kill" that process.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Mark Howard
To: 'vantage@yahoogroups.com'
Sent: Tuesday, October 22, 2002 2:04 AM
Subject: RE: [Vantage] Get Details error


If your talking about resetlic.r to clear locks in the dbase .. be carfull.
I used it and it cleared the lock BUT also killed 15 data colection machines
too.



Mark Howard
Financial Controller
------------------------------------------------------
This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential information.
No information within this email can be forwarded via email or verbally
without the consent of the sender.

If not an intended recipient of this email, you must not copy, distribute or

rely upon it and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the sender
and not the views of Jaws Buckets & Attachments.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, October 22, 2002 4:01 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Get Details error


In the case of an ODBC connection getting orphaned on the server, there is a
"KILL.exe" file that is around somewhere that you can use to kill a process
without having to reboot the server, or even restart Vantage.

It worked for me in NT 4.0 Server. I don't know if it would still work for
Windows 2000 Server or not. I haven't used it recently.

Troy

----- Original Message -----
From: Leonard, Jeremy
To: 'vantage@yahoogroups.com'
Sent: Monday, October 21, 2002 9:20 PM
Subject: RE: [Vantage] Get Details error


I was getting the Lock TAble Overflow error as well. Mine was caused by
ODBC connections that died without giving a command to clear the
transactions from the lock table. I found out that a user wasnt waiting
for
MSAccess to finish running a very long query and he was killing the
process
via the Task Manager. The only way to fix it for me was to reboot the
server.
Thanks
jeremy leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Robinson, Nick [mailto:nrobinson@...]
Sent: Monday, October 21, 2002 4:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Get Details error


We are still running version 3.0 (don't laugh) and now I'm getting 2
errors
when we try to do a get details in Job Management. It processes for about
30
seconds then we get "Lock Table overflow, increase -L on server (915)" and
"Insufficient disk space or write access denied. (291)".



TIA

Nick



[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/.
<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





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.



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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226671.2053067.3698778.2273195/D=egroupweb/S=17050071
83:HM/A=1232748/R=0/*http://store.yahoo.com/cgi-bin/clink?sharperimage-best+
KFTN2Y+si637.html>

<http://us.adserver.yahoo.com/l?M=226671.2053067.3698778.2273195/D=egroupmai
l/S=:HM/A=1232748/rand=329413702>

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]


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.



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