Release Notes

Remove WebLogic from the code base

Upgrade to WildFly 33

UI changes to clarify refresh schema behaviour

Introduce REST endpoint to validate a session

1Integrate RHEL 9 support

Upgrade to Java 21

Upgrade to GDAL 3.9.2

Don't log missing Built-in arg description

Named lookup values causing a Null Pointer Exception for missing class

Upgrade PostgreSQL repo support to PostgreSQL 16

The Context-sensitive help for DSV 'field separator' has a typo

Support SAML authentication

report_invalid: invalid inclusion reported for CSV geometry, but not FGDB geometry

Regression: 1Integate Copy To mapping not taking database PKs into account during refresh preventing Data Store save

Class hierarchy is not inherited from Reference Data Store unless additional attributes are defined

Unable to select base class in an Open Data task

WFS: Contains doesn't work in Non-Spatial Filters

Have to reset Parameters in Rule using a Rule Template for duplicated (or copy and paste) Rules

Spamming the paste option in the resource tree only a few times can cause the creation of an exponential amount of resources

Copying a parent folder and pasting it into a child folder causes an infinite copy-paste loop.

Browsers with expired tokens stored cannot access the OpenAPI docs or load the login banner

A new http_request_v2 built-in with a new parameter to control the return of status codes

SQL Server and MariaDB Data Stores – new parameters 'CRS Sample Size' and 'Dimension Sample Size' that will speed up the schema refresh

true_distance() improvement for anti-podal cases

Make the Schema Validation JSON report downloadable from the task report

AutoCAD DWG Data Store - include the ability to Copy To

Ability to use Session Parameters in the Workspace/Version field of supported tasks

Create a new Administration page split out from the Dashboard

Resource Picker lists - don't load all the resources on initial load

AutoCAD DWG Data Store does not expose all expected attributes

AutoCAD DWG Data Store only lists string attribute types

AutoCAD DWG Data Store should load insert points

AutoCAD DWG Data Store - read the COLOR values as per the AutoCAD color index

AutoCAD DWG Data Store - Objects from paper space should not be loaded on Layer 0

Don't rely on browser storage for Rule and Action state tracking

Update the supported Java patch releases to the latest

SQL Server and MariaDB Data Stores - ensure that we can always read the CRS

Extent restrictions should work if a Data Store has a CRS Override

Improve session load performance by only loading each Data Store's details once on session start

Unable to backup a resource with an ampersand or comma in the name

The field length displayed is +1 than the actual field length for gdal_real64

ArcGIS Server Data Store Fails to Write NULL

Unable to load FGDB schemas when the casing of subtype attribute names and class attribute names is different

Unable to select base class in an Open Data task when using a reference Data Store

Unable to rename a resource in a folder that shares the same name

When Data Stores or Actions referenced in Session Task Templates are renamed, the changes are not propagated to Session API responses

Map Viewer: Parsing hotspots error on locales with commas as decimal places

Non-Conformance tooltips are no longer appearing for the Conformance results chips

Fix 1Integrate access token automatic refresh on WildFly

Unable to add a 'Rule Template' to an Action

Schema Validation should not require Copy To details to be configured

Issue inserting Action Templates into conditional predicates

AutoCAD DWG Data Store - Layers From XREF-ed drawings should not be included in the schema mapping

Loop over Nearest Operation incorrectly names the geometry child node as 'count'

Named Lookup Value reading leaves open file handles behind

Include Rule Description Metadata in the 1SMS validation service results

Non-conformance Report Data Store not reading task results from tasks run inside a Session Task Template

Support the new 1SMS security model

Allow Contextual Data Store to use non-spatial filters to pass in 1SMS job IDs

Add validateChanges SOAP endpoint next to validateRegion endpoint

Autodesk DWG Data Store: support reading block attributes

Upgrade to the latest Java

Autodesk DWG and Bentley Microstation V8 DGN Data Stores should display the file name in the UI

WFS OAuth authentication option not working

In 1Integrate 4.2.0 a selection Built-in Operations don't display correctly

Long running engines showing native memory leaks

NullPointerException when refreshing some schemas that were created before 1Integrate 4.2

Selecting a value for a Named Lookup

'For All in Collection' in new rules author forces selection of a Class and rule is dramatically slower

New Built-In to print date to Custom Date Formatted strings

Prevent the primary geometry from being unindexed via the API

Added a new parameter to the GML data store to read all geometries as 2D

Improve support for reading empty geometries with Esri File Geodatabase, Esri Shapefile, MapInfo Tab, Microsoft Access & OGC GeoPackage Data Stores

Improve the rendering of outlines on 3D polygons in the Map Viewer

2D features will now appear semi-transparent in the Map Viewer

New DWG Data Store called Autodesk DWG (WildFly only)

New DGN Data Store called Bentley MicroStation Design V8 DGN (WildFly only)

