Release Notes of Invantive(R) SQL 17.32.270

Invantive(R) SQL

Invantive SQL is a netstandard 2.0 port of Invantive SQL that allows access to over 50 cloud and database platforms, all acting together as one global database.

Created: 10/11/2020 19:23:43 (UTC, deploy002)

Version: 17.32.270

State: Long-term Support

MSI Product ID: 24467287-923b-4dfa-a638-3992c9af298e

Manufacturer: Invantive Software B.V.

Brand: Invantive

Category: Business

Permissions: Software Requirements: Tags:

Included Components:

- Increase freemium limit from 20.000 to 100.000

Bug fixes:
- Fix like optimization on fields with leading or trailing spaces

Version 17.32.266, released 2020-10-07.

Bug fixes:
- Make obsoleted Exact Online columns nullable.
- Removed fields removed in Exact Online due to performance issues on GetMostRecentlyUsedDivisions.
- Improve Oracle date format matching.

Version 17.32.265, released 2020-09-25.

Bug fixes:
- Improve Windows 10 detection.
- Correct billing name for Exact Online to avoid duplicate partition use reporting

Version 17.32.262, released 2020-09-10.

- Extend system partitions by new owner of partition fields
- Add new fields to Exact Online Current/me.
- Add new fields for Exact Online SystemDivisions.

Bug fixes:
- Avoid hang on close.
- Enable use of Invantive SQL on Exact Online division 1 with missing Creator.
- Fix broken paging on CustomerInvoices for

Version 17.32.253, released 2020-08-18.

Bug fixes:
- Fix data issues in Invantive Business documents and transaction lines
- Return Exact Online currencies for Invantive Business currencies table.

Version 17.32.252, released 2020-08-17.

- Improve purging of died sessions on Data Cache repository

Bug fixes:
- Avoid StackOverflow on event log purge after more than 35 days of inactivity

Version 17.32.229, released 2020-08-06.

Bug fixes:
- Clear Account column on RevenueByDebtorList, RevenueByDebtorForYear and RevenueByDebtorForYearPeriod when an empty Guid has been provided.
- Make Account null on Exact Revenue* table functions.
- Nmbrs: default date to null

Version 17.32.228, released 2020-07-08.

Bug fixes:
- Fix parallelization bug where faulting producers would end up the consumer to wait forever.

Version 17.32.227, released 2020-07-06.

Bug fixes:
- Implement rate limit checks on Freshdesk.
- Avoid NullReferenceException in edge cases on OData
- Reduce number of columns in Exact Online XML API ItemPrices.

Version 17.32.226, released 2020-06-26.

- Allow use of license keys split across multiple lines.

Bug fixes:
- Phone number in Teamleader V2 contact telephones is optional
- Update SOAP connector

Version 17.32.223, released 2020-06-17.

- Improve error messages Exact Online on EOL down scenarios

Bug fixes:
- Reduce lifetime of Swagger definition cache from 7 to 1 day

Version 17.32.218, released 2020-05-27.

Bug fixes:
- Reduce use of IN for Exact Online OData queries

Version 17.32.217, released 2020-05-24.

Bug fixes:
- Avoid ArgumentException caused by handling another Exact Online REST exception.
- Fix changed page number semantics for
- Fix compatibility with SQL Server 2014

Version 17.32.216, released 2020-05-21.

Bug fixes:
- Also retry on HTTP 503 errors with OData
- Include all errors of aggregate exceptions for Data Hub
- Allow SQL Server 2014 till January 1, 2021

Version 17.32.215, released 2020-05-19.

- Avoid itgenuir002 error when one of both sides of a SQL set operator has null data type.

Bug fixes:
- Fix problem with Business for
- Updated paging mechanism [ITGEN-5078].
- Correctly pass long values with L suffix in OData filters [ITGEN-5065]
- Make Param_GLAccount for MatchSets, MatchSetLines, and all related tables a GUID [ITGEN-5060]

Version 17.32.214, released 2020-05-11.

- Reduce length of disk cache file names.
- Reduce length of disk cache file names.

Bug fixes:
- Add missing fields on ItemPrices and Items.
- Allow negative duration of I/O due to Windows clock going backward sometimes.

Version 17.32.213, released 2020-05-08.

Bug fixes:
- Fix unnecessary itgenlss009 error on I/O registration.

Version 17.32.212, released 2020-05-07.

- Add sys_context iiid and iuid.

Bug fixes:
- Align version detection on Azure SQL Server with on-premsie SQL Server

Version 17.32.211, released 2020-05-07.

- Revert "Differentiate discovered database per version.
- Differentiate discovered database per version
- Add registration of license code used for Data Cache to ease analysis of finger print issues

Bug fixes:
- Fix for breaking change Exact Online GLAccountClassificationMappings.
- Fix data type of physical memory on Data Replicator.
- Show which connector can not register

Version 17.32.210, released 2020-04-20.

- Backport product custom fields Teamleader from 20.0 to 17.32.

Bug fixes:
- Improve name matching on MySQL.
- Nullify nullable dates returned by NMBRS as 01-01-0001.
- Fix itgenpae011 on Data Hub connections.

Version 17.32.209, released 2020-04-17.

- Raise clearer error when an ANSI SQL create table statement includes the Invantive SQL primary key column

Bug fixes:
- Improve handling of UInt64 on MySQL.
- Fix item field not correctly deserialized [ITGEN-5014]
- Fix itgengpr082 on synchronize with nulled values
- Handle itgenrst007 for required dates filled with 0000-00-00 on MySQL.

Version 17.32.208, released 2020-04-08.

- Add payrollPeriodDataId on PayrollPeriodDataByEmploymentID__embeddedPayrollComponents.
- Add employment ID on PayrollPeriodDataByEmploymentID__embeddedPayrollComponents
- Add consistency checks on completeness of catalog, schema and table.
- More accurate determination of data container ID for ODBC-based data containers
- Allow for I18N messages indicating no access to Exact Online company.
- Change default to return no rows instead of an error when the user is not autorized on Exact Online XML API.

