Skip to content

P6 Core 6.9.2

Release date: Wednesday, 14th of June 2023

Documentation can be found here.

This release introduces some breaking changes. We recommended that you carefully read the migration guide.

Features

Clustering

Here’s the list of items that were reworked to correctly function in a clustered mode:

  • The routes service
  • p6.transaction & p6.camel DSLs
  • Cluster wide locking of auto reprocessing or AROs bootstrapping
  • Cluster wide locking for FlywayDB
  • Use of the TemporaryFileManager generated files in a cluster when /tmp folders are node specific
  • … many other internal technical enhancements

Transactions/Workflow Features

  • Add AssigneeList as a new Searchable so we can display a list of users in the WorkflowTasks UI
  • Extend the view definition language to support default values on date searchables

DSL

  • New DSL to scan files with ClamAV antivirus
  • New tables DSL methods to export lookup to file:
    • p6.table.toFile
    • p6.table.lookupToFile
  • Added a new method name() to the instance DSL to display the name of the instance
  • Enriched the script DSL with a currentName() method to return the executing script name
  • Align AppConfig DSL method signatures
  • A lot of display enhancements were made to the DSL documentation

Improvements

  • The default database is p6core, all tables (including reporting tables) will reside in that schema, you no longer need to specify the schema in your queries. For more information, carefully read the Migration guide
  • Rework transaction date display
  • Improve error message when script job exceeds the timeout
  • Performance enhancements on large data tables:
    • UX Update: Add filtering options
    • Remove sort on table data export
    • Support large data exports in CSV
    • Reduce size of CMB messages on table dsl lookup
  • Improve the build time and size of the services UI
  • Retrieve configuration from backend to frontend
  • Upgrade Apache SSHD to the latest release and allow max_sessions and custom_banner parameters to be passed via the route URI
  • Remove unused P6 Sync HISTORY operation
  • Remove unused environment property values specified in docker-compose

Bug Fixes

This release fixes the following bugs:

  • File submission endpoints will not work in a clustered environment
  • Hawtio redirect after login failing, plus adaptation to cluster mode
  • Cannot migrate SURIs into forms that display arbitrary html covering the whole panel
  • Bundled resources not deploying in preInstall script
  • Impossible to import CSV in the table service
  • Missing pagination on table data
  • Fix script saving behavior in new editor for enhanced user experience
  • transactions=allow(‘WfView1’(‘Assignee’=’%USER.EMAIL%’)) permission is broken for workflows
  • In the Script service, support of the Json format is missing on the backend
  • buildDataSource() functions in stored proc DSL should create tables even if the result set is empty
  • P6 Sync behavior should be aligned with the UI
  • Workflow history is not updated on transaction after processing a workflow tasks using a JSON form
  • P6 Sync errors instead of ignoring contentMode when present
  • Camel component p6route generating none unique keys for routing orders when under load
  • Status column is not displayed in the routes service
  • Various fixes in the documentation