added

Runtime Config File (engineParameters.xml) - updated Vault External Values Resolver examples

added

External Value Resolver - new resolution delegation system to be able to retrieve values from external systems

fixed

Session is unexpectedly not stopped when exception "java.lang.OutOfMemoryError: unable to create new native thread" occurs

added

File Component: add the ability to use apply string delimiter on all fields no matter the field value or datatype

fixed

Execute Delivery Process Action does not find the delivery to be executed when executing with "Deliv Name" parameter on a remote Runtime

fixed

File Driver - when generating a file with string_content property field the encoding set on the Metadata is not taken into account

fixed

File Component: when writing a file, the string delimiter character is not escaped properly if it is found in source data

fixed

REST Web services invocation: when an invocation was failing, JSON response was not correctly populating "Fault" part, which avoided to retrieve the error response into a target datastore

added

Support delivery pulling for deliveries published as web service on Analytics 3 repositories

fixed

Execute Delivery command: when executing from command line a delivery through 'synch' option, an 'error during waiting delivery' is unexpectedly thrown if the given delivery has the 'nbmaxParallelsession' property specified in the Process meta-inf

fixed

Runtime is now using Stambia classloading in initvariables.sh as it was the case for initvariables.bat

fixed

Schedules list is empty when Runtime is accessed through HTTP from Navigator View

fixed

ODBC: unable to execute Mappings / Processes which are using ODBC because exceptions are thrown at execution (such as "java.lang.UnsupportedOperationException" or "java.sql.SQLException: No suitable driver")

added

Delivery pulling from Analytics 3.x is now supported

added

Remove Google Sheets Component from default installation, it is now shipped as an additional Component

added

XSLT Transformation Process action: improve stylesheet error messages returned

fixed

Excel Driver: when using truncate option on large Excel files a "Java Heap Space error" is unexpectedly thrown

fixed

Runtime database connection pooling: when connection pooling is enabled, there might be errors at execution when the Runtime tries using a connection which is not valid anymore (such as when the database is restarted after the connection has been created)

fixed

SQL File Export Process Action: string delimiter is not correctly doubled when already doubled in source data

added

Ability to connect to HTTPS secured Runtimes

added

Google Sheet driver: support fetch mechanism when retrieving data

added

New scripting context methods to define and retrieve custom session classloaders

added

New options available to allow ignoring certificates checks when trying to connect to an HTTPS secured Runtime

added

XSL Transformation Process Action: support using custom session class loaders

fixed

Processing XML and JSON files recursively with the use of a mask is not working when using UNC path

fixed

__ctx__.executeCommand[s]("execute delivery mydelivery") is not working when performed in a delivery executed from startdelivery.bat/startdelivery.sh scripts

fixed

Scheduler: schedules are not starting anymore, logging java.lang.NullPointerException in log files

added

Execute Delivery action: support executing the given delivery on a Runtime cluster

added

File Driver: support using "NULL" keyword in list of columns in a select query

added

Runtime Configuration file (engineParameters.xml): add a new sample file demonstrating how to use environment variables to define values

added

REST Web service invocation: support sending and receiving a line return separated list of JSON objects as input / output

added

REST Web services invocation: support sending input parameters without encoding them through the new binding type "http:urlReplacementNotEncoded"

added

Update initvariables.sh / initvariables.bat scripts to allow more of their variables to be specified through environment variables

added

__ctx__.executeRemoteCommand[s]: support executing the given command(s) on a Runtime cluster

fixed

A File Wait action binded to a target Executed Delivery action in "Errors Accepted mode" is running indefinitely when one of the executed deliveries produces an error

fixed

Execute Delivery action: Asynchronous mode has no effect when used in Non-Memory mode

fixed

FTP actions: unable to perform operations on an FTP Server which requires to reuse the same TLS session for data connection ("Remote host closed connection during handshake" is thrown or operation has no effect)

fixed

FTP Actions: a NullPointer exception was thrown when using « Socket Timeout » parameter

fixed

Google Sheet driver: when loading data into a sheet the number of lines written is unexpectedly limited by the batch size

fixed

Google Sheet Driver: First line (after headers) is unexpectedly empty when writing data into Google Sheet with "truncate target table" parameter

fixed

Jython scripting: first execution of a Jython script might generate a "Failed to get environment" error in Runtime's console under Windows Operating System

fixed

REST Web services publication: new meta_inf options are available in Processes to define for each Process if input / output temporary files should be kept at invocation

fixed

Read Email action: NullPointerException might be thrown when reading emails containing specific attachment or content without name

fixed

Runtime Monitoring Editor: Monitoring (Thread), Virtual Machine and Purge tabs were not working when connecting to the Runtime through HTTP

fixed

Runtime Configuration file (engineParameters.xml): parameter "defaultSessionLogLevel" was not taken into account anymore

fixed

Runtime might become unavailable and unresponsive in a specific situation where a Process is trying to retrieve a connection while the Runtime is internally cleaning connections (fix deadlock issue)

fixed

REST Web services invocation: when invoking web services, the runtime should support sending / reading requests with uncommon content-type for XML / JSON input and output such as application/ld+json, application/atom+xml, ...

fixed

SQL File Export : Support the new parameter (SQL Exp Enclose All Fields) to add String Delimiter to every fields

fixed

Unable to execute an action which has been encrypted from the Designer

fixed

Write File action: out of memory issues when trying to append data with append mode "before" on big files

fixed

When writing JSON / XML files using the sort order feature, the generated queries are unexpectedly using a "non-breaking space" character which can cause issues with some databases

fixed

When the Runtime is configured with "startSoapServer" parameter to false, deliveries containing XSD Metadata do not appear in deliveries list (from Designer's and Analytics' Navigators or command line utilities for instance)

fixed

