Looking for Oracle upgrade scripts (Laserfiche and Workflow, 9.0 to 9.2)

asked on February 18, 2015

I'm currently on 9.0 for both LF and WF, on Oracle.

I'd like to test the upgrade scripts (SQL statements) that will be performed during the installation of both products, so that I can test in advance and make sure all goes smooth.

I've had problems in the past and snce I cannot test the entire installation for lack of a licensed test site, I'd like to try out the scripts in a test Oracle schema, at least.

Can someone provide me with the scripts, if they have already upgraded and have the scripts on their server ?

Previous scripts had names like
C:\Program Files\Laserfiche\Server\sql\ora-upg42.sql and C:\Program Files\Laserfiche\Laserfiche Workflow\Utilities\SQLScripts\ora-Workflow902Upgrade.sql

Thank you

0 0

replied on February 18, 2015

You can extract the files from .msi installer for the desired version of Laserfiche.

`1`	`msiexec /a filepath to MSI file /qb TARGETDIR=filepath to target folder`

1 0

View 3 previous replies

replied on February 18, 2015 • Show version history

Thank you for your reply.

I thought about this but my installer is a .EXE

0 0

SELECTED ANSWER

replied on February 18, 2015

It's not. The download from the support site is a self-extracting executable. Once you extract the files, look for the Server subfolder. In there you will see Setup.exe and a bunch of .msi files. Setup.exe is a wrapper for the .msi files to present the user with a nice interface for all the options. Either lfs_en.msi or lfs-x64_en.msi will give you the server install files.

1 0

replied on February 18, 2015

I found that executing the .exe extracts all the installation files, among which are some .msi files.

I extracted lfs_en.msi and found these sql files.

24/09/2014 05:24 PM           174,676 ora-schema.sql
10/03/2014 04:36 PM             7,136 ora-upg1.sql
10/03/2014 04:36 PM            51,718 ora-upg10.sql
10/03/2014 04:36 PM             1,901 ora-upg11.sql
10/03/2014 04:36 PM             8,324 ora-upg12.sql
10/03/2014 04:36 PM             1,582 ora-upg13.sql
10/03/2014 04:36 PM             5,796 ora-upg2.sql
10/03/2014 04:36 PM           117,757 ora-upg20.sql
10/03/2014 04:36 PM             7,327 ora-upg21.sql
10/03/2014 04:36 PM             9,467 ora-upg22.sql
11/08/2014 04:58 PM               603 ora-upg3.sql
10/03/2014 04:36 PM            57,766 ora-upg30.sql
10/03/2014 04:36 PM             7,403 ora-upg31.sql
11/08/2014 04:58 PM            12,423 ora-upg32.sql
10/03/2014 04:36 PM            46,076 ora-upg40.sql
10/03/2014 04:36 PM             2,772 ora-upg41.sql
10/03/2014 04:36 PM            54,619 ora-upg50.sql
10/03/2014 04:36 PM             2,735 ora-upg51.sql
24/09/2014 05:24 PM             3,926 ora-upg60.sql
10/03/2014 04:36 PM               375 ora-upgRM.sql
              20 File(s)        574,382 bytes

Do you know which one(s) will be executed during the upgrade from LF 9.0 to LF 9.2 ?

I see comments like "Oracle upgrade script from 8.5.1 -> 8.6.0." but none seems to apply to 9.0.x to 9.2

There are 125 more msi files in there... Must I try them all ? Certainly someone knows what the scripts are and have a copy handy ?

For Workflow I have found ora-Workflow91Upgrade.sql and ora-Workflow902Upgrade.sql which must be the correct ones.

0 0

replied on February 18, 2015

The internal schema version doesn't necessarily match up to the external version of the Server. These are indeed the files you are looking for.

I believe schema version 4.0 roughly corresponds to Server version 9.0. You can confirm the current version of your db schema in it's dboptions table. You would then run all the subsequent ones in order.

1 0

replied on February 19, 2015 • Show version history

Thanks for your help. I executed the scripts and all went fine.

I note that my proposed syntax change for procedure cleanup_tracking_log made its way to this 9.2 upgrade. Oracle users will benefit from a faster execution of the request.

0 0

replied on February 21, 2015

I did the upgrade this morning and noted the following.

Although the SQL scripts work fine at the SQLPLUS prompt the last 5 instructions in the WorkFlow 9.1 script will fail during the update with ORA-00911: invalid character

To fix it I removed the semicolumn at the end of each of those lines.
Also it important to note that in general, having a ; at the end of a line executes it, and the the / on the next line executes it again.
And indeed, in my test database, I now see that I have each of the 4 new entries in the task_error table 2 times (and there is no unique key on the table either to prevent that from happening)

Other than that all went well.

1 0

Question

Question

Looking for Oracle upgrade scripts (Laserfiche and Workflow, 9.0 to 9.2)

Answer

Replies

Sign in to reply to this post.