De producten weergeven waarop dit artikel van toepassing is.
Symptomen
Een server met Microsoft App-V worden niet verwerkt voor een rapport als de naam langer dan 64 tekens is. Vanwege dit probleem,klanten niet lang toepassingsnamen gebruiken in hun App-V-pakketten en het verslag controle van de App-V-server is onjuist.
Oplossing
Volg deze stappen het probleem op te lossen:
-
Voer het volgende script om de tabellen met vooraf gedefinieerde databaseobjecten wijzigen: /****************************************************************************************************************** ** Copyright (c) 2018 Microsoft Corporation. ** All Rights Reserved ******************************************************************************************************************/ IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[SchemaChanges]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN BEGIN IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PackageInformation_HOST_ID]') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[PackageInformation] DROP CONSTRAINT [FK_PackageInformation_HOST_ID] IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[IX_PackageInformation_2]')) ALTER TABLE [dbo].[PackageInformation] DROP CONSTRAINT [IX_PackageInformation_2] IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[DF_PackageInformation_percent_cached]')) ALTER TABLE [dbo].[PackageInformation] DROP CONSTRAINT [DF_PackageInformation_percent_cached] IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[DF_ApplicationUsage_shutdown_state]')) ALTER TABLE [dbo].[ApplicationUsage] DROP CONSTRAINT [DF_ApplicationUsage_shutdown_state] IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[CK_ApplicationUsage_shutdown_state]')) ALTER TABLE [dbo].[ApplicationUsage] DROP CONSTRAINT [CK_ApplicationUsage_shutdown_state] IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[CK_ApplicationUsage_start_time_LEQ_end_time_MULTIFIELD]')) ALTER TABLE [dbo].[ApplicationUsage] DROP CONSTRAINT [CK_ApplicationUsage_start_time_LEQ_end_time_MULTIFIELD] IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[UK_ApplicationUsage_1]')) ALTER TABLE [dbo].[ApplicationUsage] DROP CONSTRAINT [UK_ApplicationUsage_1] IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_ApplicationUsage_2') DROP INDEX [ApplicationUsage].[IX_ApplicationUsage_2] IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_ApplicationUsage_3') DROP INDEX [ApplicationUsage].[IX_ApplicationUsage_3] IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_ApplicationUsage_4') DROP INDEX [ApplicationUsage].[IX_ApplicationUsage_4] ALTER TABLE [dbo].[UnprocessedCompletedApplicationUsage] ALTER COLUMN [app_name] [nvarchar] (1024) COLLATE database_default NULL ALTER TABLE [dbo].[ApplicationUsage] ALTER COLUMN [app_name] [nvarchar] (1024) COLLATE database_default NULL ALTER TABLE [dbo].[UnprocessedCurrentApplicationUsage] ALTER COLUMN [app_name] [nvarchar] (1024) COLLATE database_default NULL IF COL_LENGTH('ApplicationUsage','shutdown_state') IS NOT NULL ALTER TABLE [dbo].[ApplicationUsage] DROP COLUMN [shutdown_state] END END GO
-
De ingebouwde SQL-scripts om de objecten in de database 'View' vernieuwen uitvoeren:%ProgramFiles%\Microsoft application Virtualization Server\Scripts\Reporting\CreateViews.sql
-
De ingebouwde SQL script uitvoeren om te vernieuwen, de objecten in de database 'Programmeren':%ProgramFiles%\Microsoft application Virtualization Server\Scripts\Reporting\CreateReportingStoredProcs.sql
Nadat u deze stappen hebt voltooid, wordt de kolom Naam_toepassing ten behoeve van de van lange toepassingsnamen worden vergroot.
Status
Microsoft heeft bevestigd dat dit probleem zich kan voordoen in de Microsoft-producten die worden vermeld in de sectie Van toepassing op.
Van toepassing op
Dit artikel is van toepassing op het volgende:
• Microsoft Application Virtualization 5.1-Server