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
Clarity 15.9.1 and Jaspersoft server 7.1
Base table missing in MSSQL DB.
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)
);