Skip to main content
Skip table of contents

10.1.0 ~ 10.1.12

QueryPie 10.1.12 Release

Bug Fix

  • [General] Fixed memory issue in audit log export for large queries.

  • [DAC] Fixed memory overload when running large queries with DML Snapshot enabled.

QueryPie 10.1.11 Release

Bug Fix

  • [General] Resolved freezing during Audit Log Export caused by unexpected exceptions.

  • [Agent] Fixed /bin/bash: osascript: command not found error on Mac.

QueryPie 10.1.10 Release

Bug Fix

  • [DAC] Fixed an issue where rows were not properly searched in the Query Audit menu when connected to Oracle Proxy.

  • [DAC] Applied local caching of SystemSetting to the database search section when performing queries.

QueryPie 10.1.9 Release

Bug Fix

  • [DAC] Resolved errors related to MongoDB.Bson.BsonInt64 in MongoDB.

  • [DAC] Fixed errors related to ORA-03113 when connecting to Oracle OCI EXACS.

  • [DAC] Resolved an issue with DML Snapshot recording when performing UPSERT operations in MongoDB.

  • [DAC] Fixed an issue with connections to SQL Server via TablePlus through a proxy.

  • [DAC] Addressed permission issues for using the UPDATE statement with WITH clauses after connecting to PostgreSQL.

  • [DAC] Resolved errors related to executing the USE statement.

  • [DAC] Fixed the "Not allowed object type undefined" error.

  • [SAC] Resolved memory overconsumption issues caused by session leaks.

  • [General] Fixed an issue where the Test button in the Logs tab of the Alert detail page was not working.

  • [Agent] Improved the process to explicitly obtain administrator rights when upgrading.

QueryPie 10.1.8 Release

Enhancement

  • [IDP] Improved user-specific synchronization to address job duplication issues during IdP synchronization.

  • [DAC] Added the ability to specify the password for the connection account when connecting via Oracle, MongoDB, and PostgreSQL agents.

Bug Fix

  • [DAC] Resolved an issue where port allocation was not performed for newly added instances.

  • [DAC] Fixed an issue with the use of aliases in UPDATE statements when executing SQL Server queries.

  • [DAC] In the Hive web editor, fixed an issue where JSON strings were temporarily visible in the object information panel on the right after establishing a connection.

  • [DAC] Fixed an issue with SQL Server DML snapshots failing to execute properly when a primary key (PK) was included in the INSERT statement subquery.

  • [DAC] Resolved an issue with Explain Plan execution related to Oracle connections through Toad, where errors occurred in proxy rows.

  • [DAC] Fixed the dbms_output not functioning correctly in SQLGate.

  • [DAC] Resolved an issue where AWS SCT-Oracle connections failed to establish properly.

  • [Agent] Resolved a network connection wait issue after unlocking the QueryPie Agent session and checking token expiration.

  • [SAC] Fixed an issue where entering a password in Korean caused connection failures when using the QueryPie SAC Agent.

  • [SAC] Resolved a "Server group not found" error when attempting to connect to a user server.

  • [SAC] Addressed an issue where the session timeout did not function correctly when there was no input after an SSH connection.

  • [Common] Resolved a "Connection reset by peer" error caused by RST packet returns when calling a Lambda function through a NAT Gateway in HTTP.

  • [Workflow] Fixed an error that occurred when many connections were requested during a database access request.

  • [Workflow] Resolved an error where "query did not return a unique result" occurred when approving a database access request.

QueryPie 10.1.7 Release

Enhancement

  • [Agent] Implementation of the Proxy Throttling function

  • [DAC] Applied logging exception handling for repetitive queries sent from client tools such as DataGrip

  • [DAC] Improved personal account usage in the agent when connecting to Oracle OCI

Bug Fix

  • [DAC] Resolved the issue of missing logs related to Oracle OCI connections

  • [DAC] Fixed an error that occurred when executing Oracle queries through the Toad tool

  • [DAC] Addressed errors related to executing LEFT OUTER JOIN queries when PostgreSQL policies were applied

  • [Common] Resolved login issues after displaying the refresh-token-expired error pop-up

  • [API] Fixed issues when retrieving the first 10 rows through an external API

  • [DAC] Applied OtherOptions when connecting to Hive via the web editor

  • [DAC] Fixed errors occurring when querying PostgreSQL and checking table information for partitioned tables in the web editor

  • [DAC] Corrected an error in MySQL when calling CURRENT_DATE or CURRENT_TIME functions without parentheses

  • [DAC] Resolved an issue where deactivated permissions were not properly marked as expired after long-term inactivity

  • [DAC] Fixed an error when executing an Update query containing a subquery targeting a table with a Ledger policy applied

