3. Bug Fixed
Outbound Interface Execution Failure with Agent Database Adapter ODBC 32-bit in Non-Open Firewall Mode
Fixed a runtime exception that occurred when executing an outbound interface with manual processing enabled using the "Manually select the sObject using the Query Builder" option. Passing a business record ID through the Agent Database Adapter ODBC 32-bit in non-open firewall mode caused a CamelExecutionException during exchange execution (org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[9AF37B6BBD26BDF-000000000000011F]), resulting in interface failure. This issue has been resolved.
Improved Error Handling for Outbound Interface Execution with Agent Database Adapter ODBC 32-bit in Non-Open Firewall Mode
We have fixed an issue that occurred when executing an outbound interface using the Agent Database Adapter with ODBC 32-bit in Non-Open Firewall Mode. Previously, when the outbound interface executed a stored procedure to insert records and passed a null value to a database field that does not allow null values, the SKYVVA message showed an unclear error: “Cannot invoke 'java.util.List.iterator()' because 'response' is null”. This error message did not clearly explain the real root cause of the stored procedure failure. With this fix, SKYVVA now returns a more specific and meaningful error message from the stored procedure execution. For example: SP execution failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'accnumber', table 'dbbusiness.dbo.tbaccountauto'; column does not allow nulls. INSERT fails.
Fixed Agent Instance ID Not Updated When Creating a New Connection
We have fixed an issue that occurred when creating a new Agent Connection with Open Firewall mode. Previously, when users created a new Open Firewall Agent Connection, the connection could display an unknown Agent Instance ID after saving. With this fix, the system now correctly updates the new Open Firewall Agent Connection with the correct Agent Instance ID after the connection is saved.
After this fix, users will see the following improvements:
- The Agent Instance ID is now updated correctly for new Open Firewall connections.
- The connection no longer shows an unknown Agent Instance ID after saving.
- Open Firewall Agent Connection creation is now more reliable.
Fixed “Operation not yet supported” Error When Using NVARCHAR Columns with ODBC in Non-Open Firewall Mode
We have fixed an issue that occurred during Manual Inbound Processing when using the option “Manually select the external database record using the Query Editor?” to retrieve records from an external database through ODBC in Non-Open Firewall Mode.Previously, when the selected database records contained columns with the NVARCHAR data type, the system could display the following error message: Operation not yet supported. After this fix, SKYVVA can now retrieve database records that contain NVARCHAR columns without triggering the “Operation not yet supported” error.
Fixed Stuck Loading Popup When PostgreSQL Database Password Is Incorrect During Upgrade
We have fixed an issue that occurred during Upgrade Mode when the Agent had an incorrect PostgreSQL database password stored in the configuration. The setup pop-up could remain stuck on the loading screen with the following message: “Please wait while Setup is loading… Get Config From Folder Install”.