Rename the FME Server Data Store to FME Flow Data Store

Add hover colour and different cursor to resize handles

Ability to filter Sessions by their current status in the Navigation Pane

Simplify the default settings in the settings.properties file (WildFly only)

Do not remove entities from the 'Available' pick lists, show them as greyed out instead

Ability to change the colour of comments within a Rule/Action

Improve the presentation of Action Map task chips

Support inheritance on the Data Store screen including allowing the configuration of inheritance for schema only data stores

Attribute references are visible on the Data Store screen and can be manually removed

Data that is updated via a Transform Schema task should allow Commit

Improve the presentation and configuration of geometries in the Replay Viewer

Add tooltips to the move node up and down arrows in the Rule and Action builder

Ability to Resolve Subtypes in the Esri File Geodatabase Data Store

1Integrate will no longer startup against a newer repository version

Use the blue colour for disabled tasks in a Session Task Template

Ability to focus parts of the subtree in the Rule and Action builder

Reintroduce "Any" to Loop over Collection

Improve support for the "Any" class

Remove the empty 'Else' from 'If...Then...Else' node title

Rule Builder: Change optional link colour when filled

Rule Builder: Disable collapsing of links

Rule Builder: Hide any/one char fields when using perl matching

Rule Builder: add option to disable new node auto focus

Avoid confusing downstream failures by throwing an error when setting a geometry to null in an action

Update the presentation of disabled tasks that have been skipped

Allow some table columns on the session and data store pages to be resizable

Make transitions in the Rule/Action builder smooth

Add buttons for Rule/Action builder controls such as zoom in and out

Allow 1Integrate repository connection pool tuning on WildFly to allow for more performance tuning options

Disable interactions with optional nodes inside imported templates

Update Linux support to Red Hat Enterprise Linux 8.9

Drop the FME Desktop-based Data Stores: Autodesk AutoCAD DWG/DXF, Esri Enterprise Geodatabase & Bentley MicroStation Design (V8)

Contextual Data Store now provided as a product extension

Update Windows Server support to Windows Server 2022

Add indication for which attributes are indexed to the Attribute Value dropdown in the Rule/Action builder

Improve Map Viewer tile generation performance for larger datasets

The Map Viewer enable all layer button now take all visible layers into account

Allow 1Integrate to be configured to allow users to login to the 1Integrate UI using OpenID Connect (OIDC) authentication with the Keycloak OIDC provider

Fix superclass name presentation in node titles in the Rule/Action builder

Improve Map Viewer compatibility with data that does not provide a CRS by updating the default Map Viewer CRS to Web Mercator (EPSG:3857)

Update FME Flow (formerly Server) support to 2023.1

Remove the tooltip on attribute type on the schema mapping screen to avoid it obscuring the type selection drop down

Custom attributes added to a Data Store class default to string

New context menu options for inserting nodes above and below a node

Ensure resource names work as expected throughout the UI no matter the characters they contain

Add padding to the right of add buttons on the Navigation Pane

Improve readability by renaming division, product, difference and sum nodes

Static values in the Rule/Action builder consistently now display their value in the title

When running a folder of Actions or Rules, Action and Rule Templates are now correctly skipped

Updated the report_invalid Built-in Function to handle null geometries

Force all primary key attributes to be enabled if the class is enabled

Fixed users occasionally getting "invalid username or password" on login for valid credentials due to their browser sending an expired token along with the login request

Add ellipsis to long Session Parameters in the Session Parameter preview window

Fix "Expand All" expanding custom classes on a Data Store

Fix Non-Spatial Filters using Session Parameters not being run as a Database Query

FGDB Data Store: Fix deriving attributes for Classes with no objects

FGDB Data Store: Fix Copy To creating a layer for each object when a class name contains a space

Fix If...Then...Else not displaying error messages even when its in an invalid state on the Rule and Action builder

Fix Reference nodes so they correctly display the Ref Name field

Fixed error handling for the Map Viewer layer style processing so that uploading an invalid layer style file does not white-out the whole UI

Allow replacing nodes that have variable child counts so long as they are within bounds

Map Viewer: Fixed the hover cursor for 'Render as wireframe'

Fixed the Single Predefined Region restriction on Open Data tasks

Fixed disabled tasks altering the session space details so disabled tasks cannot trigger "Invalid combination of spaces" errors

Fixed a race condition starting interface and engine simultaneously can result in some data stores failing to load properly

Fixed '&' character handling in session names

Fixed cases where using the singleton class as a root class incorrectly excludes the singleton class which can result in the observed behaviour that actions grouped into a single task getting different results than if run individually

Fix cases where renaming a session can make it not runnable, e.g. it contained a rule folder reference

Fix having an empty folder open in the Navigation Pane repeatedly sending API requests

Fix certain errors occurring during Map Viewer load preventing session re-run

Fix disabling Commit tasks in Sessions

Improve Class Name value preview to allow these nodes to be distinguished from others more easily

