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 error related to 'MongoDB.Bson.BsonInt64' in MongoDB
[DAC] Fixed ORA-03113 error during OCI EXACS connection
[DAC] Addressed issue with DML Snapshot recording during MongoDB UPSERT attempts
[DAC] Resolved issue with TablePlus connection via SQLServer proxy
[DAC] Fixed permission issue for using UPDATE statements with WITH clause after PostgreSQL connection
[DAC] Fixed error when executing USE statement on databases starting with numbers from certain vendors
[DAC] Resolved "Not allowed object type undefined" error
[SAC] Improved memory overuse issue caused by session leakage
[General] Fixed issue where the
Test
button did not function in the Logs tab on the Alert detail page[Agent] Enhanced the upgrade process to explicitly require administrator privileges before proceeding
QueryPie 10.1.8 Release
Enhancement
[IDP] Improved IdP synchronization to prevent job duplication by synchronizing on a per-user basis
[DAC] Added functionality to specify the password for connection accounts when accessing via Oracle, MongoDB, or PostgreSQL agents
Bug Fix
[DAC] Resolved an issue where ports were not assigned to newly added instances
[DAC] Fixed an issue with alias usage in UPDATE statements during SQLServer query execution
[DAC] Fixed an issue where JSON strings were temporarily displayed in the object information panel when connecting to Hive via the web editor
[DAC] Fixed an issue where
INSERT
queries containing primary keys in subqueries would fail when DML Snapshot was enabled in SQLServer[DAC] Resolved a proxy row issue occurring during Explain Plan execution when connecting to Oracle via Toad.
[DAC] Fixed an issue where dbms_output did not function correctly in SQLGate
[DAC] Resolved a connection issue with AWS SCT when creating Oracle connections
[Agent] Fixed a network connection delay issue after unlocking QueryPie agent sessions and before token expiration verification
[SAC] Resolved a connection failure issue when entering passwords in Korean for QueryPie SAC Agent
[SAC] Fixed a Server group not found error when attempting to connect to user servers.
[SAC] Resolved an issue where session timeouts did not function correctly after SSH connections with no input
[Common] Fixed a Connection reset by peer error caused by RST packets when invoking Lambda through NAT Gateway in Alert HTTP
[Workflow] Resolved an error occurring in DB Access Request workflows when handling a large number of requested connections
[Workflow] Fixed a “query did not return a unique result” error during DB Access Request approvals
QueryPie 10.1.7 Release
Enhancement
[Agent] Added Proxy Throttling
[DAC] Applied logging exception handling for repetitive queries sent from client tools like DataGrip
[DAC] Improved to allow the use of personal accounts when connecting to Oracle OCI through the agent
Bug Fix
[DAC] Resolved issue where logs were not recorded for Oracle OCI connections
[DAC] Fixed error when executing Oracle queries through the Toad tool
[DAC] Addressed issue with LEFT OUTER JOIN queries when PostgreSQL policies were applied
[Common] Fixed an issue preventing login after displaying the refresh-token-expired error popup
[API] Resolved an issue with retrieving the first 10 rows through an external API
[DAC] Fixed an issue where OtherOptions were not applied when connecting to Hive via the web editor
[DAC] Resolved an error when checking table info for partitioned tables while querying PostgreSQL in the web editor
[DAC] Fixed an issue in MySQL where calling functions like CURRENT_DATE and CURRENT_TIME without parentheses caused errors
[DAC] Resolved an issue where deactivated permissions due to prolonged inactivity were not marked as expired upon reaching the expiration date.
[DAC] Addressed an issue with executing update queries containing subqueries on tables with ledger policies applied
QueryPie 10.1.6 Release
Bug Fix
[General] Resolved duplicate alert dispatch logic issue
[General] Fixed Loading chunk 721 failed error
[DAC] Resolved session termination issue when sending queries simultaneously from different tools after connecting to PostgreSQL proxy
[DAC] Fixed DML snapshot functionality conflict when useServerPrepStmts=true is enabled in MySQL
[SAC] Resolved disconnection issue during simultaneous session calls via tmux
[DAC] Added sleep() queries in MongoDB
[DAC] Fixed Wrong Data Type error when executing queries in DocumentDB
[DAC] Fixed malfunction related to Workflow Status changes
QueryPie 10.1.5 Release
Bug Fix
[DAC] Fixed SecurityContext is null error occurring during query execution
[DAC] Updated AWS cloud synchronization to skip instances in the Modifying state
[DAC] Fixed Unauthorized Error when Querying Oracle after Connecting via Agent
[DAC] Fixed intermittent proxy disconnections when Oracle usage is high
[DAC] Resolved issue with Oracle proxy malfunctioning when identical BLOB data exists
[DAC] Corrected display error on the connection details page for permissions marked as inactive due to prolonged inactivity
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