Jaspersoft upgrade fails with Invalid object name JIDashboard

Products

• Clarity PPM On Premise

Issue/Introduction

Jaspersoft server upgrade 7.1 to 7.1.3 fails

Install.log excerpt:

java] Invalid object name 'JIDashboard'.
     ... [java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'JIDashboard'.
     [java]  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
..     [java]  ... 57 more

BUILD FAILED
D:\Jas7.1.3\buildomatic\bin\db-common.xml:1076: The following error occurred while executing this line:
D:\Jas7.1.3\buildomatic\bin\import-export.xml:323: The following error occurred while executing this line:
D:\Jas7.1.3\buildomatic\bin\import-export.xml:196: Java returned: -1

Total time: 33 seconds

BUILD FAILED
D:\Jas7.1.3\install.xml:332: The following error occurred while executing this line:
D:\Jas7.1.3\install.xml:1345: The following error occurred while executing this line:
D:\Jas7.1.3\install.xml:984: The following error occurred while executing this line:
D:\Jas7.1.3\install.xml:2080: ERROR: Error during running this ant target @{arg}
                        For more details, please check D:\Jas7.1.3/install.log file

Cause

Base table missing in MSSQL DB.

Environment

Clarity 15.9.1 and Jaspersoft server 7.1

Resolution

Jaspersoft Install.logs indicates that a core jaspersoft DB object missing (table="JIDashboard"). On further review the table "JIDashboard" is found on a vanilla 7.1 and 7.8 install.

Manually created the table via SQL code available in Jaspersoft setup directory (\buildomatic\install_resources\sql\sqlserver)

    create table JIDashboard (
        id numeric(19,0) not null,
        adhocStateId numeric(19,0) null,
        primary key (id)
    );