Release Note

・The following platforms are now supported:
- Server and client for execution
- Red Hat Enterprise Linux Server 9.x (x64 version)
- Oracle Linux 9.x (x64 version) (*)
(*) For kernel, "Unbreakable Enterprise Kernel" is supported.
- Amazon Linux 2023 (x64 version)Some components do not support the above platforms.
Refer to the help page for more details.

DSS-31224

・Supported PostgreSQL 14 as a repository DB.

・Supported Microsoft SQL Server 2022 as a repository DB.

・Changed the driver versions of the supported libraries for repository databases to the following:
- SQL Server 2022/2019/2017/2016
- "Microsoft JDBC Driver 12.4 for SQL Server"
- Amazon RDS for SQL Server 2019/2017/2016
- "Microsoft JDBC Driver 12.4 for SQL Server"
- Azure SQL Database
- "Microsoft JDBC Driver 12.4 for SQL Server"

・Invalid Base64 data is now handled as an error.

・In XML Framework, the security check of the data to be handled has been enhanced.
Due to this enhancement, the time required to execute components might be longer than in the previous versions.

・In various documents, added or deleted descriptions about end of support for the following components whose sales and support have ended:
- Platforms
- Microsoft Windows Server 2012
- Microsoft Windows Server 2012 R2
- Microsoft Windows 8.1 Pro/Enterprise
- Red Hat Enterprise Linux 6.x
- CentOS 7.x
- Oracle Linux 7.x

- Adapters
- Excel 2013 Adapter
- MySQL 5.7 Adapter
- Oracle 12c Adapter
- Oracle 21c Adapter
- PostgreSQL 10 Adapter
- PostgreSQL 11 Adapter
- SQL Server 2012 Adapter
- SQL Server 2014 Adapter
- MongoDB Adapter
- IBM Domino 9.0 Adapter

・The following components whose sales and support have ended are no longer supplied with the installer:
- Adapters
- PostgreSQL 8.2 Adapter
- PostgreSQL 8.3 Adapter
- PostgreSQL 8.4 Adapter
- NeoCore Adapter
- MongoDB Adapter

・Added a filter function to the list on the "Global Resource Settings" screen.
According to this change, the items in the list have changed as follows:
- Split the [Pooled size (Unused)] item into [Pool size] and [Unused pool size].
- Split the [Max capacity] item into [Enable/Disable pool] and [Max pool capacity].
For more details, refer to the "List all available Global Resources" section in the "Global Resource Settings" help page.

・You can now copy or cut and paste a Mapper logic to another Mapper.

・Fixed the following issues that occur in Studio for Web after OPC Spider 1.3.0 SP1 is applied:
- An issue where if you use a component whose schema is automatically generated, even if you edit and save the schema of the component by using the Mapper editor, when you reopen the project and confirm the Mapper, the schema returns to the state before you edited it
- An issue where if a component whose schema has been edited exists on the script canvas, the component icon is marked with the update icon when you place a new Variable Mapper, and the update icon does not disappear even if you Undo the operation
- An issue where if more than one Variable Mapper exists on the script canvas, when you set a Loop by Number of Data operation in Studio for Web, edit the schema of the operation using a Mapper in Studio for Desktop, and then open the project again in Studio for Web, mapping links disappear from the edited Mapper

・In Call Script, fixed an issue where a mapping link in Mapper acts incorrectly if both of the following conditions are met:
- Document Mapper or Variable Mapper exists in the same script as the Call Script operation, and a mapping link is drawn in Mapper from a script output variable in the Call Script operation.
- Delete the script output variable in the called script.

・Fixed an issue where if you open a script in Studio for Web and the script includes a Mapper that is created in Studio for Desktop and that maps from a script variable, and then you change the script variable name or delete the variable, a "System.Xml.XmlException" error occurs and the mapping link from the variable disappears in Mapper.

