1 Reply Latest reply on Aug 21, 2009 4:35 AM by qasam.umran

    With Partner Support errors after 7.2.6 upgrade

    Rookie

      Hi,

       

      We've just upgraded from 7.2.4 to 7.2.6 and are now getting errors when putting an incident to With Partner Support.  I've put a trace on SQL and it looks like the following command is the culprit:

      exec sp_executesql N'UPDATE pm_process_assignment SET pm_title=@0,pm_description=@1 WHERE pm_guid=@2',N'@0 nvarchar(65),@1 nvarchar(1021),@2 uniqueidentifier',@0=N'Information: Incident 24470 has been referred for partner support',@1=N'<data removed>',@2='55277562-BE02-42CE-A62B-BBDDD6B341F7'

       

      By the look of things, the issue is due to the fact that pm_title.pm_process_assignment is varchar(64) whereas the text being inserted is 65 characters long.  That said, surely the system should handle this a bit more gracefully than displaying a "string or binary data will be truncated" error?

       

      Any ideas Avocent?

       

      Regards,

      Ant

        • 1. Re: With Partner Support errors after 7.2.6 upgrade
          SupportEmployee

          Hi Ant,

           

          As you correctly identified the title field can only hold 64 characters and the usual culprit is the {Title} placeholder in a title field.  I would have a look in the process to see if there is a place holder in the title field of a automatic action/assignment/reminder after you put a incident to "with partner support".  The error message usually came up in the event log for 7.2.4 but in 7.2.6 this is different.

           

          Hope this helps,

          Qas

          1 of 1 people found this helpful