Bug fixes:
- Fix itgenrst004 on FoxPro long data type
- Fix itgenclr009 on MySQL metadata discovery
- Fix Loket metadata retrieval [ITGEN-5012]
- Apply soft-limit throttle on Exact Online when configured lower than expected
- Retry on 429 HTTP exceptions on OData
- Enable query on SystemTableColumns@DataDictionary for SQL Server on ODBC
- Fix itgenase118 error when no where clause is present on ANSI SQL.
- Avoid itgendch796 error when a table partition is obsolete but does not yet have versions.
- Do not display Swagger URL by default.

Version 17.32.205, released 2020-04-04.

- Allow use of aliases for connection string key values to fix PostgreSQL SSL mode configuration

Bug fixes:
- Pass full connector name instead of short name to logging

Version 17.32.203, released 2020-04-03.

Bug fixes:
- Fix connection to Multivers ODBC driver
- Fix use of Data Replicator stored on same platform as an active data container.
- Consider databases invalid when multiple data containers and at least one without an alias
- Evaluate true or null to true instead of null.
- Fix Teamleader language name column name with superfluous space.

Version 17.32.202, released 2020-04-01.

- Add ADO.NET metadata tables to all ANSI SQL connectors
- Include catalog used in event log to ease debugging data cache repository resolution issues.

Bug fixes:
- Avoid unnecessary itgenrst004 data integrity check error when the database data type is raw/object.
- Fix wrong mapping of byte dotnet data type in some scenarios.
- Fix SQL Server table lock escalation disablement for Data Replicator when used on table names with a space
- Show error when a database user has access to multiple repositories instead of recreating repository.
- Fix synchronize not changing not null in target to null from source [ITGEN-5003].

Version 17.32.200, released 2020-03-27.

Bug fixes:
- Handle dates returned as doubles from Excel.

Version 17.32.198, released 2020-03-26.

- Limit maximum runtime of purge old incoming messages per execution to avoid excessive runtimes after a calamity
- Fine-tune data container ID for Swagger-based connectors.

Bug fixes:
- Avoid itgendid070 error.
- Differentiate error itgendch676 depending on completed or incomplete

Version 17.32.197, released 2020-03-24.

- Serialize multiple resultsets in DAP in JSON as dictionary by their name.
- Make discovery settings less preferred than other settings.

Bug fixes:
- Make description on V2 time tracking optional.
- Translate tooltip of databases.

Version 17.32.196, released 2020-03-20.

- Improve clarity of itgenoda221 message.

Version 17.32.192, released 2020-03-20.

Bug fixes:
- Fix Visma.NET logon.
- Remove Exact Online API BankAccountsBulk.
- Backport change default character for invalid filename characters from backslash to underscore.
- Improve error when Exact XML can not be accessed by an accountant
- Add handling for null data type in coerce.
- Add handling for null data type in coerce.

Version 17.32.191, released 2020-03-18.

Bug fixes:
- Fix itgenprr002 error on single character fields on PostgreSQL when optimizing query filters.

Version 17.32.189, released 2020-03-17.

Bug fixes:
- Fix itgendch804 during upgrade of Data Replicator repository to v19

Version 17.32.188, released 2020-03-17.

- Allow deviating row delimiter on CSV.
- New RFC 4180 compliant CSV reader. Breaking change: column delimeter is now ',' instead of ';'
- New RFC 4180 compliant CSV reader. Breaking change: column delimeter is now ',' instead of ';'.
- Improve clarity of error message on CSV incorrect value data types.

Bug fixes:
- Purge orphaned facts in batches of at most 1.000 table partition versions to avoid exceeding SQL Server limit of 2100 on IN.
- Reduce lifetime of AFAS Online metadata cache from 24 hours to 10 hours to reduce incident reports
- Differentiate progress messages between SQL and PSQL.

Version 17.32.186, released 2020-03-07.

- Display 32-bit mode in version label.
- Allow variable page size on AFAS Online for better performance
- Add hint to insert error when insert values and field names count differ.

Bug fixes:
- Ignore non-available connectors to allow multiple Invantive SQL releases to be used while sharing settings*.xml.
- Data corruption when updating or deleting rows [ITGEN-4939].
- Avoid "No database selected" error on MySQL due to order of closing data reader and command for better performance
- Change default SSL mode for MySQL from VerifyFull to Required.
- Calculate domain for Windows authentication at most once.

Version 17.32.185, released 2020-02-27.

- Raise comprehensible error when current/Me on Exact Online returns a negative current division.

Version 17.32.180, released 2020-02-20.

Bug fixes:
- Increase size of phone numbers in Teamleader to 30 positions.
- Fix duplicate Swagger table names [ITGEN-4909].

Version 17.32.179, released 2020-02-19.

- Add additional field on Teamleader that might possibly be the new container for CoC number.

Bug fixes:
- Fix comparison bug with greater than or equals and less than or equals
- Move minimum-text-length backward when multiple connector attributes are present

Version 17.32.177, released 2020-02-15.

Bug fixes:
- Add missing converter for char when auto-casting.
- Rename Exact Online table SupplierItem to SupplierItems to reflect multi-row contents.

Version 17.32.176, released 2020-02-12.

- Allow use of UI_LANGUAGE_CODE without error to ease backport SQL script.

Version 17.32.175, released 2020-02-12.

- Allow specification of 20 dimensions and values on AuditEvents, even when not used for monitoring

Version 17.32.171, released 2020-02-10.

Bug fixes:
- Fix itgenpae003 error on Exact Online for minimum-text-length.

Version 17.32.169, released 2020-02-07.

- Allow incorrectly sized text in XAF files
- Extend maximum length of XML audit file tax registration identification for misbehaving applications.
- Revert "Basic implementation for PIVOT.
- Basic implementation for PIVOT.
- Basic implementation for PIVOT