・In Call Script, fixed an issue where a "System.InvalidOperationException" error occurs and you cannot open Mapper editor if all of the following conditions are met:
- Document Mapper or Variable Mapper exists in the same script as the Call Script operation.
- In an added layer in Mapper editor, a mapping link is drawn from a script output variable in the Call Script operation.
- Delete the script output variable in the called script.

・Fixed an issue where if you change a script variable name that is used in Document Mapper or Variable Mapper, Mapper is not marked with the update icon.

・Fixed an issue where if you delete a custom logic that belongs to a group, the deletion is not immediately reflected in the display.

・Fixed an issue where when you change the group of a custom logic, the screen whites out when you open the custom logic group on Tool pallet if all the following conditions are met:
- The target custom logic does not belong to a group.
- One or more custom logics exist in the group to which you add the custom logic.

・Fixed an issue where if you create a group and create a custom logic under the group in Studio, and then delete the logic in Studio for Web, the deletion is not immediately reflected in the Tool palette display.

・Fixed an issue where if you perform one of the following modifications for a component icon, the related Mapper is not marked with the update icon:
- Change [Name]
- Copy (copy/cut and paste)
- Delete
- Modify an input/output variable in the Call Script operation

・Fixed an issue where if the condition of an XML script input/output variable changes, Variable Mapper is not marked with the update icon.

・Fixed an issue where if the input source of a Merge Mapper is an XML type script input variable, even if you change the sequence of [Input data] in the "Edit Input data" dialog in Property inspector, the change might not be reflected in [Input source] in Mapper editor.

・Fixed an issue where if you close Mapper editor by using [Close editor] or [Close all editors] in the [File] menu in Designer, [Layer] and [Custom logic] remain in the menu.

・In Retrieve data by executing SQL logic, fixed an issue where if null is assigned to a SQL parameter, a "NullPointerException" error might occur.

・In the Mapper calculation logics (Add, Subtract, Multiply, Divide, Modulo), fixed an issue where if a mapping link is not connected to either of the input handlers, processing is not executed and no value is output.

・Fixed an issue where if you change a script variable name, the variable name might overlap with the mapping link line in Input source and Output destination in Mapper editor.

・Fixed an issue where if you change a script variable name, the variable name might overlap with the mapping link line in Input source and Output destination in Mapper editor.

・Fixed an issue where if you double click a component icon to open the property settings dialog and then click the outer frame of the dialog before it has finished loading, the dialog opens in minimized state.

・In Project explorer, fixed an issue where if you add, edit, or delete a script variable, Merge Mappers are marked with the update icon.

・In Mapper editor, fixed an issue where you cannot delete an element or attribute in the input or output schema using the Delete key.

・In Execute Select SQL, if the SQL parameters are specified in [SQL statement], you can specify test values for the SQL parameters in the "Input variable value" dialog box when you execute [Extraction test] or [Execute SQL statement and set output schema].

・In the "Mount Settings" help page, added the following description to the "Specification Limits" section:
- In an environment where a repository database is used, you can change the read permission, write permission, owner, and group of the directory mounted as local filesystem.

・In [Repository DB Management], fixed an issue where the metadata of Extended local file system is not included in the targets of [Cleanup repository DB].

・In Call Script, fixed an issue where if [Validation on build] is enabled, an error occurs even if a value is specified for a script input variable whose [Required] property is selected in a script.

・In Loop, fixed an issue where an "OutOfMemoryError" error might occur depending on the loop count if all the following conditions are met:
- The PSP data flow is used between a file-reading operation and a Document Mapper.
- All the output destinations of the Document Mapper are script variables.
- The Document Mapper does not use a Loop logic (*).

(*) Iterate specified node logic, Sort by Key logic, Sort by Two Keys logic, If Loop logic

・Fixed an issue where if you [Cut] and [Paste] the icons including the end icon of a control component and any component icon, only the end icon is deleted.

・Fixed an issue where if a component uses a global resource and an error occurs in the component during a Thread operation, the component pool is not released.

