Discussion
Error While Upgrading Rules Schema to Pega 7.1.8
Hi,
I have an environment with following configuration.
App Server - Tomact 7.0.41
DB - MS SQL 2008 R2
PegaRUELS - 6.3 SP1
I am trying an out-of-place manual upgrade with both source and target schema in the same db. I could successfully migrate rules to the target schema but when I run upgrade on the migrated rules I get the error "com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."
What could be the reason for this?
Thanks,
Mahesan
***Removed this comment***
I shutdown the app and tried resume.bat. It worked. I was using the same credentail used by application for running upgrade. I guess this could have caused the issue.
Helo Mahesan,
This seems like a general DEADLOCK issue with SQL Server.
Can you please make sure no other process is accessing this migrated DB when you are doing the upgrade. Also make sure you are using the migrated DB credentials and not the original for when you are doing upgrade.
The below link may give some insight about the deadlock issue and how to fix that.
http://blog.sqlauthority.com/2007/05/16/sql-server-fix-error-1205-transaction-process-id-was-deadlocked-on-resources-with-another-process-and-has-been-chosen-as-the-deadlock-victim-rerun-the-transaction/