PrevPrev Go to previous topic
NextNext Go to next topic
Forums Discuss HelpMaster HelpMaster SQL Server database
Last Post 7/4/2013 8:24 PM by  Rod Weir
Database and Report Wizard Error
 1 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Robert Bean
New Member
New Member
Posts:1
Points:3


--
6/26/2013 4:42 PM

    HelpMaster 13.6.4 Database Patch Log File
    ============================================

    Please report any errors to PRD Software at support@prdsoftware.com.au
    ----------------------------------------

    Connection string:
    Integrated Security=SSPI;Initial Catalog=HelpMaster;Data Source=DMBAPP;Connect Timeout=300;


    6/26/2013 6:37:16 PM   Patch started.

    6/26/2013 6:37:16 PM   Applying patch version '1'...

    6/26/2013 6:37:16 PM   Updating Database Compatibility Level...

    6/26/2013 6:37:16 PM   Applying patch version '1'...

    6/26/2013 6:37:16 PM   Updating Full Text Searching options...

    6/26/2013 6:37:16 PM   Applying patch version '119'...

    6/26/2013 6:37:16 PM   Checking If DB Wizard Is In Same Time Zone As Server...
    6/26/2013 6:37:16 PM   Increasing Date Line Table to 2025...
    6/26/2013 6:37:16 PM   Adding new Timezone Tables and Columns...
    6/26/2013 6:37:17 PM   Updating Database to use UTC times...

    6/26/2013 6:37:17 PM   An error occurred while updating the database to use UTC times on statement #69
     ; Error Desc.: Must declare the scalar variable "@NewPKID".
    Must declare the scalar variable "@NewPKID".

    6/26/2013 6:37:17 PM   Patch ended
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    7/4/2013 8:24 PM
    Just a quick update on this.

    This issue was solved via our tech support. The issue was having a SQL Server instance that was configured to use case-sensitive collation. This is usually not the default setting for SQL Server.

    The issue was resolved by restoring the HelpMaster database to another SQL Server that was set to use a case insensitive collation, performing the update, and then restoring the database to the original server.

    For further information about this, please contact PRD Software.
    HelpMaster development team
    Check out the HelpMaster roadmap
    You are not authorized to post a reply.

    Forums Discuss HelpMaster HelpMaster SQL Server database
    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...