Writing multiple XML or JSON files in parallel could produce "impossible to rename file" exceptions

added

Ability to communicate with Runtime through HTTP

added

Add the ability to execute custom user SQL Queries each time a connection is initialized

added

Performance improvements for SQL File Export action

added

REST Web services publication: ability to customize HTTP path and HTTP Method on which a delivery can be invoked

added

REST Web services publication: a Swagger definition describing published web services is now available

added

REST Web services publication: ability to define URL Path parameters directly in invocation path attribute through a mask

added

REST Web services publication: Swagger UI application is now shipped with Runtime

added

SOAP Web Services invocation: ability to specify a raw wsse content which will define the wsse security of the soap envelop generated for invocation

fixed

REST Web service invocation: unable to invoke web service with body parameters contains special characters in their name

fixed

When multiple log database nodes are defined in configuration file, the Runtime unexpectedly tries to connect to all of them instead of only the one specified with "userLogDefaultName"

fixed

XmlToJdbc action: when using file export option numeric columns are unexpectedly considered as string

fixed

XmlToJdbc action: when using file export option the specified decimal separator is ignored

fixed

builddelivery.bat / builddelivery.sh scripts are throwing a class not found exception when being used

added

Execute SSH action: new parameter to customize the session variable in which the error output is published

added

Runtime Configuration file (engineParameters.xml): ability to define default logging level used for executed sessions

fixed

Change the text type default value of MySQL log database configuration examples from "text" to "longtext" to avoid truncation issues

fixed

Execute SSH action: when a command fails the corresponding error output is not returned

fixed

File Driver: when loading multiple source file with a mask an error unexpectedly occurs if trying to use binary_content or string_content property fields

fixed

Runtime Configuration file (engineParameters.xml): environment variables and java properties should not be parsed when in comments

fixed

When enabling web service secure protocol security in Runtime configuration file an exception is thrown at Runtime's startup and services do not start

added

Support changing how autocommit is managed when performing select operations

fixed

Schedules launched in command line mode are not using the specified input parameters

fixed

Sql To Parameters Process Action: when using autocommit mode, connection retrieved may unexpectedly not be in autocommit mode

fixed

Runtime credentials are required error is unexpectedly thrown when invoking anonymously a Stambia Web Service on Runtime with security enabled, even if the configured anonymous user is allowed to execute

fixed

SQL Actions which using AUTOCOMMIT mode should reinitialize JDBC connection when the current connection is invalid

fixed

Web services invocation: when loading a JSON input using dynamic local node name an exception is unexpectedly thrown when data is not a valid QName

fixed

When a session is executed from web service the user executing it is not logged inside log database

added

New parameter in Runtime Configuration file to specify the batch size used for log database purge operations

added

Operating System Command action: new option to ignore error output when computing the status

added

REST Web services publication: information extracted with "extractRequestInfo" now also contain information about the hostname, ip, and user name invoking

added

Runtime Configuration file (engineParameters.xml): all previously commented parameters and nodes which have default values are now uncommented to make more comprehensive what value are used by default

added

Runtime Configuration file (engineParameters.xml): change the default folder used for web services deliveries

added

Runtime commands: "format" option is now supported on "restart session", "wait session", and "stop session" commands

added

Runtime commands: "synch" option is now supported on "restart session" and "stop session" commands

added

Runtime Configuration file (engineParameters.xml): ability to set parameters values from java properties and environment variables

added

Web services invocation: new option to specify the delay between retries

fixed

"Execute Delivery" action unexpectedly throwing exceptions when being executed on a secured Runtime (such as java.lang.NullPointerException or Credentials are required)

fixed

Change the sample JDBC URL of Microsoft SQL Server log database configuration examples to include a parameter which avoids the requests to the log database to be too slow and produce deadlocks in some situations

fixed

Excel driver: performance issue when writing a huge number of cells into an Excel file

fixed

SOAP Web Services invocation: retry number not working properly

fixed

SOAP Web Services invocation: only first element of the response is read in rpc style response

fixed

Web services invocation: when invoking a web service the proxy settings specified are not used by OAuth2 to generate tokens, leading to connection issues when using proxies

fixed

Web services invocation: revise the behavior for invocation errors and retries which was not satisfying and which differed from REST and SOAP

fixed

__ctx__.executeRemoteCommand[s] functions unexpectedly throw "java.lang.StackOverflowError" when being executed from anonymous user of a Runtime

fixed

__ctx__.executeRemoteCommand[s] functions unexpectedly throw "java.rmi.RemoteException: Credentials are required" exception even when there is an anonymous user configured in the remote Runtime

fixed

stopengine.bat / stopengine.sh scripts unexpectedly throw "java.rmi.RemoteException: Credentials are required" exception even when there is an anonymous user configured in the Runtime

fixed

XML to Database Loading: implict conversion is not performed

fixed

XML to Database Loading: java.lang.NullPointerException might be thrown when reading XML files

added

Ability to secure the RMI service through TLS

added

OAuth2: support "Client Credentials Grant", "Implicit Grant", and "Resource Owner Password Credentials Grant" flows

added

OAuth2: support changing the HTTP method used to retrieve the OAuth2 token

added

builddelivery.bat / builddelivery.sh scripts: support building deliveries from multi-deliveries packages

added

builddelivery.bat / builddelivery.sh scripts: new option to list the processes contained in a package

added

builddelivery.bat / builddelivery.sh scripts: new option to choose the process to build from the package

added

builddelivery.bat / builddelivery.sh scripts: new option to change the folder where deliveries are built

added

builddelivery.bat / builddelivery.sh scripts: new option to change the mode used to generate deliveries

fixed

Change the blob type default value of MySQL log database configuration examples from "blob" to "longblog" to avoid "com.mysql.jdbc.MysqlDataTruncation" when working with big deliveries, for instance

fixed