Fixed the Map Viewer layer colour picker having scroll bars when it should not

Fix regular expression not showing correctly in 1Integrate UI

Improve the reporting of Values in reports, e.g. making Session Parameter Value reporting consistent with Temporary Value reporting and improving data type reporting

Fix empty metadata files being included in backups for folders that lack metadata

Fix dragging and dropping resources into folders that start with the name of the resource being dragged

Disabling attributes in the UI also disables any associated foreign keys

Improve the handling of Templates that contain parameters when being added into a Rule or Action

Improve the handling of Templates that contain 2 or more parameters

Fix the handling of Data Stores whose parameter values include XML reserved characters so they do not fail their Open Data tasks

Non Spatial Filtering: Treat empty class filters the same as if there were no filter defined at all instead of throwing data away

Improved SRID lookup for datasets that contain some CRS information but not the SRID itself, e.g. MapInfo

Fixed large numbers of entities crashing the UI due to browser storage limits being exceeded

Data Store Editor: allow previously entered password values to be cleared

Fixed accented characters not being able to be used within Data Store schemas or parameter values

Session comments don't take tasks imported by Session Task Template tasks into account leading to comments appearing offset from where they should (often at the bottom for large templates)

Object iteration with null value condition

Web Browser Sessions will Timeout after 30 mins for security reasons

Measure Built-In Functions will throw an error when passed a non-measured geometry

New Session Task Templates allow sets of tasks to be defined once and used in multiple sessions

New Open Data Task Extent Override option: Single Predefined Region

Restore error messages appear in snackbar

API documentation improved to clarify different types of reports in an action

Long running tasks such as deleting many entities present a 'busy' indication

Deprecated SOAP API removed

Inline docs for operations and functions improved

Ability to add a task at a selected point in a Session

Deprecated Metadata Store removed

Map Viewer: Reported geometries now appear on the Layers list

Non-Spatial Filters: Use underscores to replace spaces in Class and Attribute names

Improved error message when deleting entities that are in use

Collapse all / expand all Data Store Classes

Implemented visual indicator for Cut objects in the navigation pane

Added support for writing to MapInfo MIF/MID file format via the MapInfo TAB Data Store

Enable/Disable all button on Data Stores now only applies to the visible Classes

Update API key REST API to validate key name uniqueness

Session task tooltips to show the task type and name

Security: Prevention of HTML Content Injection throughout the UI

Security: Improved Input Validation

Apply Action Map Task: Option to always report on the Rule nonconformances

GeoJSON Data Store: New parameter for reading all geometries as 2D

New Cast option added to Rules and Actions to allow selection of attributes from a specific class

Heighted geometries are heighted on the map

Rule node previews are more legible

DSV Data Store: Added Integer support

Scale_and_rotate can cause exceptions which stop the session

Session Failover can result in "Duplicate Key Value Violates Unique Constraint" Database Error

Schema Transform DerivedAttributeMapping should handle null entries

ends_of builtin incorrectly checks for coincident ends of target line

Data Transformation errors when using a database for schema mapping and some mappings are null

Backup mechanism should include folder metadata

Only allow supported Data Stores to be selected for a Commit task

Improve the error message for a missing “Copy To” Mapping

Long comment on Session task is overlapping with edit and delete icons

When using drag and drop in a Session the user is not warned about dependencies

No Data Available info display for Download Commit Destination Files

Stop expression parsing being logged in log files

Don't allow API Keys to be generated with unknown Permissions

Deleting an empty folder throws error messages

Null Pointer Exception when syncing 1Integrate from a local checkout folder

Used item can be deleted from the navigation pane

Unable to interact with Session controls after an error in the Session

Attempting to download a file from Copy To config when the credentials have not been set creates an error that fills the screen

Running a non-spatial filter against a Data Store containing tables with two spaces in the class name will not filter anything

Adding a parameter to a new template shows "Name in use"

Rule/Action Templates do not show the correct Classes and Names when first added to a new Rule/Action

Unable to set engine labels on Linux via the start script

Can't rename Sessions with Rule folder reference

File data created by a Copy To task not always deleted.

Built-in Functions with at least 2 optional parameters can be configured with unlimited parameters

Task Report has Incorrect count on download results

Error when trying to rename Rule or Action that uses a Template

Unable to copy multiple selected Actions, Sessions and Rules

Add UI for displaying items included in a multiselect

Improved shift select behaviour in the resource tree

Blinking Text Cursor Jumps to End in Right-Hand Menu Text String Box

Classes with no Attributes stop “Copy To” schema from refreshing

FGDB Classes containing attributes with no name are not being read in

The previews for Difference show the values the wrong way round

FME Server Data Store: Handle unexpected folders

No 1Integrate logs produced under WebLogic

Map Viewer: Allow 3D map pitch angle to be > 60 degrees

