You are viewing limited content. For full access, please sign in.

Question

Question

Unable to upgrade from Forms 9.2.0.908 to 9.2.1

asked on March 13, 2015

After applying the update and going to the Forms Configuration page, I click the Update button (screenshot below)

It starts working, but errors out with message: An error was encountered while updating the database during migration.

The AD account has dbcreator access.  However, the event logs show db query timeout entries (pasted below)

Any ideas on what I need to do in order to complete the upgrade?

 

 

Log Name:      Application
Source:        Laserfiche Forms
Date:          3/13/2015 5:48:22 PM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      [Name removed]
Description:
3/14/2015 12:48:22 AM
Message: ERROR [HYT00] [Microsoft][SQL Native Client]Query timeout expired
Stack trace:    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at FormsConfig.Util.DatabaseHelper.UpgradeDBSchema(OdbcConnection conn, String schemFolder)
   at FormsConfig.Infrastructure.DatabaseInfo.UpgradeDatabase()

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Laserfiche Forms" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-03-14T00:48:22.000000000Z" />
    <EventRecordID>8577644</EventRecordID>
    <Channel>Application</Channel>
    <Computer></Computer>
    <Security />
  </System>
  <EventData>
    <Data>3/14/2015 12:48:22 AM
Message: ERROR [HYT00] [Microsoft][SQL Native Client]Query timeout expired
Stack trace:    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at FormsConfig.Util.DatabaseHelper.UpgradeDBSchema(OdbcConnection conn, String schemFolder)
   at FormsConfig.Infrastructure.DatabaseInfo.UpgradeDatabase()
</Data>
  </EventData>
</Event>

0 0

Answer

SELECTED ANSWER
replied on March 13, 2015

I resolved my own issue.

Even though the AD account had dbowner access to the Forms database, after I added dbreader and dbwriter access, the upgrade FINALLY completed.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.