Unable to create or import SQL Tasks

Article:TECH199895  |  Created: 2012-11-19  |  Updated: 2012-11-20  |  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



Symantec is aware of this issue and will work to resolve it in a future release.  In order to receive the the SQL query used to remove the Asset classes from the database, please contact support.  Reference this article and support should be able to access the internal information required.  This is being requested due to the volatile nature of the query used to resolve the issue.




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


Terms of use for this information are found in Legal Notices