8.03.405A Reports/Queries/Printing Slowness

Yahoo Archive
1
They all are set up as "READ UNCOMMITED".



Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Tuesday, June 09, 2009 10:30 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/Printing Slowness








That could be a problem, how are the ODBC settings setup on the local
machine? They need to be all setup to be "READ UNCOMMITTED"

If not, it is possible that a record lock can occur, which can lead to
that
problem.

----- Original Message -----
From: "Blake Clemens" <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> >
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Tuesday, June 09, 2009 10:22 AM
Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness

> Yes
>
>
>
> Thanks,
>
> Blake Clemens
>
> DMC
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Bartosz Niemczewski
> Sent: Tuesday, June 09, 2009 10:19 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] 8.03.405A Reports/Queries/Printing Slowness
>
>
>
>
>
>
>
>
> Do you have any reports using odbc connection ?
>
> ________________________________
> From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
> <mailto:blake.clemens%40d-m-c.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Sent: Tuesday, June 9, 2009 9:10:43 AM
> Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness
>
> We're Progress. I've tried just stopping the Process and TaskAgent
> appservers but that didn't help.
>
> Thanks,
>
> Blake Clemens
>
> DMC
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf
> Of Ned
> Sent: Tuesday, June 09, 2009 10:09 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness
>
> Are you an SQL customer? I would quesiton whether you are having
record
> locks or not which can cause a backup similar to what you describe.
>
> If it is only printing, then that can be re-started by stopping and
> starting
> the processappserver and taskappserver, you shouldn't need to kill the
> main
> appserver to restart that.
>
> ----- Original Message -----
> From: "Blake Clemens" <blake.clemens@ d-m-c.com
> <mailto:blake. clemens%40d- m-c.com> >
> To: <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> >
> Sent: Tuesday, June 09, 2009 10:00 AM
> Subject: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness
>
>> I'm starting to have an issue with our Vantage system. We are running
>> 405A. For no apparent reason our printing seems to stop working...
our
>> queries seem to "hang"... and any reports we try to run will also
>> "hang". I'm kind of at a loss as to why this will suddenly happen. My
>> only resolution is to kick everyone out of Vantage and shut
> down/restart
>> the system. Does anyone have any ideas as to what could be causing
>> this? I asked the obvious users if they were running any "big"
reports
>> or trying to create any queries that could be a load on the system.
> The
>> answer was no. Any direction here would be greatly appreciated. I'm
>> thinking that it might be time for me to perform another "Dump and
>> Load". Yipppeeee!!! !!!!
>>
>>
>>
>> Thanks,
>>
>> Blake Clemens
>>
>> IT Systems Engineer
>>
>> Delmarva Millwork Corporation
>>
>> (800) 360-2364 x132
>>
>>
>>
>> ***Privileged & Confidential* **
>>
>>
>>
>> This email, together with any attachments, is intended for the named
>> recipient(s) only and may contain privileged and confidential
>> information. If received in error, please inform the sender as
quickly
>> as possible and delete this email and any copies. If not an intended
>> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>>
>>
>>
>>
>>
>> [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/ linksYahoo
> <http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links
>>
>>
>>
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
>
>
>





[Non-text portions of this message have been removed]
2
I'm starting to have an issue with our Vantage system. We are running
405A. For no apparent reason our printing seems to stop working... our
queries seem to "hang"... and any reports we try to run will also
"hang". I'm kind of at a loss as to why this will suddenly happen. My
only resolution is to kick everyone out of Vantage and shut down/restart
the system. Does anyone have any ideas as to what could be causing
this? I asked the obvious users if they were running any "big" reports
or trying to create any queries that could be a load on the system. The
answer was no. Any direction here would be greatly appreciated. I'm
thinking that it might be time for me to perform another "Dump and
Load". Yipppeeee!!!!!!!



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



***Privileged & Confidential***



This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.





[Non-text portions of this message have been removed]
3
Are you an SQL customer? I would quesiton whether you are having record
locks or not which can cause a backup similar to what you describe.

If it is only printing, then that can be re-started by stopping and starting
the processappserver and taskappserver, you shouldn't need to kill the main
appserver to restart that.



----- Original Message -----
From: "Blake Clemens" <blake.clemens@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, June 09, 2009 10:00 AM
Subject: [Vantage] 8.03.405A Reports/Queries/Printing Slowness


> I'm starting to have an issue with our Vantage system. We are running
> 405A. For no apparent reason our printing seems to stop working... our
> queries seem to "hang"... and any reports we try to run will also
> "hang". I'm kind of at a loss as to why this will suddenly happen. My
> only resolution is to kick everyone out of Vantage and shut down/restart
> the system. Does anyone have any ideas as to what could be causing
> this? I asked the obvious users if they were running any "big" reports
> or trying to create any queries that could be a load on the system. The
> answer was no. Any direction here would be greatly appreciated. I'm
> thinking that it might be time for me to perform another "Dump and
> Load". Yipppeeee!!!!!!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> ***Privileged & Confidential***
>
>
>
> This email, together with any attachments, is intended for the named
> recipient(s) only and may contain privileged and confidential
> information. If received in error, please inform the sender as quickly
> as possible and delete this email and any copies. If not an intended
> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>
>
>
>
>
> [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/linksYahoo! Groups Links
>
>
>
4
We're Progress. I've tried just stopping the Process and TaskAgent
appservers but that didn't help.



Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Tuesday, June 09, 2009 10:09 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/Printing Slowness








Are you an SQL customer? I would quesiton whether you are having record
locks or not which can cause a backup similar to what you describe.

If it is only printing, then that can be re-started by stopping and
starting
the processappserver and taskappserver, you shouldn't need to kill the
main
appserver to restart that.

----- Original Message -----
From: "Blake Clemens" <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> >
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Tuesday, June 09, 2009 10:00 AM
Subject: [Vantage] 8.03.405A Reports/Queries/Printing Slowness

> I'm starting to have an issue with our Vantage system. We are running
> 405A. For no apparent reason our printing seems to stop working... our
> queries seem to "hang"... and any reports we try to run will also
> "hang". I'm kind of at a loss as to why this will suddenly happen. My
> only resolution is to kick everyone out of Vantage and shut
down/restart
> the system. Does anyone have any ideas as to what could be causing
> this? I asked the obvious users if they were running any "big" reports
> or trying to create any queries that could be a load on the system.
The
> answer was no. Any direction here would be greatly appreciated. I'm
> thinking that it might be time for me to perform another "Dump and
> Load". Yipppeeee!!!!!!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> ***Privileged & Confidential***
>
>
>
> This email, together with any attachments, is intended for the named
> recipient(s) only and may contain privileged and confidential
> information. If received in error, please inform the sender as quickly
> as possible and delete this email and any copies. If not an intended
> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>
>
>
>
>
> [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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
>
>
>





[Non-text portions of this message have been removed]
5
Do you have any reports using odbc connection ?




________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 9, 2009 9:10:43 AM
Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness





We're Progress. I've tried just stopping the Process and TaskAgent
appservers but that didn't help.

Thanks,

Blake Clemens

DMC

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Ned
Sent: Tuesday, June 09, 2009 10:09 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

Are you an SQL customer? I would quesiton whether you are having record
locks or not which can cause a backup similar to what you describe.

If it is only printing, then that can be re-started by stopping and
starting
the processappserver and taskappserver, you shouldn't need to kill the
main
appserver to restart that.

----- Original Message -----
From: "Blake Clemens" <blake.clemens@ d-m-c.com
<mailto:blake. clemens%40d- m-c.com> >
To: <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> >
Sent: Tuesday, June 09, 2009 10:00 AM
Subject: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

> I'm starting to have an issue with our Vantage system. We are running
> 405A. For no apparent reason our printing seems to stop working... our
> queries seem to "hang"... and any reports we try to run will also
> "hang". I'm kind of at a loss as to why this will suddenly happen. My
> only resolution is to kick everyone out of Vantage and shut
down/restart
> the system. Does anyone have any ideas as to what could be causing
> this? I asked the obvious users if they were running any "big" reports
> or trying to create any queries that could be a load on the system.
The
> answer was no. Any direction here would be greatly appreciated. I'm
> thinking that it might be time for me to perform another "Dump and
> Load". Yipppeeee!!! !!!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> ***Privileged & Confidential* **
>
>
>
> This email, together with any attachments, is intended for the named
> recipient(s) only and may contain privileged and confidential
> information. If received in error, please inform the sender as quickly
> as possible and delete this email and any copies. If not an intended
> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>
>
>
>
>
> [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/ linksYahoo
<http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links
>
>
>

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







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



Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bartosz Niemczewski
Sent: Tuesday, June 09, 2009 10:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/Printing Slowness








Do you have any reports using odbc connection ?

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, June 9, 2009 9:10:43 AM
Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness

We're Progress. I've tried just stopping the Process and TaskAgent
appservers but that didn't help.

Thanks,

Blake Clemens

DMC

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Ned
Sent: Tuesday, June 09, 2009 10:09 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

Are you an SQL customer? I would quesiton whether you are having record
locks or not which can cause a backup similar to what you describe.

If it is only printing, then that can be re-started by stopping and
starting
the processappserver and taskappserver, you shouldn't need to kill the
main
appserver to restart that.

----- Original Message -----
From: "Blake Clemens" <blake.clemens@ d-m-c.com
<mailto:blake. clemens%40d- m-c.com> >
To: <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> >
Sent: Tuesday, June 09, 2009 10:00 AM
Subject: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

> I'm starting to have an issue with our Vantage system. We are running
> 405A. For no apparent reason our printing seems to stop working... our
> queries seem to "hang"... and any reports we try to run will also
> "hang". I'm kind of at a loss as to why this will suddenly happen. My
> only resolution is to kick everyone out of Vantage and shut
down/restart
> the system. Does anyone have any ideas as to what could be causing
> this? I asked the obvious users if they were running any "big" reports
> or trying to create any queries that could be a load on the system.
The
> answer was no. Any direction here would be greatly appreciated. I'm
> thinking that it might be time for me to perform another "Dump and
> Load". Yipppeeee!!! !!!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> ***Privileged & Confidential* **
>
>
>
> This email, together with any attachments, is intended for the named
> recipient(s) only and may contain privileged and confidential
> information. If received in error, please inform the sender as quickly
> as possible and delete this email and any copies. If not an intended
> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>
>
>
>
>
> [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/ linksYahoo
<http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links
>
>
>

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

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





[Non-text portions of this message have been removed]
7
We have the same issue. So far, server restart or restarting the progress services has been the only workaround.

Thanks,
Kunal




________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 9, 2009 9:00:51 AM
Subject: [Vantage] 8.03.405A Reports/Queries/Printing Slowness





I'm starting to have an issue with our Vantage system. We are running
405A. For no apparent reason our printing seems to stop working... our
queries seem to "hang"... and any reports we try to run will also
"hang". I'm kind of at a loss as to why this will suddenly happen. My
only resolution is to kick everyone out of Vantage and shut down/restart
the system. Does anyone have any ideas as to what could be causing
this? I asked the obvious users if they were running any "big" reports
or trying to create any queries that could be a load on the system. The
answer was no. Any direction here would be greatly appreciated. I'm
thinking that it might be time for me to perform another "Dump and
Load". Yipppeeee!!! !!!!

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential* **

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.

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







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

Next time this happens to you try to remember to look at how much RAM
your system is currently using. I've found that our system is trying to
use more RAM then possible. I just don't understand why or how it is
doing this.



Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kunal Ganguly
Sent: Tuesday, June 09, 2009 10:26 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/Printing Slowness








We have the same issue. So far, server restart or restarting the
progress services has been the only workaround.

Thanks,
Kunal

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, June 9, 2009 9:00:51 AM
Subject: [Vantage] 8.03.405A Reports/Queries/Printing Slowness

I'm starting to have an issue with our Vantage system. We are running
405A. For no apparent reason our printing seems to stop working... our
queries seem to "hang"... and any reports we try to run will also
"hang". I'm kind of at a loss as to why this will suddenly happen. My
only resolution is to kick everyone out of Vantage and shut down/restart
the system. Does anyone have any ideas as to what could be causing
this? I asked the obvious users if they were running any "big" reports
or trying to create any queries that could be a load on the system. The
answer was no. Any direction here would be greatly appreciated. I'm
thinking that it might be time for me to perform another "Dump and
Load". Yipppeeee!!! !!!!

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential* **

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.

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

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





[Non-text portions of this message have been removed]
9
That could be a problem, how are the ODBC settings setup on the local
machine? They need to be all setup to be "READ UNCOMMITTED"

If not, it is possible that a record lock can occur, which can lead to that
problem.

----- Original Message -----
From: "Blake Clemens" <blake.clemens@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, June 09, 2009 10:22 AM
Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness


> Yes
>
>
>
> Thanks,
>
> Blake Clemens
>
> DMC
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Bartosz Niemczewski
> Sent: Tuesday, June 09, 2009 10:19 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] 8.03.405A Reports/Queries/Printing Slowness
>
>
>
>
>
>
>
>
> Do you have any reports using odbc connection ?
>
> ________________________________
> From: Blake Clemens <blake.clemens@...
> <mailto:blake.clemens%40d-m-c.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Tuesday, June 9, 2009 9:10:43 AM
> Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness
>
> We're Progress. I've tried just stopping the Process and TaskAgent
> appservers but that didn't help.
>
> Thanks,
>
> Blake Clemens
>
> DMC
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf
> Of Ned
> Sent: Tuesday, June 09, 2009 10:09 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness
>
> Are you an SQL customer? I would quesiton whether you are having record
> locks or not which can cause a backup similar to what you describe.
>
> If it is only printing, then that can be re-started by stopping and
> starting
> the processappserver and taskappserver, you shouldn't need to kill the
> main
> appserver to restart that.
>
> ----- Original Message -----
> From: "Blake Clemens" <blake.clemens@ d-m-c.com
> <mailto:blake. clemens%40d- m-c.com> >
> To: <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> >
> Sent: Tuesday, June 09, 2009 10:00 AM
> Subject: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness
>
>> I'm starting to have an issue with our Vantage system. We are running
>> 405A. For no apparent reason our printing seems to stop working... our
>> queries seem to "hang"... and any reports we try to run will also
>> "hang". I'm kind of at a loss as to why this will suddenly happen. My
>> only resolution is to kick everyone out of Vantage and shut
> down/restart
>> the system. Does anyone have any ideas as to what could be causing
>> this? I asked the obvious users if they were running any "big" reports
>> or trying to create any queries that could be a load on the system.
> The
>> answer was no. Any direction here would be greatly appreciated. I'm
>> thinking that it might be time for me to perform another "Dump and
>> Load". Yipppeeee!!! !!!!
>>
>>
>>
>> Thanks,
>>
>> Blake Clemens
>>
>> IT Systems Engineer
>>
>> Delmarva Millwork Corporation
>>
>> (800) 360-2364 x132
>>
>>
>>
>> ***Privileged & Confidential* **
>>
>>
>>
>> This email, together with any attachments, is intended for the named
>> recipient(s) only and may contain privileged and confidential
>> information. If received in error, please inform the sender as quickly
>> as possible and delete this email and any copies. If not an intended
>> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>>
>>
>>
>>
>>
>> [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/ linksYahoo
> <http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links
>>
>>
>>
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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/linksYahoo! Groups Links
>
>
>
10
We had similar problem and we changed Default Isolation Level to READ UNCOMMITTED (odbc setings , tab advanced) for each workstation which using reports with odbc connections.

Bart.




________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 9, 2009 9:22:41 AM
Subject: RE: [Vantage] 8.03.405A Reports/Queries/Printing Slowness





Yes

Thanks,

Blake Clemens

DMC

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Bartosz Niemczewski
Sent: Tuesday, June 09, 2009 10:19 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

Do you have any reports using odbc connection ?

____________ _________ _________ __
From: Blake Clemens <blake.clemens@ d-m-c.com
<mailto:blake. clemens%40d- m-c.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tuesday, June 9, 2009 9:10:43 AM
Subject: RE: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

We're Progress. I've tried just stopping the Process and TaskAgent
appservers but that didn't help.

Thanks,

Blake Clemens

DMC

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Ned
Sent: Tuesday, June 09, 2009 10:09 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

Are you an SQL customer? I would quesiton whether you are having record
locks or not which can cause a backup similar to what you describe.

If it is only printing, then that can be re-started by stopping and
starting
the processappserver and taskappserver, you shouldn't need to kill the
main
appserver to restart that.

----- Original Message -----
From: "Blake Clemens" <blake.clemens@ d-m-c.com
<mailto:blake. clemens%40d- m-c.com> >
To: <vantage@yahoogroup s .com <mailto:vantage% 40yahoogroups. com> >
Sent: Tuesday, June 09, 2009 10:00 AM
Subject: [Vantage] 8.03.405A Reports/Queries/ Printing Slowness

> I'm starting to have an issue with our Vantage system. We are running
> 405A. For no apparent reason our printing seems to stop working... our
> queries seem to "hang"... and any reports we try to run will also
> "hang". I'm kind of at a loss as to why this will suddenly happen. My
> only resolution is to kick everyone out of Vantage and shut
down/restart
> the system. Does anyone have any ideas as to what could be causing
> this? I asked the obvious users if they were running any "big" reports
> or trying to create any queries that could be a load on the system.
The
> answer was no. Any direction here would be greatly appreciated. I'm
> thinking that it might be time for me to perform another "Dump and
> Load". Yipppeeee!!! !!!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> ***Privileged & Confidential* **
>
>
>
> This email, together with any attachments, is intended for the named
> recipient(s) only and may contain privileged and confidential
> information. If received in error, please inform the sender as quickly
> as possible and delete this email and any copies. If not an intended
> recipient of this email, you must not copy, distribute or rely on 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 Delmarva Millwork Corporation.
>
>
>
>
>
> [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/ linksYahoo
<http://groups. yahoo.com/ group/vantage/ linksYahoo> ! Groups Links
>
>
>

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

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

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







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