Servidor de informes de App-V no procesa un informe si se utilizan nombres largos de aplicación

Síntomas

Un servidor de Microsoft App-V no procesa un informe, si el nombre de la aplicación tiene más de 64 caracteres. Debido a este problema,los clientes no pueden utilizar nombres largos de aplicación en sus paquetes de App-V y el informe de auditoría del servidor de App-V es incorrecto.

Solución

Para resolver el problema, siga estos pasos:

1. Ejecute la siguiente secuencia de comandos para cambiar las tablas de los objetos de base de datos predefinidas:   /****************************************************************************************************************** ** 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

2. Ejecutar las secuencias de comandos integrados de SQL para actualizar los objetos de base de datos de "Vista":%ProgramFiles%\Microsoft application Virtualization Server\Scripts\Reporting\CreateViews.sql

3. Ejecutar el script SQL integrado para actualizar los objetos de base de datos de "Programación":%ProgramFiles%\Microsoft application Virtualization Server\Scripts\Reporting\CreateReportingStoredProcs.sql

Después de completar estos pasos, la columna App_name se ampliará para dar cabida a nombres largos de aplicación.

Estado

Microsoft ha confirmado que se trata de un problema de los productos de Microsoft enumerados en la sección "Se aplica a".