File Wait Process Action might cause a memory leak in some cases which may lead to out of memory errors

fixed

OAuth2: additional Authorization Parameters specified for token generation are not handled

fixed

Purge: scheduled purges launched on a secured runtime are not executed

fixed

REST Web Services Invocation: "Impossible have multi Input Content-type" is unexpectedly thrown when invoking a web service with both an "http:urlReplacement" parameter and JSON content as input

fixed

Read Email action: ClassCastException might be thrown when reading emails with specific content-types (E.g. QPDecoderStream cannot be cast to javax.mail.Multipart)

fixed

Scheduler: schedules launched on a secured runtime are not executed

fixed

Schedules launched in command line mode are not using configuration declared in STAMBIA_PROPERTIES_LOCATION

fixed

Typos in some of the Runtime .bat / .sh scripts

fixed

Variable CORE_FAILED_ACTION_ID was unexpectedly logged into log database

fixed

When a session information request is performed (from Designer for instance), some of the lines which are logged in the log files to trace the request are missing the session name

fixed

Web services invocation: when the content type of the input is set to "application/vnd.api+json" the json structure is not generated in the body of the web service invocation

fixed

Web services publication: published wsdl might be missing elements

fixed

XML Loading: when an error occurs while reading xml files, files which are copied inside the "Error Dir" are unexpectedly locked by the Runtime until it is stopped, avoiding moving or removing them

fixed

XML: when generating multiple XML files the execution fails if the generated file name contains a '$'

fixed

XML Loading: when loading multiple xml files at once into a database using wildcard, if an error occurs all the files are copied inside the specified "Error Dir" instead of only the file which causes the error

fixed

builddelivery.bat / builddelivery.sh scripts: an error should be thrown when using the -extract option without specifying a configuration name through the -conf or -conffile options

fixed

builddelivery.bat / builddelivery.sh scripts: .properties files should not be extracted when using the scripts

fixed

installEngineAsService.bat does not reference STAMBIA_VM_PROPERTIES and STAMBIA_STARTENGINE_VM_PROPERTIES variables

added

Ability to specify a custom cyphering key for password encryption / decryption

added

Ability to define a list of keystores and keys in the Runtime Configuration file

fixed

Execute Delivery action: when the Memory Mode option is set to false, an exception should be thrown if the child session becomes dead during execution

fixed

File Driver: loaded files might not be released and unexpectedly kept in memory, which might lead to Out Of Memory (Java heap space) errors

fixed

Metadata Variable: "SetToSavedValue" operation should not re-save the variable value in the corresponding connection

fixed

Metadata Variable: "AutomaticValue" operation should not re-save the variable value in the corresponding connection when the value has been retrieved from the session context

fixed

Processes / Actions might not notify correctly their parent when log database issues happen during executions, causing sessions ended "executed" even if there were errors

fixed

Premature end of file exception when retrieving the list of deliveries with utilities such as "get delivery" command, if one of the delivery files is not formed properly

fixed

Runtime log files contains "%port" in their name instead of the real port when there is an exception while processing the security of "engineParameters.xml" configuration file

fixed

REST Web services invocation: the value set in the "Delay Between Invocations" parameter is unexpectedly doubled for REST invocations

fixed

Read Email action: "ClassCastException" is thrown when the content-type of the message is application/txt

fixed

SOAP Web Services invocation: "Delay Between Invocation" is not taken into account when retrying a failed invocation through "Retry number" parameter

fixed

The retrieving of session information during execution might fail and produce exceptions in some cases because the session data exchange object might unexpectedly be cleared at some points

fixed

When writting a JSON file, the root object is unexpectedly surrounded with line returns

fixed

builddelivery.bat / builddelivery.sh scripts generate incorrect deliveries when the Package is using User Defined Functions

fixed

startcommand.bat / startcommand.sh scripts should display a better message when the Runtime is killed while a command is running

added

Execute Delivery action: new error message when trying to set a remote Runtime when Memory Mode is unchecked

added

New scripting context methods to execute multiple Runtime commands at once: __ctx__.executeCommands and __ctx__.executeRemoteCommands

added

Runtime commands: support using the "format" option on "execute delivery" command, allowing to specify the list of information to return after the execution

added

Runtime commands: a new information column, which allows to return the exception that causes the session to fail, is supported on the "format" option available on actions such as "get sessions"

added

SOAP Web Services invocation: add the ability to specify a folder where attachments returned by SOAP requests will be stored

added

The "ForceToFalse" option of the "Nil Behavior" parameter available on templates treating with XML / JSON files is now supported when writing JSON files

fixed

Execute Delivery action: when the Runtime on which the Delivery is executed is configured with Delivery repositories, the "Deliv Name" parameter does not work (File Not Found, Delivery searched in build/deliveries instead of the repository)

fixed

Execute Delivery action: "Deliv Session Name" parameter is not used when Delivery is executed in "Remote Delivery Mode"

fixed

Execute Delivery action: when executing a Delivery on a remote Runtime with ''Remote Delivery Mode" option, the child session is unexpectedly inserted twice in the log database

fixed

File Driver: when writing a file, the string delimiter character is not escaped if it is found at first or last position of the source data

fixed

Send Email action: Mail content in HTML mode is not properly encoded when the system encoding is UTF-8

fixed

Variables might not be published on the correct action when performing multiple __ctx__.publishVariable at the same time

fixed

builddelivery.bat / builddelivery.sh scripts do not handle correctly values from submetadata inherited from parent metadata, producing deliveries with incorrect values when a value is set on the parent metadata in the conf file

fixed

java.lang.NoClassDefFoundError: org/eclipse/core/runtime/Assert might be thrown when using buildDelivery.bat / buildDelivery.sh scripts

added

New option to enable the use of a connection pool for Runtime Logging

fixed

