Upgrade to Compliance Accelerator (CA) or Discovery Accelerator (DA) 8.0 from 7.5 SP6 fails with error "Could not find stored procedure 'usp_Target_RemoveFromCase'"

Article:TECH128053  |  Created: 2010-01-26  |  Updated: 2012-11-26  |  Article URL http://www.symantec.com/docs/TECH128053
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Environment

Issue



Upgrade to Compliance Accelerator (CA) or Discovery Accelerator (DA) 8.0 from 7.5 SP6 fails with error "Could not find stored procedure 'usp_Target_RemoveFromCase'"


Error



Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 64
Description:
APP ATM - Error upgrading a Customer.
Install Thread - worker thread (1)
Customer ID: 1
Number of tries: 1
Cause: Could not find stored procedure 'usp_Target_RemoveFromCase'.
Error in tmp_Target_DeActivate
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.
Could not complete cursor operation because the table schema changed after the cursor was declared.

Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 59
Description:
APP ATM - Failed to update database. System.Data.SqlClient.SqlException: Could not find stored procedure 'usp_Target_RemoveFromCase'.
Error in tmp_Target_DeActivate
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.
Could not complete cursor operation because the table schema changed after the cursor was declared.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at KVS.Accelerator.Application.Install.RunScript(String ScriptName, SqlCommand CMD, Int32 CustomerID)
at KVS.Accelerator.Application.Install.UpdateDatabase(CustomerRow theCustomerRow)

Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 49
Description:
APP ATM - Error Executing : C:\Program Files\Enterprise Vault Business Accelerator\AcceleratorDataUpdateV8.sql
Line: 571
Failed to Execute the following command:
-- Upgrade any 'nologin' users to deactivated users
DECLARE @PrincipalLogin nvarchar(100)
DECLARE @PrincipalID int
DECLARE @AddressOwnerID int
DECLARE nologinUsers CURSOR FOR SELECT PrincipalID, PrincipalLogin, AddressOwnerID FROM tblPrincipal WHERE UserType = 'nologin'
OPEN nologinUsers
FETCH NEXT FROM nologinUsers INTO @PrincipalID, @PrincipalLogin, @AddressOwnerID
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @NewLogin nvarchar(100)
SELECT @NewLogin = LTRIM(RTRIM(@PrincipalLogin))
-- Get rid of the 'removed' and the '(principalid)' parts
IF (LEFT(@NewLogin, 7) = 'Removed') AND (RIGHT(@NewLogin,1) = ')')
BEGIN
SELECT @NewLogin = RTRIM(REPLACE(SUBSTRING(@NewLogin, 9, 100), '(' + LTRIM(RTRIM(STR(@PrincipalID))) + ')', ''))
-- add on the '[PrincipalID]' string so that we don't get any clashes
SELECT @NewLogin = @NewLogin + ' ' + '[' + LTRIM(RTRIM(STR(@PrincipalID))) + ']'
END
UPDATE tblPrincipal SET PrincipalLogin = @NewLogin, UserType='user' WHERE PrincipalID = @PrincipalID
-- Deactivate the account
exec tmp
_Target_DeActivate @AddressOwnerID = @AddressOwnerID
FETCH NEXT FROM nologinUsers INTO @PrincipalID, @PrincipalLogin, @AddressOwnerID
END
CLOSE nologinUsers
DEALLOCATE nologinUsers
exec Util_DropProcedure 'tmp_Target_DeActivate'
. System.Data.SqlClient.SqlException: Could not find stored procedure 'usp_Target_RemoveFromCase'.
Error in tmp_Target_DeActivate
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.
Could not complete cursor operation because the table schema changed after the cursor was declared.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at KVS.Accelerator.Application.Install.RunScript(String ScriptName, SqlCommand CMD, Int32 CustomerID)

 


Environment



Compliance Accelerator (CA) or Discovery Accelerator (DA) 2007 (7.5) SP6 upgrading to 8.0.X.

 


Cause



The CA or DA 2007 (7.5) SP5 database is missing the stored procedure usp_Target_RemoveFromGroup and the upgrade process is unable to create it.

The upgrade processing going to CA or DA 8.0.x adds 2 columns to the tblIntTargetToTargetGroup table.

The process to add those columns fails, causing the creation of the stored procedure usp_Target_RemoveFromGroup to fail.


Solution



Ensure the CA or DA Customer database compatibility level is set to 'SQL 2005 (90)' or 'SQL 2008 (100)' prior to upgrading the database.  There are column modifications and additions that require SQL Server 2005 as a minimum.

The stored procedure usp_Target_RemoveFromGroup must be manually created in the failed to upgrade database.

A new or successfully upgraded CA or DA 8 Customer database will contain this stored procedure that can be copied and created in the failing to upgrade database to allow the upgrade to complete successfully.

Please contact Symantec Discovery Accelerator Technical Support for the steps to resolve this issue. The resolution to this issue will require modifications to the DA Customer Database(s). Please verify all Accelerator Databases have been backed up prior to contacting Technical Support.



Legacy ID



348004


Article URL http://www.symantec.com/docs/TECH128053


Terms of use for this information are found in Legal Notices