Archived Release Notes

OneVizion 8.93

Released 10/08/2018

The following is a list of changes since version 8.92:

New Features:

BPL-125297:  Add Status column at the Components Import page.           

DB-126350:  Create the script to convert the config_value_date from IOT to HEAP table  

For performance reasons config_value_date table converted from index organized to to HEAP

EFile-109273:  Implement population of blob_data.hash in Java 

With EFile-108623 we added support for file has values. Now, hash will be generated in Java in most cases, and only when blob_data modified with rules or other processes which is not providing hash value, it will be generated in DB Trigger. This should improve performance of blob_data operations. Hash column will be empty for all existing blob_data rows until blob_data value will updated. Java hash calculation has small impact on blob_data update/insert actions.

IHub-122721:  Implement support for integration repository       

We implemented UI which lists all available Integrations in integrations repository and allow admins to automatically install selected integrations.

Rule-126351:  Implement Automation Action tab on edit form    

We finished phase 1 implementation of Config Field Update Automation UI.

VF-102486:  Support OR filter operations in grids              

New feature controlled with "EnableFilterLogic" parameter and disabled by default. Outer filter operations available on parental or child fields (+)= and (+)<> can not be used in Filter Logic expressions.

Improvements:

Audit-125596:  Improve "String with href" grid cell renderer to optionally support fixed font        

We added SQL exec plans to the Usage Log grid, and it is important to out this data with fixed font to see all the formatting. Now font type controlled with GRID_PAGE_FIELD.CELL_RENDERER_PARAM2

CodeQ-134352:  Configured fields rendering optimization             

We improved reddening performance of Config Forms

Conf-125705:  Allow access to web camera and mic from external tab     

Google Chrome deprecated access to the camera, mic and geo location recently. But some external applications still may need this functionality. Now we added additional option "Allow camera and mic access" to the External Tab admin form

DB-134110:  Improve performance on loading View option and Filter option        

Improved performance of load view option and filter option

DB-134327:  Add new index to the config_field table       

Improved performance of import data load

DB-134498:  Change the varchar2 column type from BYTE to CHAR to correctly save multibyte symbols   

This changes improved internationalization support

Dash-134311:  Incorrect handling of char data type in dashboard datasource       

GUI-134166:  Minor controls layout issue on the rule editing form            

GUI-57691:  Scrollbars for small containers update          

Improved scrollbars appearance for small memo fields

IHub-124426:  Implement support for integration icons  

Integration may have icon, which will be shown in GUI

Bugs:

Admin-126463:  Exclude Trackor Key field from Mass Assign rule

Admin-126464:  Mass Assign rule does not work with Time and Date/Time fields

Admin-134111:  Error on "Admin Config Tab" form when tab has more that 1000 elements          

Admin-134638:  Rollup settings form are broken

Admin-134723:  Fields list in View Options may contain more then 1000 elements            

For performance reasons we automatically switch to the Trackor Types list, when there are more then 1000 fields are available. In some cases this didn't worked, now we fixed it

BPL-134115:  Error when trying to export Rule in the "Components Export Set Up" pop up form  

This is a recent minor bug when you try to export Rule via the Components Export page. You get an error message when you push OK button on the "Components Export Set Up" pop up form during the export setting up process. We fixed this

Dash-125571:  Remove deleted dashlets from local layout            

Prevent layout inconsistency caused by saving local dashboard layout containing deleted dashlet

Dash-134497:  Horizontal scrollbars are not visible in Dashlet Table View in IE      

DropGrid-134647:  Error when changing Config Field data type  

Err-126363:  com.onevizion.dao.BlobDataDaoOra.updateBlob:255           

Can't submit empty file

Err-134395:  /dash/FormDashboard.do:1             

Error when clicking on "Security Role" link on dashboard edit form

GUI-134009:  The dragging action is called when the controls of the selected field are clicked       

Fixed bug causing a dragging event for a field when clicking on field control controls (buttons appear above the field when it is selected)

GUI-134398:  [All] element must be at the list top on Form Designer        

GUI-134851:  Config Field editable in a grid even if there is no edit privs 

This is UI bug, user still can't submit changes if he do not have edit privs

Grid-134236:  Unable to edit text field in a grid  

Grid-134656:  Wrong data set returned when filtering user page with (+)= operator and "PreventLeftJoin" param set to Yes   

Imp-134406:  Can't create default import             

Notif-134167:  Is HTML flag is not handled properly by mail service          

Rep-135017:  Endpoint to submit ClearPath layout are not available         

Rule-134221:  Form Buttons rules hangs in "Running" status after session killed by timeout           

Now, we will update process status to "Interrupted"

VF-134164:  Unnecessary fields in the view options         

Fixed the problem of loading fields not belonging to the selected tab

VF-134407:  "All" filter is duplicated in the Form Organziner when you overwrite it              

VF-134828:  Values for "Within" filter operator are not saved

OneVizion 8.92.1

Released 09/25/2018

The following is a list of changes since version 8.92:

Bugs:

GUI-134168:  Error message on login screen       

Grid-134236:  Unable to edit text field in a grid  

1. The bug was reproduced when the text field column is included in list of frozen columns
2. The bug was reproduced when value length of the text field is more than we display in cell

Notif-134167:  Is HTML flag was not handled properly by mail service          

VF-134164:  Unnecessary fields in the view options         

Fixed the problem of loading fields not belonging to the selected tab

OneVizion 8.92

Released 09/24/2018

The following is a list of changes since version 8.91.1:

New Features:

BPL-110249:  View folders are not moved by the Components Export/Import.    

BPL-110250:  Filter folders are not moved by the Components Export/Import.

BPL-125293:  Add hyperlink to object ID that lets to open administer form at the Components Export page           

Exp-118700:  Optionally use API compatible column header in exports   

Exp-118701:  Optionally add Entity IDs to the grid exports            

IDs of all the Trackors presented in grid may be included into export file when export started with API call.

Rule-124745:  Implement Automation admin grid and basic edit form     

Rule-125721:  Implement Automation Trigger tab on edit form  

Improvements:

Admin-123285:  Show an empty string in the field "User" on Administer Processes if the user is null          

We may have empty user associated with a process for periodic rule runs (nightly, hourly, etc).

Audit-123284:  Automated error reporting improvements            

Onevizion automatically gather error reports from all installations into trackor.onevizion. In some cases valuable information may be missed in error report. This issue fixes such cases

Audit-124991:  Show "UN"/"Full Name" and EMail in History/Log grids    

History Grids show Un/FullName and Email. "FullName" is alias field that should be set on Trackor Type admin form.

CodeQ-126209:  Fix empty "where" clause in tib_sso_config       

Minor fix do not change any behavior, just makes code cleaner

CodeQ-126212:  Remove processId from temp file name

We used processId as part of temp file name stored on web server during parsing of import CSV. Now we entirely rely on system generated file name.

DB-124423:  Terminate SQL statement when user cancels grid load          

No when user cancels grid data load operation we are abandoning SQL running in DB

DB-124608:  Need ability to use bcc list in util.sendMailWithAttachments             

New parameter "BCC" added to the following routines:

util.SendMail

util.sendMailWithAttachments

pkg_email.mail

pkg_email.mail_with_attachments

DB-126063:  pkg_db_warmup improvements    

Created new table db_warmup_run to separate data between two warmups.

Fixed runtimes in DB_WARMUP_STAT in milliseconds to simplify comparison with usage_log data.

Populated DB_WARMUP_STAT.ROWS_CNT of values from RCNT column.

Improved the docs providing details on parameters and what each procedure do and sample call and where to look for the result.

DropGrid-126210:  Controller with @SessionAttributes must call "setComplete"

Fixed issue which may potentially cause redundant data storage in web server session

GUI-123165:  Text Labels on Form Designer are missing font style buttons            

Bold, Underline and Italic styles are now available

GUI-125564:  Form Designer and Listbox GUI improvements       

"Add Field" and "Add Tab" buttons are moved to the top of the list. Plus some cosmetic changes

Grid-126196:  Get rid of redundant brackets in user page SQL where statement 

Rule-124003:  Add Rule Type column to the Rule Run grid             

Rule-125844:  Fix "Edit Rule" form layout              

VF-125720:  Unsaved Filter/View should not be scrolled with the rest items          

"Unsaved X" now always on top of the view filters list

Bugs:

API-125599:  Trackor selector options not loading when  TRACKOR_KEY field is not present in default view options   

Admin-125948:  HTML markup symbols on SSO certificates System Parameter edit form 

Admin-126376:  Program Admin user contains no language after new program creation 

Admin-133870:  Owner's Trackor ID selector displays Trackors already assigned to users 

Conf-125955:  Error when using the lock / unlock button for relation fields           

Conf-134161:  Slow performance of configured tab rendering with many Task Dates         

Dash-124999:  Name of the dashlet is not updating after editing

Err-126044:  com.onevizion.web.controller.grid.SimpleDataSourceController.xml:184 ModuleName=TRACKOR_BROWSER       

Error when filtering on memo field "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" and there multi byte characters are in some values

Err-126062:  com.onevizion.facade.sqlbuilder.userpage.JoinUtils.isLeftJoinFilter:810        

Error when restricted user filtering TB grid and "PreventLeftJoin" system parameters set to "Yes"

Err-126370:  /new/js/components/entityDashletGroup.js:127    

Bug related to adding Y-Axes groups during dashlet edit is fixed

GUI-125563:  IE does not display a table on the Call Stack page   

Fixed the problem with displaying the grid on the Call Stack page in the IE browser.

GUI-133652:  Incorrect page number alignment

Fixed issue with aligning page numbers in the navigation bar

GUI-133797:  Error clicking on a button inside a minimized list    

Fixed bug on the button inside the minimized list

Grid-126143:  Horizontal keyboard navigation does not adjust the grid viewport

Problem with grid scrolling after selecting next cell using tab/arrow key is fixed

Grid-126378:  Undo is not working in grid for Single Click edit mode         

Grid-133871:  Non-english characters are not displayed in cell of grid for Memo field       

When you switch to edit mode of Memo field in the grid, you see '?????' instead of text in case if full text is not able to fit into the cell

MT-126379:  Mass Form Button rules are not available in clonned program          

Rule-126200:  Mass Assign and Mass Lock/Unlock rules are missed           

VF-125633:  Unable to configure View Options of Trackor Selector            

VF-125646:  MultiSorting option by EFile drill-down fields does not display properly values            

VF-126473:  State of the list display mode is not preserved          

VF-133838:  Value field of Time, Date/Time and Date fields are looked invalid      

The value fields are looked invalid if "Is Null" or "Is Not Null" operators are selected

VF-133963:  "Enable Trace" filter option is not saved of the Admin Rule page       

OneVizion 8.91.1 

Released 09/12/2018

The following is a list of changes since version 8.91:

Bugs:

Err-126062:  com.onevizion.facade.sqlbuilder.userpage.JoinUtils.isLeftJoinFilter:810        

Error when restricted user filtering TB grid and "PreventLeftJoin" system parameters set to "Yes"

Grid-126143:  Horizontal keyboard navigation does not adjust the grid viewport

Problem with grid scrolling after selecting next cell using tab/arrow key is fixed

Rule-126200: Mass Assign and Mass Lock/Unlock rules were missed

OneVizion 8.91

Released 09/10/2018

The following is a list of changes since version 8.90.2:

New Features:

DB-124118:  Review state of PKG_DB_WARMUP.          

Package may be used to produce DB workload based on usage_log data.

Rule-121072:  Implement rule tracing so every rule log it's run to RULE_RUN       

Improvements:

Admin-122357:  Show user settings in Admin Users grid 

User can add fields from User Settings in View Options of Admin users grid. Also, user can edit these fields in tab "User Settings" at edit form.

Audit-114850:  Exclude table CONFIG_GROUP_ELEM_XREF from Component Log              

Form layout changes won't be logged in Components log anymore. Also, old log records for CONFIG_GROUP_ELEM_XREF table will not be available in grid.

Audit-123160:  When the field was updated by an import, the call stack form should also show link to Process      

Now we show Process ID (link to import details) and Imp Run ID together.

Audit-124853:  Show Config Field Name/Config Field Label on Field History           

Now we show config field name and label in Field History window

DB-124124:  Drop tables audit_log_old and audit_call_stack_old

Tables used as data backup for issues released in previous versions

DB-124663:  Prevent Left Join in user grid SQL when it is not needed       

New system parameter added "PreventLeftJoin". When enabled will minimize number of left joins in user gird SQL to improve performance. For now it affects only CONFIG_VALUE_* tables

DropGrid-125010:  Allow to use only English symbols for field names on DG form              

EFile-125179:  Replace Aspose.PDF library in web app    

Aspose.PDF library is biggest one in our web app package - almost 40 Mb out of 110 MB. And it is used only to generate thumbnails for PDF EFiles (controlled with "GenThumbsForDocuments" system parameter) and for PDF Reports templates parsing. Now it is replaced with more compact library - BFO PDF

GUI-125509:  Deprocate successful password change message on "change password" page            

Imp-123078:  Implement import recovery interruption  

Now we support interruption from "Recovering" state. Already recovered data will be preserved

Rep-123081:  Improve handling of missed sigar library in report-scheduler           

We are using sigar (http://sigar.hyperic.com) to monitor resources usage on app server. When library is missed on app server report-scheduler silently hangs. Now it will show an error message to help troubleshot such issues

Trackor-123411:  Hide "Child Trackor ID" column on TO and Summary pages        

VF-115807:  Reload View/Filters list only when necessary             

We are retrieving list of Views/Filters each time user submits View/Filter. But it is actually only needed in rare cases. Now we are doing this only for such cases

Bugs:

API-125548:  Trackor update for trackor selector field requires Trackor browser read privilege   

Now trackor update endpoint does not require TRACKOR_BROWSER R privelege for update Trackor Selector config field

Android-125260:  App wipes offline data when server url not changed    

Now App not wipes offline data

Android-125261:  Prevent show "N fields updated" message for fields that submitted from current opened App 

In previous version after user updated some config fields in Mobile App, after few seconds he was receive message "N fields updated", when no any updates raised at GUI. Now this is fixed.

BPL-123504:  "Upload files directly to AWS S3" not moved by the Components Import    

BPL-124515:  Error while importing Config Applet with Components Import/Export          

BPL-125500:  Tours BPL Export is broken              

CodeQ-125604:  Integration changes should be submitted in single transaction   

In case of error during submitting new or editing existing Integration all changes should be reverted properly

Conf-125281:  Do not change Tab Name when label changed         

Now Tab Name auto populated with label only when it is empty

DB-124512:  Cleanup procedures should keep certain tasks data

Now cleanup procedures, which are activated with "TaskDateHistoryPurgePeriod" system parameter will preserver log data for Actuals, Projected, BaseLine, and Promised WP Task dates.

Dash-125003:  Date filters is not working correctly on Dashboards page 

Dash-125221:  Fields in dashboard filter are displayed incorrectly in IE       

DropGrid-125712:  Unable to assign new config fields to General Info tab by the DropGrid             

EFile-119263:  Issues when changing not yet submitted EFile       

EFile-120157:  Bug with Efile icon size    

Err-122039:  /js/js.js:1209           

Err-124870:  /new/js/dashboard.js:88   

the bug appears when we load apecific dashboard attached to main menu

GUI-125280:  The icon for the button for switching the display modes is missed in ie.       

Fixed the problem with displaying the icon in the browser internet explorer

GUI-125287:  Form Designer js error when using other lang for OV           

GUI-52372:  Different font size on Spec and Body tabs of "Admin DB Package" form          

Grid-122001:  After loading the grid, all the sub grids are closed 

Grid-122145:  Autoscrolling the page when selecting a sub grid entry      

Grid-125469:  Horizontal scroll reset after click on Frozen Columns           

Imp-124752:  Import validation should ignore empty values        

Rep-123998:  Apply file name normalization to report generated files     

Users were able to paste line break characters into the report file name on start report form, which may cause errors when uploading files to S3

Rule-120467:  HttpCallRule creates new SimpleJdbcCall instance on each call       

We used SimpleJdbcCall class to run call back procedure to handle response of HTTP Call rule. DB metadata requested on every SimpleJdbcCall object creation, so it may be expensive when significant amount of HTTP Call rules is fired. Now we do not use this object. As a side effect, now call back procedure must have exactly 5 arguments, otherwise "PLS-00306: wrong number or types of arguments in call" error will be thrown on call back execution attempt

Rule-125601:  HTTP Call rule error when DataSQL is empty           

The request body for HTTP GET requests is not needed and now it can be empty without filled Data SQL.

Tour-125303:  Tour step creation is not preventing common click events

Trackor-125152:  TB grid issue when multiple instances of a field in filter are used             

VF-125058:  Cannot set Filter value of Trackor Selector/Drop Down in certain scenarios  

Fixed - User gets a 'Module [] not found' error when trying to select value for a Drop Down/Trackor selector field in the filter if the filter was previous saved without any value for this field.

VF-125568:  New field in the right list of view options is not displayed in the multi-sort selector  

Fixed the problem of adding a new field to the multi-sorting list on the view options page

WP-125149:  Cannot create WP Template tasks when tasks names are too long    

OneVizion 8.90.2

Released 09/03/2018

The following is a list of changes since version 8.90.1:

Bugs:

Conf-125281:  Do not change Tab Name when label chaged Now Tab Name auto populated with label only when it is empty

DB-124512:  Cleanup procedures should keep certain tasks data Now cleanup procedures, which are activated with "TaskDateHistoryPurgePeriod" system parameter will preserver log data for Actuals, Projected, BaseLine, and Promised WP Task dates.

Dash-125003:  Date filters is not working correctly on Dashboards page

Dash-125221:  Fields in dasboard filter are displayed incorrectly in IE

GUI-125280:  The icon for the button for switching the display modes is not displayed in ie.

Fixed the problem with displaying the icon in the browser internet explorer

Grid-122001:  After loading the grid, all the sub grids are closed

Grid-122145:  Autoscrolling the page when selecting a sub grid entry

Tour-125303:  Tour step creation is not preventing common click events

Trackor-125152:  TB grid issue when multiple instances of a field in filter are used

OneVizion 8.90.1

Released 08/29/2018

The following is a list of changes since version 8.90:

Err-124870:  /new/js/dashboard.js:88   

The bug appears when we load a specific dashboard attached to main menu.

VF-125058:  Cannot set Filter value of Trackor Selector/Drop Down in certain scenarios  

Fixed - User gets a 'Module [] not found' error when trying to select value for a Drop Down/Trackor selector field in the filter if the filter was previous saved without any value for this field.

OneVizion 8.90

Released 08/27/2018

The following is a list of changes since version 8.89:

New Features:

Conf-114692:  Applet Designer: Ability to add/create, assign, unassign Config Tabs in Config Applet form.

Applet Designer - UI for defining Applets now looks more like Form (tab) Designer.

Improvements:

Admin-123249:  Keep Aspose license in system parameter instead of packaged into the app.       

New system parameter "AsposeLicense" now stores license file, which can be updated without redeploying app. App server restart still required for changes to take effect.

Audit-124853:  Show Config Field Name/Config Field Label on Field History.        

DB-124008:  Convert Config_value_number from IOT to HEAP table.         

We converted config_value_number from IOT to heap table with 1 index.

DB-124123:  Add new indexes on notif_processing_log, integration_log, message.             

Added new index idx2_message (TS, PROCESS, SUB_ID) and changed idx1_message, added idx1_notif_processing_log, changed idx1_integration_log, fixed pkg_vqutils to using these indexes for cleanup.

DB-124305:  Add indexes to non-indexed foreign keys.   

Indexes have been added to the following tables:

dashlet_field

dropgrid_sheet

imp_run

notif

param_program

param_system

report_files

report_run

rule

tm_message_field_cf_data_type

wizard_step

Grid-124424:  Remove redundant filter by program_id in user page SQL. 

Since Version 8.0 data filtered by program automatically in Oracle's view. Additional filter in grid SQL may decrease performance.

Grid-124583:  User-friendly message when there is no any available field by security reason at the (Selector) Trackor Browser.       

IHub-116939:  Implement DB encryption for settings file.

Imp-121811:  ConfiguredVTableLoad should update VALUES for a given ID.            

Import supports all operations, such as insert, update, insert / update Requires columns TABLE_NAME, VALUE, ORDER_NUMBER (or ORDER_NUM), ATTRIB_V_TABLE_VALUE_ID

Below is a description of each import operation:

    Insert: Only insert new values (if this value are presented in the table, than will be generate error)

    Update/Insert: If the value for the ATTRIB_V_TABLE_VALUE_ID column is not null, then doing only update ORDER_NUMBER and VALUE for this operation

         If the value for the ATTRIB_V_TABLE_VALUE_ID column is null or 0 or this column is missing from the import, then we finding record in DB using VALUE field.

             If it's find, then update only ORDER_NUMBER.

             If it isn't find, then create new record with imported VALUE and ORDER_NUMBER

    Update: If the value for the ATTRIB_V_TABLE_VALUE_ID column is not null, then doing only update ORDER_NUMBER and VALUE for this operation

         If the value for the ATTRIB_V_TABLE_VALUE_ID column is null or 0 or this column is missing from the import, then update only ORDER_NUMBER by VALUE.

Rule-121559:  Implement support multipart building for HTTP Call Rule. 

New ability to build Multipart HTTP request has been implemented. It supports to set up custom headers for part with dynamic parameters.

Rule-121560:  Implement support binary data in request body for HTTP Call Rule

New request body format "Binary" has been added. Data SQL should return 1 column and 1 row with Oracle BLOB data type.

Rule-123886:  Improve exception handling for HTTP Call Rule      

Now we log all HTTP Call Rule errors into RULE_HTTP_CALL_LOG.ERROR_MESSAGE database column and show HTTP Call Log ID for user.

Sec-124135:  Reload User's cached privs after object creation     

After creating any object (like Trackor Type, WF Template, Dashboard etc) this object will be accessible in OneVizion immediately.

Sec-82764:  Add security token type "Dashboard" to assign individual dashboards to the users    

The following security model is  implemented:

1) "DASHBOARD" sec group

