Home Forums Persistence Dump Files Dump file upgrade's always fail in 9.2

This topic contains 6 replies, has 3 voices, and was last updated by Alice User alice user 2 months, 1 week ago.

  • Author
    Posts
  • #12474
    Henry Zaccak
    Zaccak Solutions
    Participant

    If I try and upgrade a dump file by right clicking and selecting upgrade, I always get an error:

    ; 03:21:12,447 ERROR [GenericTool] Error executing the tool command
    nexj.core.persistence.AvailabilityException: Data source “DefaultRelationalDatabase” is temporarily unavailable. (err.persistence.unavailable)
    at nexj.core.persistence.sql.SQLAdapter.getConnection(SQLAdapter.java:914)
    at nexj.core.persistence.sql.SQLAdapter.getConnection(SQLAdapter.java:881)
    at nexj.core.admin.etl.DataLoader.dropSchema(DataLoader.java:1767)
    at nexj.core.admin.etl.DataLoader.dropSchema(DataLoader.java:1742)
    at nexj.core.admin.etl.DataLoader.dropSchema(DataLoader.java:1708)
    at nexj.core.admin.etl.DataLoadManager.upgradeDumps(DataLoadManager.java:181)
    at nexj.core.tools.DataLoadTool.execute(DataLoadTool.java:261)
    at nexj.core.tools.GenericTool.run(GenericTool.java:127)
    at nexj.core.tools.DataLoadTool.main(DataLoadTool.java:623)
    Caused by: java.lang.IllegalStateException: Fragment “DefaultRelationalDatabase” is disabled
    at nexj.core.persistence.sql.SQLAdapter.open(SQLAdapter.java:960)
    at nexj.core.persistence.sql.SQLAdapter.getConnection(SQLAdapter.java:910)
    … 8 more
    ; 03:21:12,460 INFO [GenericTool] Exit code = 2

    Error: Data source “DefaultRelationalDatabase” is temporarily unavailable. (err.persistence.unavailable)

    Checked the connection pool, looks fine.

    Checked the Test Connection button for the relational DB. Works fine.

    I can recreate, do a manual upgrade then export.. works fine but another issue pops up.

    0
  • #12502
    Shahzad Qureshi
    shahzad.qureshi
    Keymaster

    I am not sure what you are doing here as we discontinue using or generating dump file almost 4 years ago and they are not part of 9.2 release.

    Please provide the following

    1- A screenshot of this dump within the Studio

    2- Studio plugin (Help/About Eclipse SDK (or About Studio)/Installation Details

    3- Finance version (click on “Set current Model” and provide the number under “Base Revision” and “Base Version”

    0
  • #12519
    Henry Zaccak
    Zaccak Solutions
    Participant

    I’m using the official 9.2 release.

    NexJ Studio 13.6.156.000 com.nexjsystems.nexjstudio.feature.group NexJ Systems Inc.

    Base: Finance Rev. 9.2.2.0 V. 1085.1307.167.53

    0
  • #12538
    Henry Zaccak
    Zaccak Solutions
    Participant

    If I delete the dump and recreate the DB it works but I now get the following issue:

    1. In my Main.upgrade I add some UserTemplates and remove some.
    2. If I upgrade via SQL it works correctly (version 1.x to 2.x) and I see the changes
    3. If I do the recreate (without dump) (version 2.x) then the new templates aren’t there and the old ones aren’t removed but the version is changed to 2.x in the DB

     

    0
  • #12549
    Shahzad Qureshi
    shahzad.qureshi
    Keymaster

    The recreate does not make use of the Main.upgrade, it simply looks at the .datasource files. When you run your server, SysUpgrade kicks in and fills in templates and such. Main.upgrade only plays a role when you upgrade your database.

    At NexJ internally, we prefer to use SysUpgrade for template creation/updates, seeding of some data and perhaps control options blocks and things of that nature. You can create a completely new class to do all the above and call the main function in that class from SysUpgrade, recommended to be the very last “before” step before the main action in seed function. See example below

    This is not to say that you can’t use Main.upgrade, however if you are starting out a new project and recreate is needed to be done, Main.upgrade is not the correct option. Main.upgrade is useful especially for when the project is deployed and the database will be upgrade.

     

    0
    Attachments:
    You must be logged in to view attached files.
  • #12567
    Henry Zaccak
    Zaccak Solutions
    Participant

    Makes sense now. We used Main.upgrade because we were used to updating the dump file.

    Thanks!

    0
  • #12668
    Alice User
    alice user
    Participant

    x

    0

You must be logged in to reply to this topic.