Go to previous topic
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
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

    Forums Discuss HelpMaster HelpMaster SQL Server database
    ---