Monday, November 14, 2022

App-V reporting server does not process a report if long application names are used - Microsoft Support [MS]

See the products that this article applies to.

Symptoms

A Microsoft App-V server does not process a report if the application name is longer than 64 characters. Because of this issue, customers cannot use long application names in their App-V packages, and the auditing report of the App-V server is incorrect.

Resolution

To resolve the issue, follow these steps:

  1. Run the following script to change the tables of predefined database objects:
      /****************************************************************************************************************** ** 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. Run the built-in SQL scripts to refresh the "View" database objects:

    %ProgramFiles%\Microsoft Application Virtualization Server\Scripts\Reporting\CreateViews.sql

  3. Run the built-in SQL script to refresh the "Programmability" database objects:

    %ProgramFiles%\Microsoft Application Virtualization Server\Scripts\Reporting\CreateReportingStoredProcs.sql

After you complete these steps, the App_name column will be enlarged to accommodate long application names.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

 

Applies to

This article applies to the following:

• Microsoft Application Virtualization 5.1 Server

No comments:

Post a Comment

Search This Blog

August 11, 2020—KB4571692 (OS Build 10240.18666) - Microsoft Support [MS]

August 11, 2020—KB4571692 (OS Build 10240.18666) Windows 10 More... Les...