Disable the automatic drop table when (re)creating log database

fixed

XmlToJdbc action: rename of the temporary work file to final file at the end of the treatment might fail on Linux when working on mounted shared drives

added

Connections to databases are now initiated directly through a Standard JDBC connection instead of a BasicDataSource, to reduce initialization time

added

New option to enable the use of a connection pool for JDBC databases connections

added

Update the shipped ant.jar library to version 1.9.10

fixed

A SQL Operation Process Action configured with 'SQL_ACTION_TYPE' to 'SELECT' has no effect when it is not binded to any target action (query is not executed)

fixed

Execute Delivery Process Action doesn't work when configured to execute the delivery on a remote secured Runtime

fixed

File Driver: A string delimiter is unexpectedly added around null values when writing a file

fixed

Load of XML Files into Database: the conversion of XML boolean values to numeric values doesn't work

fixed

REST Web services invocation: error when connecting to a https service through proxy

fixed

Schedules created prior to runtime S17.4.4 might be paused at Runtime's startup

fixed

Web services publication: published web services unexpectedly asking for authentication when the security of the Runtime contains only an anonymous user

fixed

XML Loading: "fileAbsolutePath" Property Field is incorrectly populated with null values when using the "Nb Writers" option to read a set of XML Files

fixed

Unable to build deliveries from Packages generated on versions prior to S19 Designer

added

File Driver: new variable in transformation scripting to return an array of data: __ret__

added

New S19 Designer generation system is used in the build scripts

fixed

Deliveries built from buildDelivery.bat / buildDelivery.sh scripts are unexpectedly generated with the same id when built from the same Package multiple times

fixed

File Driver: returning a java.lang.String[] array in a transformation scripting does not work

fixed

File Driver: returning an array in a transformation scripting does not work when using nashorn

added

Generation performance improvements for the JDBC to XML action

fixed

JSON and XML: nullity doesn't work correctly since RN-702

fixed

Web Service Invocation fails when the Input node was designed after the Output node in the Metadata

fixed

File Driver: returning an array in a transformation scripting does not work when using rhino with Java 1.8

fixed

REST Web services invocation: Proxy settings were ignored

fixed

SCP Get with SFTP mode doesn't support using a relative path

added

REST Web services invocation: add support for the 'PATCH' HTTP method

added

REST Web services publication: add possibility to start the session in asynchronous mode

added

Sap Idoc Sender new parameter: "SAP_IDOC_TRANSACTION_COMMIT_NB"

added

Sap Idoc Sender new parameter: "SAP_RFC_QUEUE_NAME"

fixed

Execute Delivery inconsistently retrieves Stack trace from child session's actions

fixed

OAuth2 security: specifying a client secret should not be mandatory

fixed

Send Mail action: trust hosts when connecting with TLS to avoid connection issues with some severs

added

A custom security manager has been added to remove the security.policy file

fixed

Metadata Variable: when a large string value is saved in the variable, it might not be retrieved correctly at read

added

A new library providing utilities is shipped with the Runtime: stambia.jdbc.driver.utils.jar

added

Get Files with FTP Process Action can be used as the source of a bind link

added

Execute Delivery action: new parameter to specify if the delivery should be searched in the local or remote Runtime: 'Deliv Remote Delivery Mode'

added

Excel driver: when oppening an Excel file after performing operations on it, formulas are now automatically recomputed

added

New parameter on the execute delivery command to specify the session name: "sessionName'

added

New variables in the Runtime scripts to add Java Options add startup (initvariables.bat / .sh)

added

Runtime security: add the possibility to define an anonymous user profile with configurable rights

added

The "startcommand" utility now returns the exit code of the last executed command

added

XML Reading performances improvements

fixed

Distinct Deliveries with nbMaxParallelSessions may block each other without reason

fixed

Excel driver: A NullPointerException is raised when inserting data with a definedName

fixed

Excel driver: inserting data with a definedName corrupts the target file

fixed

Excel driver: an unexpected header with mismatched columns is generated when the order of columns in the insert query differs from the file's one

fixed

Excel driver: several fixes on data insertion

fixed

Excel driver: truncate doesn't work correctly when used on a definedName

fixed

Excel driver: When inserting rows, the style of the previous rows might not be preserved on the new ones (The style should always be retrieved from the row following the header)

fixed

Excel driver: the truncate statement doesn't handle correctly the cells with formulas and inlineStr storage mode

fixed

Impossible to remove a scheduled purge

fixed

Runtime security: an exception should be thrown at startup when the security node doesn't contain at least one user

fixed

Sql File Export: decimal values are unexpectedly rounded to 3 decimals since enhancement 2603

added

JMS Receive Action: "Out File Pattern" parameter should be optional

added

New actionConfiguration entry in the Runtime Configuration file to override Process Actions default behavior

added

Sql to Parameters Process Action: the default datetime format to use can be configured in Runtime Configuration file

added

XmlToJdbc action: new "fileEncoding" property for the file export option

added

XmlToJdbc action: new "queueSize" property for the file export option

fixed

AIX Java 1.8: An error is randomly raised during session id calculation

fixed

File Driver: String delimiter unexpectedly added on numeric fields containing decimal numbers

fixed

File Driver: the quotes used to surround the column alias in a select query are unexpectedly included in the alias name

fixed

Scheduled jobs with a custom job name are not automatically restarted once runtime is started

fixed

XML to Database: an error might occur when using several times the same source XML field on a target table

added

Add a Java Compiler to compile class at runtime

added

Excel driver: The columns that don't exist in the target Excel Sheet are created automatically at write

added

File Driver: use format property to format numeric field

added

File Driver: add new Property for default numeric format

added

File Driver: add new Property for default numeric grouping separator

added

File Driver: support files using a hierarchical directory structure in Metadata (sub-directories)

added