R- Dashboard page is accessible

E - You can modify Dashboards

A - You can create new Dashboards

D - You can delete Dashboards

2) Every Dashboard is listed in the "Sec Groups" grid with an ability to set individual permissions:

R - Dashboard is accessible

E - You can create/modify dashlets, filters and layouts of this dashboard

3) When you are on Dashboards page the drop-down on the top of the page shows Dashboards assigned to you.

4) If you are a SuperUser you will see ALL dashboards in the drop-down.

5) If you have "A" permission for the "DASHBOARD" sec group and you are adding new Dashboard - it will be automatically assigned to you via priv exceptions.

VF-115201:  Add ability to filter by User's "Email" and "Disabled" fields   

VF-119079:  Drop Administer Filter and Administer View  pages 

Administer Views and Administer Filters pages are being dropped. "Is Default Col Picks" Filter/View feature has been dropped

WP-123456:  WP Limits need to be implemented in DB  

WP Limits implemented in PKG_WP (assing_wp and edit_wp). Direct insert of WP into WP_WORKPLAN is not allowed. Direct activation of WP in WP_WORKPLAN is not allowed.

Bugs:

API-123505:  Limit SQL query for grid cells counting at /v3/exports/{trackor_type}/run   

*Now SQL query for grid cells counting is limited and not affecting web server performance.

Admin-123475:  User Trackor Priv Exception grids don't show colors for overriden privs after refresh       

Admin-124125:  "Recover" button is not available on Audit Log page       

"Recover" button is available if you have "E" priv on AUDIT_LOG

Android-122715:  Log off is not working at Edit Selector and Edit Memo/Wiki windows   

Audit-124007:  Created By/At  and Modified By/At columns of Rule component are filled incorrectly         

The columns have been added in ignore list of the Components Audit Log

Dash-124133:  Filters panel activates dashboard layout Save and Reset buttons  

Dash-124134:  Dashboard text filters should not be applied if empty        

DropGrid-123865:  Markup is broken on the 4th step Dropgrid Wizard in MS Edge             

EFile-124514:  Error on opening E-File Download History form without stored E-File data.              

Err-122945:  /new/js/newGuiCoordinates.js:1473             

javascript error when coordinates are changed in a grid using coordinate picker

Exp-122824:  Components Export List panel bug

List panel will go blank after expanding/collapsing a couple of times

GUI-124219:  Js error in view options on the E-File browser page

Fixed bug when switching list mode in view options on E-File browser page

Grid-123425:  Highlighting of changed selector and drop-down cells is not working correctly in certain cases         

Fix for several problems with changed cells highlighting for drop-down and selector field types.

Grid-123562:  Page loas with error when 'EnableDistributedParsing' system parameter is on         

The issue affects pages where 'Frozen Cols' option is used

Grid-123856:  Error on Task view             

Map-123338:  Map isn't loaded on the first page opening without coordinates    

Notif-123736:  Incorrect textual representation of filter settings on "Admin Notification" form     

Notif-124239:  Notification job failing with error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"           

When significant amount of changes generated between notification job runs and "AUTHOR_OF_CHANGE" field used in notification, job may fail with such error. Now we are limiting length of "AUTHOR_OF_CHANGE" to 1900 characters

Portal-122976:  Portal Bug: Raise Error not showing correctly when triggered on Grid Row Edit    

Trackor-124130:  Wrong prefix of WorkPlan tab at the Config Form          

VF-124121:  Workplan Template name is not displayed in the Filter Options of the Tasks page     

The name is not displayed if the Tasks page is opened from the Trackor Browser page

VF-124304:  WorkPlan fields should not be displayed in the View Options of the EFile Browser    

VF-124306:  EFile static applet is displayed twice in the View Options of the EFile Browser             

VF-124307:  Config Applets should not be displayed under the EFile Trackor Type in the EFile Browser View Options               

VF-124320:  Drill Down fields are not displayed at the EFile Browser        

VF-124481:  Global Filters/Views are not saved as 'selected' at the administer pages        

OneVizion 8.89

Released 08/13/2018

The following is a list of changes since version 8.88:

New Features:

DB-122835:  Gather additional statistics on user page SQL for selected users System parameter "SQLCommentUsageLogID" removed, instead we can gather SQL exec plans for particular users. Set value of users.collect_performance_data column to 1, to get exec plans for user page grid SQLs in USAGE_LOG_SQL_PLAN table. Option is not available in GUI and may decrease grid SQL performance for the user.

Exp-122565:  Execute export SQL in report database Now exports can be executed in report database in the same way as reports. This may reduce load on the main server and improve performance.

VF-121107:  Implement "Default View" for data pages.

VF-122635:  Create "G:All" filter on trackor type creation and make it default.

Improvements:

Admin-114751:  Show message on Publish Apps form when publish operation is not available For configured/external applets now we show notification message for make behavior more obvious. The message shows when Trackor Type is not set in Filter.

Android-84595:  Create mobile app screenshots with real look steps and fields for Google Play.

Audit-114850:  Exclude table CONFIG_GROUP_ELEM_XREF from Component Log Form layout changes won't be logged in Components log anymore.

BPL-118000:  Components Export - Add Last Modified By,  Last Modified At, Config Session.

Conf-75653:  Improvement for cascade fields import Now we optional allow to import links without having all Trackor Classes or VTable values. Non-existent values will be automatically created if needed.

DB-121131:  Speed up roles/privs update

1. Disabled Users will be excluded for privs and assignments recalculations. This should significantly improve performance of Sec Roles update operations.

1. Sec procedures used for privs and assignments recalculations were redesigned for better performance.

DB-122040:  Add "gather_plan_statistics" when performance data collection is enabled When USERS.COLLECT_PERFORMANCE_DATA = 1 additional hint "GATHER_PLAN_STATISTICS" will be added to the user page grid SQL, and additional data will be stored in USAGE_LOG_SQL_PLAN table.

DB-122903:  Add USAGE_LOG_SQL_PLAN.OUT_PLAN column to the Usage Log grid New column "SQL Execution Plan" contains Oracle execution plan for user page grid loads when performance monitoring is enabled.

DB-122904:  Omit "qb_name(qbint)" comment and "OPT_ESTIMATE" hints in user page SQLs when they doesn't needed OPT_ESTIMATE will be used only when there are more then one config_value_number tables in SQL. "qb_name(qbint)" comment will be used  when there are "OPT_ESTIMATE" or "USE_HASH" hints presented. Hints support removed from Admin WF and Workflow grids, so now hints are added only for Trackor Browser and Mapper grids.

DB-123419:  Apply "OPT_ESTIMATE" hint only for CONFIG_VALUE_NUMBER table Hint can be enabled with "SQLHintOptEstimate" system param. Limiting scope to CONFIG_VALUE_NUMBER table will help us better understand how it affects oracle exec plans.

Dash-123271:  Allow to add or remove filter conditions only if user has Edit privilege on Dashboard security group.

Exp-108562:  Show values of hyperlink CFs as hyperlinks in Excel exports.

Exp-114690:  Color Excel cells for lookup CFs when using export or TB Grid Report.

GUI-54193:  Develop custom design for 40x Error Pages.

Grid-113617:  Drop Down colors should be shown in Grid.

IHub-122641:  Support git authorization for integration.

IHub-122722:  Make "Settings File" field optional on Admin Integration" form.

Rep-122636:  "Interrupt process" button should work for multiple processes Now we allow to interrupt all selected processes at Administer Processes page.

VF-122718:  Expand Filter from 10 to 15 Rows.

VF-122720:  Transferring of the switch mode button on the viewing options page.

WP-121816:  Task Date Fields on forms and tabs should be colored like in grid.

Bugs:

API-119257:  api/v3/trackors/{trackor_id}/options/{field_name} cause error if trackor type doesn't has ancestor Now we throw error when more than one parents found for trackor if config field type is DB Drop-Down, DB Selector, Trackor Selector or Trackor Drop-Down. 

API-121565:  Review all API controllers and make sure that all entities privs are checked API v1:

GET v1/{moduleName}/filters:

1. Added filter is assigned to user check (for global filters).

GET v1/trackor_type/{trackorType}:

1. Added filter is assigned to user check (for global filters); 2. Added check has user privs on config fields if use custom filter (key=value); 3. Added is my trackor check (if tid parameter is set).

PUT v1/trackor_type/{trackorType}:

1. Added check has user privs on config fields if use custom filter (key=value); 2. Added is my trackor check; 3. Added data submit privs check (same as in GUI).

POST v1/trackor_type/{trackorType}:

1. Added data submit privs check (same as in GUI).

API v2:

GET v2/{moduleName}/filters:

1. Added filter is assigned to user check (for global filters).

GET v2/wps/{workplan_id}/tasks:

1. Added is my workplan check.

GET v2/tasks:

1. Added is my task check;
2. Added check for task static fields and static/dynamic dates (for R privilege). If no privelege on some field - value of this field in response will be null.

GET v2/tasks/{task_id}:

1. Added is my task check;
2. Added check for task static fields and static/dynamic dates (for R privilege). If no privelege on some field - value of this field in response will be null.

PUT v2/tasks/{task_id}:

1. Added is my task check;
2. Added data submit privs check (same as in GUI).

GET v2/wps:

1. Added is my workplan check;
2. Added trackor type priv check.

GET v2/wps/{workplan_id}:

1. Added is my workplan check;
2. Added trackor type priv check.

GET v2/trackor_type/{trackorType}:

1. Added filter is assigned to user check (for global filters); 2. Added view options is assigned to user check (for global v/o); 3. Added check has user privs on config fields if use custom filter (key=value) or custom view options.

POST/PUT v2/trackor_type/{trackorType}:

1. Added is my trackor check;
2. Added data submit privs check (same as in GUI); 3. Added check has user privs on config fields for filter (key=value).

API v3:

GET v3/reports/runs:

1. Added report is assigned to current user check.

GET v3/reports/runs/{process_id}:

1. Added report is assigned to current user check.

GET v3/reports/{process_id}/file:

1. Added report is assigned to current user check.

GET v3/reports/{report_id}/runs:

1. Added report is assigned to current user check.

POST v3/reports/{report_id}/run:

1. Added priv check for REPORTS_EMAIL_TO (R) when emails specified in model.

GET v3/imports/runs:

1. Added check for IMPORT_HISTORY (R);
2. Added import is assigned to current user check.

GET v3/imports/runs/{process_id}:

1. Added import is assigned to current user check.

GET v3/imports/{import_id}/runs:

1. Added check for IMPORT_HISTORY (R);
2. Added import is assigned to current user check.

POST v3/imports/runs/{process_id}/interrupt:

1. Added check for IMPORT_HISTORY (R,E,D).

POST v3/imports/{import_id}/run:

1. Added check for IMPORT_HISTORY (R);
2. Added check for CONFIGIMPORT (R);
3. Added check for CONFIGIMPORT_INCREMENTAL (R) if is_incremental=1.

POST v3/trackor/{trackor_id}/file/{field_name}:

1. Fixed privs check before trackor update.

GET v3/trackor_types/{trackor_type}/filters:

1. Added filter is assigned to user check (for global filters).

GET v3/trackor_types/{trackor_type}/filters/{filter_name}:

1. Added filter is assigned to user check (for global filters).

POST v3/trackor_types/{trackor_type}/filters/{filter_name}/set_as_current:

1. Added filter is assigned to user check (for global filters).

GET v3/trackors/{trackor_id}/locks:

1. Added check R priv for config fields.

GET v3/trackor_types/{trackor_type}/trackors/locks:

1. Added check R priv for config fields.

GET v3/trackors/{trackor_id}/options/{field_name}:

1. Added is my trackor check;
2. Added config field is read only check; 3. Added priv check for config field (E).

POST v3/programs:

1. Added priv check for WEB_SERVICES (R); 2. Added priv check for ADMIN_PROGRAM (A).

GET v3/tasks:

1. Added is my task check;
2. Added priv check for static date pairs and task fields (R).

GET v3/tasks/{task_id}:

1. Added is my task check;
2. Added priv check for static date pairs and task fields (R).

GET v3/wps/{workplan_id}/tasks:

1. Added is my workplan check;
2. Added is my task check;
3. Added priv check for static date pairs and task fields (R).

PATCH v3/tasks/{task_id}:

1. Added is my task check.

PATCH v3/trackors/{trackor_id}/wps/{workplan_name}/tasks:

1. Added is my task check.

PATCH v3/wps/{workplan_id}/tasks:

1. Added is my task check.

PUT v3/tasks/{task_id}:

1. Added is my task check.

GET v3/exports/runs/{process_id}:

1. Added priv check for ADMIN_PROCESSES (R) or user can be owner of process, otherwise access will be denied.

GET v3/exports/runs/{process_id}/file:

1. Added priv check for ADMIN_PROCESSES (R) or user can be owner of process, otherwise access will be denied.

POST v3/exports/{trackor_type}/run:

1. Added filter is assigned to user check (for global filters); 2. Added priv check for config fields (R) used in custom filters; 3. Added view options is assigned to user check (for global v/o); 4. Added custom view options priv check for config fields (R); 5. Added priv check for non primary trackor-type (R).

GET v3/wps:

1. Added is my workplan check.

GET v3/wps/{workplan_id}:

1. Added is my workplan check.

POST v3/trackors/{trackor_id}/assign_wp:

1. Added is my trackor check.

GET v3/trackor_types/{trackor_type}/views:

1. Added view options is assigned to user check (for global v/o).

GET v3/trackor_types/{trackor_type}/views/{view_name}:

1. Added view options is assigned to user check (for global v/o).

POST v3/trackor_types/{trackor_type}/views/{view_name}/set_as_current:

1. Added view options is assigned to user check (for global v/o).

GET v3/trackor_types/applets/{applet_id}/tabs/{tab_id}:

1. Added priv check for applet (R);
2. Added priv check for config fields (R).

GET v3/trackor_types/{trackor_type}:

1. Added priv check for config fields (R); 2. Added view options is assigned to user check (for global v/o).

GET v3/trackor_types/{trackor_type}/applets:

1. Added priv check for applet (R).

GET v3/trackor_types/{trackor_type}/applets/{applet_id}:

1. Added priv check for config fields (R).

GET v3/trackor_types/{trackor_type}/applets/{applet_id}/tabs:

1. Added priv check for config fields (R).

GET v3/trackor_types/{trackor_type}/trackors:

1. Added view options is assigned to user check (for global v/o); 2. Added filter is assigned to user check (for global filters).

GET v3/trackors/{trackor_id}/applets/{applet_id}:

1. Added priv check for applet (R).

GET v3/trackors/{trackor_id}/applets/{applet_id}/tabs/{tab_id}:

1. Added priv check for applet (R);
2. Added priv check for tab (read).

PUT v3/trackors/{trackor_id}:

1. Added check privs for submit data;
2. Added is my trackor check.

POST v3/trackor_types/{trackor_type}/trackors:

1. Added check privs for submit data.

POST v3/trackor_types/{trackor_type}/trackors/search:

1. Added custom view options priv check for config fields (R); 2. Added priv check for non primary trackor-type (R).

PUT v3/trackor_types/{trackor_type}/trackors:

1. Added check privs for submit data;
2. Added is my trackor check.

Admin-123475:  User Trackor Priv Exception grids don't show colors for overriden privs after refresh

Audit-122239:  Edge isn't being logged in Usage Log

Audit-122647:  USAGE_LOG_LOAD_TAB is not fully populated for non GI tabs

BPL-121547:  WorkFlow step selected fields and groups not transferring

BPL-121946:  'None' privilege is not moved by the Components Import

BPL-122658:  Components Import of Filters fails in specific cases

BPL-122742:  Components Import of Trackor Type fails if a APPLET_LABEL_ID of Trackor Type in XML greater than 0

Dash-121961:  Date on X-Axis is not working correctly

Dash-122358:  Customized dashboard layout or filters causes page leaving confirmation

Dash-122361:  Date charts is not working with several chart types if there are empty date values

Err-119269:  com.onevizion.web.sso.saml.RuleTriggeringSAMLAuthenticationProvider.authenticate:26

When user lost HTTP session by some reason before success authentication through SSO - he got message "Internal server error. Please try again later" which can confuse him.

Instead of "Internal server error. Please try again later" now we show "OneVizion session timeout expired. Try to login with [identity provider name] again" message for this error.

Err-122490:  com.onevizion.web.sso.saml.SAMLEntryPoint.commence:24

Err-122838:  com.onevizion.web.controller.grid.SimpleDataSourceController.xml:184 ModuleName=TRACKOR_BROWSER Error when using "My ..." filter in Trackor Browser.

Err-122856:  /new/js/dashboard.js:330

JavaScript error if user don't have Edit privilege on DASHBOARD security group when loading Dashboards page.

Err-123283:  com.onevizion.web.controller.grid.SimpleDataSourceController.xml:184 ModuleName=TASKS_OVERVIEW This error logged when SQL query terminated by timeout (1800 seconds by default). Now we no longer log such events as warnings and it is not delivered to trackor.onevizion.

Exp-78605:  Cannot Export Efiles to ZIP because of the Grid Cells limit Now Grid Cells limit not affects "Grid EFiles to ZIP", "Map Objects to Google Earth" and "Map Objects to Mapinfo" export types.

GUI-122905:  Js error when editing a field when creating a row editor layout.

GUI-123281:  Selection of field in list does not work correctly in the form designer Fixed problems with the selection of fields.

GUI-123420:  Js error while moving the field in the form designer Fixed js error when moving the field in the form designer.

Grid-122285:  TextCellsDisplayLimit parameter works incorrectly with multibyte symbols.

Grid-122498:  Error while loading grid on the Task View page.

Grid-123084:  Duplicated cells incorrectly marked as unsaved after edit Error when trying to add a Configured Field Name for the "Params" in the Configured Field Update Overriding Lock mapping data type.

MT-122443:  Program cloning can create objects in wrong program.

Other-98683:  Exclude test dependencies from list of 3rd party librarires We are using some dependencies for testing only, those are not included in builds. Now it will not be shown on 3rd party libs page.

Rep-119349:  Disable grid edit in preview mode of Report Wizard.

Rep-122461:  Report Generator adds something into blank Excel cells Now for pattern blocks we fill "null" value into cell if SQL query returns NULL or empty string/CLOB.

Sec-123415:  Value_clob column in program_system table must be encrypted for X.509 PEM Certificate parameter data type We encrypte VALUE_CLOB column instead of the VALUE column in PARAM_SYSTEM.

