SQL Deadlocks Blank Title 73689

Yahoo Archive
1
Hey Karen, hope all is well at FB. Say HI to Bob Schmalz.

Thanks for the info below.

Since we also run Service Connect for our PLM, perhaps it's related!

Thank you very much!



Vic




Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Office:Â 336.668.4410 x3091
Mobile:Â 704.530.3092


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Friday, January 30, 2009 4:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SQL Deadlocks

Vic,



I am no SQL expert, but we had deadlocks for Demand Processing from
Service Connect...



[09/01/23@11:11:53.470-0600] P-004328 T-004656 1 AS -- (Procedure:
'db/trg/DemandSchedule/write.p' Line:492) 40001: [Microsoft][SQL Native
Client][SQL Server]Transaction (Process ID 117) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.



Steps below received from support - and seem to have resolved the
issue...



Karen S





RESOLUTION:

1. Go the Vantage/Vista server.

2. Go to Start->Programs->Open Edge 10.0B->Progress Explorer Tool.

3. Expand the Database folder to MfgSys80, to Configurations, to

DefaultConfiguration.

4. Right-click on DefaultConfiguration and choose Properties.

5. Increase the # Lock Table Entries.

6. Increase that number to 409600 or higher. A multiple of 8192 is

recommended by Progress.

7. Click OK to save the changes.



These changes will not take effect until the DB is stopped and restarted

in the Progress Explorer Tool as follows:





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Friday, January 30, 2009 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Deadlocks



Any SQL gurus out there know how I may fix Deadlock issues while running
MRP on my SQL database?

I have already went through the Epicor SQL Performance Tuning guide....
Thank you!

[09/01/30@00:12:07.461-0500] P-005840 T-008464 1 AS -- (Procedure:
'ApplyShopLoad es/RestoreLoad.p' Line:2665) 40001: [Microsoft][SQL
Native Client][SQL Server]Transaction (Process ID 164) was deadlocked on
lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

[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
2
Any SQL gurus out there know how I may fix Deadlock issues while running
MRP on my SQL database?



I have already went through the Epicor SQL Performance Tuning guide....
Thank you!





[09/01/30@00:12:07.461-0500] P-005840 T-008464 1 AS -- (Procedure:
'ApplyShopLoad es/RestoreLoad.p' Line:2665) 40001: [Microsoft][SQL
Native Client][SQL Server]Transaction (Process ID 164) was deadlocked on
lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.



[Non-text portions of this message have been removed]
3
Do you have the Vantage SQL lock utility?

A lock utility was written by one of the programmers which would tell you
what process was locking a record at any given instance...

Generally this is something that needs to be solved with the help of epicor,
since it will probably involve a code tweak somewhere.

I would get in touch with support as soon as you can, make sure to ask for
it to be escalated as well as asking for the SQLLockUtil, and you need to
setup verbose logging if you haven't already.


----- Original Message -----
From: "Vic Drecchio" <vic.drecchio@...>
To: <vantage@yahoogroups.com>
Sent: Friday, January 30, 2009 4:03 PM
Subject: [Vantage] SQL Deadlocks


> Any SQL gurus out there know how I may fix Deadlock issues while running
> MRP on my SQL database?
>
>
>
> I have already went through the Epicor SQL Performance Tuning guide....
> Thank you!
>
>
>
>
>
> [09/01/30@00:12:07.461-0500] P-005840 T-008464 1 AS -- (Procedure:
> 'ApplyShopLoad es/RestoreLoad.p' Line:2665) 40001: [Microsoft][SQL
> Native Client][SQL Server]Transaction (Process ID 164) was deadlocked on
> lock resources with another process and has been chosen as the deadlock
> victim. Rerun the transaction.
>
>
>
> [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
Vic,



I am no SQL expert, but we had deadlocks for Demand Processing from
Service Connect...



[09/01/23@11:11:53.470-0600] P-004328 T-004656 1 AS -- (Procedure:
'db/trg/DemandSchedule/write.p' Line:492) 40001: [Microsoft][SQL Native
Client][SQL Server]Transaction (Process ID 117) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.



Steps below received from support - and seem to have resolved the
issue...



Karen S





RESOLUTION:

1. Go the Vantage/Vista server.

2. Go to Start->Programs->Open Edge 10.0B->Progress Explorer Tool.

3. Expand the Database folder to MfgSys80, to Configurations, to

DefaultConfiguration.

4. Right-click on DefaultConfiguration and choose Properties.

5. Increase the # Lock Table Entries.

6. Increase that number to 409600 or higher. A multiple of 8192 is

recommended by Progress.

7. Click OK to save the changes.



These changes will not take effect until the DB is stopped and restarted

in the Progress Explorer Tool as follows:





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Friday, January 30, 2009 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Deadlocks



Any SQL gurus out there know how I may fix Deadlock issues while running
MRP on my SQL database?

I have already went through the Epicor SQL Performance Tuning guide....
Thank you!

[09/01/30@00:12:07.461-0500] P-005840 T-008464 1 AS -- (Procedure:
'ApplyShopLoad es/RestoreLoad.p' Line:2665) 40001: [Microsoft][SQL
Native Client][SQL Server]Transaction (Process ID 164) was deadlocked on
lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

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





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