File driver: new reader version improving file reading performance (readerversion=2)

added

File driver: new property "readerversion" on the driver URL allows to change the reader version

added

Google Driver: add new option to choose manually the scope when generating OAuth2 tokens

added

JSON writer: separate root objects with \n

added

New column in 'get schedules' command output to show the state of the schedule

added

Sql File Export: new parameter to specify numeric format: "Sql Exp Numeric Format"

added

Scheduler: add the possiblity to schedule several deliveries on the same job

added

Web Services Publication: add https support on exposed endpoints

fixed

CORE_STACK_TRACE may not be populated if the Action name contains special characters such as #

fixed

Concat action does nothing when used as a bind target

fixed

Excel Driver: unable to specify multiple definedName in the jdbc url

fixed

File Driver Hexa decimal Grouping separator encoding doens't works

fixed

File Driver: decimal numbers between 0 and 1 are written without leading 0

fixed

Improve JSON writing performances

fixed

ORA-01000 may be raised when using multiple SqlFileExports in a Session

fixed

Runtime Linux scripts do not support cluster mode

fixed

Sql File Export: decimal numbers between 0 and 1 are exported without leading 0

fixed

SCP Actions may run indefinitely in some environments where Java is unexpectedly waiting for a user prompt to continue

fixed

StartDelivery should raise an error when passing a configuration which does not exist in the delivery

fixed

Scheduling a delivery on remote host doesn't works

fixed

SendEMail with attachment on Iphone System (IOS) doesn't worked correctly

fixed

The Elapsed time in the Sessions View is not calculated correctly

fixed

The purge command deletes all sessions when the user enters an unrecognized status

fixed

Unable to read an XML file that contains a local relative doctype

fixed

Web Service Invocation: "Method not implemented" Exception is thrown when the Web Service invocation is performed through a proxy

fixed

Web Service Invocation: the encoding specified is not used to encode parameters and URL

fixed

buildDelivery command doesn't build correctly with staging point

fixed

get schedules command does not work when schedule name is not provided

added

Add the ability to remove / unpublish a delivery

added

New Runtime command: get repositories

added

Orphan schedules referencing nonexistent deliveries are automatically paused at Runtime's startup

added

Rest Web Services invocation: support non structured data (binary, string, anyuri)

fixed

An unexpected null node is added when the repetition key used for loading JSON / XML files is filled with null values

fixed

Execute Delivery Action: Bind variables used on a custom parameter are incorrectly replaced when performed in a bind script

fixed

Potential incompatibility with Java 1.6 when using hostname security restriction

fixed

SAP: error when reading an Idoc with datatype QUAN

added

Add the ability to sort data when loading XML and JSON files with the addition of a new Property Field: "sortKey"

added

Add sorting direction capacity (ascending / descending) when loading XML or JSON files

fixed

Add the ability to retrieve the node path when reading JSON / XML files with a new Property Field: nodePath

fixed

Add the ability to retrieve the node position when reading JSON / XML files with a new Property Field: nodeLocalPosition

fixed

REST Web services invocation: the JSON content sent to the web service does not contain any value

added

Add the ability to define JSON and XML nodes names dynamically at write

added

Add the ability to process XML and JSON files recursively with the use of a mask

added

Add possiblity to restrict access to a list of hosts

added

Add possiblity to restrict access to a specified username and password

added

Add the ability to define a load balanced cluster of Runtimes with failover

added

Add privileges to Runtime connections

added

Allow to retrieve the system information of the current XML or JSON file

added

Add the ability to define a name pattern for JSON and XML nodes, allowing to retrieve dynamically the nodes matching the pattern at read

added

FTP: New option FTP_SYSTEM_TYPE to specify the server system type

added

File Driver: allow to define a number of ending lines to skip

added

Log database: new column in the LOG_SESSION_SESS table: SESS_LAUNCH_USER

added

New JavaConfiguration entry in the Runtime Configuration file to specify additional Java Options

added

REST Web services invocation: new Binding Type to define dynamically the HTTP Verb used at invocation: http:method

added

REST Web services invocation: Add possibility to retrieve the HTTP headers of the response

added

Review and reorganize the Runtime Configuration files

added

REST Web services invocation: Add possibility to retrieve the HTTP response code and HTTP response message

added

Stambia REST Web Services: allow to customize the response's HTTP Status code

added

Sessions can be configured to restart automatically when an error occur during its execution

added

Web Services Invocation: The Input, Output, and Fault files created at invocation can be configured to be deleted automatically

added

Web services invocation: add trace files containing the input/output headers

fixed

"FileDriverListResultSet cannot be cast to com.stambia.jdbc.driver.file.resultset.FileDriverResultSet" may be raised when working with * in file path

fixed

An error may occur when executing the same delivery in parallel, making it hang to prepared state or avoiding it to start

fixed

An error occurs on the initialization of Schedules that are configured to be executed from 'Command Line', avoiding them to start (since RN-377)

fixed

An error occurs at startup when the folder defined in FileRepository doesn't exists

fixed

An error might occur at startup when there are not any web service deliveries in the Runtime

fixed

Autocommit might be unexpectedly disabled on SQL Operation Actions configured with "SELECT" Action Type

fixed

File Driver: allow to define a range of lines to process in the Record Filters

fixed

File Driver: header generation doesn't work when writing multiple files

fixed

File Driver: Timestamp and Date fields are not loaded at the correct position at write

fixed

ReadMail: an error is thrown when the email contains an attachment with special characters in its name

fixed

ReadMail Action: The folders created for the received mails should not be created hierarchically

fixed

Stambia REST Web services: The status code returned for nonexistent deliveries should be 404 instead of 500

fixed

Web Services invocation: Json Faults responses are not supported

fixed

Write File Action: the file might be unexpectedly deleted when using the 'before' option of 'Txt Write Append' parameter