VF-122887:  Don't show the selected folder and its sub-folders in dropdown at Edit Current Folder window.

VF-122892:  Search can't find folders in dropdown at Add/Edit Current Folder windows.

VF-123118:  The Row Editor layout is not copied when you overwrite exiting view.

OneVizion 8.88.1

08/09/2018

The following is a list of changes since version 8.88:

Bugs: 

Err-122838:  com.onevizion.web.controller.grid.SimpleDataSourceController.xml:184 ModuleName=TRACKOR_BROWSER Error when using "My ..." filter in Trackor Browser.

Sec-123620:  Intersection mode Trackor Type restriction do not checks if any relation exists Bug was introduced in 8.85.0 with Trackor-117089.

OneVizion 8.88

Released 07/30/2018

The following is a list of changes since version 8.87:

New Features:

Admin-122491:  Create new function - UTIL.GetAuditCallStack This function produces a clob with info from the Audit Call Stack for the last thing this user did. This could be used  to feed a SetMessage call for debug in a Rule before an error occurs, since the error falls back and effectively removes call stack info before you can use it to debug. This will bypass that. It pulls back the audit_log info from the latest record for this user, which should be the change that triggered this Rule.

Audit-120662:  "Login As" - Usage Log should display the User New column "Login As By User" added to Usage Log and shows user who was logged in as another user. Also, for "Login As" action, now it shows target user in "User" column and logging in as user in "Login As By User" column.

BPL-110252:  Components Export/Import of Notifications Ability to export/import notifications from one environment to another.

DB-120171:  Implement "id" package. New "ID" package provides access to Config Field and Trackor Type ids by name.

Depl-112513:  Version management and integrations update Integration Hub clones a repository at first run. Also It pulls changes from repository at each integration run. Integration Hub can clone specific branch or tag if version is specified. Default version is "master". If repository or version has been changed, Integration Hub pulls new integration from changed repository or version. Integration form has a validation for Repository and Version fields.

Exp-118149:  Implement JSON export format New format can be used in any grid. For start export with new format: open grid which you want to export, click to "Export" button, click to "Run export" in popup menu and select "Grid to JSON" in Export Mode. v3/exports/{trackor_type}/run API endpoint also supports new format. For Trackor Browser grid exports we add "type" property. For config fields type is "CONFIG_FIELD" and for task dates is "TASK_DATE". Also we specify trackor type name for config fields in property "trackor_type" for get an ability to detect what trackor type is for current object.

GUI-118624:  New style for "Must Change Password" form New style matches style of login screen.

GUI-118625:  New style for "Password Recovery" form New style matches style of login screen.

Grid-65150:  Allow to change layout of row editor Now users may utilize form designer to build custom row editor form layout in Trackor Browser. New functionality available in View Options form.

IHub-121721:  Create a form for Integration Run.

IHub-121722:  New icons for Integration Run and Integration Log.

IHub-121723:  Added cron expression validation and link to docs for Schedule field on Integration Form Integration form has a cron expression validation for Schedule field. Also Integration form has link to quartz documentation with examples of expressions.

Imp-119496:  New import data type: Task set NA.

Rule-114696:  Show data from RULE_RUN on Admin Process page.

Rule-120702:  Create new index on "Process" table for improve cleanup performance of "rule_run" and "integration_run" tables.

Rule-121812:  Improve HTTP Call rule queue processing Now asynchronous HTTP Call Rule invocations are executed in parallel threads. By default we are using 10 threads.

Improvements:

Admin-121775:  Filter options for "Admin Users" page to find users with overridden privs New options implemented for Filter form on Admin Accounts page:

1. Has Overriden Sec Privs
2. Has Overriden Lock Privs
3. Has Overriden Object Assignments
4. Has Overriden Trackor Restrictions

Audit-121953:  Add Date/Time column to import recovery history grid New column "Date/Time" added to "Import Recovery History" grid.

Audit-121969:  Add "Tab Details" on Usage Log page "Tab Details" form is now available on Usage Log page in case of "Load Tab" action. 

BPDocs-120456:  Change Header and Footer of BPD Help page New style applied to the integrated documentation.

Exp-118499:  Close "Grid Export" window after export scheduled Now export results are available in notification panel.

GUI-29811:  Apply new style to message div A message that another user has shared this page with you is now displayed as an alert after all data has been loaded into the grid.

Grid-66522:  Replace old "Task Items" icon with SVG.

IHub-122029:  Create file "ihub_process_id" in integration working directory to access inside integration The ihub_process_id file is put into integration directory at each integration run. ihub_process_id is a file which contains current process_id.

IHub-122208:  Delete user and directory when deleting the integration When integration is deleted, related OS user and disk directory are deleted.

Other-118553:  User option to "mute" the events window Added the ability to disable notifications when processes are finished.

Other-118554:  Improvements for download option on Event window "Download" button in Event window will be hidden if user does not have privileges for downloading file from specific process. 

Rep-122217:  Update Aspose License.

We are using 3rd party library to generate Excel, PDF and Visio reports. Current license expires on Aug 15 2018. New license included into this release.

Rule-119509:  Add Country field into geocoding rules New fields added to the following rule classes: Geocoding, Forward Geocoding, Geocoding ArcGIS, Forward Geocoding ArcGIS.

Rule-121659:  Add parameters to HTTP Call rule to control connection and request timeouts In 8.87.0 we implemented default 30 seconds timeouts for HTTP calls, now this values can be controlled individually for each HTTP Call rule depending on limitations and performance of the services it is accessing.

Sec-121905:  Separate Token Type for Date Pairs New token type is "WP Task Field". All "TASK_*_MOD" sec groups now come under this token.

Bugs:

Admin-121578:  Display Report Name value at the Admin Notif Queue page as text Display value as text if there is no related Report Run record.

Admin-121968:  Unable to choose the Selector config field values in the Filter Options of the Notification.

Admin-122024:  Selector's Display Field is empty when you are cloning a field.

Admin-122047:  Filters by MultiSelector and Trackor Drop-down do not work properly at the Admin Notif form.

Admin-122135:  Wrong values in columns at the Admin WorkPlan Template page.

Admin-122298:  Update of WP Task Type Xref does not work properly.

Admin-122313:  Wrong checkbox highlighting on "Lock Privs" Tab grid.

Admin-122535:  The counter of fields per Trackor Type at the Admin Tab displays wrong value *When we calculate numer fields we should not include multiple fields assigned to tabs.

Audit-122159:  "User" link in Usage Log grid shows form for wrong user.

BPL-121802:  Tab and fields assignments included in WP template are not moved by the Components Export/Import The assignments are not moved if there is an EFile field with configured Image Settings. The bug is reproduced for EFile assigned to static Trackor Type (WorkPlan, Tasks, Workflow).

Conf-115808:  Config form submit hangs in Safari if form has eFile fields.

GUI-122652:  View Options: Transfer of the field to the opposite list (in the middle) does not work Fixed problem with moving the field in the view options on the admin pages.

Grid-118513:  Cannot save drop-down field in grid because of non-visible symbols.

Grid-121514:  Priv Exception grid doesn't show colors for overridden privs.

Grid-121766:  Memo/Text cell height could not be increased in grid edit mode.

Grid-121878:  Exit from the cell edit mode when working with ckeditor.

Grid-121895:  Wiki field is not loading full value on grid edit in certain cases.

Grid-122568:  The value of "Not Exist" should not be a reference The value of "Not Exist" is displayed as text, not the link.

MT-122418:  Cloning program fails in specific cases Clone fails because some entities are mistakenly cloned to the wrong program. Fixed now.

Other-118552:  Process events appear in different browser windows If you have multiple browser tabs open, the event notification will only be displayed on the current tab. When you move to other tabs, the notification will not be shown again.

Other-122112:  View Mode switcher does not save its state in filter on Tasks Summary page.

Other-122825:  WpTemplateDao.findMapTtidWpidByWpids fails if you pass more than 1000 values.

Sec-121581:  System Privs Auto-assignment feature creates extra privs Fixed bug when System Privs Auto-assignment feature creates extra privs (for example applet may support only RE but auto-assignment feature creates READ).

VF-120071:  Check global View/Filter assignment to the user when loading user pages.

VF-121470:  [Any Column] option shouldn't be available for "<>Field" filter operator.

VF-121954:  Unable to set value to Trackor Key filter at the EFile Browser.

OneVizion 8.87

Released 07/16/2018

The following is a list of changes since version 8.86.1:

New Features:

API-118702:  Support advanced search functionality for /v3/exports/{trackor_type}/run endpoint Filter syntax from /v3/trackor_types/{trackor_type}/trackors/search now supported.

BPL-29026:  Component Export/Import of Filter Options Only global filters are supported for the following pages: Trackor Browser, Tasks, Mapper, E-File Browser, Workflow, Admin WF, Tasks Overview and Summary. In case if the filter already exists, the Components Import overwrites it. If the Components Import does not find in target instance some configured fields or task dates used in the filter, it just skips them.

IHub-118287:  Implement Components Log.

IHub-120808:  Integration Hub app improvement Owner and Group have permissions on integration files.

File with process_id create in integration directory for each run.

Directories for integration and prepare integration create in current work directory. Prepare bash scripts are created with execute permission. 

Imp-114870:  Security Token for Recover Import "CONFIGIMPORT_RECOVER" sec group controls Import Recover feature. 

Imp-120556:  Routines to test new entity search feature in production This allows us to compare results and performance of new entity search implementation with existing one. Feature can be enabled with CompareFImpEntitySearch hidden system parameter. 

Notif-117509:  Limit attachment size for OneVizion emails New system parameter "NotifMaxAttachmentSize". When set, exception will be thrown when system will try to create notification with large attachment size. It will affect calls to utils.SendMail, EMail report delivery and all other processes adding messages to notif_queue. Default value - 0 - no limits. 

Rule-120659:  Set connection and read timeout for HTTP call rule Connection and read timeouts are set for http request from ForwardGeocode,Geocode, MapSnippet, Http Call rules. If request time exceeds 30 seconds rule will be interrupted with error. 

Sec-114697:  Grant full privs on newly created objects to the creator When creating new Objects full privs/access will be granted to the creator of the object. Newly created objects will be assigned to the creator through User Exceptions or through User Assignments.

The feature is implemented for the following objects:

1. Configured Applet
2. Configured Tab
3. Import
4. Report
5. Rule
6. WorkFlow
7. Relation
8. Trackor Type
9. Discp
10. Menu Application
11. Global View
12. Global Filter
13. Global Portal
14. Notification
15. Trackor Tour

WP-118494:  Task page - add an ability to filter by  Late, Early and Promised dates.

Improvements:

API-114545:  Add new endpoints for Tasks partial update New endpoints has been added:

1) PATCH api/v3/wps/{workplan_id}/tasks

2) PATCH api/v3/trackors/{trackor_id}/wps/{workplan_name}/tasks

Android-113305:  Ask permissions when they needed, not at App login screen. 

Android-119500:  Create periodic task for update user settings User can change some personal settings (Date and Time formats, Thousands separator, etc) in web UI. Now we reload this settings every ~20 minutes.

Android-121097:  Show mobile app version in "About" dialog.

DB-121100:  Create package procedure to clear user's privs and assignments Add new procedure - PKG_USER.clear_user_privs_and_asgnmts(p_user_id users.user_id%type). It clears all sec group privs and object assignments.

DB-121453:  Update trigger on CONFIG_FIELD.CONFIG_FIELD_NAME amd XITOR_TYPE.XITOR_TYPE_NAME to provide correct characters in the name We are applying new checks for Config Field and Trackor Type names: names should not contain characters that are unacceptable when creating types New rules will affect only new Config Fields and Trackor Types.

Dash-114227:  Improve dashboard datasource SQL validation to catch bind variables.

Depl-121278:  Add 6005_pkg_user.sql script Script can be used to test cases when we need to deploy pkg_user in owner schema but script executed in _user.

Exp-120869:  Cell Formatting Export restriction New hidden system parameter "MaxPKCountForCellDecor" added. Default value is 5000. Increasing it may degrade app server performance. When set to 0 decorations won't be applied.

GUI-120241:  Implement sequential focus change between fields on config forms when using "Tab" key.

Grid-121458:  Quick Search improvements for multi-line data pasting.

Imp-121302:  Change label on Import Admin form The label "Use experimental feature" has been changed to " 'Performance Feature (Beta)'"

Imp-121564:  User-friendly message in case when number of columns in CSV rows is different.

Rule-120994:  Drop "PM Task Item Update" and "OnClick" Rules (rule_type_id 2& 34) "PM Task Item Update" and "OnClick" Rule Types have been removed.

WF-121566:  Add "Role Privs" Tab to Add/Edit WF admin form "Role Privs" tab has been added to Admin WF form.

Bugs:

API-121545:  Retrieving checkbox values from GET api/v3/trackor_types/{tarckor_type}/trackors endpoint cause error Retrieving checkbox values from GET api/v3/trackor_types/{tarckor_type}/trackors endpoint cause error if "Choice Element In Grid " User Settings parameter is set to "Yes\No DropDown".

Admin-121793:  Unable to open Components Log form details.

Admin-121796:  Unable to preview applet at the WorkPlan Template page.

Android-120009:  Error when click on config field.

Android-121456:  App allows user to edit read-only datetime field.

BPL-121291:  Security Role general tab checkboxes are not copied properly.

DB-121128:  General Info view breaks a grid The grid fails if there are WorkPlan configured fields assigned.

DB-121463:  Delete user trackor when deleting user account When deleting User Account the associated User Trackor will also be deleted.

EFile-119129:  Normalize file names on upload While uploading file dangerous symbols(/:*?"<> and carriage return symbols) will be removed from file name.

Err-114719:  /js/form/cf.js:7189

Err-121341:  /js/grid/excell/Common.js:57 Fixed a bug that occurs when you press a key with a character with a selected cell of type "memo"

GUI-121405:  Paste from Excel into QS doesn't automatically add commas as value separator.

Grid-121109:  Incorrect appearance of sub grid with single line.

Grid-121459:  QuickSearch clear button is not visible when value being pasted.

Grid-121507:  "Field Comments" form is broken. Fixed.

Grid-121561:  Js error when you call the context menu of a cell type the file size Fixed the error that occurs when clicking the right mouse button on a cell with the types "file size". 

Grid-121582:  "Is New" and "Is Not New" filter operations do not work properly with Trackor Selectors.

Map-121548:  JS error on empty Mapping page. 

Other-120583:  External applet not opening in IE. 

Sec-119839:  Fix CWE-327 in "Sensitive Data Encryption".

Vulnerable ECB chaining mode replaced with secure CBC. Customers using this feature should re encrypt their data using additional script after upgrade before startup of app and web servers.

We provide a script for re-encrypting data using a new algorithm. The script should be executed on databases that use encryption, see the comments and the attached script. The instructions for using the script are inside it.

Tour-118817:  Tour's "backdrop" options doesn't work.

Trackor-118556:  Error when searching on a Memo Field Search by Memo and Wiki Config Fields in grid works only with 1st 4000 characters.

VF-119603:  Create filter form for Administer SSO Providers Filter was missed for "Admin SSO Providers" grid. Fixed now.

VF-121693:  Unable to select a Trackor in the Trackor Selector in specific case.

OneVizion 8.86.1

Released 07/03/2018

The following is a list of changes since version 8.86:

Bugs:

GUI-121405:  Paste from Excel into QS doesn't automatically add commas as value separator. Fixed.

VF-121338:  Selected filter is not saved in specific cases. Selected filter is getting saved in Trackor Browser pages only for Trackor Type selected under 'Trackor Browser' menu. Fixed.

Released 07/02/2018

The following is a list of changes since version 8.85:

New Features:

BPL-113618:  Rules BPL Export/Import - move ID Number.

BPL-116718:  Components Export/Import for Integration.

Conf-119070:  "Color Legend" for color ranged fields.

DB-119840:  Update trigger on CONFIG_FIELD.CONFIG_FIELD_NAME and XITOR_TYPE.XITOR_TYPE_NAME to enforce Oracle identifier naming limits We are applying new limitations for Config Field and Trackor Type names:

                              1 max length 30 characters

                              2 Oracle keywords cant be used as identifier name New rules will affect only new Config Fields and Trackor Types

GUI-120170:  Enforce new rules for Config Field names and Trackor Type names.

IHub-120345:  Integration db improvement.

IHub-120346:  Add an ability to interrupt Integration Process via Administer Processes page.

Rule-116167:  New grid for RULE_RUN table RULE_RUN table stores information about scheduled and form button rule runs.

Sec-61933:  Implement caching for program user privs.

VF-119080:  "General Info" view must be default for new users

Improvements:

Android-119346:  Tab label is missed when there only one tab on Config Groups WF step type Tab label may contain valuable information, for example status color icon.

Android-119350:  Make submit button not overlap last config field.

Android-119491:  Warning user about wipe pending data when login to another server.

DB-108606:  Drop DB objects related with the Grid Container. The following objects have been dropped:

  1) Views:

VW_BPL_CF_GRID_TAB

VW_BPL_GRID_TAB

VW_BPL_GRID_TAB_ELEM_XREF

2) Types:

LIST_CONFIG_GRID_TAB

T_CONFIG_GRID_TAB

3) Tables

CONFIG_GRID_TAB

CONFIG_GRID_TAB_ELEM_XREF

CONFIG_GRID_TAB_ELEM_XREF_OLD

CONFIG_GRID_TAB_FIELD_XREF_OLD

CONFIG_GRID_TAB_OLD

4) Sequences:

SEQ_CONFIG_GRID_TAB_ID

SEQ_CONF_GRID_TAB_ELEM_XREF_ID

DB-118147:  Create Pruning Job for Integration Run and Integration Log - IH 2.0 Integration log table stores logging records for integration.

Integration run table stores information about runned integration Retention period is controlled with "IntegrationRunHistoryPurgePeriod" and "IntegrationLogHistoryPurgePeriod" system parameter. Default is set to 2 months to keep log data.

DB-119843:  Refactor pkg_sec_priv_program.user_sec_exception_* function to improve user privs recalculation performance Instead of recalculating privs for the whole role when it is assigned/unassigned to a user, we now recalc only specific user's privs.

DB-120065:  Trunc dates sent to util.settaskdate pkg_dl_support truncs dates but pkg_wp does not. Since most updates from rules come from util, trunc there makes sense so we do not have to remember to trunc in all the rules.

Depl-120555:  Improve maven config to better handle repositories Added "distributionManagement" section to the parent/pom.xml to refer to the https://ci.onevizion.com/archiva/repository/ repositories. Added "ov-internal" repository into "repositories" section Credentials must be configured in Maven's settings.xml

Exp-118148:  Rollup and Number Fields in EXCEL export must be have Number data type instead of General.

GUI-120249:  Save view mode on View Options form.

GUI-120298:  Support more then 999 fields on Config Form Tab Maximum number of rows on Config Form Tab increased from 999 to 2000.

Grid-119140:  Cell layout update in edit mode.

IHub-116356:  Integration Hub app. Command field has been added in Integration table. UN field in Process table is no longer NOT NULL.

Imp-117781:  Improve entity search performance We improved the search for primary keys for the entity. To use it, you need to enable the 'Use experimental performance feature' option, and use only the sql to find the entity (not  pl/sql).

Imp-120006:  Expand data format related control on Admin Import form

Other-120466:  Don't reset user timezone on every login

Portal-118979:  Keep proportions when resizing window at portals page

Rule-114550:  Created/Updated TS/By for Rules New fields (Created By, Updated By, Created TS, Updated TS) added into the Rule admin grid and on Rule edit form.

Rule-119258:  Remove "Sync Data" rule class Rule class is no longer supported. "HTTP Call" rule + Onevizion API provide flexible functionality to archive same results.

Sec-114551:  Filter Sec Groups by Trackor Type

1) Filter by Trackor Type is available on "Security Groups Tabs".

2) "Description" column shows Trackor Type name of the sec group if applicable.

Bugs:

