KNOWN ISSUE: Getting error "Invalid object name dbo.fnAssetGuidListToTable" when trying to add a resource
Last Updated July 23, 2007
When trying to select a
Resource Type under
Configuration tab >
Server Settings >
Discovery Methods >
Add Resource, the following error occurs:
Server Error in '/Altiris/Resource' Application. Invalid object name 'dbo.fnAssetGuidListToTable'. 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. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.fnAssetGuidListToTable'.
The function "fnAssetGuidListToTable" is is installed with Asset Control Solution. Before R4, the edit resource page never called this function. R4 introduced a modification that calls this function to correct a bug with Asset Control. If Asset Control is not installed, you will get the invalid object error.
This issue is resolved in Roll-up 6 (R6) for Notification Server 6.0 SP3.