fixed

java.net.ConnectException: Connection timed out might occur when connecting to some FTP Servers

fixed

File Driver: ".bad" files are not generated on non-Windows operating systems

fixed

Web Services invocation: The Authorization http header should be generated automatically from the Security's User and Password set in the WSDL Metadata

fixed

Web Services invocation: malformed Json input when data contains empty strings

fixed

XML: Boolean values are not converted to INTEGER if the target database does not have any boolean datatype

fixed

java.util.ConcurrentModificationException may be raised on actions having multiple target bind links

fixed

An error is raised when using the FTP Put Action as a bind target

fixed

File Driver: java.lang.ArrayIndexOutOfBoundsException when using bad file functionality

fixed

Web Services invocation: the new woodstox library (RN-474) causes an error at execution

fixed

A NullPointerException is randomly raised when executing an execute delivery action in parallel with other actions

fixed

Stambia Web Services: Input and Output files are not generated correctly and unexpectedly rewritten at invocation

fixed

SOAP Web Services invocation: An error might be thrown when the WSDL Metadata contains a part of type string

fixed

Web Services invocation: An error is thrown when the response contains line breaks

added

"get trigger" commands are renamed to "get schedule" commands

added

Add the possibility to encrypt action code

added

Add support for AMQP technology

added

Add support for BSON technology

added

Add Directory Scan for File Repository and web service

added

Exposed Webservices support HTTP repository to retrieve the delivery information

added

Embedded HSQL engine is upgraded to 2.3.4

added

File: new property "Physical Size" on Fields to specify the size in bytes

added

File Driver supports reading multiple Files using a mask in the file name

added

File Driver: add support for reading and writing string or binary content (raw mode)

added

HTTP Rest web service invocation: http headers can be specified as Parts with the new http:header binding type

added

Load Xml To Jdbc Improve performance

added

Runtime as Windows service: service log files are now rotated

added

Rest Web Service invocation supports non structured data (binary, textual, etc...)

added

REST web services endpoint: get parameter values from url path

added

SAP Connector: new action SapAbapExecute

added

Scheduler: Allow to specify a custom name for a Schedule

added

Stambia REST Web Services can now be customized with the use of a new META-INF property: httpRestWebServiceProperties

added

Web Services: New REST endpoint #2 supports Json input/output

added

Xml To Jdbc a "choice" with "macOccurs=-1" doesn't fill all records

added

XmlToJdbc: new SPLIT_PATH and SPLIT_NB_ELEMENT properties to split the intput xml file

added

XmlToJdbc: new NB_WRITER property to launch multi thread writing

added

XmlToJdbc Action: add FILE_EXPORT_PROPERTIES to write files instead of datastores

added

__ctx__ has a new method getJsonUtils() helping reading and writing of JSon data in scripting

added

purgeLog.sql: add DELETE statements for new tables in this sample script

fixed

Action Bind: it is now possible to continue execution if an iteration fails - see #2117

fixed

Bind with FileWait as a source: target action is sometimes not executed

fixed

Blob Datatype to Base64Binary conversion, one byte is missing

fixed

Creating a schedule raises an error when a previous schedule was deleted on the same delivery

fixed

File driver: StackOverflow when big number of rejects

fixed

Jython script fails when using "import" command

fixed

Jython script fails when using import command on java class

fixed

Missing parameters in the Help Command

fixed

Missing method when Calling a webservice with JSON on AIX

fixed

Performance issue on Unzip when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on Untar when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on File Wait when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on SCP Get when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on SCP Send when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on File Delete when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on File Copy when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue on File Move when using Includes/Excludes on a directory containing a large number of sub-directories

fixed

Performance issue when reading base64Binary XML data

fixed

REST web services endpoint: fixed error message when number of input metadata is > 1

fixed

Schedule Cron expression starting with a space raises an exception when trying to edit from the navigator

fixed

Soap webservice call: error raised when response contains xsi:type and type attributes

fixed

Sessions suddenly appear as prepared but cannot be executed, forcing to restart the Runtime

fixed

SSH action: errors when used as bind target

fixed

Typo in the get triggers command: prugeunit should be purgeunit

fixed

The wsdl descriptor file of Stambia's Soap Web services should not contain Json Web services

fixed

The responses of Stambia's REST Web services do not contain the content-type header

fixed

When using publishVariable with realTimeReport=true the variable does not appear in Analytics

fixed

Woodstox library is updated from 3.2.8 to 4.4.0

fixed

java.sql.SQLException: No suitable driver when using the JDBC-ODBC Bridge Wrapper

added

JdbcToXml: new parameter FILE_EXISTS_BEHAVIOUR

added

Oracle to Xml : new Empty Value Keyword for writing empty values in XML attributes (template update required)

fixed

Different scripting connections may be shared if started concurrently

fixed

ExecuteDelivery: NoClassDefFoundError when DELIV_MEMORY_MODE is set to false

fixed

FtpGet: when FTP_NB_FILES is set to -1 no file is retrieved

fixed

FtpGet raises "remote path not found" when FTP_WAIT_MODE set to true and FTP_NB_FILES greater than effective number of files

fixed

Rdbms Actions do not handle BLOB datatypes correctly

fixed

Rhino Scripting: CharAt() and length() have erratic behavior

fixed

Rhino engine is randomly erratic since Bug #1593

fixed

SqlOperation Statistics are incorrect when the number of rows is a multiple of the batch size

fixed

SqlOperation : ORA-22275 may be raised when binding CLOB data between different Oracle databases

fixed

Web service and Xml statistics are not cumulative

fixed

Xml does not support base64Binary

added

Google Spreadsheet: new command line utility to get Oauth2 access_token and refresh_token

added

New REST URL supports publication of Web Services with unwrapped endpoints

fixed

