Jump to content
We've recently updated our Privacy Statement, available here ×
  • "ERROR: relation "jiazuresqldatasource" does not exist" during upgrade


    stasp
    • Version: v6.4, v6.4.3, v6.4.2, v6.4.0, v6.3, v6.3.1, v6.3.0, v6.2, v6.2.1, v6.2.0, v6.1, v6.1.1, v6.1.0, v6.0, v6.0.0 Product: JasperReports® Server

    Issue description

    When performing an upgrade using js-upgrade-samedb shell script the process fails, and an error referring to jiazuresqldatasource table is thrown, for example:

    ERROR: relation "jiazuresqldatasource" does not exist[/code]

    Cause and solution

    This issue happens when upgrading from an older version of  TIBCO JasperReports® Server, like 6.1.*, to one of the latest versions (6.3.* or 6.4.*). In the newer versions, the new database table jiazuresqldatasource was added to jasperserver database, and the samedb upgrade script does not take it into account. You will have to use a different upgrade approarch (like the js-upgrade-newdb shell script) to perform an upgrade from an older version


    Other notes

    Same error can also happen when running js-export script from a command line from a newer distribution of JasperReports Server while connected to jasperserver database of an older JasperReports Server installation. In such case you will have to use an older script to perform the export.


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...