1Integrate with cache sharing enabled on the cloud leaks gothic data roots

Data Store schema refresh should retain added classes or ontology mappings.

Report created, modified and deleted counts on Commit Task.

Differentiate between Global, Local and Task scope temporary values.

Remove 1Validate sessions folder

Improve handling of unique keys in the Data Store page

Support H2 for repo, simplifying local/non-production deployments

Error Catcher value to deal with exceptions/errors (Try...Catch)

Remove GDAL-based PostGIS and FME-based SQL Server Data Stores

Remove the deprecated Gridstatistics endpoint

Add a new parameter for adjusting the threshold for heavily compressed archives (zip bombs)

Ability to use Temporary Values in Rules

PostgreSQL/PostGIS Data Store - objects with a UUID are failing to commit

Validation Service: Combine point spatial hotpots into multipoint geometries in the validation report per non-conformance

Split the Session Results REST endpoint into a separate endpoint

Don't extract required 1Integrate libraries to the temp directory

Record Rule and Action Replays for debugging

Non Spatial Filter on CheckRules, ApplyActions, and ApplyActionMaps Tasks

Built-in Function to calculate convex hull of all data in the named Classes

Option to retain the attribute order (GDAL-based Data Stores)

Brand-new User Interface

New future-proof Map Viewer

Additional descriptions for REST API Swagger documentation

Withdraw the Legacy Backup endpoints

New User Permissions

Validate Schema Task - allow reference schema excess classes

Add “OGC” to "Web Feature Service (WFS)" Data Store name

Include the product version in REST API

Improve error message when Schema Only Data Store is committed to

JDBC-based Data Stores: Auto-index attributes on read

Remove GDAL PostGIS libraries as Data Store is now withdrawn

Update Swagger docs to include API keys as a means of authentication

Transform Schema Task : allow source schema excess classes

GDAL-based Data Stores: Copy To Tasks should retain attribute field length and precision

Revert MSINT-3951 (Classes set via REST with no attributes should be considered disabled)

With "Production Mode" enabled on a Session, skip the pre-session validation checks

Allow Objects, Nested Values and Array elements to be used in Assignment Operations

Remove the Partitions Status Map

Rename Data Store parameter to "Fix ring direction"

Update Data Store WKT converter to be able to handle polygons of a single point

File Geodatabase Data Store should retain Field Aliases

Remove the MySQL Data Store

Dark UI Theme

Download data files directly from a Session

New admin dashboard

New look documentation (WebHelp)

Ability to add and edit Session Parameters in the UI

New Fixed Schema options on Data Stores

Add Generic ‘For Loop’

Add Execute and return / Execute and check

True and False predicates

Multi-select Data Stores for Rule and Action Context

Rule and Action Context should persist

New API endpoints for managing folders

New API endpoints for moving all resource types

Session reports downloaded from the UI now JSON, no longer XML

Map Viewer styles stored in the browser cache

Per-page Search/Filter for items in the tree

Ability to hide unselected Classes and Attributes on a Data Store

Ability to bookmark entities

Deprecate Metadata Data Store support

Withdraw the home page

Trailing Spaces in Temporary Values cause issues

REST API returns EntityRef member in RulesTask

Session timings reset to zero after exceeding 24 hours

Backup creates a folder if a Rule has a backslash (\)

Open Schema Task should be sufficient to allow Copy-To to a Data Store

NPE Message for Missing FME Server Datastore Input Parameters

JDBC Data Stores: Can't use spatial filter when PostGIS and 1Integrate repo both in non-public PostgreSQL schemas

FGDB unpredictable behaviour on open data when null geometries are present

FME Server Data Store: Unable to read any integer attributes for classes written using the licenced Esri FGDB writer

Non Spatial Filter throws parsing errors when 'contains' function is followed by other open brackets

Check Rules task non-conformance reports do not include any hotspots for non-spatial checks (that contain more than one attribute)

Update Java Support - latest point release

FME Server Data Store - Allow files that aren't zips to be uploaded

Ability to configure the Wildfly transaction timeout

Improve performance extracting DEFLATE_64 compressed zip files

FGDB Failed to load GDAL dataset - when zip contains more than .gdb

Non-spatial filter: Update per-class filter with no classes to match all classes

Update the 1Integrate REST API to update the display name for uploaded files when a new file is uploaded

Update the WildFly bundle to WildFly 26.1.2.Final

Do not include the format "f" parameter when making WFS calls

Files On Disk: Update the cleanup of temporary Data Store files created to support REST API Data Store file downloads to happen after download rather than after server shut down

Ensure consistent handling of the CRS across all Data Stores

FME Server Data Store: FGDB OBJECTID column read in as null

FME Server Data Store - Parameters with quote disappear from GUI

Non-Conformance Report Data Store - java.lang.NullPointerException when task appears in session before future check rules tasks

1Int 3.4 Online help link points to 1Int 3.3 page