Bind Error "Host variable 'p0' is not initialized" when implicit conversion disabled with some column types

fixed

Classpath is too long when defining the Runtime as a windows service

fixed

Errors caught when Child Session executes a webservice are still raised

fixed

ExecuteDelivery in non-memory mode raises an exception if the child process contains a beanshell scripting action

fixed

Indented XML files: elements are loaded with one text record for each indented child element

fixed

Rhino is missing under JRE 1.8

fixed

Start Delivery with absolute file path on windows does not generate any log entry

added

SqlOperation: when BatchSize is set to 0 runtime does not use the addBatch() JDBC method

fixed

Delivery as a webservice: pLogLevel has no effect, but plogLevel works

fixed

Jdbc File Driver: line transformations do not work with Java 8

added

Google Sheet driver: add support for latest GoogleSheet format

added

Google Spreadsheet driver supports Oauth2

added

Oauth is supported

fixed

NoClassDefFoundError javax/jms/JMSException when executing on Windows XP a process containing a bind link

added

Embedded log4j is upgraded to 1.2.17 and now supports smtpAppender

added

File driver supports data containing the String Delimiter

added

New property Numeric Padding Char on a file specifies the character to append to the left of a numeric value

added

Reduce STAMBIA_STACK_SIZE to 256k by default in initvariables.sh

added

Stambia's Web services can be invoked through HTTP/Rest

added

Sql File Export supports data containing the String Delimiter

added

WebServices invocation support JSON

fixed

Command "resume trigger" has no effect

fixed

Excel driver may fail when writing to excel file

fixed

Execute SSH: SSH_RET_MESS contains an extra carriage return

fixed

Excel driver: conversion functions do not support empty values

fixed

Excel driver does not replicate the style of the cells to the inserted rows

fixed

NullPointerException when invoking Web Services with indented response

fixed

SendMail: cannot establish connection with TLS security

fixed

StartDelivery fails to parse properties on AIX

fixed

The position of the Fields is not respected when writing to hierarchical file

fixed

Variable Manager does not support LONGVARCHAR JDBC Datatypes

fixed

Wrong substitution when generating a mapping expression containing more than 10 process parameters

fixed

Error when GetSCP is bound to a SqlOperation with more than one result

fixed

Error when PutSCP is bound to a SqlOperation with more than one result

fixed

Mail actions (send and receive), IND_SESSION_MAIL_LST_INFO table is not filled anymore ("To", "CC", "BCC" informations)

fixed

Session Id can sometimes be the same for two sessions launched at the same time (in addition to fix 1194)

fixed

Bind sometimes leaves the statement open since 17.2.8

fixed

Writing to a Multirecord file can raise an error since fix 1342

added

FileWait can be directly used as a source of bind link

added

New API __ctx__.createBindedPreparedStatement() in Scripting Actions to produce a Resultset for an outgoing Bind link

added

New option JDBC.BIND.DISABLE_IMPLICIT_CONVERSION to disable implicit conversion during a binding operation

fixed

Binding NVARCHAR data into Postgresql fails because setNString() is not implemented by the driver

fixed

Command "get triggers" displays jobName instead of deliveryName in the Delivery column.

fixed

Execute and schedule Commands do not work anymore since s17.2.5

fixed

File driver: numeric data with more than 8 digits are altered by INSERT statements

fixed

File driver: on Linux, Numeric columns are written with the "," as the group separator

fixed

Log purge fails on MySQL and SQL SERVER since S17.2.2

fixed

Runtime command: schedule delivery should use "jobName" instead of "with name"

fixed

Runtime command pause trigger has no effect

fixed

Sap: Transaction commit does not work with jco3

fixed

SqlToParameters may raise an Exception on AIX

fixed

Variable Manager: only the latest value of one Variable is saved. Other values are always lost

fixed

WSDL: runtime locks temporary files if an Exception is raised

fixed

WSDL: with REST URL replacement the space character in URL is replaced by + instead of %20

fixed

installEngineAsService : AccessControlException when security.policy is externalized

fixed

startdelivery.sh configured with an encrypted password for the log database raises "Problems getting the log parameters"

added

Http Rest Web Service: add support for urlReplacement

fixed

Sql File Export: Max File Size parameter unit (K M G) doesn't work correctly

fixed

Sql To parameters: String datatype doesn't work anymore since RN-263

added

Bean Scripting actions support __ctx__ object

added

Sql To Parameters: new attribute dateTimeFormat to convert date or datetime into String

fixed

Process with a loop : Sub-process in error is not executed on next iterations

fixed

Session Id can sometimes be the same for two sessions launched at the same time

fixed

Unable to execute a command on a Runtime

added

Jdbc File Driver: PreparedStatement supports setClob()

added

Web Service HTTP: add support for XML inputs

fixed

SqlFileExport fails when data contains a CLOB column

added

Embedded Hypersonic SQL database version is upgraded to 2.3.2

added

StartDelivery's stack trace contains the synchronous child session's stack trace if any

fixed

A process with too many RDBMS connections in parallel hangs

fixed

Delivery file parsing error on AIX

fixed

File Driver delimited mode does not generate unmapped fields in the correct order

fixed

StartDelivery: default session name is the delivery ID instead of the delivery name

fixed

Stop/Start (restart) scheduler doesn't work on version S17.2.2 only

fixed

Stop/Start/Restart soap sever doesn't work

fixed

Unreadable Delivery file generates Exceptions during session report

fixed

Variable Manager with save and refresh connections doesn't release correctly the connections to the connection pool

fixed

VariableManager: refreshing a variable with datatype NVARCHAR raises an error

fixed

Xml to Rbms may execute a last empty batch which fails on some technologies

added

Bean Scripting Framework: SCRIPTING_LANGUAGE now supports "beanshell" (Java Bean Shell)

added

