Unable to create or import SQL Tasks

Article:TECH199895  |  Created: 2012-11-19  |  Updated: 2015-03-02  |  Article URL http://www.symantec.com/docs/TECH199895
Article Type
Technical Solution


Issue



When you try to create a new SQL Task or import a SQL task, you receive a generic error in the console.  When reviewing the SMP logs you see the error mentioned in the Error section below.


Error



"11/7/2012 9:22:45 AM","Unhandled error
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8400.0&language=en&module=5Mmi+w/RiNdBI0Eni9fvVezDvDLBtPiNjHKi4WIV+h6AjSSqphGqqvE8NoR4GW09VskMSP77C1GbnHCYuzN20uBZH2QE7hkoPZD++tn2KR4=&error=1126815723&build=**CEDUrlEnd**
 
 
( Exception Details: Altiris.NS.Exceptions.AeXException: An unexpected exception has occured during CreateInstance. (Assembely:Altiris.AssetContractCommon, Version=7.0.0.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4f Type:Altiris.AssetContractCommon.Operation.DisplayType.GuidCollectionUniqueDisplayType) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Altiris.AssetContractCommon, Version=7.0.0.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4f' or one of its dependencies. The system cannot find the file specified.
File name: 'Altiris.AssetContractCommon, Version=7.0.0.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4f'
   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Activator.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(String assemblyName, String typeName)
   at Altiris.NS.ClassActivator.CreateInstance(String assembly, String type, Object[] parameters)
 
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
 
   --- End of inner exception stack trace ---
   at Altiris.NS.ClassActivator.CreateInstance(String assembly, String type, Object[] parameters)
   at Altiris.NS.ItemManagement.Item.CreateInstance(String strClassAssembly, String strClassType, Object[] parameters, Guid itemGuid)
   at Altiris.NS.ItemManagement.Item.GetItemInternal(Guid itemGuid, IEnumerable`1 accessPermissions, ItemLoadFlags itemLoadFlags)
   at Altiris.NS.ItemManagement.Item.GetItem[T](Guid itemGuid, IEnumerable`1 accessPermissions, ItemLoadFlags itemLoadFlags)
   at Altiris.NS.ItemManagement.Item.GetItem[T](Guid itemGuid, ItemLoadFlags itemLoadFlags)
   at Altiris.NS.ItemManagement.Item.GetItem(Guid itemGuid, ItemLoadFlags itemLoadFlags)
   at Altiris.TaskManagement.DisplayTypes.BasePropertyDisplayType.GetCompatibleDisplayTypes(Type baseType)
   at Altiris.TaskServerTasks.SqlQueryTask.SqlQueryTaskEditControl.SetInitialValues()
   at Altiris.TaskManagement.UI.TaskControls.TaskEditControl.ResetControl()
   at Altiris.TaskManagement.Web.ManageTask.InitializeControls()
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) )
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.TaskManagement.UI.AltirisPageInstanceCachePage.OnAltirisPageInstanceCachePageError(Object sender, EventArgs e)
   at System.Web.UI.TemplateControl.OnError(EventArgs e)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.managetask_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
   at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
   at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
 )
( Extra Details:  Type=Altiris.NS.Exceptions.AeXException Src=Altiris.NS
 
  Inner Extra Details:  Type=System.IO.FileNotFoundException Src=mscorlib )","Altiris.TaskManagement.UI.AltirisPageInstanceCachePage.OnAltirisPageInstanceCachePageError","w3wp","3"
 

Environment



Symantec Management Platform 7.x

Asset Management Solution/Suite removed from server


Cause



Defect, Etrack 3002027.

Asset management was not properly removed from the database.  References to the assembly cause this error.


Solution



This issue is resolved in Symantec Management Platform 7.5.  

For resolving the issue in previous versions of the console, there is a SQL script to resolve the issue. Please contact Symantec Technical Support for access to this script.




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


Terms of use for this information are found in Legal Notices