1Integrate 3.4 not installing as a Windows Service - configuration does not exist: standalone.xml

FME Server Data Store: 1Integrate\TEMP directory not cleared for deleted/stopped sessions

FME Server Data Store - 1DGW uploaded file gets renamed to the name as defined in the 1INT Master Session not the cloned session.

GeoJSON Data Store default to WGS84 when CRS not specified

Engine log file has the wrong name

FME Server Data Store - REST API should not automatically unzip uploaded data

New FME Server Data Store

Allow a Session's Open Data Task Extent Override to be 'Extent of Previous' even when a session is restricted by a polygon

Introduce Access Groups for folder level permissions

Esri File Geodatabase Data Store domain resolution

Esri ArcGIS Server Data Store - fix ring direction parameter

New GeoJSON Data Store

New Non-Conformance Report Data Store

Compile 1Integrate with Java 11

Add missing file options to GDAL-based Data Stores

Use session parameter to filter predefined region

New GML Data Store (read-only)

Exclude folders from being synched

Find Kickbacks Built-in does not handle null geometry

Tag log messages with the user ID

Update GDAL to 3.5

Avoid relying on the PostGIS column definition to determine geometry dimensionality

REST API: Add endpoints to download Data Store source file

Non-Spatial Filter casting issue - handling numbers vs. strings

Remove sync button from the Synchronisation Tool

Update Ignite to 2.13

Non-spatial filter with a Class name that is also a function name doesn’t parse correctly

Zip full restore doesn't update metadata only changes

Wildfly Packaging

Remove 'Powered By' header from the WildFly bundle

Add an endpoint to 1Integrate to get the license time remaining for monitoring license expiry

Cannot write classes with special characters out to DSV

Classes set via REST with no attributes should be considered disabled

DSV Data Store: Make the nominated geometry column(s) optional

DSV Data Store loads WKT Heighted features as 2D

Open Data and Schema Task Class Selection Validation: unexpected exception cause by references to excluded Classes

Shapefile datastore reads 0 timestamp as 0002-11-29 23:29:40.000

Failed Backup: java.io.IOException - two trailing spaces

Geopackage Boolean Data Type being populated as Integer

Update WildFly bundle to WildFly 26.1.1

Validate Schema Task: Inclusion of Data Store paths in the report to be configurable through new checkbox which defaults to off

Validate Schema Task: Flip Missing & Excess and rename Target to Reference

Support Azure Active Directory credentials for SQL Server Repository

Improve support for OAuth 2.0 in WFS Data Store

Add a Schema Transformation Task

Add Schema Enquiry built-in functions

Add a Validate Schema Task

Non-Spatial Filter (like a WHERE clause) when opening data, using session parameters in the filter

Add a Schema Only Data Store

Open Data and Open Schema tasks should ignore attribute metadata differences such as field length and precision

Latest Java support

Helm: Custom extensions available by allowing a custom image to be used in place of our official images

Add a Built-in function to get an object's Data Store

List the Null attributes on the Session Data Viewer attribute panel

REST API: Ability to update just the extent of a session without providing whole session payload

Add a Built-in function to make HTTP calls during a session

Add descriptions for all REST calls to the REST API docs

Add coordinate reference system information to validation report

Enable Commit on file datastores for FGDB and GeoPackage

Update Split_geometry Built-in to support 2D inputs

Add a Built-in to compare attributes

Accurately detect SQL Server dimensionality to better support mixed dimensionality data

PostgreSQL Data Store: Disable Auto-commit when reading data to reduce memory footprint

PostGIS write errors not updating pre-class error count

Make schema handling case sensitive to ensure reading from the expected schema for all formats

XYM data written out to SQL Server becomes XYZ data

JDBC based MariaDB/MySQL, PostgreSQL and MSSQL: SRS ignored during write

JDBC based MariaDB/MySQL, PostgreSQL and MSSQL: Manually specified SRS value always ignored

JDBC based MariaDB/MySQL, PostgreSQL and MSSQL: Fix the quoting in the geometry column description query for SQL Server

Options cog hidden if Engine host name is long

Engines interrupted when waiting on a lock to process a session will infinite loop and fill up the logs

Sync Tool cannot handle backups with long pathnames on Windows

Session Data Viewer legend does not include target classes from load schema tasks

Attempting to rewind a Session without a running engine results in a stuck Session

Fix style upload button within the Session Data Viewer

New Backup mechanism doesn't include shortcuts in use which leads to unrestorable backups

Open Schema task should not try to connect to the Data Store

Fix SQL Server timestamp handling (milliseconds)

Unable to use AzureAD authentication via the JDBC based SQL Server Data Store while 1Integrate is installed as a Windows service

Cloning items as shortcuts gets a 'Copy of' prefix instead of 'Shortcut to'

Iterating over all:geometric includes non-geometric Classes such as singleton

JDBC datastore large memory overhead during write due to only flushing after each Class was written out