・Fixed an issue where if you execute a process that does not pass through an End Transaction icon, but instead uses an operation such as end, break, or continue within the Transaction operation, and a component that uses a global resource exists before the Transaction operation, the component pool is not released.

・Fixed an issue where if multiple Output Log operations with the same file specified for the log output destination are executed simultaneously, issues such as some logs failing to be output might occur.

・In Retrieve data by executing SQL logic, fixed an issue where if null is assigned to a SQL parameter, a "NullPointerException" error might occur.

・Fixed an issue where if you save and reopen a project, double-click an already placed custom logic to open the custom logic editor, and then add a handler, you cannot delete the added handler.

・Added Oracle 23ai Adapter.
This adapter can be connected to Oracle Base Database Service (Oracle Database 23ai).
Refer to the help page for more details.

・In accordance with the change of the service name from Oracle Database Cloud Service to Oracle Base Database Service, the service name described in various documents has been changed as follows:
- (Old name -> New name)
- Oracle Database Cloud Service -> Oracle Base Database Service

・Added PostgreSQL 16 Adapter.
This adapter can be connected to PostgreSQL 16.
Refer to the help page for more details.

・Added PostgreSQL 15 Adapter.
This adapter can be connected to PostgreSQL 15.
Refer to the help page for more details.

・Added PostgreSQL 14 Adapter.
This adapter can be connected to PostgreSQL 14.
Refer to the help page for more details.

・Modified the content of the error message that occurs when an SSL connection is made without the certificate in the keystore under the "Main Exceptions" section in the "Limitations" page for each supported version in the help.

・Added the setting for the SSL connection function to the global resources.
Property name
[SSL connection] in the [Required settings] tab

Value description
[Checked]: SSL connection will be performed.
[Not checked]: SSL connection will not be performed.

Default value
[Not checked]
Refer to the help page for more details.

・Added SQL Server 2022 Adapter.
This adapter can be connected to Microsoft SQL Server 2022.
Refer to the help page for more details.

・Changed the driver versions of the supported libraries to the following:
- SQL Server 2022/2019/2017/2016 Adapter
- "Microsoft JDBC Driver 12.4 for SQL Server"

Due to this change, error details stored in component variables might change.

・Supported UNIQUEIDENTIFIER type.

・In various documents, added information on libraries for Windows authentication used in the Windows 32bit environment.

・On the "Operation Environment" help page, the client required for the Write by Loader operation has been changed to "sqlcmd utility" in the "Supported Versions" section.

・Fixed an issue where if you omit [Database name] in a global resource, you might not be able to handle the properties in the property settings dialog of each operation that uses the global resource.

・In Read CSV File, fixed an issue where if all the following conditions are met, a portion of the data after a newline might be read more than once:
- [Enable multi-thread processing settings] is selected.
- Fields that contain newlines exist in the input data.
Due to this fix, the time required to execute a Read CSV File operation with multi-thread processing enabled might increase or decrease compared to the previous versions.

・In Write, fixed an issue where if [Use format of target cell] is specified for [Style] in [Column list] and a string in exponential notation or a string with leading zeros is written to an Excel book, the string is converted to a numerical value in different notation.

・In Write, fixed an issue where if data is written to an Excel 2003 workbook that has cells of formulas entered in bulk by using a function such as Auto Fill, the formulas might disappear.

・In Write, fixed an issue where if input data that contains the newline characters CR+LF is written to an Excel 2003 workbook, the newline characters are converted to CR+CR+LF.

・In Read Sheet, fixed an issue where if you omit the sheet name, the file cannot be read.

・In Write XML File, fixed an issue where if you specify "UTF-16BE" or "UTF-16LE" for [Encoding] and execute the script, even if writing to the file with the specified encoding ends successfully, the "Warning: The encoding '<specified encoding>' is not supported by the Java runtime." message is output to the OPC SpiderServer console.

