SQL Problems (Upgrade path from 11.5 to 2013 to 2013 R2)

[dilorenzo]

Hi,

Ive updated a SQL Server instance going through the following updates:

11.5 to 2013 to 2013 R2.

Now during import the following error message appears (Application Manager):
-------------------------------------------------------------
AppvPlugin: Importing [PathToSFT].0.sft
Initializing System Tables...
Appv System Data Importing
Appv System Data Imported
Appv File System Importing
Appv File System Imported
Appv Registry Entries Importing
Appv Registry Entries Imported
Appv Importing Shortcuts
Appv Shortcuts Imported
Appv File Associations Importing
Appv File Associations Imported
Appv Environment Variables Importing
Appv Environment Variables Imported
Appv History Importing
Appv History Imported
Extracting Application Icons...
Icon Extraction Complete
AppV Package Data Extraction Completed
AppVPlugin: Completed import
Adding package to catalog
Adding import data to catalog
Creating package for [ExamplePackage]
One or more errors occurred.
Package "[ExamplePackage]" failed to import.
Schema needs to be updated. Contact your system administrator. Sql text: Invalid object name 'dbo.ASTestResultCounts'.
AppvPlugin: Importing [PathToSFT].0.sft FAILED.


Package(s) that failed to import:
[PathToSFT].0.sft

-------------------------------------------------------------
How can we fix this? is there some kind of SQL script?
rebuild from scratch is not an option. we have already imported over 500 applications (MSI & App-V)

PS: Ive already cleared "cssysSchemaInfo" to rererun all the upgrade scripts but without success.

Regards,
Fabio

[Alpesh]

Hi Fabio,

Does any other App-V package import fine?

The missing object gets created by the 'AS_TestCenter_StoredProcedures.sql' file. Did you run this file?

Thanks!

[dilorenzo]

Alpesh wrote:
Hi Fabio,

Does any other App-V package import fine?

The missing object gets created by the 'AS_TestCenter_StoredProcedures.sql' file. Did you run this file?

Thanks!

No, import wasnt working at all.

ive now used Red Gate's SQL Compare Tool to synch the SQL Schema against a newly from scratch created 2013 R2 Application Catalog.

Import now works again however SQL Compare still shows the following differences which cannot be applied:

[CODE]SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
PRINT N'Refreshing [dbo].[ASApplicationTree]'
GO
EXEC sp_refreshview N'[dbo].[ASApplicationTree]'
GO
PRINT N'Refreshing [dbo].[ASTestTypeSupportedPackageTypes]'
GO
EXEC sp_refreshview N'[dbo].[ASTestTypeSupportedPackageTypes]'
GO
PRINT N'Refreshing [dbo].[ASTestSetGroupAndApplicationState]'
GO
EXEC sp_refreshview N'[dbo].[ASTestSetGroupAndApplicationState]'
GO
PRINT N'Refreshing [dbo].[ASTestAssessment]'
GO
EXEC sp_refreshview N'[dbo].[ASTestAssessment]'
GO
PRINT N'Adding foreign keys to [dbo].[ASTestSetPackageState]'
GO
ALTER TABLE [dbo].[ASTestSetPackageState] ADD CONSTRAINT [FK__ASTestSet__RowID__3F51553C] FOREIGN KEY ([RowID]) REFERENCES [dbo].[cstblPackage] ([RowID]) ON DELETE CASCADE
ALTER TABLE [dbo].[ASTestSetPackageState] ADD CONSTRAINT [FK__ASTestSet__TestS__40457975] FOREIGN KEY ([TestSet]) REFERENCES [dbo].[ASTestSet] ([OID])
ALTER TABLE [dbo].[ASTestSetPackageState] ADD CONSTRAINT [FK__ASTestSet__TestS__41399DAE] FOREIGN KEY ([TestState]) REFERENCES [dbo].[ASTestState] ([State])
GO
PRINT N'Adding foreign keys to [dbo].[cstblPackage]'
GO
ALTER TABLE [dbo].[cstblPackage] ADD CONSTRAINT [FK_ASCMSupportedPackageTypes_PkgType] FOREIGN KEY ([PkgType]) REFERENCES [dbo].[ASCMSupportedPackageTypes] ([OID])
GO
PRINT N'Adding foreign keys to [dbo].[cstblPackageVirtBlockers]'
GO
ALTER TABLE [dbo].[cstblPackageVirtBlockers] ADD CONSTRAINT [FK__cstblPack__PkgRo__4A18FC72] FOREIGN KEY ([PkgRowID_]) REFERENCES [dbo].[cstblPackage] ([RowID])
GO

[/CODE]

Executing these SQL Statements result in:


[CODE]
Refreshing [dbo].[ASApplicationTree]
Refreshing [dbo].[ASTestTypeSupportedPackageTypes]
Refreshing [dbo].[ASTestSetGroupAndApplicationState]
Refreshing [dbo].[ASTestAssessment]
Adding foreign keys to [dbo].[ASTestSetPackageState]
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK__ASTestSet__RowID__3F51553C". The conflict occurred in database "AdminStudio", table "dbo.cstblPackage", column 'RowID'.
Adding foreign keys to [dbo].[cstblPackage]
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_ASCMSupportedPackageTypes_PkgType". The conflict occurred in database "AdminStudio", table "dbo.ASCMSupportedPackageTypes", column 'OID'.
Adding foreign keys to [dbo].[cstblPackageVirtBlockers]
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK__cstblPack__PkgRo__4A18FC72". The conflict occurred in database "AdminStudio", table "dbo.cstblPackage", column 'RowID'.



[/CODE]


Im not a SQL expert at all. May you be able to assist?

If there is no easy way, would it be possible to send in the database to flexera?


Regards,
Fabio

[Alpesh]

Hi Fabio,

I believe you have a support plan with Flexera. Please submit an incident and provide us all the information.

Thanks!