GDAL FGDB reading in Bezier curves as multipart geometries

Legacy hotspot information missing from reports

Sync Tool error on empty repo: IOException: Archive contains entries that point outside of the archive directory

Open Data Task doesn't take excluded classes into account when building the Schema for rule validation

File Upload does not recognise upper case file extensions

Session Data Viewer does not display dates

SQL Server format unable to write out null values for date, float and string types

Session error if disabled open schema task precedes a Commit Task

Support tab delimiters in DSV Data Store

Role-based REST API Access now consistent with user interface

New API keys option for managing access to REST API

Add an Open Schema task to only create schema but load no data

Empty recycle bin button should delete all deletable items when some can't be deleted

Drop deprecated FME Data Store shape format

Allow an engine to be marked for shut down (so that no new jobs are queued)

Support Java 11

New Centroid built-in function

DSV Data Store - Unable to read UTF-8 BOM encoded files

Enable both Repository and Data Store to use Integrated Security

Sync tool not setting the content-type header

M values are being changed when build topology task is run

Measures (M Values) don't exist after Build Topology

Add X,Y,Z or X,Y,M option on as-standard DSV Data Store

Add X,Y,Z or X,Y,M option on as-standard FGDB Data Store

Update the folder REST endpoint to include the full path to each entry

3.1.0

As-standard Data Store support via JDBC connections for

• MySQL/Maria DB

• Postgres/PostGIS

• Microsoft SQL Server

GeoPackage as-standard Data Store support

Microsoft Access as-standard Data Store support

New DSV Data Store parameter to optionally include line numbers as a feature attribute

FGDB write (copy-to) for as-standard Data Store

Deprecate legacy PostGIS and Microsoft SQL Server formats

Deprecate legacy FME Shapefile format

Add a Kubernetes mode to 1Integrate

Add dynamic engines for Kubernetes deployments

New easier deployment for custom built-in functions and custom Data Stores

Modernise password encryption

Signed 1Integrate EAR files for added security

Session Data Viewer Enhancements

The Parts of Solid and multihedral surface geometries can iterated over in a rule or action

New Built-in Function - Split String

Buffer build-in can take a negative buffer size to shrink polygons.

New Built-in function - rule_hotspot_attribute_names

New "Folders" REST endpoint for folder management

Add useRecycleBin query parameter on REST API delete calls

Latest Java 8 update

Update to WildFly 24

Update to GDAL 3.3

MySQL and MariaDB do not need to offer Z or M or 3D options

session_has_class not finding classes when run from singleton class

DSV Data Store save where import mapping has an integer attribute causes Null Pointer Exception

1Integrate logs contain an error every time an uncompressed file is uploaded to a Data Store

REST API Encrypted passwords returned by the REST api are scrambled when Data Store re-uploaded

3.1.0

Reduce the false positives or errors or warnings in Wildfly logs

Esri FileGDB as-standard Data Store treats null values as 0

douglas_peucker built-in now tries to generate a valid geometry rather than erroring when simplification would result in an invalid geometry.

ALREADYLOCKED: Another process has already locked this file. Error can happen when running sessions after opening Data Viewer

DSV Datastore: Null geometries cause write errors

JSON restore / sync tool does not set user and timestamp metadata

Connection failure after restoring JSON backup for GDAL Data Store

All Geometric superclass included non-geometric classes

Additional attributes in DSV datastore are not mapped correctly in the output mapping

DSV Datastore throws OpenData Session Task error if Properties file "countTotalObjects=True"

Uploaded files not being deleted when load complete, causing disk space to grow

00036330: Rule discovery does not run

Session Data Viewer: Unable to rotate and zoom at the same time

Session Data Viewer: Erratic zoom behaviour in 3D mode after rotating the camera

Session Data Viewer: Handle selecting unrun tasks more gracefully

Session Data Viewer: Only show z values in Fly to Coordinates box when in in 3D mode

Session Data Viewer not displaying all layers

Datastore parameters containing XML special characters cause session run failures

1Integrate session validation should not check tasks that have already run

Restrict to Extent of Opened Data doesn't work with geometries that have M values

Report summary conformance graphs in cache viewer display the incorrect number for conforming objects

Commit task back to ESRI Enterprise GDB failing to commit all features

offset built-in has typo "bea" in description

Regression: Unable to upload ontology through the UI

Sync Tool ‘Force Update Filesystem’ error if folder names don’t match across entity types

Action Map with Filter Rule shows incorrect summary count

Renamed entities cause errors when synching or restoring backups

When a restore is blocked by a referenced entity being deleted, list the items blocking it

Support Full 3D data as a licensed option:

• Oracle Data Store: full support for read and write of Full 3D geometries

• Beta support for read and write of full 3D geometries via: PostGIS, SQL Server, Esri File GDB and Enterprise GDB, Shapefile, Tab file, DWG/DXF, DGN