・Fixed an issue where if a file is read with "UTF-16", "UTF-16BE", or "UTF-16LE" specified for [Encoding], a character that contains 0x0A or 0x0D (new line codes in ASCII) in its character code may be treated as a new line code.
Additionally, in accordance with this modification, the exception that is thrown and the message code that is output when an unsupported encoding is specified for [Encoding] have been changed as follows:
Before change:
- Exception that is thrown: "java.io.UnsupportedEncodingException"
- Message code: "IO0002E"

After change:
- Exception that is thrown: "java.nio.charset.UnsupportedCharsetException"
- Message code: "VARLENGTH0000E"」

・Fixed an issue where if a file that uses a new line code other than "CR" is read with "UTF-16" specified for [Encoding], a "StructuredTextParseException" error occurs.

・Added SAP S/4HANA Cloud to the supported versions.
Refer to the help page for more details./p>

・Fixed an issue where the number of sessions on the SAP system side increases with the number of executed operations.

・Fixed an issue where when you select [IDoc] for Interface in an Execute Business Method operation to execute, if the value of the SEGNAM element specified in the input data is different from the element name of its parent, a "NullPointerException" error occurs.

・In each operation, CHANGING parameters are now displayed in the schema if [RFC (including BAPI)] is selected for [Interface].

・Fixed an issue where if a trigger with [Interface] set to [IDoc] is started, the trigger is disabled in either of the following cases:
- When the trigger settings are invalid
- When the script executed by the trigger ends unsuccessfully

・Fixed an issue where if a trigger with [Interface] set to [RFC (including BAPI)] is started by a BAPI that is executed in the background, the trigger is disabled in either of the following cases:
- When [Reply Type] is set to [Synchronous] or [Asynchronous], and the trigger settings are invalid
- When [Reply Type] is set to [Synchronous], and the script executed by the trigger ends unsuccessfully

・Fixed an issue where SAP triggers cannot be migrated after you upgrade OPC Spider from a version earlier than 1.2.3.
For the migration procedure for SAP triggers, refer to "SAP Adapter Migration Guide".

・SHA-256, SHA-384 and SHA-512 hash functions and the ECDSA signature method are now supported for SFTP connections.

・In Delete, fixed an issue where if the remote path consists of only directories, the deletion fails.

・・Fixed an issue where if an FTP server that supports only Explicit mode for FTP over SSL is specified for the destination, and [FTP over SSL] is specified for [Security type] and [implicit] is specified for [SSL connection type] in the [Secure FTP settings] tab in a global resource, Studio becomes inoperable when you execute the connection test.

・If a proxy server is specified in OPC SpiderServer, [Connection test] in the global resources now connects to the destination via the proxy server.

・Added the Execute PATCH operation to use the HTTP PATCH method.
Refer to the help page for more details.

・Fixed an issue where in each operation, if a string that contains "~" or "*" is set in [Query parameter] in the [Required settings] tab, the URL encoding for the request parameter is different between version 1.2.3 or earlier and version 1.3.0 or later.
With this fix, the same encoding as that in version 1.2.3 or earlier is applied.

・In the "Receive E-mail (POP3)" and "Receive E-mail (IMAP4)" help pages, the element name "Sent Date (Received Date)" has been corrected to "Sent Date" in the "Output Schema" section.

・Added the setting for the SSL connection function to the global resources.
Property name
[SSL connection] in the [Required settings] tab
Value description
[Checked]: SSL connection will be performed.
[Not checked]: SSL connection will not be performed.
Default value
[Not checked]

Refer to the help page for more details.

・Changed the driver versions of the supported libraries to the following:
- Azure SQL Database Adapter
- "Microsoft JDBC Driver 12.4 for SQL Server"
Due to this change, error details stored in component variables might change.

・Fixed an issue where if a user does not have permission to edit the global resource for OAuth 2.0, a "ProhibitedOperationException" error occurs and processing fails when the access token is updated.
With this fix, the access token is now updated and processing is executed, but a log is output at the log level "WARN" to indicate that saving the global resource failed because the user does not have the permission.

