1 Reply Latest reply on Mar 13, 2017 7:13 AM by Casity.chris

    Cannot Archive to Asset Control.  Unable to remove duplicate devices.

    spinnur1 Rookie

      2016.3 Management Suite/Data Analytics

      Recently upgraded from LANDesk 9.6 SP2

       

      Since the upgrade, along with several other issues, we cannot Archive to Asset Control.  Here are the steps:

       

      Go to

      All devices

      1) r. click on a device

      2) select Archive to Asset Control

      3) click t/Yes button to delete from Mgmnt Suite

      4) click on t/ellipse (...) button (does not respond, since t/upgrade).  clicking OK takes you to Perform Operation... (cannot edit  Attributes: field.  Clicking t/Start button produces following error in t/Messages box:

       

      Finished rule

      Finished device

      All link attributes are blank for source device.

      Starting device {71F7488B-055B-45DA-B904-3190A90CB582}

      Update attributes returned: Error copy child object Error creating table CREATE TABLE MPACFileConnections(MP_AC_Devices_Idn int, MPACFileConnections_Idn int IDENTITY(1,1), ConnectCnt int, FileConnection NVARCHAR(512), FileName NVARCHAR(255), FileSize int, FirstConnect DateTime, InfoXml , LastConnect DateTime, MD5Hash NVARCHAR(80), RemoteHost NVARCHAR(255), RemoteIP NVARCHAR(80), SHA1Hash NVARCHAR(80), SHA256Hash NVARCHAR(80), Suspicious int, Title NVARCHAR(255), Vendor NVARCHAR(180), Version NVARCHAR(120), Virtual NVARCHAR(255)) The definition for column 'InfoXml' must include a data type.    at
      System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

         at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

         at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

         at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

         at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

         at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

         at DPISoftware.DPI_Database.DPIDatabase.Execute_Statement(StringsSQL)    at ManagedPlanet.Database.CachedMetaData.BuildTable(SingleObject so)

         at ManagedPlanet.Database.CachedMetaData.CopyChildObject(SingleObject soSource, SingleObject soParent)

         at ManagedPlanet.Database.CachedMetaData.CopyChildObject(SingleObject soSource, SingleObject soParent)

         at ManagedPlanet.Database.CachedMetaData.CopyMetaTree(String sSourceBNF, String sDestBNF)

      Updating attributes

      Starting rule

      Starting rule

       

      Anyone have any idea as to what this mean?

       

      Any help would be appreciated.

      (going on 2yrs of using LANDesk, and I still feel like an idiot)

       

      Thanks.

        • 1. Re: Cannot Archive to Asset Control.  Unable to remove duplicate devices.
          Casity.chris SupportEmployee

          Hello,

           

          This issue is resolved in Service Update 1, or SU1, for 2016.3. You should be able to download the patch on the core server using patch manager.

           

          - Navigate to Tools>Security and Compliance>Patch and Compliance>Download updates

          - Check the box for "LANDESK 10.1 Software Updates" under Windows>Software Updates

          - Click download now and once complete, you should see the update (LD2016_SU-2016-1102) in the Scan>Scan (global) folder.

           

          If you are having a hard time finding the update, please give us a call and we will be glad to help you.

           

          Thanks,

          Chris Casity