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 http://www.symantec.com/docs/TECH176643
Article Type
Technical Solution


Issue



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


Error



"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.


 


Environment



Symantec Management Console 7.1 SP1 / SP2

Asset Management Solution 7.1 SP1 / SP2


Solution



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.

 


Attachments

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

Supplemental Materials

SourceETrack
Value2527407


Article URL http://www.symantec.com/docs/TECH176643


Terms of use for this information are found in Legal Notices