Fixed Issues in 21R2.3 Release

Release Date: September 24, 2021

This week's release includes fixes for the following issues:

A * next to the issue number denotes an internally found defect filed during the development of Limited Release features.

Blank & Detail PDFs

Issue Description Issue No.
Detail PDF jobs fail without explanation. VDC-80945, VDC-80274

Casebook Versioning

Issue Description Issue No.
Users receive various validation errors after creating a new Casebook Version. VDC-80208

CDB - CQL

Issue Description Issue No.
CQL returns an error when the WHERE clause uses @ItemGroup.SeqNbr. VDC-70892*
If an Item is used in more than one repeating Item Group, CQL may return rows for that Item across all possible Item Groups, instead of the selected Item Group. VDC-71759*
CQL may return duplicate rows when using Union and join on subject. VDC-71958*
CQL returns extra rows for a repeating Item Group unless both @ItemGroup.Name and @ItemGroup.SeqNbr are included in the projection. VDC-72088
When a statement has a Union with a Union in a subquery, CQL returns "The used SELECT statements have a different number of columns". VDC-72381
When a statement has a Union with a Union in a subquery, CQL returns "The used SELECT statements have a different number of columns". VDC-74873
When an Item is used in both a repeating and non-repeating Item Group on the same Form, CQL returns all instances of the Item when only the non-repeating Item Group's Item is in the projection. VDC-78325
The LBLOC column shows the ID instead of the Lab ID. VDC-78386*
CQL may not return any results when using on subject with only Forms from a log-type Event. VDC-79210
CQL doesn't treat CAST as a function and so doesn't parse provided parameters, resulting in unknown column errors. VDC-79239
If @Form.LinkID is used with On Subject, CQL doesn't return any results. VDC-79491
When using Group By, CQL returns an unknown column error for @ItemGroup.SeqNbr. VDC-79904*
The SDTMDateFormat function doesn't return datetimes in yyyy-mm-ddThh:mm format with the time in the timezone entered by the site. VDC-80072
CQL may return an unknown column error when the from clause includes the source. VDC-80367*, VDC-80744*
For LBORRES and TRANSLATED_LBORRES, Workbench shows a precision of 1 instead of 2. VDC-80656*
CQL may not return all possible results when using COMPACT. VDC-80782*
With this release, CQL is able to support statements with many union operations. VDC-80834

CDB - Export

Issue Description Issue No.
The Issue Log for export package generation may not display the issue list. VDC-77846*
Listings may show N/A cells with raw dates and translated units because CQL attempts to apply those functions even when a cell value is null. VDC-77936*
When copying a raw export definition using Save As, after renaming listings within that definition, Workbench shows a warning that the original listings (before renaming) no longer exist and will be discarded. VDC-78124*, VDC-78030*
If a user attempts to edit the Title of an Export Listing, Workbench removes all listings from the Export Definition. VDC-78886*
If a user copies a raw Export Definition with valid, third party listings, they receive the following error: "Cannot save Export Definition. Export Definition contains invalid listings". VDC-78904*
Workbench may fail to generate export packages due orphaned reference IDs. VDC-79032
Export may fail when a Study has just finished importing a new package, but Workbench has not yet applied the new package to the export definition. VDC-79038
The error message for failed exports shows the full message from the Issue Log. VDC-79156, VDC-79428
UOM columns are truncated in SAS packages for raw-type exports. VDC-79382
When copying a raw export definition using Save As, after renaming listings within that definition, Workbench doesn't copy any included query listings with the "The following no longer exist and will be discarded: {listings}" warning. VDC-79942*
If a user renames a Core Listing in a raw export definition and then uses to use Save As, Workbench copies that listing with the original name. VDC-79968*
With this release, CDB has returned to treating BIGINT as numeric fields, so that BIGINT fields will use periods (.) for blanks. VDC-80211

CDB - Import

Issue Description Issue No.
Workbench may change the timezone to the site's timezone when importing datetimes from third party sources. VDC-78799
The Intentionally Left Blank reason value in export packages should be in quotations. VDC-79018
The Import > Packages page may take a long time to load or not load at all in Studies with large numbers of packages. VDC-79028
A Study may get stuck in the New status for import. VDC-79744
If the import manifest has "generate" set to "false", and the import CSV contains an unmatched Event, the import fails without an assigned error code. VDC-80203
With this release, all number Items for Labs are imported into Workbench as strings. VDC-80583

CDB - Listings

Issue Description Issue No.
Users receive an error when attempting to filter a listing by @ItemGroup.SeqNbr with the UI Sort & Filter menu. VDC-73687
If a Study includes multiple Sources, or if multiple Studies have Forms and Item Groups with the same Names, listings may get stuck in the Pending status when a user attempts to enable Review for those listings. VDC-79127
When a listing includes data from many instances of repeating Forms and Item Groups, Workbench may unexpectedly truncate records in the Listing UI, while still including those records in the generated CSV. VDC-79144
With this release, we removed the row-level decoration for Item Group Sequence. VDC-80018*

