Discovery and Inventory Group

 View Only
  • 1.  Merge Resources Error - Conversion failed

    Posted Jun 28, 2016 01:53 PM

    Hello,

    Since the upgrade to 7.6 (we are now on 7.6 HF7), we have been occasionally getting the error below when we try to merge resource records:

    "Merge failed. Converstion failed when converting from a character string to uniqueidentifier"

    We don't want to alter anything in our database but this appears to be related to a SQL Convert error. Has anyone else come across this? If so, what did you do to correct it? It does not occur for all of our resource merges, just the odd merge and we can't identify a pattern as to which resource merges will produce this error.

    Any help is much appreciated!



  • 2.  RE: Merge Resources Error - Conversion failed

    Posted Jul 01, 2016 08:59 AM

    If this helps, here is the error from the Notification Server logs:

    Unspecified Dataloader SQL Exception encountered for inventory data class 'Patch Computers Subject For Licensing' (0e048885-4d81-4fd9-bea4-4d6e2b15e5a7). (SQL Exception Number: 208)
    Invalid object name 'dbo.xdls_Inv_Patch_Computers_Subject_For_Licensing'.

    Unable to merge the specified resources (Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.xdls_Inv_Patch_Computers_Subject_For_Licensing'.