Known Issue: Stored Procedure: getResourceAssociationByResource for Resource Association Grid/Diagram gives error in Console 'Server error in 'Altiris/ResourecePlatform' Application'

Article:TECH176643  |  Created: 2011-12-09  |  Updated: 2012-07-04  |  Article URL
Article Type
Technical Solution


When clicking on the Resource Association Grid, the following error occurs: 'Server error in 'Altiris/ResourecePlatform' Application'.


"Server error in 'Altiris/ResourecePlatform' Application"

String or binary data would be truncated.
String or binary data would be truncated.
The statement has been terminated.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.



Symantec Management Console 7.1 SP1 / SP2

Asset Management Solution 7.1 SP1 / SP2


This issue has been addressed in ITMS 7.5

As a workaround, you will need to increment the size of the following colums for the #resultsTable and increase them from 255 to 1024:

[ResourceGuid1Name] [nvarchar] (255)
[ResourceGuid2Name] [nvarchar] (255)
[AssociationTypeName][nvarchar] (255)

The attached file can be run to make this modification.



Updated stored procedure that can be run to update the columns
sp_getResourceAssociationByResource.sql (9 kBytes)

Supplemental Materials


Article URL

Terms of use for this information are found in Legal Notices