Bug fixes:
- Fix NRE on joins resulting in null [ITGEN-4817]
- Provide list of languages in preferences when not logged on.

Version 17.32.167, released 2020-01-31.

- Make message itgendch159 non-fatal.

Bug fixes:
- Avoid re-use of metadata structure.
- Dynamically check which fields are available from ADO.NET metadata.

Version 17.32.165, released 2020-01-30.

- Add investigation methods on ADO.NET metadata for ODBC v3
- Add ItemExtraFields to Exact Online.
- Improve clarity of error message itgenpsr061
- Differentiate error itgenfrt003 for easier diagnosis.

Bug fixes:
- Add rowversion data type SQL Server support
- Capture 404 error on ItemExtraFields
- Include language on XAF.
- Fix missing column event_modified when installing empty database with Data Replicator
- Improve handling OData array responses
- Do not use $select on Item Extra Fields with Exact Online to avoid HTTP 404 error
- Count number of required table function parameter values instead of all to determine whether all required table function parameter values have been provided.

Version 17.32.164, released 2020-01-28.

- Reduce sync logging for better throughput on Data Access Point.

Version 17.32.163, released 2020-01-25.

- Drop Invantive maintained views on upgrade to ease upgrades with platforms such as PostgreSQL

Bug fixes:
- Allow use of decimal as input for int64 in combination with itgenrst004.

Version 17.32.161, released 2020-01-23.

- Include data type in itgenrst004 error message
- Add view dc_sessions to datacache service connector
- Add client sessions table for improved check on non-concurrent use
- Include auto-repair on itgendch682 and itgendch683
- Fine-tune SqlException with incorrect certificate setup.
- Finetune message codes given out on connection open failure.

Version 17.32.160, released 2020-01-21.

- Make error itgenttn243 better readable for easier diagnosis.
- Include data type in string representation of parameter list to aid analysis.
- Increase default number of retries for connection loss.
- Force SSL data tansport on MySQL, PostgreSQL and SQL Server and increase connection timeout from 15 to 60 seconds
- Register error code for Oracle exceptions.
- Add retry on BadGateway HTTP error on OData sources such as

Bug fixes:
- Display error message itgencmr004 and itgencmr089 with translation
- Small OR evaluation optimization.
- Do not include settings.XML files with invalid elemtns in database list.
- Fix grouping logic where one row too many was returned.
- Include more context in message itgeneor137
- Clarify error message of OData HTTP servers.
- Avoid connection leak when an error occurs on validation of the Data Replicator repository

Version 17.32.155, released 2020-01-10.

Bug fixes:
- Make tinytext and mediumtext nullable by default on MySQL due to different semantics.
- Add native support for uint16/32/64 on MySQL Invantive SQL maintained tables.
- Enable Invantive maintained tables with int64 rows on MySQL.

Version 17.32.153, released 2020-01-09.

- Differentiate error message itgenoda046 on OAuth failure depending whether on log on or later on during the session
- Add hint when PostgreSQL user is not properly authorized.

Bug fixes:
- Add missing 't' in mapping .net data type int64 and uint64 to an identifier.
- Enable replication of tables with MySQL uint16, uint32 and uint64 data types
- Avoid closing essential service providers to enable license installation even after failing to validate license.

Version 17.32.147, released 2020-01-03.

- Give hint for possible alternatives data containers on itgendch070.
- Auto-create data container ID on downloading replicator messages

Bug fixes:
- Fix split of escaped fully qualified names such as on ODBC with some Microsoft Access drivers
- Fix parse error on ODBC connection string key value in the format {VAL;}.

Version 17.32.136, released 2019-12-16.

- Make number of obsolete table partition versions to purge configurable as a ratio with actual work done on Data Replicator

Version 17.32.135, released 2019-12-14.