• Full 3D support for existing built-ins such as union, difference, intersection, dimension, boundary, count_parts, is_valid etc.

• New 3D built-in functions: count_surfaces, extrude, outer_shell, solid, volume,

• Full 3D support for most spatial operators

New built-in function change_dimension

New built-in function get_geometry_as_WKT

Is_valid takes tolerance as a parameter

Engine can crash when using nearest N objects functionality

SQL Server Data Store does not report the Z value when Reporting on geometry with Z enabled

Report XML should include heights when reporting heighted geometries.

Cannot commit to a PostgreSQL table with a foreign key constraint enabled

New and improved 1Integrate Session Data Viewer

New Standard Superclasses for rule/action writing

Support creation of Metadatastores via REST API

Support creation of shortcuts via REST API

New built-in function split_geometry

New built-in polygons_from_lines

New Collection Element value to handle "Array, collection or geometry element"

Allow finding of nearest n objects

Improve ArcGIS Feature server datastore's error handling - catch non-successful status codes early

Support Oracle Linux 7.9

Support latest Wildfly 23.x

Unable to read WFS with data format defined using lower case geojson.

00022194 GDAL Data Store type doesn't offer 'Fix ring direction and inclusion errors' option.

Uploading a file through the REST API does not update the upload credential

Shortcuts in restored backups not detecting clashing existing element/name

DSV Data Store reads invalid geometries regardless of Allow Invalid flag

REST API and UI backup doesn't include all parameters

DSV WKT polygon ring direction not being handled correctly.

New Repo Sync Tool returns blank error message when synching from an old-style filesystem structure.

00036010: Regression: gdal_datetime parsing issue in FGDB date types from 1Int 2.8.1 “Unparseable date: "2018/09/07 00:00:0"

Unable to backup shortcuts

NullPointerException when writing to ArcGIS feature layer that doesn't exist

When running multiple actions in a task, run all features through each action (in UI order), rather than individual features through all actions

Enable simple configuration of Wildfly logging levels in config file

Support WebLogic Server 14.1.1

Native Delimited Separated Values datastore (CSV) that supports geometry

Ability to set and retrieve session parameters via REST API

New session parameter value in Rules and Actions to access session parameters

Ability to generate a Placekey for a location or address

Backup/Restore improvement and new repository synchronisation tool

Make 1Integrate docker images available (contact customer support)

Update admin page to new style

Full repository backup/restore from admin page

SQL Server Integrated Security has a missing a file in v2.8.1

ArcGIS Feature Service Data Store writes null for multipart polygons read in from other formats.

Data Store parameters containing XML special characters cause session run failures

ArcGIS/AGOL Feature Service Data store not recognising some layers as spatial

Recycle Bin records Radius Studio as the user who created the folder

Introduce a system warning when approaching licence expiration date

Allow users to choose between XYZ or XYM for XYZM data via SQL Server Data Store

Configure security settings via settings.properties

New API call to get the number of engines, their availability and the queued jobs

Show which tasks were disabled in the Cache Viewer session tasks tab.

WFS Data Sstore: New OGC Web Feature Service Data Store supporting GeoJSON and OAuth.

Clone an entity via REST API

Remove PostGIS FME datastore (PostGIS support is now only via inbuilt PostGIS data store)

Support PostgreSQL 12.4 and PostGIS 12.4

Java version Support: Oracle Java 8 update 281 with WebLogic

Unable to run a session with special characters in Data Store password

copy_attributes builtin not locating class attributes when specifying attributes to exclude

The error details text on the Licence validation error page is almost invisible

Actions or rules referencing All Classes fails with UNKNOWN CLASS if run before any Open Data tasks

00032528: Unable to backup Session with no classes selected in open data task

REST API doesn't return correct state for a partitioned session

Don't show the FME datastores if the environment's FME build number is below the minimum supported version

Do not load 1Spatial news on the landing page

CAD datastore unable to change attribute type mapping

Opening non-spatial File Geodatabase data using the inbuilt GDAL Data Store in a session with an extent restriction causes the engine to crash.

1Integrate ignores the temp.directory setting

Copying a file based datastore does not copy the uploaded file

1Integrate REST API doesn't support CORS (cross-origin resource sharing) requests

Installation guide update to clarify SQL Server repository user creation

Large files between 500Mb and 1Gb fail upload to a Data Store when using a PostgreSQL repository.

ArcGIS Feature Service Data Store does not handle incorrect polygon ring direction

1Integrate status is incorrectly set to warning even with supported SQL server version

Data Store input mapping attribute indexes are unset on upgrade to 1Integrate v2.8.0 (workaround if already upgraded is to download and re-upload the Data Store through the UI or API).

REST API - Data store GET request is not returning the correct value for whether input mapping attributes are set to "report"

New “Singleton” system class (sys:singleton) for performing action or rule logic exactly once

