PEM v7.13

Release date: 2020-02-20

Features

PEM-594 - Logout the user session when there is no user activity.
PEM-3107 - Core usage report.
PEM-2794 - Added capability in pemAgent to send SNMP trap with SNMP v3 support.
Issue #2554 - Added support for a multi-level partitioned table.
Issue #3452 - Added a Schema Diff tool to compare two schemas and generate the diff script.
Issue #4762 - Allow screen-reader to read label & description of non-textable elements.
Issue #4763 - Allow screen-reader to identify the alert errors.
Issue #4764 - Allow screen-reader to read relationship attributes in nested elements.
Issue #4770 - Added labels and titles after parsing and validating all the web pages for accessibility.
Issue #4993 - Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.

Housekeeping

Issue #4988 - Refactored SQL of Table’s and it’s child nodes.
Issue #5023 - Refactored SQL of Views and Materialized Views.
Issue #5024 - Refactored SQL of Functions and Procedures.
Issue #5038 - Added support for on-demand loading of items in Select2.
Issue #5049 - Improve code coverage and API test cases for the CAST module.
Issue #5050 - Improve code coverage and API test cases for the LANGUAGE module.
Issue #5072 - Updated wcDocker package which includes aria-label accessibility improvements.
Issue #5088 - Improve code coverage and API test cases for the Event Trigger module.
Issue #5096 - Replace node-sass with sass for SCSS compilation.
Issue #5176 - Enhance logging by tracking stdout and stderr of subprocess when log level set to DEBUG.
Issue #5185 - Added option to override the class name of a label tag for select2 control.

Bug fixes

PEM-383 - Provide the column picker toolbar button in SQL profiler trace window.
PEM-723 - Fixed a SQL Syntax error when PEM Agent queries tablespaces. [Support Ticket #570926]
PEM-789 - Fixed historical span issue with memory usage graph. [Support Ticket #665140]
PEM-933 - Fixed sorting of table chart data when rendering on custom dashboard. [Support Ticket #764647]
PEM-1406 - Fixed the Swap Consumption alert template to reflect the actual swap consumption instead of total swap space. [Support Ticket #806008]
PEM-2255 - Fixed in PEM RestAPI for server black out option. [Support Ticket #882589]
PEM-2545/Issue #4511 <https://redmine.postgresql.org/issues/4511> - Grant wizard is not able to handle multiple objects because all objects are passed as query string URL [Support Ticket #897419]
PEM-2573 - Fixed for shared_buffers dashboard’s historical span issue. [Support Ticket #894867]
PEM-2614 - Fixed idle in transaction (aborted) state check in the probe code for session info. [Support Ticket #908442]
PEM-2647 - Fixed storage pie chart issue to display the correct value. [Support Ticket #907753]
PEM-2686 - Fixed save password functionality is not working when server was registered by PEM worker. [Support Ticket #912948]
PEM-2828 - Fixed “Alert Errors” alert template to count the errors for which alerts are enabled. [Support Ticket #903272]
PEM-3041 - Fixed not able to see the agent status in the PEM Monitoring dashboard due to numeric overflow error. [Support Ticket #934778]
PEM-3139 - RLS policy was not updated properly for “pem.job” table during the PEM upgrade. [Support Ticket #937823]
Issue #3812 - Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
Issue #4198 - Fix syntax highlighting in code mirror for backslash and escape constant.
Issue #4410 - Fixed an issue while editing char[] or character varying[] column from View/Edit data throwing an error.
Issue #4506 - Fix an issue where clicking on an empty textbox like fill factor or comments, considers it as change and enabled the save button.
Issue #4601 - Added tab navigation on close buttons for all the panels and create/properties dialog.
Issue #4633 - Added support to view multilevel partitioned tables.
Issue #4724 - Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node.
Issue #4818 - Fix server connection drops out issue in query tool.
Issue #4827 - Fix column resizable issue in the file explorer dialog.
Issue #4842 - Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
Issue #4926 - Fix VPN network disconnect issue where it hangs on expanding the Servers node.
Issue #4933 - Ensure that the Servers collection node should expand independently of server connections.
Issue #4943 - Added more information to the ‘Database connected/disconnected’ message.
Issue #5000 - Logout the session when no user activity of mouse move, click or keypress.
Issue #5008 - Ensure that the error message should not be displayed if Tablespace is not selected while creating the index.
Issue #5009 - Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
Issue #5025 - Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.
Issue #5047 - Added tab navigation for tabs under explain panel in query tool.
Issue #5065 - Updated the incorrect icon used for the cast node on refresh.
Issue #5066 - Fix an issue where refreshing a package results in the change in the object completely.
Issue #5074 - Fix an issue where select, insert and update scripts on tables throwing an error.
Issue #5107 - Set proper focus on tab navigation for file manager dialog.
Issue #5116 - Fixed an issue where Save Password control disappears after clicking on it while creating a server.