- Reduce number of columns in DocumentAttachment on Exact Online XML.
- Make execute script available to all license forms, including free.
- Improve error message itgendid044 when the source by accident uses the wrong culture.
- Disable use of bulk insert on Exact Online following desupport notice.
- Include origin in error itgenrst007 of all columns
- Ignore 'alter persistent cache refresh' when no table partitions have been registered instead of raising itgendch637.
- Make skip of client-side cacheable tables with Data Replicator configurable
- Make default use of ODS in Data Replicator configurable
- Increase default packet size on SQl Server from 8.000 to 32.767
- Reduce runtime of queries yielded the data partial from their result set on SQL Server
- Include client ID in rate limits of Exact Online for when using multiple clients.
- Allow ignoring milliseconds of absolute time when considering file replacement.
- Accept some timestamp difference when replacing timestamps on files
- Disable use of synchronize statement with 17.32 when Data Replicator is active.
- Disable Data Replicator on synchronize statement
- Ensure lock escalation is disabled on Data Replicator with SQL Server starting repository version 24
- Disable lock escalation when creating a table on SQL Server.
- SQL: Nullable/not nullable on create table.
- Make batch size for delete and insert configurable
- Rename AFAS non-standard names to only use identifiers.
- Add support for unsigned float, double and decimal.
- Add consistency checks on Data Replicator.
- Make number of rows per OData insert batch configurable
- Make minimum number of remaining API calls till hard limit configurable.
- Make PostgreSQL logging configurable, improved DDL generation
- Allow database group names to be empty.
- Specify which Exact Online table function parameters are required.
- Differentiate between Invantive SQL and MySQL semantics of non-nullable strings when handling the empty string ''.
- Add support for HH24:MI time format.
- Output PDF wage slips on connector
- Yield results in Teamleader
- Tune retrieval using limit clause from Invantive SQL views
- Enable configuration of page size for payrolling REST connector.
- Improve naming of connectors
- Clarify license encryption error message itgenale013
- Add environment_id to Data Replicator, while removing active version last from the repository
- Backport repository version 21 and 22 to 17.32 to allow version 23 to be used.
- Improve error message when a named parameter is specified twice in a table function
- Enable production use of REST connector.
- Add default views to REST connector.
- Enable replication of table functions with required but defaulted parameter values
- Include time component in cells of Excel export when there is a time component.
- Add unreliable connection simulator for OData and REST connectors
- Retry on timeout and other hard connection loss with Swagger-based connectors such as
- EOL: Raise an error when out of hard daily limits.
- Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure.
- Show different error code itgenexl109 when Exact Online returns an Object Reference not Set itself.
- Provide more fine grained replication progress than table and partition [ITGEN-4507].
- Reduce logging.
- Include table name in message itgendch380.
- Include agreement code in message itgendch380.
- Add partition ID to message itgendch384 when trickle loading is skipped on Data Replicator.
- Change translations.
- Ignore more disk cache encryption problems.
- AFAS: server side filtering: support between
- Make sync keys compare correctly despite deviating type.
- Allow specifying columns to ignore on checking if a row should be updated.
- Allow specifying columns to ignore on checking if a row should be updated.
- Allow to specify excluded columns when synchronizing.
- Add AFAS forwarded server-side filtering.
- Integrate new data encryption model.
- Measure duration of encrypt/decrypt operations for HTTP disk cache.
- Raise clear error when the number of columns changes for trickle loading is different between old and new data set.
- Enable use of acceptance and test environment on AFAS Online.
- Rename Exact Online hour status code domains.
- Add new API V2 Teamleader fields and tables such as withholdingTaxRates, Products, Quotations, LevelTwoAreasByCountry, EventAttendees and EventLinks
- Add retry support to OData POST requests when retry is on to cover 429 recovery for Teamleader.
- Add domain ProjectTimeTransactionStatuses to Exact Online.
- Consider Invantive code parse errors of encrypted disk cache also as a signal for retry.
- Add repository checks that version numbers are handed out in increasing order.
- Enable re-use of automatically discovered databases across 17.33 and 17.32 releases.
- Add SalesOrderLinesBulk Exact Online to webhook tables.
- Refactor TOTP to allow generation of shared keys.
- Provide clear error when the AFAS token does not have the expected format.
- CBS: Enable paging and retrieval of more than 10000 rows.
- Display a default label for partition when connector has none.
- Add more complex data types to FoxPro.
- Allow REST connector to clean data when swagger is invalid.
- Improve performance by more scenarios in which a coalesce forwards to the use of a server-side filter.
- Improve byte array support on PostgreSQL.
- Clarify error message when Data Replicator is not licensed [SUP-805].
- Allow specification of data container alias to derive IUID from in settings.xml on database level using 'iuidSource' attribute.
- Allow specification of data container alias in SYS_CONTEXT for improved logging and analysis features.
- Add default translation for invalid licenses to aid in V5 to V6 license switch.
- Add ascii_to_blob / unicode_to_blob SQL functions to enable Twinfield office and password encoding.
- Display clearer context of SQL parse error.
- Add flattened views to Teamleader for easier deployment on replication.
- Enable forcing of custom field values to strings to aid in analysis of number of wrongly typed values in Teamleader.
- Add dbms_trace.put_line PSQL procedure.
- Make setting Oracle client information optional.
- Allow specification of SQL statement to execute upon open and close of pooled connection.
- Ignore empty connection string attributes.
- Update translations.
- Do not retry OData request when a HTTP 501 is returned, such as on 'select * from CommunicationNotes where statusdescription is null'.
- Accept that a configurable number of CBS tables raise an error when loading metadata.
- Improve message when an encrypted disk cache file is empty.
- Increase granularity of deletes when purging orphaned facts using attribute orphaned-facts-delete-page-size-rows.
- Allow check on connection pooling active on ANSI SQL connectors using SystemDataContainerProperties view.
- Add picture for Exact Online user to be displayed in SystemDataContainers.
- Add picture of user to SystemDataContainers as workaround for missing picture in SystemUsers.
- Allow specification of backing database bulk insert page size in rows and bytes for Data Replicator.
- Improve clarity of exceltable error messages.
- Allow collection of Data Replicator repository contents for support purposes.
- Change redirect URL to for all Exact Online apps except Netherlands.
- Include error code from nested exceptions in message.
- Add analysis features for HTTP disk cache usage per connector in data dictionary.
- Reduce length of HTTP disk cache files to more easily fit on length-constrained platforms.
- Check on maximum length of file name and path combined.
- Restrict number of times a user message is displayed in client editions.
- Improve performance by reducing translation lookups.
- Include origin in obfuscated columns to be shown on error reporting.
- Improve nameing of HTTP disk cache files to reduce length.
- Allow use of disk cache with Data Replicator.
- Split cache files for HTTP disk cache and Data Cache.
- Allow specification of minimum needed freshness interval for partition versions to be selected in refresh.
- Raise error when user tries to explicitly refresh a table or partition that isn't replicated yet [ITGEN-4345].
- Allow purge of orphaned facts on upgrades of Data Cache repository.
- Add refresh origin to table partition versions of Data Cache to allow prediction of whether pre-loading data is necessary.
- Add api-url parameter to Mendix.
- Make default primary key field name configurable per ANSI SQL connector.
- Avoid long hang on log on to AFAS with invalid credentials [ITGEN-4314].
- Allow table function parameters without placeholders on Facebook API for better selection.
- Reduce file I/O conflicts in massive parallel environments for backups of discovery database.
- Performance: Rewrite of retrieval from database cache so we can stream the results.
- Enable multi-tenant use of Data Cache objects within one database.
- Improve resilience against Facebook rate limit errors.
- Allow inclusion of retry mechanisms signaled through OData errors.
- Memorize content type of HTTP requests.
- Forward more filters on join sets for better performance on OData queries.
- When Data Replicator version loading database fails on first version, purge that version too automatically.
- Differentiate between maximum accepted and maximum desired URL length for HTTP-based platforms.
- Add extra column to display documents of Exact Online.
- Add Exact Online functions ThumbnailByUrl, ThumbnailByRow, AttachmentByUrl and AttachmentByRow.
- Enable retrieval of BLOB content from native scalar requests.
- Add view dc_fact_size_statistics_r for Data Replicator.
- Rename Owner Company to Subscription Owner in Exact Online.
- Give hint when on SQL Server the date tried to insert is outside of allowed value for SQL Server.
- Retry on itgenoda039 for Exact Online [ITGEN-4173].
- Update Exact Online bulk APIs fields that support server-side filters.
- Improve messages when Exact Online only returns partial data.
- Improve XML Exact Online error messages.
- Add views on Exact Online payroll APIs to ease replication.
- Add new Payroll APIs to Exact Online connector.
- Reduce minutely rate limit from 600 to 300 for Exact Online.
- Upgrade components.
- Improve performance by reduced use of DateTime.Now.
- Improve performance of determining balance type of GL account on Exact Online.
- Allow presence of not yet available connector names in database configuration files.
- Check URL for maximum lengths.
- Update Exact Online domain code values.
- Update Exact Online XML data model.
- Add table functions for Exact Online XML APIs for more fine-grained access.
- Support retrieving child rows on Swagger operations: naming resolution.
- Return number of transactions changed by Exact Online Upload XML instead of 0.
- Support retrieving child rows on Swagger operations.
- Default maximum length of partition code and name.
- Add 'exists(...)' SQL-condition.
- Display clearer message when Invantive Keychain file is empty.
- Exact Online: add App Center APIs.
- Improve retry mechanism on Exact Online when Exact Online crashes during retrieval of XML data.
- Add sql%rowcount, sqlerrm and sqlcode pseudo variables [ITGEN-3366].
- Add SQL functions sqlcode, sqlerrm and sqlrowcount.
- Add Visma eAccounting connector [ITGEN-1645].
- to_date and to_char functions updated to support RFC3339 dates.
- Add SQL function excel_day.
- Add SQL function months_between [ITGEN-4068].
- Add Data Replicator attribute 'facts-delete-page-size-characters' to limit number of bytes deleted per facts delete batch.
- Add SQL Server bulk insert option 'bulk-insert-page-size-bytes' to limit size in bytes on top of existing limit in number of rows.
- Enable use of connector-specific views in distributed databases.
- Improve recognition of CSV date/time export by Google Sheets [ITGEN-4071].
- Add CaseWare and AccountView databases.
- Set schema name to folder and correctly convert memo field values to long string on Foxpro.
- Add support on to_date for date mask 'MM'.
- Add hint to error message on unknown filter column on XML-based connectors.
- Add REST connector [ITGEN-3870].
- Default user name and password of credentials container to the defaults of the data container when no other are available.
- Improve handling of Data Replicator when the backend database fails.
- Update Octopus connector.
- Allow connector attribute specification of in-memory cache for event logs of Data Replicator
- Create Octopus InvoiceLines, DeliveryNoteLines and BuySellBookingLines tables [ITGEN-4045].
- Octopus: Add BookYearPeriods table [ITGEN-4044].
- Provide company code table function parameter when running queries [ITGEN-4051].
- Add columns for company code and name [ITGEN-4050].
- More clearly log externally triggered errors such as SQL Server crashes in dc_event_log of Data Replicator.
- Allow SQL syntax with 'except' as in "select t.* except col1, ..., coln" [ITGEN-3979].
- Add pre-defined views to Facebook connector.
- Add Foxpro connector.
- Add Firebird connector.
- Allow specification of alias using @xxx for table and partition refresh. [ITGEN-4017].
- Add new bulk Exact Online APIs to trickle loading.
- Add 18 new Exact Online bulk API tables.
- Update Mendix connector.
- Add Octopus connector [ITGEN-3613].
- Implement controltype, decimals and length for fields on AFAS [ITGEN-4008].
- Display partition code in error message [ITGEN-3990].
- AFAS Online connector: Subject, File and Version connector [ITGEN-2935].
- Include failing table name in itgenrst004 error.
- Do not fail on invalid column name when dropping it.
- Add AFAS Online connector [ITGEN-2935].
- Add connector attribute 'ignore-http-500-errors' for OData connector [ITGEN-3991].
- Simply null checks when one or both the operands are constants.
- Allow use of PSQL variable as value on billing id, billing reference and set value.
- Add partitioning on table functions on Swagger-based connectors [ITGEN-3963].
- Optimize SQL function execution.
- Reduce registration time of connectors by 150 ms.
- Reduce load time of Exact Online data model.
- Reduce start-up time of Dummy connector by 50%.
- Reduce time to initially load Data Replicator repository by 50%.
- Add check on maximum length on databasecolumn constructions, as on ColumnSpecification.
- Enable registration of billing ID using expressions.
- Include SQL fragment causing error in error message.
- Extend HTTP download in Dummy connector to enable more flexible online downloads such as JSON from secured web sites.
- Allow specification of glschemeid on Exact Online XML General Ledger tables.
- Allow configuration of maximum allowable age in seconds of Swagger specification disk cache.
- Improve performance of XPath element splitting.
- Unwrap XML OData errors.
- Improve Data Replicator special repository upgrades.
- Add Data Replicator attributes upgrade-force-execute, upgrade-force-repository-version-start and upgrade-force-specials.
- Add connector attribute 'page-size-rows' to
- Reduce number of rows per page from 5.000 to announced 500 rows.
- Require use of Azure SQL Server S1 or better with Data Replicator.
- Restrict number of audit events not only to a specific age, but also to number of entries.
- Use default translations where available when a lock exception occurs during translating.
- Add check that last used SQL engine version should at least be matched for Data Replicator.
- Restrict maximum length of various Exact Online columns.
- Add ensure view dropped and column dropped methods to ANSI SQL-based connectors.
- Add data dictionary view SystemDataContainerReservedWords.
- Allow installation of comment on PostgreSQL and Oracle.
- Limit lengths of various Exact Online text fields.
- Rename Data Cache repository columns to enable use on Oracle 11g:
seconds_before_obsolete -> sec_before_obsolete
seconds_before_droppable -> sec_before_droppable
seconds_retention_forwarded_ime -> sec_retention_fwd_ime
seconds_metadata_is_droppable -> sec_metadata_is_droppable
date_trickle_approach_activated -> date_trickle_activated
date_copy_approach_activated -> date_copy_activated
date_smart_approach_activated -> date_smart_activated
- Migrate boolean to char data types to ease portability of Data Replicator to less advanced backing database platforms.
- Check values for insert and update before actual transport in Invantive SQL for adherence to metadata.
- Validate rows before insert to match metadata.
- Add data dictionary view SystemMessages.
- Include automatic conversion between Char and string(1) dotnet data types.
- Enable out-of-band messages for PRINT on SQL Server.
- Register notifications from PostgreSQL.
- Add generic handler for connector notifications.
- Show clearer error message when implicit data type conversion for joins fails [ITGEN-3881].
- Limit number of table partitions obsoleted when partially refreshing.
- Add checks to Data Replicator on not (yet) installed database objects.
- Reduce time slot in which crash leads to inconsistent last active version registration and version creation.
- Reduce memory allocations when checking row integrity.
- Increase throughput of GLAccountClassifications XML API of Exact Online in scenarios with over 200 companies.
- Aggregate errors found during consistency check into 1 error.
- Increase maximum degree of parallelism for file operations.
- Add connector attributes to ignore Exact Online XML no access errors.
- Force regeneration of fact and history tables and logical views upon upgrade.
- Check consistency of installed table columns with table specification after executing DDL statements.
- Include name, type, nullable and origin of column in generated SQL DDL.
- Add consistency checks between table partition and versions.
- Add global support by basing times of Data Replicator on UTC instead of local time.
- Show clear error when data downloaded for Data Replicator does not match specifications [ITGEN-3860].
- Extend logging field names of result set rows by their origin.
- Retry HTTP timeout without payload as a Internet connection down with same retry mechanism.
- Upgrade Salesforce connector API from 37 to 39.
- Set partition for non-partition specific tables to 'DEFAULT'.
- Add consistency check on Data Replicator when purging data.
- Automatically have Data Replicator recreate facts and history tables when database object was removed by user [ITGEN-3836].
- Allow drop of Data Replicator partition without access to original partition [ITGEN-3821].
- Add paging on Visma .NET and all other Swagger-based connectors, preparing for 2019Q2 release of
- Add application controls on minimum/maximum number of rows in a table partition [ITGEN-3835].
- Add Exact Online APIs PayrollComponents, ProcessWarehouseTransfer, WarehouseTransferLines and WarehouTransfers.
- Structure table names for Visma.NET.
- Add various statistics to Data Cache table partitions and versions.
- Add Data Replicator sourcing_date column to store when a row was loaded from the original source.
- Throttle Exact Online API calls according to rumoured new limits for short-time rate limits.
- Add checks itgendch454 and itgendch455 to dc_warnings_r.
- Add manual purge of unneeded Data Cache incoming messages.
- Add partition based rate limits [ITGEN-3810].
- Add to_boolean SQL function.
- Allow specification of billing reference.
- Clarify error message when object definition could not be found when switching to trickle loading.
- Maintain statistics over time per table partition in Data Replicator repository.
- Add check on trickle loading not being activated within 30 days for Data Replicator.
- Add Facebook Marketing, Graph and Insights rate limits view.
- Add COMPlus_DebugWriteToStdErr environment variable documentation for .NET Core.
- Include more partition statistics on Exact Online for better performance of SQL engine
- Add Data Dictionary view SystemTableFunctionParameters.
- Add Facebook paging.
- Add Facebook Marketing tables: AdCreativesByAd, TargetingSentenceLinesByAd, AdRulesByAd, CopiesByAd, LeadsByAd and AdPreviewsByAd.
- Allow floats and doubles in to_number.
- Add Facebook Marketing API tables AdInsightsByAd, AdKeywordStatsByAd, AdCampaignsByAdAccount, OwnedPagesByBusiness, OwnedAdAccountsByBusiness, OwnedAppsByBusiness, OwnedProductCatalogsByBusiness and SystemUsersByBusiness.
- Show front-end and repository version numbers in Data Replicator error message when different.
- Add new Exact Online APIs such as BankSubscriptions.
- Display warning pop-up when a Data Replicator environment has tables not being maintained for too long time.
- Include name of source table when an error occurs in Data Cache upgrading a facts or history table.
- Add Facebook tables: ImpactingAdStudiesByAdAccount, AdInsightsByAdAccount and 8 others.
- Add Facebook rate limit statistics table.
- Support for table function parameters in Facebook.
- Clarify error message when partition is not found.
- Add Facebook tables AdPixelsByAdAccount and AdvertisableApplicationsByAdAccount.
- Add IsLicensed to SystemDivisions for Exact Online.
- Add support for retrieval of sub nodes in Facebook metadata. [ITGEN-3710].
- Add Facebook tables: AdCreativesByAdAccount, AdSetsByAdAccount, MyPublishedPosts, MyTaggedPosts, MyFriends, MyGroups and MySessionKeys.
- Update Facebook documentation.
- Add photos, likes and businesses to Facebook connector.
- Add Facebook table adStudies.
- Include 2nd order dependencies only once on Facebook columns.
- Add columns to Me on Facebook connector.
- Add profile picture on Facebook connector user.
- Simplify overall view maintenance for cross-country use of Exact Online with Data Replicator [ITGEN-3708]
- Disable retries by default on SOAP-based connectors.
- Only retrieve page number requested on
- Implement re-raise statement, only valid from within exception block [ITGEN-3690].
- Support MySQL and Teradata connector on non-Windows platforms.
- Add automatic time correction based upon Internet time of Invantive servers.
- Include fetch parameters in session I/O logging.
- Add memory and disk cache to Swagger-based connectors [ITGEN-3674].
- Optimize SQL coalesce operator [ITGEN-3671].
- Load connectors from settings file.
- Synchronize on identifying columns having all nulls [ITGEN-3681].
- Rename company columns to COMPANY_CODE and COMPANY_NAME for
- Add synchronize support for Swagger-based sources such as
- Allow generic provider-specific definition of partition name column.
- Add trace native calls to Swagger-based providers.
- Extend RateLimits view on Exact Online by several additional columns.
- Add trace-native-calls setting to all SOAP-based providers such as NMBRS, and
- Added Exact Online DocumentAttachments and DocumentAttachmentsBulk tables.
- Add EXPLANATION column to SystemProviderAttributes.
- Update Exact Online documentation.
- Add Exact Online tables EmploymentConditionGroups, PayrollTransactions and PayrollTransactionsByPayrollYear.
- Avoid log on to customer 1 for Teamleader.
- Add overdue warnings as events on Data Cache to make it easier to manage for users.
- Display details of progress in Query Tool spinner.
- Auto-adapt on Exact Online API gateway which seems to use two types of UNIX epoch times.
- Increase resolution for refresh periods from days to seconds.
- Add view to query currently known Exact Online rate limits per partition.
- Add warning statistics on number of missed purges and obsoletions.
- Add Swagger grouping tables.
- Add day of week to_char format.
- Update documentation.
- Improve message code on raise_application_error in PSQL.
- Add Visma .NET provider.
- Require metric value when using custom monitoring events.
- Allow case-insensitive matching on service URL when retrieving OData service metadata.
- Add tables ItemBarCode and EmploymentInternalRates to Exact Online.
- Enable uploading across divisions of Exact Online document attachment files.
- Display context where an error occurs in exceltable data.
- Exclude settings.xml from session initiation procedure.
- Add ISO week number date mask YYYY-IW.
- Check Exact Online responses for inline error messages outside of standard.
- Handle changed parameter value correctly; do not keep using the default value [ITGEN-3562].
- Add clone methods for partitions.
- Reduce duplicate retrievals of partition information for better performance on ANSI SQL.
- Improve performance of SQL Server data model discovery by factor 5.
- Add data models.
- Extend documentation Teamleader.
- Extend Data Replicator statistics.
- Two-way synchronize SQL statement.
- Sync table statement uni-directional way.
- Require data container alias when using distributed databases.
- Reduce startup time of connection manager by 50 ms.
- Improve clarity of error messages when parsing Excel tables.
- Extend userenv by various folders such as for Templates.
- Display correct user name on [ITGEN-3477].
- Display results from consecutive pages and cache results [ITGEN-3478] [ITGEN-3476].
- Updated scopes for Teamleader API v2. Removed deprecated scopes.
- Add CompanyInfo data model.
- Restructure reading the WSDL SOAP definitions.
- Add AdAccounts to Facebook provider.
- Exclude short description from label in Log On Window when not present.
- Add table partition columns to view dc_table_partition_version_r.
- Store all discovery connections in settings-discovery.xml.
- Differentiate error messages on Exact Online for easier recognition of rotating refresh tokens.
- Add named table function parameters to Invantive SQL.
- Default casing of Invantive SQL identifiers is upper case.
- Add userenv sys_context variables: database_comment and database_short_description.
- Add short one-line description to database groups and databases for better human recognition of groups and databases with codes as names.
- Differentiate in logging between two types of view creation for Data Replicator.
- Add documentation on how to use free fields on Items with Exact Online.
- Register origin of database column for more meaningful error messages when using Data Cache.
- Better naming of view columns in Data Replicator mode for PostgrSQL.
- Show clear error when the backing database data model doesn't reflect the intended data model and can't be upgraded easily [ITGEN-3385].
- Memorize origin of Data Cache columns and show them in error message.
- Add SYNC and COMPARE syntax to Invantive SQL.
- Add explicit configuration of casing and length of logical view names and view column names.
- Add default rule for GUIDs in Data Replicator when upgrading to new backing database model version with required GUIDs.
- Update translations.
- Add TransactionLineVATs and SubledgerTransactionLineVATS to XML Audit File Financial 3.0, 3.1 and 3.2.
- Clarify error message on itgenttn159.
- Simplify event monitoring on duration tasks.
- Add columns to auditevents table in Data Dictionary for monitoring metrics.
- Introduce string_split table function.
- Improve performance of updating and deleting on the in-memory storage provider [ITGEN-2919].
- Enable insert ... values with multiple rows.
- Add group function ZIP (blob expression, file name) [ITGEN-3251].
- Data Cache: allow providing partition mode when setting the seeding approach, so you can set all, the currently selected or a specific partition.
- Add SQL statement 'alter session set billing id'.
- Update Teamleader documentation to include V2.
- Update translations.
- Enable log on for Data Hub using a refresh token specified as command line argument.
- Restrict maximum length of itgenrst009 error message.
- Include additional license information in SystemLicenses view.
- Reduce size of individual delete statements on obsolete table partition versions to improve reliability on platforms such as PostgreSQL which don't support paged deletes [ITGEN-3321].
- Update Exact Online data model for REST APIs: creditedsalesinvoices, OAuthScopes and extensions to SystemDivisions and Accounts for GDPR.
- Add Exact Online domain view ReturnStatuses.
- Pivot Open Exchange rate tables.
- Include possible values for enumerable types in Invantive SQL error message.
- Update translations.
- Prepare encryption of HTTP disk cache.
- Improve formatting of errors with nested errors by adding line feed.
- Include label of division for which you might not have access on Exact Online in error message.
- Include label of division in errors when you specify an unregistered Exact Online division.
- Allow logical overall views with names exceeding 30 characters.
- Parallellize disable and enable on webhooks [ITGEN-3233].
- Enable web hooks from set options approach statement. Keep loading completely when receiving no messages [ITGEN-2985].
- Finetune warning views of Data Replicator.
- Add metadata to Open Exchange Rates provider.
- Aggregate exceptions occurring during disable/enable webhooks.
- Allow differentiation between generating JSON for trusted or untrusted readers.
- Increase maximum size of result set to above 4 billion rows.
- Add support for maintenance of webhooks when a data container other than Exact Online is also connected.
- Remove remaining support for apiclientid, apiclientsecret and apiclienturl without dashes.
- Add label to rows_affected column.
- Implement manage webhooks statement [ITGEN-2985].
- Allow specification for Data Replicator of index facts and/or history tables.
- Add cast SQL-function to cast values to another data type [ITGEN-3193].
- Check consistency of index names early on when creating tables on ANSI databases through Invantive SQL.
- Limit index name length based upon underlying platform restrictions for Data Replicator.
- Add set operator: 'union distinct on', allowing to match a union on specific fields.
- Optimize the registration of web hook statistics when downloading the feed on clients [ITGEN-3063].
- Add Exact Online subscription owner data to Me view.
- Add suggested filename for download an Exact Online backup
- Fill ActionInProgress field in Exact Online backups table.
- Avoid trailing underscore in custom field views of Teamleader.
- Add provider attribute 'backing-maximum-length-identifiers' to Data Replicator to specify non-default maximum length of identifiers for a platform.
- Add provider attribute 'maximum-length-identifiers' to specify non-default maximum length of identifiers for a platform.
- Extend data dictionary model to allow differentiation between read-only partitions and read/write partitions.
- Add support for JSON flattened output. Traditional format renamed to jsondataset.
- Introduce new table function exceltable, allowing to read Excel files [ITGEN-3065].
- Remove leading and trailing '_' for custom field names in Teamleader introduced due to non-alphabet characters being used.
- Combine consecutive set operators like 'union', 'union all' and 'minus' to improve performance with 100+ consecutive set operators.
- Upgrade components.
- Add optional specification of initial database on PostgreSQL log on window to simplify with AWS environments with no access to postgres and template1 database leading to PostgreSQL 3D00 error.
- Allow synchronous and asynchronous backups.
- Fix 'alter persistent cache purge obsolete table partition versions' not actually deleting rows when connected to multiple data containers [ITGEN-3145].
- Include event description in Data Cache's dc_event_log in addition to event code.
- Allow using expressions as input for the JSONTABLE and XMLTABLE table functions.
- Allow using expressions as input for the CSVTABLE table function.
- Simplify aggregated exceptions for clearer error messages.
- Include column name for which data type is missing in error message itgenfir003/4.
- Retrieve cookies from logon dialog.
- Clarify error message itgensql104 when no partition is selected for USE.
- Switch to production release.
- Update translations.
- Add group functions First() and Last() [ITGEN-2754].
- Add more context to error messages on Teamleader invalid data in custom fields.
- Add linefeed between attributes in settings.xml for easier manual maintenance.
- Add row context when Teamleader or other OData sources return corrupt data, not matching the agreed upon metadata.
- Add support for JValue in DataUtility conversion methods for better error messages on Teamleader corrupt data.
- Include row data in streaming result set checks on individual column values for easier resolution.
- Add serialization to string of a named array or spare array row.
- Improve uniqueness of HTTP disk cache file when a Windows user uses multiple cloud accounts to the same platform.
- Add Sample Dummy data source to Invantive Business.
- Clarify error message itgendid170 about missing alias.
- Register Data Container ID and Log On Code in HTTP response cache object to improve correct matching for re-use of disk caches.
- Extend Invantive Business metadata and Invantive SQL integration.
- Allow non-default casing column names on ANSI SQL providers.
- Reduce number of alternative provider attribute names to avoid confusion with users.
- Add number of HTTP disk and memory cache incorrect version and content counters to providers.
- Improve CPU performance of SQL LIKE.
- Reduce memory pressure when massively calculating API URLs.
- Improve performance of file name determination by factor 10.
- Improve performance of parallel MD5 calculation for HTTP disk cache.
- Cache Teamleader custom field definitions for 1 hour on disk for better performance under repeating connects.
- Add SQL_VARIANT SQL function.
- Add auto-maintained indexes on in-memory storage provider.
- Determine result set statistics on demand.
- Improve performance by streaming row checks.
- Streamed reading for ANSI SQL providers, like SQL Server and Oracle.
- Reduce CPU load due to compression of result sets.
- Use default user name and password when mode is read only.
- Check on presence of user and password/secret for Loket, NMBRS and Visma Severa.
- Clarify error message on Teamleader API group authentication.
- [ITGEN-3052] Add drop table support on MySQL.
- Add SQL function 'sign'.
- Change database data type of flags in dc_settings from char to varchar for better MySQL.
- Improve error message when repository view can not be installed of Data Cache.
- Add data dictionary views 'systemcatalogs' and 'systemschemas'.
- Add SQL function 'basename'.
- Update EDIFACT drivers.
- Add Outlook data model documentation.
- Add PSQL "alter data dictionary set ..." statements.
- Support encrypted connection strings when connecting to Data Replicator/Data Cache from a DDL statement.
- Include attributes as fields on XSD simple type extensions.
- Add ItemTranslations and GLAccountTranslations to Exact Online XML API.
- Add data dictionary provider connection string and encrypted to database definition [ITGEN-2832].
- Allow explicit column specifications with 'create or replace table'.
- Add execute native to PSQL [ITGEN-2963].
- Add dbms_lock.sleep PSQL procedure [ITGEN-2964].
- Add execute immediate INTO clause to PSQL.
- Add PSQL go to label and support <