cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Issues with DA upon Upgrading from 2007 SP1 to 7.5 SP1

GianniCool
Level 6
Partner

‎11-23-2009 07:37 AM

Hello folks!
I have a client in the UK that just upgraded from 2007 SP1 to 7.5 SP1.  Everything went perfect with no errors except DA.  They ran the Deployment Scanner and it came up with a few SQL problems.  However, these were fixed by their DBA's and went ahead with the upgrade.  There were SQL deadlock errors throughout the installation, but then it stated that it upgraded successfully.  EV 2007 SP5 is running for them as well as DA, but the client is "leary" that the upgrade on DA was in fact successful.  Here's what he sent me:

Event Type:     Error
Event Source:   EV Accelerator Service
Event Category: None
Event ID:       1
Date:           11/23/2009
Time:           5:22:23 AM
User:           N/A
Computer:       USHOUDA01
Description:
APP AT - Customer ID: 9 - Failed to log error to the DB
Reason: This SqlTransaction has completed; it is no longer usable.
Stack:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at KVS.Accelerator.Common.Error.UpdateDS(ErrorDS DS)
   at KVS.Accelerator.Common.AcceleratorEvent.LogInDB(ErrorType Type, String Description)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type:     Error
Event Source:   EV Accelerator Service
Event Category: None
Event ID:       1
Date:           11/23/2009
Time:           5:22:34 AM
User:           N/A
Computer:       USHOUDA01
Description:
APP AT - Customer ID: 9 - Failed to log error to the DB
Reason: Transaction (Process ID 496) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Stack:    at KVS.Accelerator.Common.Error.UpdateDS(ErrorDS DS)
   at KVS.Accelerator.Common.AcceleratorEvent.LogInDB(ErrorType Type, String Description)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I suggested to him that we reinstall back to 2007 SP1, and then perform the upgrade again to DA to see if we have the same errors.  Any insight into this would be helpful!


0 Kudos
1 REPLY 1

GianniCool
Level 6
Partner

‎11-24-2009 08:52 AM

OK, does anyone have a way of performing the 7.5 SP1 upgrade on a certain database with deadlocks friom Vault 7.5?  Here's my client's concerns:

As discussed please find my concerns with rolling back our Discovery Accelerator database:
  • Which databases should be rolled back?  Just the live customer DB or should this also include the config DB or indeed the stale customer DB still on version 6?  Please note the Config DB is shared with our working Compliance Accelerator service, so presume rolling this back will also effect this service.
  • If we did roll back the DBs what else is required?  Do we need to reinstall DA 2007 SP5 software on our DA Server and the Journaling Connectors software on our EV Journaling servers or should it detect and the older DB automatically and prompt us to upgrade.
  • Since we have yet to determine the route cause of the upgrade failure, I would suspect the same issue would occur if we just re-attempt the upgrade.  So believe we need to understand the cause of the failure and resolve this before any upgrade is reattempted.
Lastly, as it appears the DA service is operationally, perhaps a roll-back isn't needed.  Is there anyway to determine if the DBs upgraded successfully and perhaps then we could then work on why the Deadlock errors are occurring.
 
Thanks,
0 Kudos