QueryPie 10.1.6 Release

Bug Fix

  • [General] Fixed an issue related to the duplicate sending logic for alerts.

  • [General] Resolved the "Loading chunk 721 failed" error.

  • [DAC] Fixed an issue with session types when queries were sent simultaneously from different tools after connecting to the PostgreSQL proxy.

  • [DAC] Resolved a conflict with the DML snapshot function when useServerPrepStmts = true in MySQL.

  • [SAC] Fixed a disconnection issue when sessions were called simultaneously through tmux.

  • [DAC] Added support for the sleep() query in MongoDB.

  • [DAC] Resolved a "Wrong Data Type" error when executing DocumentDB queries.

  • [DAC] Fixed a malfunction related to changes in Workflow Status.

QueryPie 10.1.5 Release

Bug Fix

  • [DAC] Fixed a "SecurityContext is null" error while executing queries.

  • [DAC] Resolved an issue where AWS Cloud Synchronization skipped instances in the "Modifying" state during synchronization.

  • [DAC] Fixed an "Unauthorized" error when querying after connecting to Oracle as an agent.

  • [DAC] Resolved an issue where Oracle proxy connections were terminated intermittently under heavy usage.

  • [DAC] Fixed a malfunction in the Oracle proxy when identical BLOB data was present.

  • [DAC] Resolved an error in the connection detail page display when permissions had been granted for long-term non-connected instances.

QueryPie 10.1.4 Release 

Bug Fix

  • [Workflow] Fixed an issue where delegate approvers were unable to view the Request page for approval tasks.

QueryPie 10.1.3 Release 

Enhancement

  • [DAC] Limited access to only the SID or ServiceName registered in the connection information when connecting to Oracle

Bug Fix

  • [Agent] Improved Agent Refresh Token expiration logic

  • [Syslog] Resolved issues with log retransmission and proxy connection delays

QueryPie 10.1.2 Release 

Enhancement

  • [DAC] Added defensive code to ensure automatic cleanup of sessions and jobs in case of leaks

Bug Fix

  • [DAC] [MySQL] Fixed an issue where errors occurred when processing Query Attributes

  • [DAC] [MongoDB] Corrected an error where successful connections via Agent were recorded as failures in DB Access History

  • [DAC] [MongoDB] Fixed an issue where a failure in the KillCursors command on the Proxy would result in an error

  • [DAC] Resolved an issue where a payment approval popup for the Ledger table was not displayed when accessing the Proxy via a 3rd-party after upgrading to version 10.1.1

  • [SAC] Addressed a problem where some search results were intermittently not displayed when the Server Group list contained a large number of results

  • [SAC] Fixed an issue where only a partial server list was displayed during the final step of Grant Permission when a large number of servers were registered simultaneously

 

External API

  • [SAC] Added a new API for Grant Direct Permission by Name, allowing permissions to be granted based on resource name

 

QueryPie 10.1.1 Release 

 

Enhancement

  • [Dashboard] Improved the loading speed of the dashboard page

 

Bug Fix

  • [SAC] Resolved an issue where an error message appeared when users selected a role after a server with permissions was deleted

  • [SAC] Fixed an issue where an error message appeared when duplicate access permissions were granted to a server the user already had access to

QueryPie 10.1.0 Release 

New Features

  • [SAC] Added the ability to assign a command whitelist when granting individual user permissions

  • [SAC] Enabled the use of Allowed Zones based on server tags

  • [SAC] Supported Jump Host access in multi-hop environments (ProxyJump)

  • [SAC] Added support for new protocols (FTP, Telnet)

  • [SAC] Added password management features (bulk changes, cycle management, etc.)

Enhancement

  • [SAC] [RDP] Added a password entry step when deleting server agents

  • [KAC] Expanded Proxy domain configuration to support IP addresses

Bug Fix

  • [Dashboard] Fixed an error when deleted accounts appear in recent server access history

  • [Security] Resolved an issue where users were logged out before the session timeout

  • [IAM] Fixed an error when accessing accounts with multiple Admin Roles

  • [DAC] Fixed connection errors with specific Oracle JDBC Driver versions

  • [DAC] Corrected missing pre/post data after running an UPDATE query with DML Snapshot enabled

  • [SAC] Fixed duplicate host names in User Access History when logging in via Okta

External API

  • [SAC] Added Whitelist object to the Get Direct Permission API

  • [SAC] Modified Grant Direct Permission API to allow whitelisting

  • [SAC] Added a new Grant Whitelist API

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close