・The following platforms are now supported:
  - Common to server and client for execution, and client for development
  - Microsoft Windows Server 2022 Essentials/Standard/Datacenter (x64 version) (*)
  (*) Server Core and Server with Desktop Experience are supported.
  - Client for development
  - Microsoft Windows 11 Pro/Enterprise (x64 version)
Some components do not support the above platforms. Refer to the help page for more details.

・Changed the supplied Java Runtime Environment (JRE) to "AdoptOpenJDK 1.8.0_292-b10".

・In the "Service Operation" help page, changed the description about objects for which an access log is output as follows:
 Before change: From clients
 After change: From applications, triggers, or components

・Supported Oracle Cloud Infrastructure Database (Oracle Database 21c) as a repository DB.

・Supported PostgreSQL 13 as a repository DB.

・Adapters
  - Oracle 18c Adapter
  - PostgreSQL 9.6 Adapter

・The following components whose sales and support have ended are no longer supplied with the installer:

　 - MySQL 5.0 Adapter
    - SQL Server 2008 ODBC Adapter

・The installers for the following are no longer supplied:

　 - OPCSpider JDBC Proxy Server

・The script processing after firing HULFT Script trigger may be delayed and cause successive delays in firings of other triggers.This bug is fixed.

・fixed an issue where "System.NullReferenceException" occurs and the behavior of Designer becomes unstable when you open a script that includes script variables and then perform one of the following operations with the script variables displayed in the tree in Project explorer:    

    - [Restore project from server]
    - [Team development] - [Commit]
    - [Team development] - [Update]
    - [Team development] - [Overwrite project with latest server version]

Due to this change, deleted the following operation menus to make specifications the same as Studio for Desktop:
    - Menu bar [Local custom] in Mapper editor
    -　[Add custom logic] in the [Local custom] category in Tool palette

・For local custom logics, fixed an issue where a local custom logic can be created with the same name in the same level as a group.

・In local custom logics, fixed an issue where groups are always displayed first in the display order in Tool palette.

・Fixed an issue where Collective logic (*) does not work correctly if you execute an edited script with the Mapper editor closed (not loaded into memory).
    (*) Sum logic, Average logic, Number of Node logic, Maximum Node logic, or Minimum Node logic
   
    To reflect this modification, perform the following procedure after version upgrade:
    1. Open the Mapper logic where this phenomenon is occurring.
    2. Edit the script in some way, such as moving the Mapper logic icon on the mapping canvas.
    3. Save the project.

・In local custom logics, fixed an issue where the "NullReferenceException" error may occur when you press F1 in the property settings dialog box.

・Fixed an issue where the prefix and mapping link of an element disappear from an Assign Variable icon in which a child element (with a prefix) of the element with the namespace declaration (prefix and URI) is mapped to a script variable when you copy or cut and paste the icon.
・In Variable Mapper, Document Mapper, or Merge Mapper, fixed an issue where the prefix and mapping link of an element disappear from a Mapper when you place a new Assign Variable icon on the script canvas, if a child element (with a prefix) of the element with the namespace declaration (prefix and URI) is mapped to an output element in the Mapper.

• Added Impulse Adapter.
• Added Impulse post timeseries vector function.
• Added Impulse get inference result function.

• In ScriptRunner, improved the password encryption for launch settings files.

  After applying this patch, perform the following procedure 
  to encrypt passwords again for all launch settings files:
  
  1. Open a launch settings file, and replace the value 
     for the password element with a plain text password.

  2. Specify [false] for the encrypt attribute of the password element, 
     or delete the attribute.

  3. Encrypt the password described in step 1 by following 
     the "Password encryption of launch settings file" section in the 
     "ScriptRunner" help page.

  To use the launch settings file in another environment, you must perform 
  the above procedure again.