CDB - Queries

Issue Description Issue No.
Users may receive a "failed to retrieve cell details" error when attempting to open a query against a third party data item. VDC-78818*
The EDC Closed Queries listing includes the @QRY.Name column twice. VDC-79140

Coding

Issue Description Issue No.
For WHODrug and JDrug, the Route and Indication columns of the Code Request listing are in the wrong order. VDC-77574*
Impact reports fail when a Synonym is missing an Assigned code. VDC-77827
The Query Status on Medical Coding Request Queries doesn't update to "Closed" when the query is closed. VDC-77841
When a Code Request is approved, Vault doesn't populate the Indication or Route to the newly created Synonym. VDC-78169*
The Code All Forms and Update Synonym List email notification doesn't display the number of Code Requests for which coding or synonym creation failed. VDC-78182*
Even after autocoding from dictionary, MedDRAJ may not return any search results for a Verbatim. VDC-78387*
If a Verbatim contains an apostrophe ('), coding managers are unable to approve the Code Request if Apply to Synonym List was selected. VDC-78402
Not all expected coding requests are generated after running the Reconstitute Code Request job. VDC-80710
Partial verbatim matches don't garner suggestions in Coder. VDC-80816*

Coding Configuration

Issue Description Issue No.
Users may be unable to map Adverse Event forms to a MedraJ Dictionary Version. VDC-78212

Compare Versions & Vaults

Issue Description Issue No.
Vault doesn't show the Name of the Study for Study 2 in the Select Options dialog when Study 2 is in a different vault than Study 1. VDC-78674

Data Entry

Issue Description Issue No.
Users receive a server error when freezing an Item after unfreezing an Event or Form. VDC-68024*
Editable grids don't display or save all entries. VDC-79051
Action menus display on every row of the editable grid in completed forms with repeating Item Groups. VDC-79672*
In some cases, users can't edit the first row of an Editable Grid after selecting a new row. VDC-80111
Progressive Display doesn't work correctly on forms using Editable Grids. VDC-80127
Users may receive a server error when attempting to reset an Event. VDC-80684
Date Item values aren't reformatted and stored in the correct format. VDC-81216

Deployment

Issue Description Issue No.
Users are shown an error message when attempting to delete an environment in some cases. VDC-78792
Users may find unexpected differences related to Review State when running a Vault Comparison job (Diff report). VDC-79421
Users may find unexpected differences related to Review State when running a Vault Comparison job (Diff report). VDC-79527
Deployments fail with an error message about the dictionary release version when using a third party coder. VDC-80712

Developer Features

Issue Description Issue No.
Site and Subject IDs are missing leading zeros in the response for Retrieve Code Requests. VDC-78754
Users can't set Items marked as derived via API. VDC-79036
With this release, CDMS APIs (starting with v21.2) accept both simple and complex values for the Content-Type parameter ("application/json" or "application/json; charset: utf-8"). VDC-79368

Integrations

Issue Description Issue No.
SDV Complete Dates don't transfer to CTMS. VDC-78496

Jobs

Issue Description Issue No.
In study data extract output, for a custom object that has a field referencing the Event object, the custom object's file shows the ID for the Event, instead of the Event Name. VDC-78150*
Vault lists the Override Lab Normals Report operation in the Job History. VDC-78512*
The Audit Trail Export by Study job fails in Production. VDC-79903

Labs

Issue Description Issue No.
A query doesn't fire in Labs when units don't match. VDC-78106*
Users can't add certain approved Lab Locations. VDC-78403*
The Outdated Normals Report job and the Update Outdated Lab Normals job fails with errors. VDC-79034

Randomization

Issue Description Issue No.
The Audit Trail for Unmasked Data is missing kits/devices. VDC-69600*
In Internet Explorer™, Treatments don't display, and Vault doesn't allow users to add new Treatments. VDC-75377*
Dynamic Site Assignment should be disabled when randomizing by Study. VDC-76443*
Multiple pages in the Randomization tab don't display in the Internet Explorer™ browser. VDC-77871*
The "Reveal Treatment" action is disabled in Data Entry until the user views a form. VDC-79225

Role & User Management

Issue Description Issue No.
Users may receive a server error when attempting to access a Permission Set from Tools > System Tools > User Defined Permission Sets. VDC-74604*
Read Only roles can't view queries in 21R2. VDC-79202
Users with Read permissions can't access Subject records. VDC-79772

Rule Editor

Issue Description Issue No.
Rules on common Forms with repeating Item Groups that use only aggregate identifiers return [null]. VDC-78395
Users may receive an "Undetermined" error when writing a rule expression using the Max() function. VDC-78800
The sequence numbers for aggregate objects should be sorted numerically, not alphabetically. VDC-79697*
Item groups on some forms don't display in the Rule Details section when the form is first selected. VDC-80330

Rule Execution

Issue Description Issue No.
Vault doesn't populate the Subject or Event Group columns for an Add Schedule or Add Event rule that removes the Event Group or Event. VDC-56691*
Vault doesn't record the correct value in the Forms column of "rule_details.csv" for the execution of Add Assessment rules. VDC-57776*
Users receive a server error after deleting an Unscheduled Event in which the Event Date is the controlling value for a dynamic Event in that Event Group. VDC-72978*
Users receive incorrect data validation errors when attempting to execute a rule. VDC-79217

SDV & DMR

Issue Description Issue No.
In certain cases, the Event & Form List panel may not display the expected SDV and DMR status icons, even though those statuses are correctly represented in the Content panel. VDC-78385*
In certain cases, the Event & Form List panel may not display the expected SDV and DMR status icons, even though those statuses are correctly represented in the Content panel. VDC-78411*

Signatures

Issue Description Issue No.
Users are shown an error message when attempting to edit a signature definition in Studio in a study that is configured with Data Model 1.0. VDC-80256*

Study Administration

Issue Description Issue No.
Study imports fail when an environment other than Development is selected. VDC-77932
500+ warnings display in Validation reports when users are attempting to deploy to Production. VDC-79130

Study Data Extracts

Issue Description Issue No.
The Study Data Extract job fails when the user adds a "Space" field to the Page Layout of the Custom Object. VDC-78067*
Scheduled SDE jobs fail with errors when the user selects "Run Now." VDC-78712*
The Study Data Extract job fails inexplicably. VDC-78829
New SDE jobs fail inexplicably and current jobs remain "In Progress." VDC-79117
The Study Data Extract job fails with an error for some users. VDC-80120

Study Design

Issue Description Issue No.
Users receive errors when running the validation job. VDC-79062
Some users can't compare study versions between a dev study and production study because the production vault doesn't appear as an option to compare. VDC-79760
The rule link in the hover-over text of the lightning icon in the Studio > Schedule grid redirects the user to the wrong rule editor version. VDC-79946*
The first section of the Labs tab in the SDS should be titled "Local Lab Configuration" instead of "Randomization Configuration." VDC-81330

UI & Performance

Issue Description Issue No.
If a statement has multiple uses of the Label function within a union, CQL may take a very long time to return results. VDC-69648
Workbench may be slow to load the Public Listings page. VDC-71512
Users are shown a server error when attempting to create an open query on a blank frozen form. VDC-72078*
Vault is slow to load the list of Rules in the Copy From Study dialog. VDC-75265*
In Labs > System General Settings and Study General Settings, the subtab header and scrollbars flicker. VDC-77501*
EDC Tools doesn't show all studies that the user has access to unless a specific organization is selected. VDC-77565*
Users experience performance issues in the Data Entry tab when using the Chrome™ browser on Microsoft® Windows 10. VDC-77764
In EDC Tools > Review Plan Assignment, subtabs may not display correctly. VDC-78079*
Users are shown an error message when resetting an event that is Marked for Removal. VDC-78139*
The help content set in the Properties Panel in Studio doesn't match the help text displayed in the Review tab. VDC-78529
In certain circumstances, Vault may not display the SDV or DMR status icons in the Event & Form List panel. VDC-78769*
Derived items don't populate in the Data Entry or Review tabs for certain forms and subjects, despite being visible in audit trails, detail PDFs, and data extracts. VDC-78813
Users are shown a network error message when copying a training mapping from a previous study. VDC-79213
Users receive a server error message when attempting to submit SAE forms. VDC-79377
Certain database tables may have extra rows, resulting in performance issues. VDC-79429*
Users are shown a server error message when entering a Query ID in Review > My Studies > Queries. VDC-79525
The Synonym List detail approval suggestion generation takes too long. VDC-79619*
Users are shown a server error message when attempting to open associated links in a Concomitant Medication form in Data Entry. VDC-79899
For certain custom listings, CQL may take longer than usual to return results. VDC-79933*
Users are redirected to their subject list in Data Entry after entering data into a form. VDC-79999
Users are redirected to the bottom of the page when clicking "Close Query" in the Review tab. VDC-80207
Editable grids with multiple item groups that begin with a question and are configured with Progressive Display don't allow the user to enter data in the first row. VDC-80308
Users are shown an error message when attempting to view an Event Audit Trail and failed Detail PDF job. VDC-80320*
Users are redirected to the subject list when completing a form that triggers Progressive Display in Data Entry. VDC-80559
The deployment history page doesn't load in EDC Tools. VDC-81078

Vault Administration

Issue Description Issue No.
Admin users can't delete subjects or set event dates. VDC-80814*