Unable to import software resource; 'unable to merge the specified duplicate resources'

book

Article ID: 158424

calendar_today

Updated On:

Products

Altiris Software Development Kit (ASDK)

Issue/Introduction

When attempting to import software from Setting -> Notification Server -> Console 
Settings -> Views -> Software -> Software Catalog -> Deliverable Software -> 
Right Click -> Import and then they choose a software package xml file.

Error during import - Unable to merge the specified duplicate 
resources

 

Log File Name: C:\Users\Administrator\Desktop\a.log
Priority: 1
Help and Support: 
Date: 4/17/2012 2:29:12 PM
Tick Count: 598665973
Host Name: PDWDCMSQL001
Process: w3wp (3928)
Thread ID: 7
Module: w3wp.exe
Source: Altiris.SoftwareManagement.Web.Dialogs.dlgFullImport.RaiseCallbackEvent
Description: Error importing items: 



( Exception Details: Altiris.NS.Exceptions.AeXItemImportException: Item Import 
exception : 97fe4b52-6d62-4905-88d8-0e57a4e12be2 = 
Altiris.SoftwareManagement.Resources.FileResource(1f2dbe83-d96f-4960-a79f-
b8f6ca689ee5) ---> Altiris.NS.Exceptions.AeXException: Unable to merge the 
specified duplicate resources (Resource: 97fe4b52-6d62-4905-88d8-0e57a4e12be2, 
Duplicate: 8f0bb459-c692-4edc-ae6b-978bf91189c6, Type: File (018b191b-47ae-4180-
9fcd-7f3cea4f1e12), Exception: System.Data.SqlClient.SqlException: Invalid 
column name 'FileResourceGuid'.
Invalid column name 'FileResourceGuid'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, 
Boolean breakConnection)
   at 
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject 
stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand 
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, 
TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, 
RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, 
DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult 
result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at 
Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_ResourceManagement_DataAcce
ssLayerResourceManagementDataAccessLayer.spResourceMerge(Guid FromGuid, Guid 
ToGuid, Boolean AllowRename)
   at Altiris.NS.ResourceManagement.Resource.PerformMerge(Guid fromGuid, Guid 
toGuid, Boolean allowRename)
   at Altiris.NS.ResourceManagement.Resource.PerformMerge(Guid fromGuid, Guid 
toGuid)
   at 
Altiris.NS.ResourceManagement.Resource.ResolveDuplicateItems(DuplicateItemArgs 
args)). ---> System.Data.SqlClient.SqlException: Invalid column name 
'FileResourceGuid'.
Invalid column name 'FileResourceGuid'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, 
Boolean breakConnection)
   at 
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject 
stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand 
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, 
TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, 
RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, 
DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult 
result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at 
Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_ResourceManagement_DataAcce
ssLayerResourceManagementDataAccessLayer.spResourceMerge(Guid FromGuid, Guid 
ToGuid, Boolean AllowRename)
   at Altiris.NS.ResourceManagement.Resource.PerformMerge(Guid fromGuid, Guid 
toGuid, Boolean allowRename)
   at Altiris.NS.ResourceManagement.Resource.PerformMerge(Guid fromGuid, Guid 
toGuid)
   at 
Altiris.NS.ResourceManagement.Resource.ResolveDuplicateItems(DuplicateItemArgs 
args)
   --- End of inner exception stack trace ---
   at 
Altiris.NS.ResourceManagement.Resource.ResolveDuplicateItems(DuplicateItemArgs 
args)
   at Altiris.NS.ResourceManagement.Resource.SavePartitionedResource(Boolean 
bSavingFromClone)
   at Altiris.NS.ItemManagement.Item.Import(XmlNode itemNode)
   at Altiris.NS.ItemManagement.Item.ImportItem(XmlNode itemNode)
   --- End of inner exception stack trace ---
   at Altiris.NS.ItemManagement.Item.ImportItem(XmlNode itemNode)
   at 
Altiris.SoftwareManagement.Resources.SoftwareComponentResource.FullImport(String
 
xml)
   at 
Altiris.SoftwareManagement.Web.Dialogs.dlgFullImport.RaiseCallbackEvent(String 
xml) )
( 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.SoftwareManagement.Web.Dialogs.dlgFullImport.RaiseCallbackEvent(String 
xml)
   at System.Web.UI.Page.PrepareCallback(String callbackControlID)
   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.dialogs_dlgfullimport_aspx.ProcessRequest(HttpContext context)
   at ComponentArt.Web.UI.CallbackHandler.ProcessRequest(HttpContext context)
   at 
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.I
ExecutionStep.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(Http
Context 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.AeXItemImportException 
Src=Altiris.NS

  Inner Extra Details:  Type=Altiris.NS.Exceptions.AeXException Src=Altiris.NS

  Inner Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net 
SqlClient Data Provider )

Resolution

This issue is resolved is 7.1 SP2 MP1 (7.1.7863) Roll up Version 3. All subsequent roll ups will contain this fix.