• In ScriptRunner for Amazon SQS, 
  improved the secret key and password encryption for launch settings files
  and the secret key encryption for property files.

  After applying this patch, perform the following procedure 
  to encrypt passwords and secret keys again for all launch settings files 
  and property files:
  
  1. Open a launch settings file, and replace the values 
     for the secretkey element and password element 
     with a plain text secret key and password.

  2. Specify [false] for the encrypt attributes of the secretkey element 
     and password element, or delete the attributes.

  3. Encrypt the secret key and password described in step 1 by following 
     the "Secret key and password encryption of launch settings file" 
     section in the "ScriptRunner for Amazon SQS" help page.

  4. Open a property file, and replace the value 
     for the AWS_SECRET_KEY key with a plain text secret key.

  5. Specify [false] for the ENCRYPTED key, or delete the ENCRYPTED key.

  6. Encrypt the secret key described in step 4 by following 
     the "Secret key encryption of property file" section 
     in the "ScriptRunner for Amazon SQS" help page.

  To use the launch settings file and the property file in another 
  environment, you must perform the above procedure again.

• In Merge Mapper in Studio for Web, fixed an issue where if you map data to
  a Mapper logic with "three" or more input handlers and then close and
  open the project again, the mapping links to the third and subsequent
  handlers disappear.

• In Studio for Web, fixed an issue where a "Failed to load the component." error may occur when you open a project and the Call Script operation on the script may be lost.

• In Studio for Web, fixed an issue where a script other than the edited script is saved or committed and the version is increased when you perform the following procedure:

  1. Put a script in the edited state (the script is marked with the update icon).
  2. Execute the script.
  3. Save or commit the script after executing it.(*)
  * If the Team development function is enabled, the version is increased when the script is committed to the server, not when it is saved locally.

• When the team development function was enabled in OPC Spider Studio, if you executed "Import..." - "Differential import of projects" from "Control Panel" - "OPC Spider Server Settings", Manage the Local Script History disappeared. This bug is fixed.

• The script processing after firing HULFT Script trigger may be delayed and cause successive delays in firings of other triggers. This bug is fixed.

• In HULFT Script trigger, the temporary mounting method when the trigger fires changed. After applying this version, the mounting information of HULFT Script trigger will not be stored in the repository DB.

• Added Aes128Sha256RsaOaep and Aes256Sha256RsaPss to the security policy in the OPC UA connection function.

• Added OPC UA history reading function.

• Added a function to set the timeout time and number of retries for connection with the OPC server.

• Writing to all tags would fail if there was even one invalid NodeID. This bug is fixed.

• The item list import of the backup function failed. This bug is fixed.

• Even if the key number was duplicated in the value reading process, the process was executed and the wrong value was output. This bug is fixed.

• The error message for duplicate key numbers was always in Japanese regardless of language settings. This bug is fixed.

• Added mcframe SIGNAL CHAIN Adapter.
• Added mcframe SIGNAL CHAIN operation monitoring upload function.

• Changed the component names to "HCL Domino Adapter" from "IBM Domino Adapter".
• Added the HCL Domino 11.0 Adapter. This adapter can be connected to HCL Domino 11.0 and HCL Domino 10.0.

• In SAP Adapter, changed the supported version of SAP Java Connector to 3.1. Only version 3.1 of SAP Java Connector is supported.

• In global resources for SFTP connection of FTP adapter, added a function to connect by using HTTP Proxy server. This function is displayed when you select [SFTP] in [Security type] of the [Secure FTP settings] tab.

  <Property name>
  　[Use the HTTP proxy server] in the [Secure FTP settings] tab
  <Value description>
  　Checked : Use the HTTP Proxy server.
  　Not Checked : Do not use the HTTP Proxy server.
  <Default value>
  　Not Checked
  <Property name>
  　[HTTP proxy host] in the [Secure FTP settings] tab
  <Value description>
  　Enter the host address of the HTTP Proxy server.
  <Property name>
  　[HTTP proxy port] in [Secure FTP settings] tab
  <Value description>
  　Enter the port number of the HTTP Proxy server.
  * The user authentication for the Proxy server is not supported.

• Added the PostgreSQL 12 Adapter. This adapter can be connected to PostgreSQL 12.
• PostgreSQL 12 is supported as a repository DB.