API-120070:  Check that View/Filter is assigned to user in /v3/trackor_types/{trackor_type}/*/{*_name}/set_as_current endpoints We added security checks, to ensure View and Filter assigned to the user for the following endpoints:

/v3/trackor_types/{trackor_type}/filters/{filter_name}/set_as_current

/v3/trackor_types/{trackor_type}/views/{view_name}/set_as_current

Admin-117873:  Image settings are not copied when cloning EFile Config Fields.

Admin-120750:  Unable to open the Admin Trackor Forms You can not open the edit form if a related report, import or user has been deleted

Android-119599:  Show empty screen if there are no tabs found on step.

Android-120238:  After open tab step first tab appears empty and second tab has contents of first tab.

Android-120838:  mobile-trackor app updating failed from Google Play with error -505 If user has already installed one of (mobile-trackor, mobile-trackor UAT or mobile-trackor DEV) all other apps can't be installed or updated.

BPL-120473:  Components Export/Import does not update Trackor Key and Trackor Class fields properly The Components Export/Import sets CONFIG_FIELD.IS_STATIC value to 0 for the fields. It is a source of error when creating a Trackor in the future.

Conf-119357:  Max length for Text CFs can't exceed 2000 characters.

Conf-120256:  Unable to use a link in Wiki configured field Fixed the problem with opening links in the grid created in the wiki field.

Dash-120165:  Error on deleting dashlet field group with fields.

Dash-120315:  Dashboard is not changing when dashlet is in edit mode.

EFile-120066:  Picture Library only allows one upload session Fixed problem with adding several files in the picture library.

Err-120370:  /js/grid/excell/Number.js:177 Fixed the problem of working with grid fields on the tabs provided that the form contains several tabs sects.

GUI-119850:  Textarea in Error Log form is editable.

GUI-120463:  Duplicate the search icon for the listBox Fixed the problem of duplicating the search icon.

Grid-119864:  Small height desync of frozen columns and the rest columns in grid.

Grid-120064:  Sub grid displays not all data. Fixed problem with displaying data in the grid when the EnableDistributedParsing mode is enabled.

Grid-120095:  Error with empty grid containing trackor selector columns.

Grid-120667:  Summary View grid is not loading correctly after filter change Summary View filter change is fixed.

Grid-120927:  Drop-down value with "<" or ">" symbols is not handled correctly on first edit.

Map-119596:  Color Legend Field loads with error on Mapping View Options.

Rep-116295:  Reports should show checkboxes values as Yes/No instead of 1/0. For new reports created with Report Wizard Yes/No values will be shown for Checkbox columns.

Tour-120492:  Cannot add image file to a Tour. 

VF-119131:  Filter icon is not updated when filter cleared When user clear filter on admin page, filter icon is not updated and shows filled icon.

VF-120462:  Incorrect Last Days value in View Options opened from the Usage Log if the FluxxCapacitorEnabled parameter is switched off.

VF-120665:  Unable to choose a field in the Tasks Overview Filter Option. CaseID 103467.

WF-119600:  Set Wf Description from Field grid loads with error on edit WF Template form. 

WF-119606:  WF Template field is empty on "Edit Workflow" form.

OneVizion 8.85

Release Date 06/18/2018

The following is a list of changes since version 8.84.1:

OneVizion 8.84.1

Release Date 06/06/2018

The following is a list of changes since version 8.84:

Bugs:

Err-119057:  com.onevizion.dao.viewopt.ViewOptDaoOra.findByReportWizardId:406

You can not modify a report with help of the Report Wizard if it has been created by the Report Wizard as well. Fixed.

OneVizion 8.84

Release Date 06/04/2018

The following is a list of changes since version 8.83.2:

OneVizion 8.83.2

Release Date 05/31/2018

The following is a list of changes since version 8.83.1:

Bugs:

Admin-118869:  General Info global view is not updated when you update General Info tab. When General Info tab is updated, all columns from related "G:General Info" view are wiped out leaving it with single "Trackor Key" column. Now fixed, corrupted views are recovered.

OneVizion 8.83.1

Release Date 05/30/2018

The following is a list of changes since version 8.83:

Bugs:

Err-118731:  com.onevizion.dao.log.viewopt.UlogViewOptSortColumnDaoOra.createAll:42. The grid is not loaded if multiple sorting uses primary Trackor ID field.

Exp-118822:  Error when exporting user grid with two row headers Two row headers produced for CSV exports. 

Exp-118830:  Wrong field names in CSV export.

Grid-118710:  Task Overview page is not loading on Filter change.

Grid-118711:  Disable distributed parsing for Task Overview page. Distributed parsing can cause issues with grid loading on Task Overview page therefore we had to disable it temporarily.

OneVizion 8.83

Release Date 05/28/2018

The following is a list of changes since version 8.82.1:

OneVizion 8.82.1

Release Date 04/23/2018

The following is a list of changes since version 8.82:

GUI-116517: Error in click handler on login page Fixed the error when log in button did not work at first click.

OneVizion 8.82 

Release Date 04/23/2018

The following is a list of changes since version 8.81.1:

Android-109567:  Implement new tabs design with coloring top bar background by dropdown values.

Audit-115069:  Automatically gather Oracle execution plans for slow grid SQLs Trigger tua_usage_log_sql_plan_store created for USAGE_LOG table. It is disabled by default. When enabled it will monitor DB runtime for grid actions and extract Oracle execution plans for SQL running longer then 1 minute. Plans will be stored in USAGE_LOG_SQL_PLAN tables, records older then 60 days will be wiped out by cleanup procedure. We also added USAGE_LOG_ID as comment to the every user grid SQL, to simplify plan search and extraction.

API-112643:  Don't allow to use static Trackor Types in TB API.

API-114685:  Store HTTP Status in Usage Log for API calls.

Admin-115809:  Components Package options of Trackor Type is not moved by the Components Export/Import.

Android-114691:  Authorization action not correct work.

BPL-116184:  Components Package options of Config Field is not moved by the Components Export/Import.

BPL-116186:  Components Package options of Rule is not moved by the Components Export/Import.

BPL-116187:  Components Package options of DB package is not moved by the Components Export/Import.

Conf-115155:  External Applet - Make URL Dynamic.

DB-112713:  Cancelling the page should kill the Oracle session Any web app query running longer then 30 minutes will be canceled. This may also affect From Button rule runs and other submit operations.

Exp-108423:  Enable grid exports on all admin pages Export enabled for the following grids:

ADMIN_CLIENT_FILES

ADMIN_REPORTS

ADMIN_CONFIG_TAB_EXT

COMPONENTS_AUDIT_LOG

ADMIN_CONFIG_DATA_GROUP

ADMIN_WF_TEMPLATE

ADMIN_RELATOR_ITEMS

ADMIN_USERS

ADMIN_SECURITY_ROLES

CONFIGIMPORT

ADMIN_RULE_TYPES

ADMIN_LANGUAGES

ADMIN_BPDOC_ITEMS

ADMIN_PORTAL

ADMIN_CONFIG_APP

ADMIN_CONFIG_APP_EXT

NOTIFICATIONS

ADMIN_SYS_MESSAGE

ADMIN_TRACKOR_TOUR

ADMIN_PARAM_SYSTEM

ADMIN_PARAM_PROGRAM

ADMIN_DISCIPLINES

ADMIN_SSO_PROVIDERS

ADMIN_PUBLIC_MAP

ADMIN_TABS_TO_CLASS

ADMIN_DB_MAT_VIEW

ERROR_LOG

ADMIN_DB_JOB

ADMIN_DROPGRID

ADMIN_PLSQL_BLOCK

ADMIN_WP_TASK_TYPE_GROUPS

Grid-112935:  Improve big data grids performance.

Grid-115562:  Implement USE_HASH hints for Trackor Browser grid SQL We figured that "OPT_ESTIMATE" hint may be ignored by Oracle in some cases. We implemented support for "USE_HASH" hint which forces Oracle to use has join for ANCESTOR, XITOR and CONFIG_VALUE_NUMBER tables. New hint may be enabled with new system param "SQLHintUseHash" (disabled by default). Parameter "UseSQLHints" used to control "OPT_ESTIMATE" hint renamed to "SQLHintOptEstimate". Both hints may be used simultaneously, performance should be monitored. 

Imp-110154:  Remove DATA_MAP_COUNT and GEN_DM_SQL_FINISHED_TS columns from IMP_RUN table Custom import packages should be verified and fixed after UAT deployment.

Map-113553:  Remove "Display implementation status" option from the Maps.

Menu-115605:  Menu Item name should match Page name.

Rule-115368:  Commit after each row when executing "Mass Lock/Unlock" and "Mass Assign" form button rules Take into account, if exception occurs during "Mass Assign" or "Mass Lock/Unlock" changes in already processed rows wont be rolled back.

Trackor-112728:  Ability to pass a field from the tab to the trackor selector field applet.

API-114408:  Check ADMIN_GROUP_RELATOR_ITEMS privs for /v3/trackor_types/{trackor_type}/children and /v3/trackor_types/{trackor_type}/parents.

Admin-115163:  Edit Package form doesn't remember size and position.

Admin-115475:  JS error when you work with the Security Group privileges at the Admin User form. Fixed: Error when opening the Security Group tab or working with checkboxes.

Admin-115828:  Do not log 'SimpleDataSource/Views.do' and 'SimpleDataSource/Filters.do' requests in usage log We log requests to 'SimpleDataSource.do' to get data of a grid but we should not log requests to get list of views or filters - it is 'SimpleDataSource/Views.do' and 'SimpleDataSource/Filters.do'. 

Android-116195:  Complete step not working.

Audit-112704:  Audit log for Number Fields doesn't show the full precision.

BPL-114942:  Applet assignment is not moved by Components Export/Import for Config Applet WF step type.

CompPack-116246:  Wrong checkboxes state of the Config Applets items at the Components Export page The checkboxes are always  unchecked in Config Applet subgrid if you select a components package with config applets.

Conf-115092:  Required relations are displayed on the config form as not required. Fixed: The relation field is displayed without asterisk in label and there is no check if the field is empty when you click by OK/Apply.

Conf-115144:  'Workplan [...] not found" error when the config form is refreshed The bug is occured after submitting when the config form refreshes field values. 

Dash-115105:  Error during updating field group.

Err-110718:  com.onevizion.dao.filteropt.FilterOptDaoOra.read:216.

Err-113959:  /new/js/newGuiScrollbar.js:657 Fixed scrollbars error caused on improperly detached Memo cell editor.

Err-114005:  /new/js/newGuiScrollbar.js:330 Fixed the js error that occurs in the Internet Explorer browser when scrolling with the mouse wheel on the tractor's edit pages.

Err-114106:  /js/grid/excell/Common.js:2120 Fixed bug js that occurs when a grid is loaded, namely when formatting a value for cells of the type "number".

Err-114209:  /js/grid/SimpleGrid.js:510. Fixed bug js with locking / unlocking the grid cell on the Trackor browser page.

Err-114469:  /new/js/contentConstructor.js:82.

Err-114797:  /new/js/newGuiScrollbar.js:28 Error on scrollbars attach procedure for already destroyed grid.

Err-115245:  /new/js/newGuiTableWidget.js:579 Fixed error on opening source data for certain rows on table view dashlets with groups.

Err-115247:  /new/js/dashboard.js:559. Fixed error on dashlet edit for certain dashlets.

Err-115291:  /new/js/newGuiScrollbar.js:924 Error on grid resize handler being called after grid is unloaded.

Err-115308:  /new/js/dashboard.js:57.

Error on resize when dashboard layout initialization is not completed yet.

Err-115318:  /js/js.js:1226.

Error on saving form position and size to localStorage when closing the form in Safari browser.

Exp-115264:  Grid export does not work at the DropGrid page.

GUI-115075:  Edit button shifts the record type in the Form Designer Fixed the problem of the field type offset in the list in the form designer.

GUI-115560:  Values of VTable that do not have colors are colored in the drop-down list Fixed bug where the VTable values for which no color was specified were colored in the drop-down list in the colors of the selected value.

GUI-115806:  Show "Loading" on grids, right after View/Filter closed After user submit View/Filter changes we retrieve list of Views/Filters from the server, and then show "Loading" panel and reload the grid. Now we show "Loading" immediately after closing View/Filter form.

GUI-116192:  Field type "drop-down" does not save colors when changing tabs Fixed a problem with the disappearance of the colors of the drop-down fields when changing tabs.

Grid-114304:  Grid Stat filter doesn't work for Checkbox fields.

Grid-115098:  Unnecessary grid reload request after Filter/View change.

Grid-115252:  Trackor Browser is empty if the grid contains drill-down EFile column.

Grid-115473:  Implement support for "New" icon in grid for Trackor Drop-Down fields  Trackor Drop-Down cells in TB grid now indicate recently created trackors with the "new" icon.

MT-114854:  Assignments of security role to WF step is not moved when you clone a program.

MT-115555:  Changing Trackor Type name in one program will change sec groups in other programs having same names of trackor type.

Rep-115213:  java.sql.rowset.SerialClob is stored as value for all memo fields in PDF reports.

Rule-115664:  Trigger 'Update User' rule when security privileges are changed 'Update User' rule is fired when you change privileges on security group or assign/unassig security roles or security objects.

Sec-114955:  XSS attacks protection: WriteJsonTagHandler.java Security Enhancements.

Sec-115224:  Upgrade Spring Framework dependencies to 5 version Spring Framework dependencies were upgraded from 4.2.4.RELEASE to 5.0.5.RELEASE Spring Security  dependencies were upgraded from 4.1.0.RELEASE to 5.0.4.RELEASE.

TMail-116198:  Poor trackor-mail performance when handling messages with attachments large then 10MB Large attachments retrieval performance increased. In our test 2 emails with 9MB attachment each were handled in 9 minutes.

VF-115466:  Incorrect error message when adding View with existing name Fixed.

VF-115480:  Hint Label option is not copied properly. Fixed: The value is not copied properly when you save 'Unsaved' view with name or promote a local view to global.

VF-115481:  Promoting local view to global fails if there are Trackor Types from level below from primary or drill-down primary level.

WF-115283:  All fields are disabled on 'New Trackor' WF step type The bug occurred because we have checked the 'A' privilege for each field on that step instead of 'E'.

WF-115669:  New Trackor tab is not loaded of WF You can not open the tab and see what fields are selected in that WF step. It is affected for running WF. 

WF-115672:  Wrong child Trackor is loaded at the New Trackor WF step When you load the New Trackor WF step after creating Trackor, the fields on the form contain data of other Trackor but not that what you have created.

OneVizion 8.81.2

The following is a list of changes since the 8.81.1 version: 

GUI-116517:  Error in click handler on login page Fixed the error when log in button did not work at first click

OneVizion 8.81.1

The following is a list of changes since the 8.81 version: 

Sec-114955:  Security Enhancements

OneVizion 8.81

The following is a list of changes since the 8.80 version: 

New Features:

DB-110189:  Create DB job which will prune data in the Audit Log. New: Case ID: 100583, 102778: To improve performance, DB Job added to prune Audit log based on system parameters(ConfigFieldHistoryPurgePeriod, LockHistoryPurgePeriod, RelationHistoryPurgePeriod, TaskHistoryPurgePeriod, TrackorHistoryPurgePeriod, WorkplanHistoryPurgePeriod). Parameter values for data can be 0-36 months. 0 - No purge.

Dash-109261:  Adding ability to create field groups in axes on a dashboard page in edit mode New.

Improvements:

API-112636:  Add ability to retrieve all system and program params via API v3. Improved: CaseID-102773

Admin-113579:  Display 'Grid' actions at the Usage Log page for the Selectors and Assignments pages. 

DB-113580:  Drop USAGE_LOG.VIEW_SEC3_CATEGORY and USAGE_LOG.FILTER_SEC3_CATEGORY DB columns. Improved: Unused columns are dropped.

DB-113870:  Improve performance of USAGE_LOG_SQL_PARAM table Improved for better performance.

GUI-110145:  Adding a placeholder to the events panel If there are no items in the event pane, a tooltip is displayed that notifies you when an import, export, or report is run.

GUI-110146:  Minor improvements to the events panel. Improved: Pop-up event notifications appear only for executed processes with the status "success", "executed with errors", and "executed with warnings".

GUI-112519:  Show edit button near selected value in top panel drop-downs. Improved: Pages affected: Administer Menu, Dashboards, Portal View, Documentation Organizer, Components Export.

Map-113587:  Support DrillDown child Trackor Types in the Mapper View Options. 

Rep-113307:  Add "Report Scheduler" drop-down to Report Admin form. Improved: CaseID-102814: Added an ability to set Process Scheduler for a report on Admin Form. Also you can see "Process Scheduler" column on Admin Reports and Admin Process pages with an ability to Filter by "Process Scheduler"

Rep-114302:  Add a "Clear All" or "Clear Event History". "Clear All" link added to the top of the Events panel, it allows to cleanup events panel in one click. All related data still available in Export History and on Admin Processes page. 

Rep-114405:  Default value of "Send To" field for E-Mail report delivery methods. 

Rule-110757:  Refresh page when Trackor Class is changed through a rule. Improved-CaseID-102660: The Config Form and WorkFlow form (if a step type is 'Config Applet') are reloaded if trackor class value of primary trackor is changed manually or in a rule. 

Rule-113650:  Commit after each scheduled rule Improved. Added commit after successful execution of each scheduled rule. 

Rule-113651:  Add exceptions handling around shceduled rules. Improved:CaseID-102750: An error in one of the scheduled rules will not stop execution of other rules.

VF-114303:  Filter/View tree levels must remember last state (open/closed). Improved: CaseID-102888.

Bugs:

Admin-114063:  Tab with fields are not loaded when you open a config applet in 'preview' mode Fixed.

Admin-114064:  Submit of Java rules is broken. Fixed: It affects on Copy EFile, Sync Data, ZipEFiles, HTTP Call, Tower Diagram, Tower Profile and Map Snippet rule classes.

Admin-114214:  Applet Admin form incorrectly shows External Tabs Fixed

Admin-114693:  The Admin Trackor Type form is not opened if 'Fields of Automatic Filtering' option references to non existent config fields.

Admin-114742:  Config Form is loaded with error in preview mode if there are DB Drop-Down or Drop-Down fields Fixed.

Android-114073:  Child Trackors Tabs doesn't duplicate in mobile app for ConfigTab step Fixed

Audit-113718:  Cannot Filter to Timestamp on Error Log page. Fixed: CaseID-102843

BPL-110372:  'Is Published' option of config applet is not moved by the Components Export/Import Fixed

BPL-114067:  Components Import of security role fails when there are global and local filters with the same name Fixed

BPL-114243:  Components Import of Tower Diagram rule fails if dynamic table value of tower group is not found Fixed

BPL-114275:  Autokey formula is not created when cloning the program Fixed. The issue is related to order of importing components - at first we import trackor types and then config fields which are used in autokey formula. The autokey formula should be created at the end of components import when all config fields are imported

BPL-114380:  Components Export of View Options fails Fixed

BPL-114415:  View Options are not copied if you clone a program Fixed. There is no any View Option from source program in the copied new program.

Conf-114072:  F/V drop-downs don't show up above the grid when the very first Tab on the form is trackor container Fixed-CaseID-102861.

Conf-114324:  Coloration of Drop-down values on a form issue. Fixed-CaseID-102890: Drop-down values with no color overrides field color. Fixed to allow drop down value color to override field color only when drop down value has color set.

Conf-114331:  The task date is not saved when using slash or partial date on forms Fixed:CaseID-102881, 102907.

Conf-114524:  Fields validation not working on form submit with a hotkey Fixed

DB-114173:  UTIL.GetValNum doesn't return value for XITOR_KEY and XITOR_CLASS_ID fields. Fixed: UTIL.GetValNum now correctly returns values for the XITOR_KEY and XITOR_CLASS_ID fields.

Dash-115105:  Error during updating field group.

DropGrid-113666:  The DropGrid can not create a Trackor Type if you are not super user Fixed.

DropGrid-114244:  Bug in DropGrid Mapping. Fixed:CaseID-102874: When map is opened for the first time, it fails, because some mapping properties are not properly initialized.

EFile-113472:  Bulk Uploader doesn't support cascading drop-downs Fixed:CaseID-102824.

Err-110520:  /js/Default.js:199 Fixed:CaseID-102936.Uncaught reference error:processesEvents is not defined.

Err-110962:  /js/grid/SimpleGrid.js:1909 Fixed js error that occurs when you try to open "E-File Download History" from the context menu for sub columns "Size" or "Thumbnail".

Err-113981:  /js/ps.js:1107 Fixed js bug that occurs when previewing the filter if in the filter selects a dateTime type field and is set to "is Null" or "is not Null".

Err-113983:  /js/ps.js:4417 Fixed: Added interception of errors that occur when closing user forms.

Exp-113896:  "ORA-01745: invalid host/bind variable name" when export data to Excel and grid contains Task Dates. Fixed: CaseID-102851: Bug introduced with Exp-97263 "Add in grid cell colors for Task dates and Number fields to Excel export". As with Exp-103233 "ORA-01745: invalid host/bind variable name" when running TB Grid Export and TB Grid Report" we will apply cell decorations for grids with less then 5000 Trackors only

Exp-114042:  Excel cells coloring is missed for TName, TOrd, TWbs Task dates if there are no other Task dates in grid Fixed

GUI-114520:  Constraint violation when adding a task date to the Form Designer Fixed

Grid-112823:  Trackor Browser child grid sorting issue Fixed:CaseID-102783:Grid sorting is unavailable if view options uses multi-sorting by unavailable(due to privilege restriction) field(s)

Grid-113577:  Loading page action is not logged properly in the Usage Log if generation of SQL fails Fixed.

Grid-113592:  "Share Page Link" doesn't work for Task Overview grid. Fixed:CaseID-102832

Grid-113675:  Config Applet buttons are always disabled at some user pages Fixed:The button is disabled at the Tasks, Mapper, Summary and Tasks Overview pages if the Trackor Type does not have trackor classes.

MT-114245:  Cloning of program fails if there a HTTP Call rule. Fixed: The cloning fails because the rule is being created in wrong program. 

MT-114251:  Cloning of program fails if there is a WorkPlan template. Fixed: The cloning fails because assignments of static date pairs (baseline, actual, projected, etc.) are created in wrong program.

MT-114270:  Cloning of program fails if there is a workplan with task links or a task with assigned config applet. Fixed: The cloning fails because WorkPlan links or assignment of config applet to a task are created in wrong program.

MT-114416:  Can not delete program if it has hint label in view options of the Mapping page Fixed

MT-114419:  Creating program is not rollbacked if an error occurs after importing of workplans The rollback does not work properly because when we import workplans, we call pkg_wp_template.calc_all_based_on_template routine. That routine contains 'commit;' operation inside and it breaks a transaction.

Notif-113904:  Explicit cursors in the package pkg_notif are not closed. Fixed:CaseID-102855:Error: "ORA-01000: maximum open cursors exceeded" when running notification processing job.

Other-114410:  Need to escape \u2028 and \u2029 characters for JavaScript context Fixed.CaseID-102879. Unable to load trackor record if these characters were present in a field.

Rep-114088:  "Send To" selector doesn't show up on Report Exec form for some users. Fixed:CaseID-102866

Rep-114171:  Error after removing report exec window. Fixed:CaseID-102795

Rep-114246:  Cloning of program fails if there is an Excel report with worksheets. Fixed: The cloning fails because report worksheets are being created in wrong program.

Trackor-114729:  Task date from parental trackor is not displayed. Case-102900

VF-108378:  Administer Filter and View pages errors on submit. Fixed

OneVizion 8.80

The following is a list of changes since the 8.79.4 version: 

New Features:

===========

Rep-109011:  Add Process ID column in Usage Log for Excel Submit action New.

Improvements:

===========

Admin-112307:  Remove "WorkPlan to Trackors" mass assign page Improved:CaseID-102669.

Admin-112328:  "ckeditor" not working with slow internet connection. 

Android-112061:  Update ACRA to latest version 3rd party library to build and deliver bug reports.

DB-113158:  util.RaiseError should handle Nulls. Improved:CaseID-102804:  Now, util. will raise Error correctly returns "NULL" message.

DB-113159:  GetVal for unchecked checkboxes should return 0 instead of NULL. Improved: Added two new functions to UTIL for checkboxes to return 0 for unchecked and 1 for checked: GetValCheckbox() GetValCheckboxByID()

DB-97103:  Remove "EnterprisePkPrefix" system parameter This is cleanup of recovery data after DB-94947 "Get rid of Enterprise PK prefix" released with 8.70.0

GUI-111880:  Do not show [All] option of Form Designer, when it contains more then 1000 items. Improved: CaseID-102743:Form Designer will open on list of Trackor Types when there are more then 1000 Config Fields. 

VF-108501:  Add calendar filter options to date/time fields. Improved: CaseID-102233.

WF-110153:  Remove "WP Key Value Field" and "Sub-Key Value Field" from WF Improved.

WP-108539:  Make tasks appear NA'd in the tab just like they would appear NA'd in the grid

Improved: CaseID-102243: Now we display 'N/A' value in task date field on the config form if a task is not applicable.

Bugs:

===========

API-113460:  "You have no [A] priv on []" error when creating new trackor via v3/trackor_types/{trackor_type}/trackors endpoint

Admin-112627:  Grouping on the Report History grid does not work properly if you change set of columns or an order of columns.

Audit-108582:  "Fluxx Capacitor" in Usage Log grid is always "Off". Fixed.

BPL-110266:  BPL Export doesn't generate xml file in FireFox

Conf-113306:  Incorrect behavior of the wiki type field when changing the field settings. Fixed: Changing settings on wiki field doesn't behave as expected (eg, read only, mandatory settings).

DB-112734:  util.hasRole doesn't use passed UserID param. Fixed: CaseID-102782: util.hasRole now works correctly when userId parameter is passed.

DB-113469:  pkg_sec_priv_program.set_priv_by_name needs to filter by PID

Grid-113171:  Can't access SQL data in Usage Log grid Fixed

Imp-113154:  IMPORT cannot see History. Fixed: CaseID-102811.

MT-113527:  You can not clone a program if there is ZIP EFile rule

MT-113528:  The Admin Program page is not loaded.

Map-112518:  Fix mapping for drill down entries We broke support for drill down entries on maps in Map-88644 (8.79.0). It is fixed now.

Other-112340:  Increased space between words on config forms. Fixed.

Rep-113157:  Can't delete report from history grid. Fixed: CaseID-102806.

Rep-113174:  Wrong sorting at the Reports page. Fixed: Reports should be sorted by group and name.

Sec-112481:  "HTTP Status 403 - AbstractAccessDecisionManager.accessDenied" error when using "Login As" . Error caused by obsolete privileges assigned to the user. i.e. READ instead of expected R.

VF-112324:  Error when you select 'All' applet in the View Options of the Mapper page. Fixed.

VF-112811:  Disable "Display this type of Trackor" option in the Mapper View Options for tabs with only polyline and polygon shape types Fixed.

WF-112832:  Error when trying to select existing step for WF Decision Option. Fixed: Error: You have no [R] priv on [ADMIN_WF_STEPS] Security group. 

WF-112985:  Error on "Config Tab" WF Step. Fixed: Error happens when mixing tabs from Trackor Type with and without Classes on single "Config Tab" WF step.

OneVizion 8.79.5

The following is a list of changes since the 8.79.4 version: 

OneVizion 8.79.4

The following is a list of changes since the 8.79.3 version: 

Imp-113154:  IMPORT cannot see History. Fixed

Rep-113157:  Can't delete report from history grid. Fixed

OneVizion 8.79.2

The following is a list of changes since the 8.79.1 version:

Admin-112627:  Grouping on the Report History grid does not work properly if you change set of columns or an order of columns. Fixed

Err-112345:  com.onevizion.grid.userdatarenderer.userpage.MapperUserData.getMapperFeatures:328 Fixed: Case ID-102777-Error on Mapping page after 8.79.0 upgrade

GUI-112648:  Layout collapse on several administer forms in Chrome Fixed: Case ID-102775. Fixed

VF-112811:  Disable "Display this type of Trackor" option in the Mapper View Options for tabs with only poly-line and polygon shape types Fixed.

OneVizion 8.79.1

The following is a list of changes since the 8.79.0 version:

Bugs:

GUI-112341:  Config Form layout is broken in Google Chrome 65 Fixed. HTML tables are stretched to the full width even there are no explicit style.

Other-112340:  Increased space between words on config forms.

VF-112324:  Error when you select 'All' applet in the View Options of the Mapper page Fixed

OneVizion 8.79

The following is a list of changes since the 8.78.3 version:

New Features:

Dash-102482:  New Portal Frame - Dashlet New - Existing dashlets from Dashboards can now be added to Portal frames.

VF-108602:  New View Options design for admin pages New - View Options look and feel similar to Form Designer.

Improvements:

API-109272:  Don't save base64 encoded files in UsageLog when updating Efile fields. Improved.

Audit-110880:  Add usage_log.cols_count column to keep number of columns selected in View Options. Improved.

Dash-111897:  New chart type "Stacked Column". New Feature.

Dash-111898:  New calculation method "Count All".  New feature to allow for plotting  'Count All' values in Dashboard.

Grid-109376:  Use "DefaultGridMaxRows" program parameter for grids without View Options. Improved: CaseID-102456.

Grid-110255:  Use hints to improve exec plans for TB SQL Improved. CaseID-102610: Feature disabled by default. Can be enabled with "UseSQLHints" system parameter. Affects only Trackor Browser SQLs.

Map-88644:  Draw Line, Polyline and Polygon shapes using coordinates from Child Trackors. Improved: Mapping page supports 4 types of drawings: Map Icon, Circle, Polyline and Polygon. Last 2 require multiple coordinate pairs to draw the shape. Previously we used multiple line CFs for this purpose, now multiple line CFs are deprecated and added support of child Trackors as source for multiple coordinates. Now it's primary Trackor Type of Mapping page has children Trackor Type with Lat/Long fields it will appear in View Option twice: 1st time as usual to draw Map Icons or Circles for each Trackor, 2nd entry will have name in format <Parent Trackor Type>-<Child Trackor Type> and will be support Polygon and Polyline ,using all children Trackors of each parent to draw. 

Sec-108639:  Provide an ability to see all checked READ/None privileges. Improved:CaseID-102334: Added an ability to filter on Privilege. New filter option implemented for Security Groups Tab on "User" and "Sec Role" forms. 

Bugs:

Admin-111015:  Do not display  Reports, WF Step and Program Trackor Types at the Publish Applets form. Fixed: For these Trackor Types we do not support configured applets. 

Admin-111022:  Error when opening User Settings->Notification form Fixed. The error occurs when the list of Trackor Types are obtained. 

Admin-111606:  Admin Notif Queue page does not load if Attempt Date column is selected Fixed. 

BPL-110523:  Parental fields are missed when you clone new program. Fixed: When cloning a program, parental fields in tabs are not being copied over. 

BPL-111153:  Config Applets are not displayed as components related to a components package Fixed.

BPL-111156:  'Fields for Automatic Filtering' option of Trackor Types is not moved properly by the Components Export/Import. Fixed: If source Trackor Type includes two or more fields in the 'Fields for Automatic Filtering' option, then the option is not moved properly by the Components Export/Import and there is an error when the admin form is opened. 

Conf-109264:  Use continuous numbering for Drill-Down field indexes Fixed:CaseID-102444.

Conf-111017:  Tab with Wiki field is not loaded if you have only R privilege on it Fixed.

Conf-111028:  Fields are editable even if there are no privileges on a tab. Fixed: If the same fields are presented on two tabs and you have full access to the first tab and only R privilege on the second tab, then the fields on the second tab are editable but should not be.

EFile-110592:  Can't upload file to S3 when there is Cyrillic symbols in file name Fixed

Err-109056:  /new/js/newGuiTree.js:70. Fixed a javascript bug that occurs when resizing a browser window on a dashboard page. 

Err-109785:  /js/grid/SimpleGrid.js:1523 Fixed the error js that occurs when a cell is selected. The error could be reproduced when working with an incorrect cell object. 

Err-110005:  /js/admin/configdatagroup/GroupFieldsDesigner.js:1258. Fixed bug js which occurs when the transfer of some config fields is started.

Err-110616:  /js/form/cfHandlers.js:819. Fixed bug when loading a file in the efile type field in the IE browser.

Err-110662:  /js/grid/excell/Memo.js:95. Fixed bug that occurs when trying to change the memo field in the grid. An error occurs if the request to load the complete memo field data exceeds a certain time.

GUI-110370:  Quick Search input is readonly if user doesn't have edit privileges on some forms Fixed

GUI-111047:  Download to ZIP shouldn't be available if no files on Tab Fixed:CaseID-102697.

GUI-111883:  Fields counter on Form Designer is not updated when list is filtered. Fixed

Grid-110476:  Component Export: Sorting does not work in Config Applet columns. Fixed

Grid-111263:  Task cell in TB grid NOT refresh after Task popup is closed. Fixed: CaseID-102707.When users go to "UN-N/A" from tasks form, it does not UN-N/A after unchecking the N/A box and clicking on "ok".

MT-110380:  Workplans are not cloned when you create new program Fixed.

Menu-110887:  Folder List doesn't show left paddings and icons Fixed. Folder list will show hierarchical structure in Firefox and Chrome. Firefox will be without icons.

Other-110758:  Incorrect transfer of parameters for page URL. Fixed. Errors on certain conditions when trying to search in Filters/Views

Rep-111264:  Report Wizard is broken when Report Parameters are set. Fixed

Rep-111944:  Can't delete report. Fixed: CaseID-102749: Can't delete report having archived (deleted) instances of "Pending/Running/InQueue" state

Sec-111056:  Fields privileges are not calculated properly for the grids and the Grid Row Editor Fixed:If you have NONE privilege on all tabs where a field is present, then user cannot read and edit that field anywhere irrespective of privileges on Trackor Type.

Sec-111607:  Do not check 'A' privilege when you set value to config field at first time. Fixed

WF-110149:  Fix security on "Start WorkFlow" form . Fixed: User must have R privileges on WokFlow security group + A on WorkFlow Template to start new WorkFlow. Or, A on ADMIN_WF sec group to be able to start for any WorkFlow Template.

WF-110150:  JS error if user doesn't have privilegess on WF Template of selected WF on WORFLOW page. Fixed

WF-110152:  Fix security on "Edit Workflow" form. Fixed:Users without E on ADMIN_WF, can't modify running WF

Conf-115155:  External Applet - Make URL Dynamic

Grid-115562:  Implement USE_HASH hints for Trackor Browser grid SQL We figured that "OPT_ESTIMATE" hint may be ignored by Oracle in some cases. We implemented support for "USE_HASH" hint which forces Oracle to use has join for ANCESTOR, XITOR and CONFIG_VALUE_NUMBER tables.New hint may be enabled with new system param "SQLHintUseHash" (disabled by default). Parameter "UseSQLHints" used to control "OPT_ESTIMATE" hint renamed to "SQLHintOptEstimate". Both hints may be used simultaneously, performance should be monitored

Rule-115368:  Commit after each row when executing "Mass Lock/Unlock" and "Mass Assign" form button rules Take into account, if exception occurs during "Mass Assign" or "Mass Lock/Unlock" changes in already processed rows wont be rolled back.

Conf-114324:  Coloration of Drop-down values on a form issue. Fixed-CaseID-102890: Drop-down values with no color overrides field color. Fixed to allow drop down value color to override field color only when drop down value has color set.

Err-110718:  com.onevizion.dao.filteropt.FilterOptDaoOra.read:216

Err-113959:  /new/js/newGuiScrollbar.js:657. Fixed scrollbars error caused on improperly detached Memo cell editor.

GUI-114520:  Constraint violation when adding a task date to the Form Designer. Fixed.

Rep-115213:  java.sql.rowset.SerialClob is stored as value for all memo fields in PDF reports.

Trackor-114729:  Task date from parental trackor is not displayed. Case-102900

VF-115466:  Incorrect error message when adding View with existing name. Fixed.

OneVizion 8.78.3

The following is a list of changes since the 8.78.2 version:

Improvements:

Grid-110255:  Use hints to improve exec plans for TB SQL Improved. CaseID-102610: Feature disabled by default. Can be enabled with "UseSQLHints" system parameter. Affects only Trackor Browser SQLs.

OneVizion 8.78.2

The following is a list of changes since the 8.78.1 version:

Grid-111263:  Task cell in TB grid NOT refresh after Task popup is closed

Fixed: CaseID-102707.When users go to "UN-N/A" from tasks form, it does not UN-N/A after unchecking the N/A box and clicking on "ok".

OneVizion 8.78.1

The following is a list of changes since the 8.78 version:

Rep-110753:  Report Details Form was broken. Fixed

OneVizion 8.78

The following is a list of changes since the 8.77.1 version:

New Features:

===========

Android-108493:  Offline mode switch. Now user can explicitly enable offline mode when network connection is unstable

Sec-103209:  Clone Onevizion accounts

Improvements:

===========

Admin-110013:  Improve performance of Trackor Types Page Grid SQL is modified

Android-109088:  Show not filled lat/long fields as empty

Android-109564:  Remove ability to save multiple user credentials

Android-110023:  Don't reload step when user change Offline Mode

DB-109016:  Some Oracle sequences has low cache size, causing waits on table inserts

DB-109019:  Change LOB columns from basic file to secure file and disable in row storage for USAGE_LOG table. This changes should improve log writing performance.

Dash-109271:  Ability to save default filter for dashboard Current filter will be stored as a default when saving dashboard layout

EFile-109709:  "Efile Download History" should also show history of previously uploaded Efile "Efile Download History" now show history for the current Efile and for all previous copies. The grid is grouped by File Name.

Grid-109614:  Remove "Admin Components Package" page

Grid-109694:  All user grid SQL IN parameters are strings Expected small performance improvements of user grids when filtered by numeric fields (including Trackor Key, Drop-Down, Selectors, etc)

Grid-110020:  Replace all literals with bind variables in user grid SQLs We used literals in outer SQL for function calls, now replaced to bind variables to improve SQL performance

Menu-108656:  Add "Tasks" menu for task dates on config tabs

Notif-109566:  Create new index on notif_queue.queue_status_id This should improve notifications processing by mail-service

Rule-109108:  "Rule Type" form should be read-only

Sec-110148:  Delete obsolete ADMIN_WF_STEPS sec group Security group is no longer used after dedicated admin page for WF Steps was removed few years ago in WF-19834

Bugs:

===========

API-109012:  [applet_id] and [trackor_type] are not dependent in v3/trackor_types/{trackor_type}/applets/{applet_id}/tabs endpoint For v3/trackor_types/{trackor_type}/applets/{applet_id}/tabs endpoint user can specify [applet_id] which is not from specified Trackor type with parameter [trackor_type]

API-109698:  maven-plugin-swagger generates invalid json if endpoint return value is Long

Admin-109276:  You can not modify View Options at the Administer View page

Admin-109279:  You can not modify Filter Options at the Administer Filter page

Admin-109288:  The Administer Trackor Class page must work only with non static Trackor Type

Admin-110147:  Do not display some static Trakor Types at the Import Entity form Comment, Report, Program, WF Step and Workflow values should not be displayed in the 'Trackor Type' option

Android-109015:  Incorrect number field rounding in mobile app

Android-109097:  Step is blocked after field submit error

Android-110371:  Use same fonts for all devices

BPL-109180:  Required Field import options are not moved when you create new program

BPL-109181:  Mapping parameters of import are not moved when you create new program

BPL-109275:  Rule description is not moved when you create new program

BPL-109283:  Components Import does not work for View Options at all

BPL-109868:  User can show components packages at Components Export page when no privilege available

BPL-110022:  Some Workflow Template options are not moved by Components Exp/Imp Key Value Field, Sub-Key Value Field, WF Description Config Field and Use Wizard options are not moved by the Components Export/Import

BPL-110024:  Error when creating program with single Trackor Type

BPL-110033:  Trackor Classes are not created when cloning the program

BPL-110061:  External Applet options are not moved when creating new program 'Show In Modal Window', 'Components Package' and page assignments are not cloned when you create new program

BPL-110248:  Blank Line markup element is not moved by the Components Export/Import

BPL-110296:  Values of dynamic tables are not moved with a config field by the Components Export/Import

DB-110256:  Cache of privileges for WF config fields is not cleared when privileges on WF template are changed Privileges on config fields are cached in DB to improve performance. When you change privileges on WF template,  must clear cache in order to calculate privileges on config fields by new.

Dash-110359:  Data is grouped incorrectly when a user filters it by the group key

DropGrid-109193:  Some changes are not logged in Components Log After using DropGrid, some changes to the configuration may not be logged in Components Log. This may happen for any user, not only for one who run DropGrid

DropGrid-109399:  Field name prefix is not updated when you move forward to 3rd step and back to 2nd

DropGrid-109841:  Checkbox's tick is mis-positioned on the 3rd step

GUI-109189:  Config Field buttons doesn't have border on colored fields

GUI-109379:  Incorrect behavior of the lock / unlock function for some fields on the config form

GUI-109400:  Error on text label double-click in the Form Designer

GUI-109716:  Cropped text in tree elements

GUI-109717:  Button overlaps items in the calendar on config form

GUI-109718:  Incorrect font in the memo type field in read-only mode

GUI-109947:  Trackor Selector is not populated when new trackor is added or existing one is modified

Grid-109555:  Repeating alias of restricted user sub query in TB SQL may lead to expensive cartesian join We modified TB SQL builder to use different table and view aliases

Grid-109869:  Large differences between DB Time and Web Server Time in TB when filter by grouped WP Task field When filter Trackor Browser grid by one of TName*, TOrd, TWbs fields and there are thousands WPs assigned to the Trackors of Primary Trackor type, TB SQL generation become slow

Grid-110374:  Task grid not refreshing after save changes on TaskForm

Imp-109396:  Import scheduling process is not transnational If error occurs during import scheduling, import run record maybe created but not all related data is filled. As a result this record may confuse users

Label-69100:  Support AppLabelMessageSource for simultaneous operation We improved our web server labels caching mechanism

MT-109574:  Cannot Delete Program - The error was thrown when deleting Program with:

1. WF Templates with Key Value Field set 2. Trackor Forms with Authless TF User set

MT-110289:  Assignments of config fields to a tab are not cloned when you create new program

MT-110373:  DB mutation error on program deletion

Rep-109553:  "Invalid Email Found" error when email wasn't used at all

Rep-110528:  Recurring TB Grid report doesn't get "Show NA Task" settings

Sec-109274:  Config Fields on Tab and in Grid must take into account Trackor Type privs When we calculate config field privilege with help of 'get_max_field_privs()' we do not take into account privilege on Trackor Type. Now we check Trackor Type priv first, then we check permission for Applet and Tab.

OneVizion 8.77.1

The following is a list of changes since the 8.77 version:

GUI-109400:  Error when double-clicking on an text label in the Form Designer

OneVizion 8.77

The following is a list of changes since the 8.76 version:

Android-108497:  Show progress information in "Complete Step" control .

New: Show (number of fields filled/total required fields) as part of 'Complete Step'

Android-108635:  Support any Config Field as value for Trackor Selectors in mobile app New.

BPL-108427:  Export of Component Package

New: Component Packages can be exported from 'Components Export' page. Declaring new Packages can be done from this page as well. Defining what belongs to a Component Package needs to be done in respective entities (Rules, Filed, Tabs, etc.) . 'Administer Component Packages' page is being deprecated.

Conf-102489:  Support any Config Field as value for Trackor Selectors

New: Allows for any config field associated with a Trackor Selector to be displayed (instead of forcing the trackor id to be displayed). Available only for non static trackor types.

EFile-108623:  Add blob_data.hash column to keep hash value of stored files

New: CaseID 102325: Efiles have a HASH column in BLOB_DATA table to store hash values of files. This will allow files to be compared in Rules.

Feature is disabled for now, because performance impact is unknown

Rep-108544:  Submission history for Excel with VBA Reports

New: Usage Log will have an entry ExcelSubmit to log all excel data submits.

Improvements:

===========

API-108532:  Make [view] and [fields] parameters for GET /v3/trackor_types/{trackor_type} optional

Improved: Now GET /v3/trackor_types/{trackor_type} endpoint will return all trackor type fields if [view] and [fields] when parameters are not passed

API-108533:  Add list of fields for v3/trackor_types/{trackor_type}/applets/{applet_id}/tabs

Improved.

Admin-108643:  User-friendly message when deleting a field assigned to any WF step Improved.  'Unexpected Error' ' will now be 'Error. You can not delete field assigned to WF Step.'

Admin-108645:  Display Trackor Class and Pages tabs at the Admin Applet form for master applets

Improved: All Trackor Class and Pages assignments are selected and disabled for master applets

Admin-108646:  Display Trackor Class tab at the Admin Tab form for master tab

Improved: All Trackor Class assignments are selected and  disabled for master tabs

Android-108492:  New "Complete Step" button

New: 'Complete Step' button is available

Android-108614:  Don't load selectors values in mobile app for offline mode Improved.

Android-108626:  Android keyboard overlaping ok/cancel buttons when editing memo fields values Improved.

Android-108628:  Show warning before moving to previous step

Improved: Warn user before moving to previous step in Android WorkFlow step.

Android-108658:  Bring back control to Workflow list after App close Improved.

Android-108673:  Set active template as default in start WorkFlow window Improved.

Conf-108615:  Two digit year format validation

Improved: Validation for 2 digit year format (selected in user settings) for date fields edit.

Dash-108394:  Add new operators for dashboards date filters

New: Dashboard supports date filters available in in Filter options

Dash-108583:  Store user's dashboard layout changes

Improved: All user's changes of dashboard layout will be persisted in user's browser. User will be able to restore default layout using Reset button. 'Save' button can be used for storing layout changes in the Server.

Dash-108625:  Complex pie chart support

Improved: Added the ability to create a pie chart with two levels

Dash-108659:  Add Cancel button on dashboard data loader

Improved: Allows for loading dashboard to be cancelled, allowing user to access and debug dashboard SQL query, if necessary.

GUI-108516:  Optimizing the Form Designer

Improved: Working in Form Designer is much slower as number of fields in the form increases.

Grid-108437:  Change Privileges for Trackor Browser page

Improved: TRACKOR_BROWSER security group will only have Read (R) and None Privileges. Read/Edit (RE), Read/Add(RA), Read/Edit/Add(REA) and Read/Edit/Add/Delete(READ) are being removed as these are not applicable.

Grid-108439:  Change privileges for Task Overview page

Improved: TASKS_OVERVIEW security group will only have Read (R) and None Privileges. Read/Edit (RE) is being removed. The Tasks Overview grid will be editable if the user has E for the TASKS security group

Imp-102479:  Import - Validate program parameters (CalendarMinYear, CalendarMaxYear, DataFormat, TimeFormat)

Improved: Additional validation for Import based on Program parameters - CalendarMinYear, CalendarMaxYear, DataFormat, TimeFormat. Error message will include Import Mapping Name.

Label-108591:  Replace system labels in config items with program labels

Improved: System Labels in config items(like config apps/tabs/fields/menu etc) were replaced with config labels. Constraint checks were added to prevent use of system labels in config items.

Notif-108415:  Improve performance of notifications handling Improved.

Notif-109086:  Split NotificationSender param

Improved: CaseID 102453: New system parameter "NotificationSenderUser" for cases when NotificationSender email is different from user name.

Existing implementations will have NotificationSenderUser set to "NotificationSender" parameter value.

Notif-109087:  Move "SmtpHost",  "SmtpPort" system params into the "Notification" group

Improved: Moved from "General" group to Notification group. Now params are in a more intuitive place.

Rep-108517:  Report 'Execution Time Window' - implement error proof behaviour

Improved: Additional data validation for 'Execution Time Window'

Rep-108560:  Add hint to the Schedule Report form to inform users on format for email list

Improved: Send To, 'Email' option can take comma/semicolon separated list

Rep-108601:  Upgrade BFO PDF library to version 2.21

Improved: BFO PDF library used to generate PDF reports upgraded from 2.16.2.

http://bfo.com/viewtext/products/pdf/docs/CHANGELOG.txt?title=Big%20Faceless%20PDF%20Library%20Changelog

Rep-109008:  Support both comma and semicolon for email list at Schedule Report form Improved.

Sec-108629:  Update logback-core and  logback-classic dependencies to 1.2.3

Improved: Updated logback-core, logback-classic, logback-access libraries from version 1.0.13 to 1.2.3. Older versions are vulnerable to CVE-2014-3577

Bugs:

===========

API-108575:  Fix check privs for v3/applets/{applet_id}/tabs/{tab_id} endpoint if tab is from static trackor type Fixed.

Android-108578:  Crash when user attempt to input invalid URL at Login

Fixed: URL input in login page is not being validated causing Login to crash

Android-108630:  User should return back to WorkFlow list after completing a WorkFlow step Fixed

Android-108631:  App crashes when trying to edit relation field Fixed

Android-108674:  Android ver. 6 asks permissions on every App launch Fixed. If permission is already granted, dialog will not be shown to user.

Android-108675:  Relation field becomes read only after submitting Fixed

BPL-108638:  Relation options are not moved by the Components Exp/Imp Fixed. Options such as Cardinality, Unique By, Color Code , Child Requires Parent, On Parent Delete Cascade, Lockable, Show All Records in Trackor Container

BPL-109125:  Creating new Program fails if you select Workplans Fixed.

Conf-108613:  Control keys works incorrectly for Lat/Long fields in grid

Fixed: Incorrect behavior of Ctrl, Shift, Del and other control keys in grid edit mode for Lat/Long fields

Conf-108684:  Excess blank spots on Config Form

Fixed: Case ID: 102339: Additional blank spaces in Config Form after 2 column span fields (even though they are not present in the Form Designer)

DB-108589:  In Adminster pages, user can not promote a local Filter/View to global if name already in use on other page

Fixed: In Administer pages, user gets an Error that name already exists when user tries to promote a local filter/view to global and the name already exists in any one of the Global View/Filter in any of the Administer pages.

DB-108617:  Wrong implicit change of relations between Trackors

Fixed: When we change relation between Trackors then we change implicitly relations of the same parental Trackor in other branches in Trackor Tree in some cases but only if there are certain relationships between Trackor Types.

Dash-108332:  Sql with CLOB isn't loading on Dashboards page

Fixed: Memo fields and other fields with CLOB datatype will be skipped in dashboard datasource results.

Dash-108561:  Zero values are not calculated with several calc methods

Fixed: Calculation methods (such as Count, Count Distiict) in Dashboards, do not take empty string, null or 0 values. Fixed to handle 0 as acceptable value in every calc method. Null is only countable as a value in case of Distinct method, Count method will skip it. Empty string will be treated as null.

DropGrid-108590:  Generated field names do not match column names in excel spreadsheet

Fixed: Identical column names within sheets of a spreadsheet do not get translated to identical field names in DropGrid. Subsequent sheets' column names get translated to field_name_2, etc.

DropGrid-108607:  Unable to delete configuration objects created by the DropGrid (after manually deleting a config field)

Fixed: Unexpected error when trying to drop all related objects of a DropGrid, after manually adding and deleting a config field to the Trackor created from DropGrid.

DropGrid-108610:  Error isn't shown when a user enters an existing FieldName on the 2nd step

Fixed: Error isn't shown when a user enters an existing FieldName on the 2nd step.

EFile-108663:  EFiles are not uploaded to AWS S3

Fixed: Sec-88671 update to Apache HttpClient to introduced error that caused efiles to not get uploaded to AWS S3

Err-108863:  Administer Processes grid fails to load data

Fixed: CaseID 102426: Processes grid fails to load data when one of reports with "Email To" field string length > 500 chars. Fixed to truncate the string to 1000 characters in the grid.

Err-108865:  Clicking on the hyperlink for Trackor Container in Admin Applet form throws an error

Fixed: Hyperlink is no longer displayed for Trackor Containers.

Exp-108537:  Grid exports for admin pages export data from all programs

Fixed: Added new command line for running additional report-scheduler (added _user schema as 2nd parameter).

GUI-108522:  Firefox and Edge browsers dont prevent form submission when data validity checks fail Fixed

GUI-108624:  Ctrl-C on a value of Trackor Selector clears the field (FireFox Only)

Fixed: CaseID:102323.

GUI-108627:  Add security check to work with fields in Form Designer Fixed. Security groups ADMIN_CONFIG_FILDS and ADMIN_CONFIG_DATA_GROUP control Form Designer access to tab fields.

GUI-108828:  "Details" button icon does not get repositioned in the Form Designer

Fixed: When relative width of a trackor selector is changed using the controller, the details button does not get re-positioned.

Grid-108543:  Can't unselect all items of multiselector in TB grid

Fixed: CaseID 102117

Grid-108551:  Problem with decoding the contents of the memo field when the cell focus is lost.

Fixed: Line break tab <br> was not getting decoded correctly in memo fields.

Grid-108604:  Comma in Exact Search String should be ignored

Fixed: CaseID 102302: Exact search string (within double quotes) fails when search string has a comma

Grid-108608:  Disable 'Delete Config' button at the DropGrid page if the grid is empty Fixed.

Grid-108654:  Old selected values in popup selector of Multi-Selector field at the grid

Fixed: In grids, popup selector of a multi-selector field when opened, doesnt show the correct values (even though the multi-selector field itself shows the correct values).

Grid-109014:  Trackor Containers are empty in Config App frame of the Portal Fixed. Trackor Type of selected Applet had not been saved properly.

After release, user should open the Portal Frame form with 'Config Applet' type, make sure that all values at the form are correct and click by OK.

Imp-108642:  Do not use "force" option for import job interruption Fixed. Using force = true option in dbms_scheduler.drop_job requires powerful "MANAGE SCHEDULER" privilege. With this fix, import jobs can be interrupted without force = true.

MT-108329:  Users shouldn't be able to login into a disabled program Fixed.

MT-108636:  User cannot edit 'Arrange Tracker Tree' if the relation is lockable and program is cloned

Fixed: TUA_RELATION_TYPE_LOCK trigger in DB does not take into account PROGRAM_ID in place where we search a security group by name

MT-109105:  Unable to delete Program if tours exist Fixed.

Rep-108442:  Report Wizard will not update existing report pattern block

Fixed: CaseID-101221.

Rep-108600:  "Attach Pdf" SQL Type on PDF reports do not copy forms from source PDF

Fixed: CaseID-102304.

Rule-108664:  Layout of Rule Edit form is broken

Fixed: Rule Type and Order Number have incorrect horizontal alignment.

SSO-108653:  Unable to get load metadata entities from SSO provider admin page when SAML core not initialized

Fixed: When SSO is disabled admin cannot retrieve entity list and complete provider configuration

Sec-108523:  Session time starts before user authentication

Fixed: CaseID-100671- User gets logged (timed) out after logging into system, if the user has left the browser on the login page. SessionExpireTime is getting calculated from login page (and not after user authentication).

WP-108536:  Make "Calendar" field required on Task Edit form

Fixed: All tasks with empty calendar will be updated to calendar with minimal WP_CALENDAR_ID

OneVizion 8.76

The following is a list of changes since the 8.75 version:

Perf-88196:  Platform Performance Assurance - Mass Assign Rule Does Not Commit. Fixed: Exceptions in Rules will rollback already processed rows. The fix will now commit after executing rule for each row. Exception will stop processing for subsequent rows, but will not rollback changes for already processed rows. This improvement should prevent DB locks when running Form Button rules on large datasets.

RDE-88634:  Drop RDE page. Deprecated: RDE page removed.

Sec-88671:  Update Apache HttpClient to newer version Upgraded.

Imp-88673:  Ability to add Component Package drop-down values to certain imports

New: BPL - Imports can now be defined as part of a 'Components Package'

Rule-88875:  Tower Diagram slide arrows aside when stuck

Improved: Tower Diagram can now slide arrows to left  or right as needed, if stuck.

Rep-100196:  Show "Email To" field on Admin Processes popup

Improved: Case 101721 - Email To field now available in 'Administer Processes' tab

Rule-100197:  Add a memo field for "Rule Description" on the Rules general tab. New: Memo field "Rule Description" on the Rules general tab and Rules grid has been added. This field maps to "Description" field on Best Practices Documents.

Grid-100203:  "Maximum call stack size exceeded" when open the Trackor Browser page. Fixed: If the configuration has specific config field relations, then the Trackor Browser page is not loaded if that field relations selected in the grid.

WF-102472:  Remove obsolete WF step types. Deprecated: Workflow Step Types  "Image Capture", "Dynamic Child", "Capture EFile fields" are deprecated and removed.

Imp-102480:  "Don't start import on errors" as default "Data validation mode" for new imports

Improved: Data validation mode will default to 'Dont start import on errors'

API-103232:  Add API endpoint to run report. New: API endpoint to schedule reports

GUI-106299:  Support CF creation / modification on Form/Tab Designer. New: Configured Fields can now be created from Form/Tab designer. There is a 'Create Field' button that launches the 'Add Configured Field' window.

GUI-108328:  Incorrect behavior of date, date/time and time fields at the config form in case when the same field is presented on different tabs. Fixed: When the same Date, Date/Time, Time field is present on different tabs, changing the value in one of the tabs is not showing up when switching to another tab that has the same field.

Depl-108374:  Add parameter to services app to choose which services to run. Improved: Specify services names to run at the end of command line separated with commas: MAIL_SERVICE,TRACKOR_MAIL,REPORT_SCHEDULER,RULE_SERVICE. This is useful when specific services need to be run on other instances.

Grid-108414:  Cascading field is editable in a grid even if a child field is read-only or locked. Fixed: Case-102126

BPL-108428:  Support "Components Package" for Config Applets. New: Applets can now be defined as part of a "Component Packages" .

BPL-108429:  Support "Component Package" for reports. New: Reports can now be specified to be a part of a Components Package. The issue includes a fix for components package exporting - you were getting an error if there was not any entity assigned to the component package. Components Package is created if it is not found by name (case insensitive)

Dash-108434:  Count Distinct calc method. New: Dashboards - New method 'Distinct' to calculate unique values from defined field.

Grid-108443:  Dependent parent field wipes out the Xitor Class field. Fixed: In a grid that contains Trackor Class field and only the Parent/Root fields (and not the dependent fields), changing the Parent/Root fields value makes the Trackor Class value to disappear.

Conf-108446:  Config Element width cannot be set to 100% in several cases Fixed

Rep-108447:  Show all User trackor types instead of first one at Report Launch Form and Share Link Page

Rep-108451:  Add DB trigger to ensure new report can't be scheduled out of "Exec Time Window". Improved: Ability to setup blackout windows for reports.

Rep-108454:  Can't download file if it has commas in filename (Chrome). Fixed: Files that have commas in their name cannot be downloaded in Chrome.

DropGrid-108455:  Cant import data into existing config with DropGrid. Fixed: In Drop Grid, when importing data into existing Trackor Type and Configured Fields, the fields are being marked as invalid because of 'Name is already used' error.

DropGrid-108456:  DropGrid import fails if you select General Tab (master tab) in "Config Tab" option Fixed.

Notif-108461:  Create new procedure util.SendMailWithAttachments. Improved: New procedure in Util to send mail with multiple attachments.

Conf-108462:  Layout inconsistency could be caused by dragging fields in form designer on heavy tabs. Fixed: Tab/Form Designer crashes when dragging fields in tabs with a lot of fields

Map-108464:  Issue when using Num Pad for entering Lat/long Fixed

Map-108465:  When the radius search returns nothing the Map Legend is not updated Fixed.

VF-108466:  "Already exist" error is displayed when the user tries to create a folder with empty name in FormOrganize

GUI-108473:  Form Desginer: The height of the wiki type field is not displayed correctly. Fixed: Field height not displayed correctly when a wiki field is added, deleted and then added again.

GUI-108474:  Form Designer: Memo field is overlaying icons in fields beneath it Fixed

GUI-108475:  Form Designer: Error when moving a field. Fixed: If the markup is opened in the listbox when a field is removed from form, further work with the field will cause an error.

Dash-108477:  Long string values are rendered incorrectly in the dasboards table representation Fixed.

Dash-108478:  Dashboards filters validation is not working correctly Fixed.

Rule-108479:  Tower Diagram Display Field selector open error Fixed

VF-108480:  Summary and Tasks Overview View Options do not display child applets Fixed

Grid-108483:  Issue with multi-line memo and "Copy To All"

DropGrid-108484:  DropGrid error messages are incorrect

DropGrid-108485:  Default field name is generated incorrectly on DropGrid

Dash-108486:  Dropdown options list is positioned incorrectly when there is not enough space in dashboard filters panel.

Notif-108487:  add parameter "p_reply_to" to procedure pkg_mail.mail_with_attachments.

GUI-108489:  Error when dropping fields in the Form Designer. Fixed: Moving fields to different columns causes fields to be numbered incorrectly and causes an 'Unable to submit' error.

Android-108491:  New layout for configured fields. Improved: New margins and font sizes.

Conf-108499:  Issue when enetering lat/long

Trackor-108500:  Memo value is not saved when prompted to save changes in case when user has the alert "Following fields with unsaved changes has been modified on the server..." and click by OK The issue is related to the Trackor Selector field - when you change it we check if there are changed other fields from the form in last 30 seconds, if so, we inform of user about it and he can choose to refresh the fields or leave them as is. The issue occurred for Memo field - the refresh works properly but when user saves the form, the memo field does not save current value

VF-108502:  Folders should be go before Filter/View at the same level

VF-108503:  In some cases View and Filter folders are hidden in selector. Fixed: View/Filter: If order number of subgroup was less than order number of parental folder then subgroup folders were not displayed

BPL-108508:  Tower groups of Tower Diagram rules are not moved by BPL

Rule-108512:  Tower Diagram Height groups not cloning

API-108513:  Fix API endpoints descriptions in API Docs

GUI-108514:  The position of the slider to resize the column is shifted to Form Designer

WP-108515:  Calendar field at the Task form is always empty even if a value is selected. Fixed: Field can be modified but unable to see the value.

GUI-108518:  Search input clear icon is duplicated for text filter values dropdown in IE/Edge

Admin-108519:  Error when you switch to just created program. Fixed: If you create a new program with the same email as for progadmin account and trying to switch it, you get an error.

Imp-108520:  Make "Insert/Update" import action default for new imports on Admin Import page

Menu-108525:  Hidden subgroup's content is visible in menu

DropGrid-108527:  Trackor Browser link is displayed before the processing is completed on the 4 step

BPL-108528:  Trackor Tree is not moved properly by BPL. Fixed: When importing Component, the Trackor Tree does not contain relations between imported Trackor Types.

DropGrid-108529:  Trakor type field is not repopulated when a user changes selected list.

GUI-108530:  The Drill Down fields are displayed in the list when editing, although they have already been added to the form to Form Designer.

Admin-108531:  Incorrect filter behavior on Admin Param System/Program grids

Dash-108540:  Dashlet is minimized when a user tries to start editting and it was already maximized

Dash-108541:  Dashlet table shows wrong values

BPL-108542:  BPD Items are not moved by BPL Fixed

GUI-108556:  Fix a broken download-button on event panel for FireFox

Dash-108559:  Changing colors for fields in the dashboard page

BPL-108564:  Fields are duplicated on a tab after Components Import. Fixed: Importing a Config Tab with 'Add fields onto the tab even if it has fields already' option will create duplicate fields in Tabs if imported fields already exist in the Tab.

DropGrid-108565:  Uncaught TypeError when a user clicks on Import Log on the 4th step

BPL-108566:  Components Import for security roles fails. Fixed: Import fails when a security role is exported and imported within the same program.

Sec-108567:  Components Export is not available. Fixed: New user accounts  will be unable to export some components, as OK button on 'Components Export Set Up' form is disabled.

DropGrid-108568:  Wrong values in Trackor Selector and Trackor Drop-Down fields on the 2nd step

Map-108569:  Impossible to delete the integer part in lat/long fields

EFile-108572:  Change Bulk Uploader privilege checking. Fixed: In case of Bulk Insert action, E privilege is being checked on the Trackor Type (instead of R)

BPL-108574:  Notification Type assignments are not moved by the Components Exp/Imp

BPL-108576:  Master Tab View assignments are not moved by the Components Exp/Imp

OneVizion 8.75

The following is a list of changes since the 8.74 version:

BPL-77458:  Removing "Store export in Database" option when exporting components 

Rep-82506:  Report Execution Window - span days 

Dash-82768:  Table and CrossTab views 

Admin-88653:  Sample SQL for calculated Configured Fields. Added new table: default_val_sql. It contains predefined SQL queries which can be used in Calculated Configured Fields.

Rule-88874:  Tower Diagram assign fields to groups. Now Tower Diagram can group fields with specified types for make an ability to easy compare it's heights. 

Exp-97263:  Add in grid cell colors for Task dates and Number fields to Excel export. Now we are coloring task dates same as in Trackor Browser grid. Negative and Positive values of Number CF are also colored. 

Imp-98713:  Add "Data Validation Mode" Setting to Administer Import View. 

GUI-100210:  Warning about unsaved user's changes is not displayed when the user closes the Config Form The warning is not displayed in case when an user saves the config form, gets error and clicks by the Cancel button. 

BPL-100217:  Log components import errors. Now you can find an error which you get during BPL import at the Error Log page. 

Trackor-100219:  Field values are changed in case when user have the alert "Following fields with unsaved changes has been modified on the server..." and click by OK The issue is related to the Trackor Selector field - when you change it we check if there are other changed fields from the form in last 30 seconds, if so, we inform of user about it and he can choose to refresh the fields or leave them as is. The issue occurred for DB Drop-Down, Drop-Down, Checkbox and EFile.

GUI-102487:  Support value color for Drop-Down and selector Configured Fields 

Imp-103227:  Make Process Comments fields editable. Now users are able to modify "Comments" field after process start, and also when it is finished.

Notif-103237:  Adding ability to download file for completed processes from Events panel. 

Dash-103256:  Ability to filter string fields in dashboards by a substring search.

GUI-103257:  Show loader while using form designer.  

Conf-105887:  Do not pull all child Trackors on EditTrackor form.

Rule-106318:  Error message with <ERRORMSG> tags throwed from the rule may be ignored and default error shown instead We didn't properly handled line breaks in error messages enclosed in "<ERRORMSG>" tags. Now we do, also now we are using case insensitive search to find "<ERRORMSG>"  tags.

GUI-106319:  "Blank Line" config element on Form Designer.

Rep-107646:  Error when opening Trackor Edit form from the Report Wizard data grid. 

Grid-107647:  Filter in Trackor Browser by date field with "=" operator returns no data. 

Conf-107648:  "In Use" column on "VTable Values" grid may show "No" while value actually in use. This value didn't takes into account multi selectors. 

BPL-108324:  BPL importing does not work for HTTP Call rule class. 

Rule-108325:  Tower Diagram remove height value rounding. Now values in Tower Diagram show as is, not rounded.

VF-108327:  Nested filter folders disappear on Trackor Selector pages. 

Dash-108347:  "Uncaught TypeError" when user tries to add a filter after searching for a field. 

GUI-108349:  "My Trackors" checkbox is overlapping filter popup. 

GUI-108350:  The button "Stretch on two columns" did not change when you press it in succession, but only when you close it and open the panel again. 

GUI-108351:  The field editing panel did not popup when field added to the form with double click. 

MT-108373:  Value in "Owning User" column disappears when editing program on Admin Program page.

GUI-108375:  Can't create/modify config tabs for static Trackor Types (Tasks, Workplan, Worflow). 

GUI-108376:  Do not show Program, Comment, WorkFlow Step and Report static Trackor Types in Form Designer. We do not support Config Tabs/Applets for those Trackor Types. 

MT-108377:  Assign security roles to the default user account when creating new program by copying config from another. 

Admin-108379:  Add field "Related Trackor Type" to the "Form Designer".

"Related Trackor Type" drop-down is only shown for Task and WP tabs, and allows add additional Configured Fields from Trackor Types to which WP will be assigned. It was missed for new From Designer.

GUI-108380:  Problem with rendering section with multiple line Configured Fields. 

Admin-108383:  Config Tab was not created if you added a checkbox field.

Rule-108384:  Error when submitting URL with parameters in HTTP Call Rule. 

Trackor-108385:  Trackor template should not contain required fields except for primary Trackor ID Required fields were appeared after refreshing a form. 

VF-108386:  Admin WorkFlow View Opts does not display fields assigned to applet/tabs of WorkFlow level. 

Dash-108387:  Add Dashlet button is enabled even if there is no dashboards. 

Dash-108388:  Add Dashlet button is enabled even if another dashlet is being edited already. 

VF-108389:  TrackorOnMapSplitGrid controller ignores filterId parameter TrackorOnMapSplitGrid is used as external applet for TB to show selected Trackor on Map. "filterId" parameter is supposed to override filter selected by user with one specified, but it didn't worked properly.  

VF-108390:  When opening TrackorOnMapSplitGrid, filter by selected Trackor overrides 1st entry of current filter. 

Imp-108392:  "Workplan Date by Trackor" import data type do not trigger calculations New imp data type param "Force Calc" added. Behavior of existing import mappings is not affected. 

Rule-108404:  Always hide error message details if there is <ERRORMSG> presented, regardless of ADMIN_RULE privs. 

Conf-108416:  Changed config field's width is resetting after form submit. 

Conf-108417:  Label and Splitter creation is not working in Firefox. 

Notif-108418:  Notification processing fails with error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" at "PKG_NOTIF", line 465 Error occurs when length of the names for entities selected at the right selector (Config Fields for Trackor notifications, WP Task Dates for  WP Tasks notifications etc) exceeds 500 chars. During notification processing those names are concatenated and may be used in notification subject or body as one of Event Attribute (for example [CONFIG FIELD] for Trackor notifications). 

GUI-108420:  JS error when moving multiple fields (task, drill-down) from the listbox of From Designer. 

Map-108426:  Error when using fractional numbers in "Search Radius" field on Map page. 

GUI-108431:  Fractional numbers has different appearance in the grid and on the config form In case if number decimal digits is not set for Number field and user saves fractional value then the grid displays fractional part and the config form does not display. 

Trackor-108432:  Trackor Drop-Down of Workplan or Task or Workflow level does not display value. 

Rep-108433:  SFTP settings form uses invalid security check SFTP settings form uses invalid security priv check when opening from Run Report Form. 

Sec-108435:  Reload user security settings every 1 minute. We are caching user security settings and check if settings updated in DB every 5 minutes. Now interval decreased to 1 minute. 

Rep-108444:  Error on saving report filter with EmailTo of Account type. Now Report filter saves correctly. 

Rep-108445:  Don't take into account "Archived" report processes when checking for "In Use". "Archived" report processes won't be taken into account when checking for "In Use". This affects "Delete" button on Admin Reports page. 

Dash-108448:  Dashlet size is calculated incorrectly in Firefox and IE11. 

Dash-108449:  "Element not found" is displayed when a user tries to add field to an axis in Edge and IE11. 

GUI-108450:  When changing value of the Related Trackor Type field on "Form Designer", a warning alert should appear to clean the form. "Related Trackor Type" drop-down is only shown for Task and WP tabs, and allows add additional Configured Fields from Trackor Types to which WP will be assigned. 

OneVizion 8.74

The following is a list of changes since the 8.73 version:

EFile-98703:  Child level CFs from EFile container Trackor Types are empty in EFile Browser 

GUI-98873:  Never ending error loop on Date field 

BPL-100194:  Tower Diagram rule options should be moved by name with help of BPL 

Trackor-100206:  Values of Trackor Class field are not filtered in dependent on parental cascading field(s) There is the following branch: Field1 -> Trackor Class -> Field2. When you click by Apply button on the Config Form, the form is refreshed and Trackor Class displays all values instead of dependend values on the Field1 

BPL-100209:  Color of VTable values is not moved by BPL 

GUI-102478:  Remove "Blank Spot", "Text Label" and "Horizontal Splitter" CF data types Now this functionality supported in form designer. 

Doc-103205:  Update ER Diagrams New diagrams are added to DB Documentation 

Menu-103228:  Error when trying to modify Menu Item label 

GUI-103234:  On Form Designer WP Task Dates label is missing Order Number and prefixes Now, labels on form designer are the same as will be shown on the form with data 

GUI-103235:  "ORA-00001: unique constraint (UN2_CONFIG_GROUP_ELEM_XREF) violated" when arranging fields on form designer Sometime users were unable to submit changes in Form Designer. Fixed now 

Conf-103245:  Add SQL_FIELD_NAME to the Admin Config Field grid SQL_FIELD_NAME is guaranteed unique across all Config Fields in Program 

Dash-103251:  Incorrect drag image when dragging field with opened drop-down 

Dash-103252:  Editing dashlet is not being resized properly when reducing window width 

Dash-103253:  When dragging field on X-Axis it's calc method won't be cleared in the title 

Trackor-103258:  Can't leave empty required EFile CFs on Trackor Template 

Trackor-103259:  Trackor ID value is disappearing in the Grid Row Editor when Wiki field is changed 

GUI-103265:  Scrollbar is not updating properly on VF drop-downs content changes 

Sec-105884:  Users can't delete local Views and Filters We used TRACKOR_BROWSER sec group to control supported operations on local Views/ Filters. Now we will only check Read priv for all operations 

Conf-106292:  E-File field is not marked as changed if user have selected a new file with the same name 

Rep-106297:  Can't save Report Params when Trackor Type is not set on "TB Grid Worksheets" tab 

Dash-106302:  Field names aren't displayed in the chart legend 

Dash-106303:  "Count" is always selected by default for every field when user enters the edit mode 

Conf-106316:  Do not add Trackor Class field on the "General Info" tab when creating new Trackor and Class label is not set 

Dash-106317:  Error on window resize if no dashboard is loaded

Conf-106320:  Error when creating External Tab 

Rep-106322:  Cannot reschedule report when "EMail-To" was used 

GUI-107649:  New filter/view icon is too small 

Dash-107655:  Edit and Delete buttons are not working for newly created dashlets

OneVizion 8.73

The following is a list of changes since the 8.72.2 version:

Notif-66338: Notifications were being created in a wrong program - corrected.

API-68221:APIfor reports

Dash-84733: Filters for Dashboards

Dash-97183: Layout container sizing bug

Sec-98853: Can't create user with name containing digits only

Trackor-100208: You can not delete a Trackor if there is at least one non empty locked multi-selector field

Trackor-100212: Any WP field is available to edit on the Config Form even if it is not assigned to active WP You can add any WP field to a config tab if Trackor Type has 'Single Active WP' mode but you can edit only that fields which assigned to active WP, other fields should be disabled

GUI-102470: On the form of the task, you can set the percent complete > 100

DB-102504: Add missed indexes for FK cols

Conf-102509: “ORA-01427: single-row subquery returns more than one row” on cascading fields submit You can not save a config form if there are two or more different groups of cascading fields

DB-103172: Add constraints and user friendly error message for wp_tasks.percent_complete User friendly error message will be returned when user will try to set value grater then 100

Admin-103177: Problems with navigation on the Form Designer

WF-103212: “Config Tab” step were not taking into account Trackor classes

Rep-103213: Emailto doesn't shown in Reports History grid

Dash-103225: Add element Ids to dashboard controls

DB-103229: AUDIT_LOG.LINE_NUMBER was not being populated

Exp-103233: “ORA-01745: invalid host/bind variable name” when running TB Grid Export and TB Grid Report Bug introduced with Exp-31698 (8.70.0). Within this we will color Excel cells only when there are less then 5 thousands Trackors in the grid

Conf-103239: Same tasks with different date pairs work incorrectly in form designer

GUI-103240: The list of fields in the form designer is not cleared when changing the Trackor Type

EFile-103243: TB Bulk Uploader is broken Incorrect behavior of controls at the form

Dash-103246: Edit and Delete buttons isn't work correctly after dashlet being moved in layout

Android-103262: Steps not removing from offline when it not available into loaded list

Android-103263: Crash when attempt to start WorkFlow twice

Exp-103264: Can't download grid exports executed by other users from Admin Process page

OneVizion 8.72.2

The following is a list of changes since the 8.72.1 version:

DB-103238: Since 8.72.0 release util.GetValStr() return TRACKOR_KEYs wout an Alias

OneVizion 8.72.1

The following is a list of changes since the 8.72.0 version:

Conf-103226: Submitting new tab with a pre-defined trackor type was not working correctly.

OneVizion 8.72

The following is a list of changes since the 8.71.1 version:

Notif-62671: Improve OV notifications about statuses of my processes

API-72086: Support partial update in TasksAPI

Imp-78426: Enhance DB Import Package to check that CF Value has not changed New parameter “Update even if new value = old” added to “Configurable Field” import data type. When empty (by default) or “No” we are not updating value of CF if it is equal. When - “Yes” value will be updated, actually we are not overriding value in DB tables because using “merge” statement, but all related rules will be fired. For existing import value set for “Yes” to preserve old behavior

Notif-80743: System parameter to ignore SSL certificate checks New hidden (ie not available inGUI) parameter created: “mail.smtp.ssl.trust”. It controls SSL config for Mail Service and Trackor Mail. Leave blank for default behavior - server certificate is checked by Java, set to a whitespace separated list of hosts to make this hosts trusted, set to “*” to make all hosts trusted. You should understand that when setting value for this parameter you are opened up for MITM attack. More detail on this parameter:https://javaee.github.io/javamail/docs/api/com/sun/mail/smtp/package-summary.html

CodeQ-88819: Do not use 'gridIdx' parameter in TbGridSubmit, TasksGridSubmit and TasksOverGridSubmit controllers In previous version 'gridIdx' was used just to get values of HTTP parameters. The grid submitting has been updated and now we pass the changes from a grid with HTTP parameter names without 'gridIdx' as postfix

GUI-88853: Fix js code, showModalDialog() was removed in Firefox 56.

WF-98654: Admin Notification grid is not filtered when opened from WF Designer

GUI-98774: New design for Add/Edit Config Tab form Form designer moved to the “General” tab of Tab Add/Edit form

GUI-98793: Applet without tabs has empty tab with “nbsp” labels

GUI-100204: Error while clicking on the static field label

GUI-100205: Unsaved changes alert when no data actually changed on Admin CF form It was issue with Color Picker form. Fixed now

BPL-100209: Color of VTable values is not moved by BPL

DB-100214: Unique index U1_XITOR_TYPE error Now we show user friendly message when user trying to create Trackor Type with already used name

Admin-101753: Filter not working on ADMIN_LABEL_TASK page

Admin-102471: New User rule is fired instead of User Update when you modify user options

OneVizion 8.71.1

The following is a list of changes since the 8.71 version:

Sec-102063: Corrected - Can't switch user with “Login As…”

OneVizion 8.71

The following is a list of changes since the 8.70.1 version:

Grid-64687: Grid sort is corrected when sorting on a field that is a trackor selector with an alias.

BPL-78628: Options of ZIP EFile rule type are correctly moved with help of BPL.

BPL-83325: Add filtering and search capabilities for BPD New columns added to the Document Items grid: Description, Technical Description, Steps To Use and WebURL. These columns are available for filtering and Quick Search. Also now user can change View Options columns.

Admin-84606: Improve Time Zone handling New program parameter “ForceUserTimezone” added. When set, override user Timezone offset (by default retrieved from the user browser) with value from “PrimaryTimezone” system parameter. For “PrimaryTimeZone” text field replaced with drop down listing all available time zones.

Sec-88564: Don't reload user privileges from database for every HTTP request Now system privileges are cached in web server memory and reloaded only when changed or every 5 minutes.

Sec-88672: Update Xalan library to newer version Xalan 2.7.1 is vulnerable for CVE-2014-0107| CWE-264. Replaced with 2.7.2

Admin-88718: Add Menu Item - Should default to “Trackor Browser” type, and Label should not auto-populate with “Trackor Browser”.

Conf-88748: Add support of Config Applets to the Portal page.

Rule-88873: Color arrows on Tower Diagram We are using V_Table value color (see Admin-98903).

Map-94453: Fix order of items on “Map Legend” panel Now values ordered by V_Table order.

MT-94946: Static Tabs missed after creating new program Workflow, WorkPlan and Comments static tabs are now available in newly created programs.

BPL-94954: BPL Import of materialized views fails but the view is created in PKG schema Also fixed: Description field is not moved with BPL and User field is blank after importing.

BPL-94955: Warning message was not moved with BPL.

BPL-94956: Lat/Long fields of Map Snippet rule were not moved with BPL.

Trackor-95503: Corrected submit cascading fields when Trackor Class field is root of hierarchy.

WP-95533: Workplan Task - Block Calc when created Added a feature to the task attributes so a task will be automatically 'block calc' when the workplan is created. Uses can Un-block later if that's what they want. Similar to the N/A box where a task is marked N/A when created, and users can Un-N/A later if deemed necessary.

Grid-96183: Quick search and Filter by ED: columns is ignored on EFile Browser grid.

WF-96653: Refreshing of WF form with mulitple child tab is corrected.

Conf-97083: Delete “Grid Container Tab” security token Grid Container tab are no longer supported.

GUI-97163: Don't hide User Menu when loading favorites.

DB-97173: Drop obsolete tables. No longer used tables v_company and v_link_type are dropped.

GUI-97213: “Loading” panel on Tree items deletion is disappears before tree actually updated.

DB-97233: Make WF_DECISION_OPTION.WF_DECISION_OPTION_ID not nullable.

DB-97283: User can not delete a Trackor Type XITOR_COUNT table mutation issues fixed.

DB-98613: Remove debug output from PKG_WP.

Trackor-98663: Trackor ID field is not displayed properly in some cases Trackor ID field has 3 different appearances: Text field, Relation and read only Trackor Selector. 1 Text field - Trackor Key it is on Primary Trackor Type Config Tab 2 Relation - Direct Parent on Master Applet of Primary Trackor Type 3 Read only Trackor Selector all other cases

Dash-98733: Dashlet name was not submitting after being changed - corrected.

Dash-98734: Cancel button is not working properly on edited dashlets.

Admin-98743: Remove static Trackor Types from Admin CF page We do not allow to assign CFs on Program, Report, WF Step Trackor Types, so we removed it from the lists on Admin Config Field page.

Grid-98753: Grid buttons on Manage Database Jobs page aren't disabled when no row is selected.

GUI-98783: Allow to enter empty label for Portal Frame If user left “Label” field blank, old label will be deleted and Portal Header will not be shown.

MT-98794: Create new user for the new program directly on Add Program general tab.

DB-98795: Unique index U1_CONFIG_FIELD_NAME error.

DB-98803: Unique constraint DX15_CONFIG_FIELD error when adding new Trackor Type.

Conf-98833: Required Fields check is not working correctly in some cases.

API-98843:APIendpoint to create new Programs /v3/programsAPIendpoint allows to create Programs with admin account configured. Login information will be emailed to the Program admin.

Trackor-98863: Cascading fields are submitted in wrong order

Trackor-98893: Static Fields were not working properly at the Grid Row Editor. At the Grid Row Editor WP fields are not display at all and WF fields do not display values - corrected.

Admin-98903: Implement color setting for V_Table attributes Now every V_Table value may has own color. We are planing to use color in other features later.

Admin-100216: Can't delete a security role.

OneVizion 8.70.3

The following is a list of changes since the 8.70.2 version:

Conf-105887: Do not pull all child Trackors on Edit Trackor form.

Conf-106292: E-File field is not marked as changed if user have selected a new file with the same name.

Exp-103264: Can't download grid exports executed by other users from Admin Process page.

GUI-103235: "ORA-00001: unique constraint (UN2_CONFIG_GROUP_ELEM_XREF) violated" when arranging fields on form designer. 

Rep-106297: Can't save Report Params when Trackor Type is not set on "TB Grid Worksheets" tab.

Rule-106318: Error message with <ERRORMSG> tags throwed from the rule may be ignored and default error shown instead.

Sec-105884: Users can't delete local Views and Filters. We used TRACKOR_BROWSER sec group to control supported operations on local Views/ Filters. Now we will only check Read priv for all operations.

OneVizion 8.70.2

The following is a list of changes since the 8.70.1 version:

Grid-96183: Quick search and Filter by ED: columns is ignored on EFile Browser grid

WP-100225: Get Error when deleting a successor for WP Task

Exp-103233: “ORA-01745: invalid host/bind variable name” when running TB Grid Export and TB Grid Report Bug introduced with Exp-31698 (8.70.0). With this fix we will color Excel cells only when there are less then 5 thousands Trackors in the grid

OneVizion 8.70.1

The following is a list of changes since the 8.70 version:

GUI-96683 Issues with Label element on Form Designer

WF-98653 WF Description area overlaps other fields on Admin WF General tab

WF-98655 WF Status icons are missed

Dash-98693 Error when adding field on Y-Axis while X-Axis is empty

Rep-98834 Reports is not sending to arbitrary emails

OneVizion 8.70

The following is a list of changes since the 8.69.2 version:

API-96643 NOT_EQUAL filter operator doesn't work for v3/trackor_types/{trackor_type}/trackors/search endpoint

Admin-97273 User can not assign Drill-Down Trackor ID to a tab if primary and drill-down types are the same

Android-96673 Android App crashes when open Trackor selector It may happen when current step has lot of data and can't be serialized to Android's standard storage. Now we are serializing step into local DB instead

Conf-88635 Remove Teams support

Conf-97123 Cannot submit required EFile fields when file inserted from the clipboard

DB-94947 Get rid of Enterprise PK prefix Function pkg_vqutils.make_pk dropped. Now primary keys are generated using sequence directly

Dash-95523 Category with Null value has incorrect label

Dash-95524 Changing field aliases in datasource SQL causing error if it was already used in charts. Remove or rename of existing fields won't break dashlets any more. Fields used in dashlets but missing in datasource will be displayed in edit mode but skipped in chart. User will be able to see that field is missing by it's color (light gray).

Dash-95525 Group field on Y-Axis is missing in edit mode

EFile-95413 NullPointerException when submitting EFile and BLOB_DATA.CREATED_TS = null for old EFile value

Exp-31698 Add in grid cell colors to Excel export. Now we are coloring recent changed cells in Excel Exports based on View Options settings. Negative and Positive values of Rollup CF are also colored.

GUI-95483 Missed “Close” button on export finish notification panel

GUI-96674 Config Tab contains duplicate parental Trackor Key fields

GUI-97253 Changed field value is not submitting with hotkey while field is focused. Submitting form with hotkey while required configured field is focused is now working correctly.

Grid-95424 pkg_relation.get_parents_children_count do not update count when there is 0 in xitor_count.count We removed invalid rows from the cache.

Label-95513 Wrong label on Admin Filter form Label “Trackor” renamed to “Trackor Type” for prevent confusion while Filter configuration is in use.

Rule-88776 ORA-01400: Cannot insert NULL into AUDIT_CALL_STACK.ROUTINE_ID when updating CF on “Is User” Trackor Type via “Update User” rule.

Rule-94953 Error messages are not properly formatted when raised from Task update rule. The message has included technical details from DB of an error.

Sec-88184 Make “Password” optional for Onevizion accounts. In case of SSO, empty password will prevent users from logging in using Onevizion credentials and will force to use SSO.

Sec-88670 Update Apache Commons Collections to newer version. We replaced Apache Commons Collections 3.2.1 vulnerable to CVE-2015-6420 with version 3.2.2.

WF-96143 Error when selecting user selector CF in “Start WF” and “Mass Start WF” forms.

WF-96613 Can't create new WF Template using wizard on “Admin Trackor Type” page All controls were disabled because of incorrect security checks. Fixed now.

WP-96153 Error when open Task Selector from “Assign Task Type” form

OneVizion 8.69.2

The following is a list of changes since the 8.69.1 version:

GUI-96663: Can't submit form designer when CONFIG_ELEMET_ID is the same as one of CONFIG_FIELD_IDs

Gallery-96693: Recover Galleries, and Photo Libraries.

OneVizion 8.69.1

The following is a list of changes since the 8.69 version:

Dash-96173: Dashboards page was not loading if there is not any existing dashboards. Dashboard page is now loading correctly and users will be able to add first dashboard using drop-down.

OneVizion 8.69

The following is a list of changes since the 8.68.2 version:

GUI-77742: Required fields (other than text) were missing red outline.

Imp-78563: “Import File” column was empty in “Import History” grid when file stored in AWS S3.

Grid-84604: Bug - Column Sort functioning incorrectly. Selectors and Drop Down fields will now sort by VTables order number and then alphabetically by Value.

Admin-84639: Tab Designer should display only Trackor ID field of parental Trackor Type if the relation is MANY-MANY. If the relation is MANY-MANY display only Trackor ID field of parental Trackor Type. If the relation is ONE-MANY display all published fields.

Grid-84640: Allow wildcard usage in filter value for Lat/Long fields, Ability to use wildcards (*) in the Latitude/Longtiude fields in the Filter Example: '*4.567*', '45.456*' or '*4.56789023'.

API-84705: CreateAPIendpoint for system and program params NewAPIendpoints added for getting System [Version, AdminEmail, EmailFooter, ReplyToAdminEmail, ServerCommonName, NotificationSender] and Program Parameters [DateFormat, TimeFormat, ClientLogo, LicenseTo, Default_Language].

Sec-88565: User timezone was not available when using SSO force redirect. Setting up user timezone after going into system.

WF-88584: WF view/filter drop-downs were rendered in an incorrect location.

Sec-88615: Log SAML response XML into Usage Log. Log SAML response XML into Usage Log when user logged in with SAML or fail to log in with SAML.

DropGrid-88618: Update field name prefix without prompts.

DropGrid-88619: Field names are changing when switching column on/off after Trackor Type label was changed.

Sec-88621: Do not show certificate content on edit form for “X.509 PEM Certificate” param data type For security reasons will not show content of certificates after it was submitted. So, there is no way to get certificate content using the field in the tab. To store new certificate just paste it into the text area as usual.

Admin-88663: Admin Config Field for Trackor Selector was not loaded when default View Options was changed. The bug is fixed and the admin form loads properly. Also 'All' items were added into the Config Applet/Tabs fields. ie..in the View Options of the Trackor Browser.

Sec-88669: Update Apache Commons Beanutils to newer version. Removed Apache Commons BeanUtils dependency because of CVE-2017-5662 vulnerability discovered in used version. Use Spring Beans instead of Commons BeanUtils.

CodeQ-88704: Get rid of Excel Orchestrator.

GUI-88719: Predecessor/Successors of a task can not be updated with help of a rule The fields can not be updated with help of a rule if it is fired in proccessing of submit from the Trackor Browser page.

CompPack-88736: Text of error message is updated at the BPL Import page In case when you are trying to run BPL importing but a XML file with BPL components are not loaded we display error message. That message has been updated.

Gallery-88749: Depreciation of Galleries (Photo Library).

Rule-88753: Save actual HTTP response code to Usage Log when request is succeed It always saves 200 for any 2xx response codes.

GUI-88778: Unable to create a frame in Portal view.

Admin-88815: Label ID of fields at the Admin Trackor Type form is not updated if a label is added when the form in 'edit' mode Hyperlink with label ID is not updated when the form is opened in 'edit' mode, the label does not exist and you click by Apply button

VF-88820: Long dropdown items text is not truncated Long View or Filter names now will be truncated to fin into the panel

GUI-88822: Hint for grid buttons is missing Some buttons were not showing hint for mouse over. Eg. TrackorBrowser buttons - Add, Edit and Delete. This has been fixed.

Conf-88838: Remove obsolete program parameter “GridContMaxCols” After grid containers were removed, we no longer need this param

SSO-88855: Login form disappears when Username/Password login failed Login/Password form disappears after user fails to log in with password, when one or more SSO providers available. Now this is fixed

Dash-88883: Chart categories incorrect order on X-Axis

Conf-94483: Can't assign multiple parents to the User Trackor If User can have multiple parental trackors, then all relations were getting created but only one was displayed in the User tab. This has been fixed to show all parents.

Grid-94945: Submitting of Date, Date/Time, Time fields are not working from the Trackor Browser grid Time, Date and Date/Time fields are now functioning correctly.

OneVizion 8.68.2

The following is a list of changes since the 8.68.1 version:

Grid-94945: Submitting of Date, Date/Time, Time fields are not working from the Trackor Browser grid

OneVizion 8.68.1

The following is a list of changes since the 8.68 version:

Conf-94483: Can't assign multiple parents to the User Trackor. If you assign multiple parental trackors, then all relations are created but displayed only one parental in the relation field.

OneVizion 8.68

The following is a list of changes since the 8.67.1 version:

Rep-52106: Excel Reports generated by Rep Wizard have wrong formatting for Date cells Now Report Wizard settings up correct formatting for Date, Date/Time and Time fields.

Rep-82114: Support arbitraray email addresses for “Email” report delivery methods. Now Reports can be sent to external e-mail addresses. User can type any e-mail addresses or select users from user trackor types.

Dash-83925: Newly added dashlet disappears on drag

Grid-84636: For Grid Exports add Number of cells, number of rows, and number of columns We add “Cells count” column into Export History, Export Details and Administer Processes pages. Cells counting executes before export is running. Cells count value is same as exporting grid cells count.

Admin-84742: User can not update Trackor Type if there is no label of Trackor ID field If Trackor Type exists but there is no label of Trackor ID by some reason, user can not create a label and update Trackor Type

DropGrid-88616: “Name already in use” warning after unchecked and then checked back column

Trackor-88626: Unable to Clone because of missing file blob data

Sec-88668: Update Apache Commons FileUpload to newer version We upgraded Apache Commons FileUpload used for processing HTTP Multi part requests, because of CVE-2017-5662 vulnerability discovered in older versions

TMail-88708: Mapping for email body breaks when csv file is attached We utilized commons-email library to better handle data extraction form emails.https://commons.apache.org/proper/commons-email/

WP-88724: History of task static field is not loaded If you open the Task Form and try to open the field history of a static field like Predecessor, Successor, Comments, etc., then you will get an error

BPL-88738: Tour Name column is emtpy when you import tours with help of BPL

Dash-88775: GoldenLayout library update for Dashboards

Grid-88777: Fix presentation of value in IN SQL statement for user pages in Usage Log SQL Previous when inserting param values into Usage Log SQL we generated queries like this: and¹⁾)) even when comparing with number column. This may confuse users. Now we properly handle IN statements params substitution and produce queries like this: and²⁾))

Admin-88813: js error when opening the form designer The form is not loaded properly if there is the container of multiple fields

Other-88823: Version for JS component resources is missing

OneVizion 8.67.1

The following is a list of changes since the 8.67 version:

GUI-88719: Predecessor/Successors of a task can not be updated with help of a rule.

OneVizion 8.67

The following is a list of changes since the 8.66.1 version:

WF-88723: Reload labels after WF Wizard creates new WF Template

BPL-88716: 'Support Async Submit' option of excel report with VBA is not moved by BPL

BPL-88715: Worksheet Images of excel reports are not moved by BPL

BPL-88714: 'Hide CF Names Header' option of excel report is not moved by BPL

BPL-88713: Lookup options of report parameters are not moved by BPL

Trackor-88706: Submit of cascading fields fails in some case The bug is occured time to time in case when there are the following relationships between fields: Field1 → Field2 → Field3 → Field4 → Field5. Submit failed when you changed values at the Grid Row Editor

GUI-88705: Permanent unsaved changes alert on Pattern Block edit form

Android-88693: Android App new trackor step submit correct save PK for submit queue fields Now app correctly submit new trackor step in second request from queue after first request is sent

Android-88666: Android App does not consider fields accessible Now app correctly deny edit unaccessible fields in any case.

Sec-88664: Hide LogOff and change password functionality when user logged in with SSO.

Admin-88647: Values of dependent fields are not displayed in tree at the Import Dependent Values form

Grid-88646: Update user page SQL Builders to support new Drill Down storage structure New DB structure to store Drill Down CFs were created in DB-7857 (8.65.0), in some cases it may cause errors on TB grid page. Fixed now

Grid-88645: When removing Drill Down CF, filter entries should be ignored If you choose some drill-down fields in a filter and after some time they become inactive because drill-down Trackor Selector has been dropped or unassigned from all tabs, the loading of page fails with error

GUI-88629: Automatically create sections for multiple line CFs in form designer When 1st multiple line CF moved to the form, section will be created automatically

GUI-88622: “All” item in Trackor Types list on From Designer should be on the 1st position

DropGrid-88620: Can't delete drop grid record Delete button of the grid does not work at all

VF-88195: View/Filter Item Gets Removed From Folder if Re-Saved

Android-88193: Need Documentation for Android App. Documentation for Android App has been deployed to wiki.onevizion.com

GUI-88183: Disable tree control buttons after node deletion Minor fix affection Admin Menu, Admin Trackor Tree and other pages where trees are used

DB-87483: When exporting tasks dates set with rules, dates appears with time part in Excel We modified pkg_dl_support.set_config_date and pkg_dl_support.set_date procedures to remove time part. This procedures are also utilized from util.settaskdate

Perf-87468: Java caching for GRID_PAGE DB table This table is used internally, data may be changed only during releases, so we will keep data in Java heap to speedup access

BPL-87466: “Don't Clone Field Value” and “Do not Clone Locks” are not moved by BPL

DB-87465: Drop old views. We dropped some old views used internally in previous versions, which are no longer used and are invalid now

Admin-84745: Config Elements are not removed when you unassign it from the tab in From Designer If you unassign a config element from a tab, the assignment is removed but the record in CONFIG_ELEMENT table is still kept. Now this is fixed. Labels for “Text Label” element are also removed.

BPL-84719: 'Data Validation Mode' and required params of fields and mappings of Import are not moved by BPL

DB-84715: Reuse SimpleJdbcCall. We reduced Oracle metadata access by initializing all SimpleJdbcCalls on startup and then reusing objects.

Menu-84656: When clicking on empty folder in menu browser opens new empty page and nothing happens

DB-83924: Adding primary key column in DRILL_DOWN table The new column is used in foreign constraints in DB

Rep-83907: Failed to run Excel report with VBA Submit, when there are certain objects on the Sheet Fixed in Aspose.Cells for Java 17.9.7

Dash-82951: Remove “Highcharts” label from the graphs

Dash-82950: Fields are being removed from field list when dropped on a placeholder

Dash-82897: Axis name is not saving after dashlet submit

Dash-82766: Data Series Grouping. Placing group (blue) fields on Y-Axis will split chart data into multiple data series based on unique values of placed field

Grid-82765: WF static fields are broken in TB grid

Admin-82504: Clone - Edit Configured Field - Clone all elements Now system clone all elements when user clone config field

Dash-82500: Dashboard Series are not saving Format Name

Imp-81913: Better exception handling when parsing CSV data for import Now CSV parse error contains row number that broke import

Admin-78598: Drop support of “Grid Container” feature Admin interface for Grid Containers removed

Grid-76219: Convert Grid Containers to Trackor Containers All Grid Containers have been converted to trackor container grids.

Dash-74717: Date columns are not handled properly. Date fields are fixed, date/time axis type support is added

GUI-65315: Display drill-down fields on the Config Form New section added to the left panel of Form Designer - “Drill-Down”. User can pick Trackor Selector field from the primary Trackor Type (“Short Name” propery must be set) and then add CFs from the tree starting at Trackor Selector's Trackor Type

The following is a list of changes since 8.59.12 version:

Grid-109694:  All user grid SQL IN parameters are strings Expected small performance improvements of user grids when filtered by numeric fields (including Trackor Key, Drop-Down, Selectors, etc)

Grid-110255:  Use hints to improve exec plans for TB SQL Improved. CaseID-102610: Feature disabled by default. Can be enabled with "UseSQLHints" system parameter. Affects only Trackor Browser SQLs.

DB-111749:  PKG_NOTIF spec is invalid.

DB-84715:  Reuse SimpleJdbcCall. We reduced Oracle metadata access by initializing all SimpleJdbcCalls on startup and then reusing objects.

EFile-114869:  Error when opening EFile history from EFile Download History grid.

Grid-109555:  Repeating alias of restricted user sub query in TB SQL may lead to expensive cartesian join We modified TB SQL builder to use different table and view aliases.

Grid-109869:  Large differences between DB Time and Web Server Time in TB when filter by grouped WP Task field When filter Trackor Browser grid by one of TName*, TOrd, TWbs fields and there are thousands WPs assigned to the Trackors of Primary Trackor type, TB SQL generation become slow.

Grid-113147:  Fix TB SQL performance hints. Fixed: CaseID-102809: This issue fixes performance hints introduced with Grid-110255. Before this fix, hints didn't affect performance. 

Grid-113592:  "Share Page Link" doesn't work for Task Overview grid. Fixed:CaseID-102832

The following is a list of changes since 8.59.11 version: