Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Problem to import a new package.

Created: 11 Apr 2013 | 1 comment
cec.kadu's picture

Mr,

When I import software on new packages the console showed, this error.

I restart altiris services and check database, the database have defragmentation max but works fine.

---------------------

<event date="Apr 11 17:40:39 +00:00" severity="1" hostName="Servername" source="global.asax" module="w3wp.exe" process="w3wp" pid="3124" thread="31" tickCount="786619987"><![CDATA[Unhandled exception.  Type=Altiris.NS.Exceptions.AeXException Msg=Unable to update the specified item from the Altiris NS database
StackTrace=
   at Altiris.NS.ResourceManagement.Resource.SaveResourceToDatabase(Boolean bSavingFromClone, String userName)
   at Altiris.NS.ResourceManagement.Resource.SavePartitionedResource(Boolean bSavingFromClone)
   at Altiris.SoftwareManagement.Resources.SoftwarePackageResource.Save()
   at Altiris.NS.ItemManagement.Item.Create(Guid productGuid)
   at Altiris.NS.ResourceManagement.Resource.Create(Guid productGuid)
   at Altiris.NS.ResourceManagement.Resource.CreateItem(Guid productGuid, Guid resourceTypeGuid)
   at Altiris.SoftwareManagement.Web.Dialogs.dlgImportInstall.Page_Load(Object sender, EventArgs e)
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Inner exception.  Type=System.Data.SqlClient.SqlException Msg=Violation of PRIMARY KEY constraint 'PK_SWDPackageServer'. Cannot insert duplicate key in object 'dbo.SWDPackageServer'. The duplicate key value is (7b3c83a2-77b3-4fc8-9ebb-854454b21071, fbf495c6-1e77-4dce-bb28-7477cb48d399).
The statement has been terminated.
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8400.0&language=pt&module=0wXZ+dbwnK6i5ne1iXT8/3ZC57DlFoAbEnKjDhXZCCgbMQXeP0kvmoy4CGk8/Gak&error=1052612286&build=**CEDUrlEnd**
]]></event>

---------------------

Regards,

Comments 1 CommentJump to latest comment

Andrew_Shishkov's picture

Hi,

Looks like duplicated entries exist in vResource for your Package Server. The root cause which could cause this problem is already fixed in currently developed problem, but in yor case you need to clean up the duplicated entry from the database. I suggest to log support incident for this problem and request this clean-up script from Symantec Support.

Thanks,

Andrew.