Squore 19.1 was released on September 23st 2019.

This release brings performance improvements (mainly to the deletion of projects and versions), the new Gantt chart, a new milestone management menu that allows you to view the Goals for the current version.

Read on to take a visual tour of the new features of Squore 19.1!

New Features

Performance Improvements

• Drastically improved project and version deletion (#13473)
  
  • Review internal versioning management
• Optimized PostgreSQL parameters (#9063)
  
  • Detect SSD/HDD at install time (Linux)
  • Minimize I/O on large transactions
  • More aggressive auto-vacuum parameters

Show trends in Highlights tab (#13467)

Now, it is possible to view the trend values and icons for each cell of an highlighted artefact. 

To add evolution on measure, info or indicator, just activate the "Show trend" option:

New Gantt chart (#13567)

It is now possible to display a Gantt chart on the dashboard, used to illustrate a project schedule.

Using "task" artefacts with a "start" and "end" date connected by "dependency" links, you can display a Gantt chart like this:

For more information, see the full documentation.

Display goals of milestones by version (#13564)

On the dashboard project portofolios, it is now possible to consult the goals of milestones for each version.

1) Click on a version sandwich menu

2) It opens a popup with the milestones information

Add a way for the user to select charts and tables to add in a report (#13579)

On the report section, you can add two new fields to select tables and charts to add on your report dynamically.

To add this possibility, on your configuration, add the new "freeSelection" attribute:

<Report id="FLEX_APP_REPORT" templatePath="../../Shared/Reports/templates/template.jrxml" onArtefactTypes="APPLICATION">
	<Charts displayComments="true" freeSelection="true">
		...
	</Charts>
	<Tables freeSelection="true">
		...
	</Tables>
</Report>

Background color of charts and tables can be variable (#13706)

Background color of artefact charts and artefact tables could be defined by an indicator using "backgroundColorFromIndicator" attribute. So it is possible to have a "red" background color if the indicator is "bad" and "green" if the indicator is "good".

Show executed tasks of projects (#13692)

To have a better overview of the activity of a project through time, we created a new page that shows all tasks executed on a project (build, delete, apply changes, copy ...). It is also possible now to download task logs to investigate potential issues.

If you have user rights, you can access to the Tasks page from the "Projects" page, by clicking on the "Last task status" column, or by the contextual menu "Tasks", situated on the last column.

Ease access to log files from UI (#13422)

It is now possible to download both server and database logs directly from the user interface. Note that the database logs concern only those of the current week.

The feature interface is implemented in a new tab of the Administration > System page in place of the "Server Logs" submenu of "Administration".

New REST API to generate reports (#13472)

It is now possible to generate reports using the Squore REST API.

Url: {server-url}/api/artefacts/{artefact-id}/reports/{report-id}

Using the generic data provider execution, sub process execution can be conditioned (#13491)

In the form.xml file that describes the execution phases of a data provider, it is now possible to define an <executeIf> element in the <exec> and <exec-tool> elements in order to make them conditional.

This can be used to group data providers that optionally have a binary part to execute (for example Findbugs / Findbugs_auto).

The <executeIf> element use the same syntax than the <displayIf> element used to have a visibility condition for a parameter (since 19.0).

<exec-phase id="add-data">
	<exec name="java"> 
		<executeIf>
			<equals key="outputFile" value="" />   <!-- Execute this Java process only if the output file is not provided. -->
		</executeIf>
		...
	</exec>
</exec-phase>

Schema API

Some URLs and json elements have been changed to avoid the use of the "dash" that complicates some calls from scripts.

• highlights-definition → highlightDefinitions
• action-items → actionItems

Licensing Changes

Your 19.0 annual subscription license is fully compatible with Squore 19.1. As Squore 19.0, Your 17.x or 18.x annual subscription license is fully compatible with Squore 19.1 if your license has been distributed from March 1st 2019.

Changes in Installation Prerequisites

No changes since 19.0.

Upgrade Notes

From previous minor version to this version :

• Some benchmarks:
  • Platform: Fedora 30, PostgreSQL 11.5, Intel Xeon CPU E3-1545M v5 @ 2.90GHz (4 procs), 32 GB RAM, SSD disk. / Time: 0.8 s/GB.

Configuration Changes

For a detailed changelog of the Shared folder, consult the full Configuration Folder Changelog :

• 19.1.2 vs 19.1.3
• 19.1.1 vs 19.1.2
• 19.1.0 vs 19.1.1

Known Issues

• If you are using Oracle, make sure to deactivate statistics columns before upgrading otherwise the upgrade will fail with the following error : "Caused by: java.sql.SQLException: ORA-54032: column to be renamed is used in a virtual column expression".

  • To know more about Oracle Extended Statistics : https://blogs.oracle.com/optimizer/extended-statistics

Full Changelog

19.1.14 and up

See Vector official website for more information, section "Support & Downloads > Downloads > Service Packs".

Download page shortcuts :

• Linux : https://www.vector.com/squore/linux
• Windows : https://www.vector.com/squore/windows

19.1.13

Published on 28th October 2020

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.17
  

19.1.12

Published on 25th September 2020

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.16
  

19.1.11

Published on 31st July 2020

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.15
  

19.1.10

Published on 2nd June 2020

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.14
  

19.1.9

Published on 27th April 2020

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.13
  

19.1.8

Published on 15th April 2020

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.12
  

19.1.7

Published on 20th March 2020

• Includes database upgrade: Yes
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

• Also includes all changes and bug fixes from Squore 19.0.11
  

19.1.6

Published on 7th February 2020

• Includes database upgrade: Yes
• Includes WildFly configuration upgrade: Yes

• Upgrade Impacts Analysis Model: no

19.1.5

Published on 20th December 2019

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

19.1.4

Published on 18th December 2019

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no

19.1.3

Published on 4th December 2019

• Includes database upgrade: no
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no (diff)

• Also includes all changes and bug fixes from Squore 19.0.10
  

19.1.2

Published on 14th November 2019

• Includes database upgrade: yes (from any version)
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no (diff)

• Also includes all changes and bug fixes from Squore 19.0.9
  

19.1.1

Published on 18th October 2019

• Includes database upgrade: yes (from any version)
• Includes WildFly configuration upgrade: no

• Upgrade Impacts Analysis Model: no (diff)

19.1.0

Published on 31st August 2019

• Includes database upgrade: yes (from any version)
• Includes WildFly configuration upgrade: yes (from any version)

• Upgrade Impacts Analysis Model: yes (from any version)