Concat Files: Support for special characters \n \t \r \f

added

New logLevel -1 is supported to prevent any logging by the runtime

added

New log file com.indy.engine..rdbmsLog.log provides information on log storage

added

SQLFileExport: Support for special characters \n \t \r \f to specify the Field separator and the Row separator

added

SqlToXml: new option NO_DATA_BEHAVIOUR

added

Scheduler: org.quartz.jobStore.dataSource property supports "internal" keyword to avoid the definition of a datasource

added

engineScheduler.properties is optional

added

startdelivery.bat and startdelivery.sh: new parameter loglevel

fixed

Execute Delivery doesn't work if JAVA_HOME contains a space character

fixed

Excel JDBC driver does not handle correctly upper case column names when columnNameStyle is set to flat

fixed

File driver silently ignores errors on dates and timestamps with wrong numbers and returns erroneous values

fixed

JDBC File Driver: Computed Field do not work correctly on delimited files

fixed

Log deletion on DB2 UDB doesn't work

fixed

Missing method when generating a Hierarchical File on AIX

fixed

SOAP Web Services published by Runtime are not WS-I compliant

fixed

When exporting a Sap Bapi Structure the name "Structure" is used instead of the real name

added

SCP/SSH actions: New parameter SSH_TIMEOUT (in milliseconds)

added

Variable Manager: if a "Var Value" is specified and the "Operation" is set to "AutomaticValue", the Variable Manager will use this value

fixed

Calculation of statistics is sometimes incorrect

fixed

Conflicts occur when using the same runtime installation directory to run multiple runtimes publishing the same delivery as a webservice

fixed

SqlFileExport: SQL_EXP_UNCRYPTED_JAVA_PASWORD parameter returns null

fixed

Wrong statistics returned to Analytics when iterating in a process

added

A meaningful message is raised when an error occurs during the parsing of a delivery

added

Command execute delivery: new parameter configuration will support multi-configuration deliveries coming with Analytics 2.1.0

added

ExecuteDelivery: new parameter Deliv Configuration will support multi-configuration deliveries coming with Analytics 2.1.0

added

FtpPut and FtpGet: new Paramater CONNECTION_TIMEOUT in milliseconds

added

FtpPut and FtpGet: new Paramater SOCKET_TIMEOUT in milliseconds

added

FtpPut and FtpGet: new Paramater DATA_TIMEOUT in milliseconds

added

File Driver supports Timestamp

added

New demo environment

added

PutFtp: new Parameter "Append" allowing to append the content being transferred

added

Runtime can be configured to support Http Repositories coming in Analytics 2.1.0

added

SSH: new parameter SSH_OUTPUT_PROPERTY allows to specify a session variable storing the standard output of the command

added

TransactionName property of actions having a Rdbms connection defaults to T1 instead of empty string

added

startdelivery.bat: new parameter -configuration will support multi-configuration deliveries coming with Analytics 2.1.0

added

startdelivery.sh: new parameter -configuration will support multi-configuration deliveries coming with Analytics 2.1.0

fixed

Bind links may execute a last empty batch which fails on some technologies

fixed

File Driver writes fields based in the order where they were declared instead of using the Position

fixed

Starting the same delivery twice may cause an error on Runtimes using the logging on a Rdbms

fixed

Unsuccessful links are not evaluated when used on Actions bound to a Target action with a Bind link

fixed

Execute Delivery: Property file is not set correctly when the STAMBIA_PROPERTIES_LOCATION variable is set in the child session

fixed

Runtime does not start on AIX

fixed

Sessions may not be displayed correctly

fixed

Execute Delivery fails when the parent session is started in command line

fixed

Exception is thrown when converting a SQL BIGINT datatype into an XML long datatype

fixed

Missing method when generating an XML File on AIX

added

Add the ability to write into hierarchical files

added

FTP: new option FTP_ENCRYPT_CHANNEL_DATA for better support of FTPS

added

FTP: New option FTP_DISABLE_LOGIN to avoid authentication on FTP server

added

Initial Pool Size for JDBC connections is set to 1 by default

added

JDBC File Driver uses an implicit conversion when no numerical formatting is specified

added

New method __ctx__.executeRemoteCommand(, , ) to execute a command on a remote host from the scripting context

added

New option "var" on execute delivery and schedule delivery commands allowing to pass a Variable value

added

New parameter "silent" to the "connect" command avoids the feedback normally written on the standard output

added

New method __ctx__.executeCommand() to execute a Runtime command from the scripting context

added

New attribute "status" allowing userLog event filtering. Allowed values are: EXECUTED, ERROR, KILLED

added

ReadMail: new option MAIL_MARK_AS to mark emails as read

added

Runtime supports user log events production to enrich actions

added

Support JSON as a source

added

Web Service invocation supports WSSE Security

added

Web Service invocation supports XOP and MTOM binary data formats

fixed

Action SqlToParameters used repeatedly on Oracle throws Max Open Cursors error

fixed

ExecuteDelivery ignores parameters DELIV_ENGINE_HOST et DELIV_ENGINE_PORT

fixed

Issues when using transactional mode on Teradata

fixed

Runtime no longer requires a JDK to publish Web Services

fixed

Runtime randomly hangs when executing multiple mappings in parallel in the same process

fixed

ReadMailAction: Connection timeout is ignored

fixed

ReadMail generates an error when receiving an email without subject

fixed

ReadMail: Exception is thrown when "Mail Keep on Server" is unchecked and reading emails from an IMAP server

fixed

Variable value displayed in the Designer is the default value of the parameter and not the one really used if Runtime is stopped or restarted

fixed

When binding a select with a DDL_DML operation an error occurs if the select query returns no row

fixed

XML attributes are randomly ignored

added

Stopping a Runtime with Sessions that are in status "Waiting" stops the scheduler and the execution services