PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 1/23/2012 8:20 PM by  Chandrasekar Vasudevan
Error
 4 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Chandrasekar Vasudevan
Helpdesker
Helpdesker
Posts:9
Points:17


--
1/19/2012 9:16 PM

      

    I tried upgrading the database using the database upgrade wizard on windows 2008 R2 server.... When i did .... i get this error .... Why ????

    20/01/2012 3:03:42 PM   Patch started.

     
    20/01/2012 3:03:42 PM   Applying patch version '1'...
     
    20/01/2012 3:03:42 PM   Updating Database Compatibility Level...
     
    20/01/2012 3:03:43 PM   Applying patch version '49'...
     
    20/01/2012 3:03:43 PM   Checking database integrity...
    20/01/2012 3:03:43 PM   CorrectReferentialIntegrityIssuesInRelationshipTables...
    20/01/2012 3:03:59 PM   Writing new database version number for version 49
     
    20/01/2012 3:03:59 PM   Applying patch version '50'...
     
    20/01/2012 3:03:59 PM   DropFullTextIndexes...
     
    20/01/2012 3:08:59 PM   An error occurred while DropFullTextIndexes on statement #1
    Error No.: 5 ; Error Desc.: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
     
    20/01/2012 3:08:59 PM   Patch ended.
     
     
    Cheers,
    Chandrasekar
    Scott Ward
    HelpMaster development team
    Helpdesker
    Helpdesker
    Posts:25
    Points:29


    --
    1/19/2012 9:59 PM
    Hi Chandrasekar

    It appears the patch is failing when it is trying to remove your full text indexes,
    It probably does not have permission to remove these.

    Can you try the following

    1. Run the "Database and reports wizard" as an administrator,
    to do this right click its start up icon and select "run as administrator"
    and see if this allows it to work correctly

    2. if that does not work then try
    Open the "HelpMaster database and reports wizard",
    select the "database and report tools",
    Select your server,
    Pick the "database tools",
    go to the "fulltext searching" tab,
    select your database,
    and press the "remove all full text information"
    If this works without errors then run the patch again, if it works correctly follow the steps above to check if the full text has been re-enabled if not press the "setup/rebuild fulltext searching"

    3. If none of these work, try removing the fulltext indexes directly from your database, before running the patch
    the user you are running the patch under needs permisions to create, delete and modifiy the database objects.
    If you need help with this feel free to contact us through our support chanels.

    Let us know how you go
    Scott
    HelpMaster development team.
    Have you seen what's new in v13 yet?
    Chandrasekar Vasudevan
    Helpdesker
    Helpdesker
    Posts:9
    Points:17


    --
    1/19/2012 11:51 PM

     Hi Scott,

     Thanks for your help as you said in the 2. option it was the full text search problem. I was able to upgrade it as you instructed.

     

    Now in IIS i created all the virtual folder as mentioned in the help file. But when i launch the web app .... its saying in ie

    Could not load file or assembly 'HMP.Common.BaseObjects' or one of its dependencies. An attempt was made to load a program with an incorrect format.

     

    Cheers,

    Chandrasekar.

    Suman Das
    HelpMaster development team
    Helpdesker
    Helpdesker
    Posts:18
    Points:18


    --
    1/22/2012 3:29 PM

    Hi Chandrasekar,

    Please make sure that the bit-ness of your HelpMaster app pool is the same as the installed application (i.e. you'll need to "enable 32 bit applications" on the HelpMaster app pool using IIS manager, in case you've installed the 32 bit HelpMaster application).  If it's already set correctly, then try recycling and/or restarting the app pool prior to accessing the web interface.

    Let us know how it goes and if you require any further assistance.

     

     

    HelpMaster development team.
    Have you seen what's new in v12.0 yet?
    Chandrasekar Vasudevan
    Helpdesker
    Helpdesker
    Posts:9
    Points:17


    --
    1/23/2012 8:20 PM
    Hi Suman Das,

    Thanks for ur support and i was able to solve it... Thanks a lot ....

    Cheers,
    Chandrasekar.
    You are not authorized to post a reply.


    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...