Question

Forms Database Upgrade

Forms

Updated January 13, 2017

asked on November 10, 2016 • Show version history

Hi All

Just need some information. I have upgraded Forms from 10.0 to 10.1. All went well and when I go on the Forms configurator, it tells me I must update the DB. I have started this process and has been running a couple of hours already.

Is this normal behaviour or not?

Thank you

0 0

Answer

SELECTED ANSWER

replied on November 15, 2016

A support case was opened for this matter. After investigating the database, there were many instances that needed to be deleted so depending on the SQL Server performance, this could take a while to complete. With a high performing SQL Server, the upgrade completed in less than 10 minutes.

0 0

Replies

replied on November 10, 2016 • Show version history

From my experience, typically the Forms DB Update takes a bit of time, but subsequent updates with patches only takes a couple minutes. See Alex's note below.

1 0

replied on November 10, 2016

Steve

Thanks I did try that including restarting the server as well as SQL server

0 0

replied on November 10, 2016

I'd run the Installer again, if that didn't work I'd get a hold of Support or jump on a CFW if you have access to those.

0 0

replied on November 10, 2016

When going from Forms 10.0 to 10.1, one of the steps during the database upgrade is to actually delete the instance data that was previously marked for deletion from the database. To clarify, in earlier versions of Forms, when you "deleted" instances, the data still stayed in the database, but was just flagged as "deleted" so it wouldn't show up in the web interface. In Forms 10.1, we now actually delete the instance data from the database. Therefore, when you are updating the Forms database to the 10.1 schema, it will locate all instance data that had been marked for deletion and delete that.

If there is a lot of instance data to be deleted, the upgrade process can take a while processing this step. However, if the procedure times out, the Forms upgrade could hang.

If you can restore a backup of the Forms 10.0 database, then you can manually run the SQL queries from C:\Program Files\Laserfiche\Laserfiche Forms\Forms\SQL\mssql_upg100_101.sql in SQL Server Management Studio and that should be able to complete, even with a lot of instance data to delete.

If you do not have a backup of the Forms 10.0 database that you can restore, then I would suggest backing up the current database and provide that to Laserfiche Support by first opening a case.

1 0

replied on November 11, 2016

Thank you for the reply

Just to confirm Must I ran all the upgrade scripts that is available?

I have restored the DB and ran only mssql_upg100_101.sql. When going to Forms Config it asked me to upgrade, and now it is just saying Updating please wait.

0 0

SELECTED ANSWER

replied on November 15, 2016

0 0

replied on November 15, 2016

Thank you

0 0

replied on January 13, 2017

Not sure if I should be starting a new post for this, but I am having a similar problem upgrading from 10.1 to 10.2. The other Rio 10.2 upgrades went well, i.e. Server, Workflow, Web Client, Discussions.

In my case, I upgraded Forms to 10.2, but when I was directed to /FormsConfig, I received an error that my database is of a previous version. Based on instructions in this post, I attempted to upgrade the database manually by running mssql_upg101_102.sql in SSMS script, which was successful, but I had no better luck getting into either /Forms or /FormsConfig.

I have since restored the database and the Forms server to their previous states, but I'd still like to upgrade ASAP, so if anyone can think of a reason why our first attempt at upgrading Forms failed, I'd appreciate the help.

Thanks,

Jesse

0 0

replied on January 13, 2017

For the benefit of other users. A case was opened for the issue Jesse raised. The issue that Jesse ran into was caused by http redirection on the Forms server. Removing redirection permitted browsing to http://localhost/Forms/FormsConfig from which the upgrade could continue and the issue resolved.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms Database Upgrade

Answer

Replies

Sign in to reply to this post.