Support for Microsoft Visual C++ 2019 64 bit Redistributable

Support for Oracle databases that have no locator or spatial module installed

Ability to temporarily disable a task within a session

Support for MS SQL Server 2019

Support for deploying 1Integrate as a service on WildFly, on Windows only. See installation guide for details.

New "session" scoped temporary value, and renaming of existing “local” and “global” scope to “object” “task” respectively within the UI (API functionality is unchanged)

Esri Feature Service Data Store: Authentication via Portal

Scripts and documentation for installing 1Integrate as a service on WildFly, on Windows.

Ability to override the session extent for an open data task, to open all data.

Latest Java patch support

Esri Feature Service Datastore: Related Non Spatial Objects

Error message “unexpected geometry type: 12” when dealing with multisurface feature

Accented characters corrupted in xml backups

Cache viewer not always finding the feature for a non-conformance, when stepping through non-conformance report

Unable to dismiss large error pop-ups

Improved information if Data Store is unavailable (e.g. FME is disabled or custom data store removed)

Unable to load FME PostGIS data store after loading cache viewer

Error message persists when encountering an upload/restore error

Correction to XOR condition description in UI

“Hide stack traces” mode causes repeated error messages

Indexing appears checked at class level when attributes are un-checked

Features failing to write out to Shape via GDAL

APIs not reporting correct indexing state of primary geometry attribute

Toggle all Indexes On/Off within datastore input mapping

Ability to include a custom banner on the login page

Support role-based authorisation when deployed to WebLogic

Upgrade to WildFly version 20

Users can add custom names to tasks within a session, for improved readability

New Data Store: Allow read and write to Esri ArcGIS server feature services

Support Java 8 update 251

Support Windows Server 2019

Support AdoptOpenJDK 8 update 252

Only available Data Store types are listed (dependent on FME integration)

Error in UI when running a session with a multi-polygon extent

Validation Report ignores descriptions of rules when running a folder

Action Map output message corrected (from "fixed" to "applied")

Unable to write out file based Data Stores via FME

Action Map does not return detailed counts in REST API

Ensure the GDAL writer can write classes that contain a colon

Risk of data loss when writing shape files through GDAL

GDAL datastore unable to write out points and multipoints in the same layer

Cache viewer broken in IE 11

Broken feature selection in the cache viewer

Inconsistent session results via REST API

Failing WMS request parsing

Broken XML report download button on the Rule Conformance Results page

Session stuck on polygon WKT open data restriction

OGC simple built-in function can stop session with 'Error in nesting of rings in polygon' for some invalid polygons

Google BigQuery performance and query size fix

Show which session queue is running a session

Support Oracle Database 19c R1 (Database 11g no longer supported)

Support for measures for GDAL Data Stores

New built-in functions (class_get_attribute_type, class_get_attribute_value, class_get_attributes, class_is_attribute_null)

Data Store setting to specify whether to read M or Z when reading XYZM data

Enable Windows Authentication for the FME SQL Server Data Store

New datastore type: Google BigQuery

Restrict Open Data Task's extent to that of convex hull of already loaded data

PostgreSQL repository: Error when uploading large files

Height built-in function throws exception for non-heighted geometries

Remove WildFly library classpath warning in logs

rule_hotspot_geometry built-in function isn't restorable from a 1Integrate for ArcGIS .rules backup

Two dots in a FGDB Data Store name gets blocked by security check

Job graphs don't work consistently across all browsers

PostGIS Data Stores: Cannot set 'Output Mapping' to a different target table to source

GDAL Data Stores leave file handles open, leaking resources

WebLogic startup errors related to classes implementing the Java EE spec

Data store names inconsistently referenced in file upload errors

NullPointerException when generating hotspot for spatial relationships in certain conditions

Security: Various security improvements

Out-of-the-box ability to read and write PostGIS data from PostgreSQL 9.5 without the need for FME (PostGIS via FME on Linux no longer supported)

Support Java 1.8 Update 211

Upgrade to FME 2018 (Note: Using FME 2018 via Data Stores on Linux when running on WebLogic can cause crashes which will be fixed in a later release)

New copy_attributes Built-in operation to copy matching attributes from one object to another

Use more meaningful names for files created by downloading entities

Improve data upload form to be the same as rules upload form

Allow rs_data_loaders role to upload files

Open data tasks error when opening two tables into the same class

Loading a large ontology to a Data Store takes several minutes to upload/select Data Store/use as context

When reporting missing built-in function, report the rule that contains it

Cache viewer not showing multi-part geometries

Cache Viewer rendering wrong for Geodetic data with reversed axis ordering

Cache viewer doesn't display Advanced Style page correctly

Ontology is not backed up with the Data Store

Type error starting session when ontology changes type

Data Gateway: Enable definition of user-defined classes through API to prevent validating report objects.

ORA-00054: resource busy and acquire with NOWAIT specified sometimes seen at startup