pcAnywhere solution filters are not properly populated in the SMP 7.5 release

book

Article ID: 158426

calendar_today

Updated On:

Products

Symantec Products

Issue/Introduction

Issue: 1
After installing / upgrading to SMP 7.5 the following filters may be empty when computers without pcAnywhere should be listed in them.
"Windows Computers with no pcAnywhere Plug-in Installed"
"Macintosh Computers with no pcAnywhere plug-in Installed"
"Linux Computers with no pcAnywhere plug-in Installed"

Issue: 2
After upgrading from SMP 7.1 SP2 to SMP 7.5 the following filters may be empty when computers having older version of pcAnywhere should be listed in them.
"Windows Computers requiring pcAnywhere Plug-in Upgrade"
"Macintosh Computers requiring pcAnywhere Plug-in Upgrade"
"Linux Computers requiring pcAnywhere Plug-in Upgrade"
Issue: 1
There would be no error observe. However, results of the above filters are empty.
Issue: 2
Logs similar to the following may also be seen in the NS logs.
=============
Error delta updating collection 'e397b6ae-ad14-4d40-be03-8840fe824235':
Altiris.NS.StandardItems.Collection.AeXInvalidCollectionQueryException: Data Source failed to run. --->
Altiris.DataSource.Exceptions.DataSourceRunException: An unexpected SQL error occurred when running the RawSqlDataSource: 'Windows Computers Requiring pcAnywhere plug-in Upgrade' (e397b6ae-ad14-4d40-be03-8840fe824235) --->
System.Data.SqlClient.SqlException: Invalid length parameter passed to the LEFT or SUBSTRING function.
=============

 

Resolution

 
Note:  The issue discussed in this kb has been addressed in pcAnywhere solution 12.6.8 as provided in Symantec Client Management Suite 7.5 SP1 release. http://www.symantec.com/docs/DOC7355
 
Please install pcAnywhere HF 1 from SIM before applying this fix.   More information can be found at http://www.symantec.com/docs/DOC6435
 
The following steps need to be performed on the SMP server.
 
1. Download and Extract attached pcA_7.5_Filters_PointFix.zip
2. Launch command with "Run as administrator".
3. Navigate to the extracted folder location.
4. run install.cmd
5. Enable the pcA plug-in policies and you will observe that filters are working correctly.
 
NOTE:  If you don't immediately see results after applying the filter fix, wait a few minutes or run a Resource Membership Update to have the server repopulate the filters and targets.

 

 

Applies To

Issue 1: Symantec Management Platform 7.5 fresh installed / upgraded from 7.1
Issue 2: Symantec Management Platform 7.5 upgraded from 7.1