PrevPrev Go to previous topic
NextNext Go to next topic
Forums Discuss HelpMaster Bugs!!!
Last Post 10/6/2009 5:31 PM by  Rod Weir
Active Directory Sync
 4 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Jeff Willson
New Member
New Member
Posts:3
Points:5


--
10/6/2009 4:51 PM

    When running the active directory sync I get an error message that string or binary data will be truncated and there are no users added to helpmaster pro. Any suggestions.

    Error Reads as Follows

     Exception: 'System.Data.SqlClient.SqlException: String or binary data would be truncated.
       at HMP.ActiveDirectory.Manager.clsADFunctions.AddNewClients(String p_strLdapPath, Int32 p_intLdapLink, clsActiveDirectoryProfile p_objProfile, DateTime dtNow)
       at HMP.ActiveDirectory.Manager.clsADFunctions.RunProfile(clsActiveDirectoryProfile p_clsADProfile)
       at HMP.ActiveDirectory.Manager.clsADService.a(Boolean b, String& b)'
    Error occurred at marker 12 in HmpAdi.Timer_Elapsed. Please use this information in any support requests.
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    10/6/2009 4:59 PM

    Hi Jeff,

    Thanks for the post and welcome to the HelpMaster community.

    Can you please let me know which version of HelpMaster you're running?

    This error occurs when the data you're extracting from your AD is too large for the database columns within the HelpMaster database.  The attached SQL script can be run against your HelpMaster database (using SQL Server Management Studio), and it will increase the size of the AD table columns to their maximum.  This should fix the issue.

    Please let me know if after running this patch the problem continues.

    Best regards,

    Rod

    HelpMaster development team
    Check out the HelpMaster roadmap
    Attachments
    Jeff Willson
    New Member
    New Member
    Posts:3
    Points:5


    --
    10/6/2009 5:21 PM

    Thanks Rod

    I am running the evaluation copy of version 9.

    I will run the script and see how I go.

    Cheers

    Jeff Willson

     

     
    Jeff Willson
    New Member
    New Member
    Posts:3
    Points:5


    --
    10/6/2009 5:28 PM

    Rod

    Just to advise the script corrected the issue.

    Thanks for your prompt help.

    Cheers

    Jeff Willson

     
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    10/6/2009 5:31 PM
    Thanks for the confirmation - good to hear it worked. Sounds like you're using v9.0. The recently released v9.1 contains this fix.

    Best regards,
    Rod
    HelpMaster development team
    Check out the HelpMaster roadmap
    You are not authorized to post a reply.

    Forums Discuss HelpMaster Bugs!!!
    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

     New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

     March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

     July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

     June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...
    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

     RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

     New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

     New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

     March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

     July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

     June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

     February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

     November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

     May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...