Update Rollbase 3.1.3 to 4.0.0 using SQL script - Forum - Rollbase - Progress Community

Update Rollbase 3.1.3 to 4.0.0 using SQL script

 Forum

Update Rollbase 3.1.3 to 4.0.0 using SQL script

  • Hi Guys,

    I try to update my local machine with Rollbase from version 3.1.3 to 4.0 for some testing.

    i followed these steps:

    1. Download the latest Rollbase binary from http://www.progress.com/products/rollbase/try-it/private-cloud
      • This should be composed of rollbase.zip, lib.zip and webapps.zip, available in the "Files" section
      • Do NOT download the automatic installer as these are only to use with new installations
      • Download as well from the "Database Updates" section any SQL file(s) available to migrate to the latest version (e.g. if you are upgrading from 2.0 to 2.2 that would be the 2.0.0.3, 2.1.0 and 2.2.0 update files)
    2. Shut down the Tomcat instance that is powering Rollbase
    3. Make a backup copy of Rollbase config directory
    4. Uncompress lib.zip in Tomcat's lib directory
    5. Uncompress webapps.zip in Tomcat's webapps directory
    6. In Tomcat's webapps directory, delete the master, rest, rss, storage, workflow, prod1, router, search and webapi directories
    7. Uncompress rollbase.zip in Rollbase directory. Note that this will overwrite files such as license file, general configuration
    8. Restore the Rollbase config files to their original location
    9. If there was any relevant database update SQL file:
      • Edit each file and only keep the part relevant to your DBMS
      • Apply each SQL file to your DBMS in order (e.g. if you are upgrading from 2.0 to 2.2, run the 2.0.0.3 update first, then the 2.1.0 update and finally the 2.2.0 update)
    10. Restart Tomcat

    Everything is going well until I get to step 9

    How can i update the OE database with the SQL scripts downloaded at step 1 (update_3_2_0.sql and update_4_0_0.sql).

    Thanks in advance.

    Jorrit 

  • Hi -

    You should comment out the default one's & uncomment the lines following 'OpenEdge' by removing the leading double dashes at all places throughout the file. This will help you run the file against OE database. So, do this for both 3.2 and 4.0 scripts and run them in that same order.

    Regards,

    Manooj

  • Hi Manooj,

    That's what I saw in the documentation, my question is actually how to run the SQL script against the database? witch program should i have to use?

    Regards Jorrit.

  • Hi Jorrit -

    Please find the solution in a similar thread community.progress.com/.../70245.aspx

    -Regards

    Manooj

  • Hi Manooj,

    The link is not working.

    Message:

    Group Not Found

    The requested Group cannot be found.

    Regards Jorrit

  • Hi,

    RB Installer By default update_4_0_0.sq file not run on existing database. We manually run update script on OE Database.

    Please follow the below  steps to run update script.

    Swtich to <Rollbase Home>\Rollbase\db\bin\proenv.bat. After that

    1.set jrehome=%DLC%/jre

    2.sqlexp -db rbdb -S 8911 -user dbadmin -password dbadmin -infile update_4_0_0.sql

    Note:

    By Default update_4_0_0.sql file has Update against MYSQL database . Need to uncomment lines related to OE database and comment existing one.

    After run update_4_0_0.sql  restart Serv

    - See more at: community.progress.com/.../70245.aspx

    Thanks,

    Rajkumar

  • Hi Rajkumar,

    Thank you ill try it later this day and let you know what the result is.

    Regards

    Jorrit

  • Hi,

    When I updated to 4.0 the service appeared to execute update_4_0_0.sql script upon startup.

    I had tested this by

    • installing update files
    • commenting out every non-commented line in update_4_0_0.sql - so that the script file contained just comments
    • started the service and noted the new table not existing error upon login.
    • stopped the service
    • started the service again and noted the new table not existing error still occurred upon login.
    • stopped the service
    • uncommented the OE lines in update_4_0_0.sql
    • started the service.
    • logged in successfully. 

    I wanted to do this as this was my first update and I wanted to see what happened when i skipped steps

    Is it a valid conclusion that the script does indeed run?

    D.

  • Yes. You can also look for tables/columns in the schema that corresponds to entries in update_4_0_0.sql