Fixed Issues in 21R3

Pre-Release Date: November 8, 2021 | CDB Pre-Release Date: November 12, 2021 | Release Date: November 19 & December 3, 2021

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

An asterisk (*) next to the issue number denotes an internally found defect filed during the development of Limited Release features.

Highlighted Issues

The fixes for the issues highlighted below may introduce behavioral changes from the previous release.

Category Description Issue No.

Audit Trails

Issue Description Issue No.
The audit trail incorrectly shows that a site accepted a PDF when a new PDF was being generated. VDC-82962

Blank & Detail PDFs

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

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
When the date item's value is null, CQL returns "COMPLETE" instead of null for the Unknown() function. VDC-79464
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
For LBORRES and TRANSLATED_LBORRES, Workbench shows a precision of 1 instead of 2. VDC-80656*
CQL may return an unknown column error when the from clause includes the source. VDC-80744*
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
The DateFormat function may unexpectedly alter the time of a datetime when a time format isn't specified. VDC-80979
The SDTMDateFormat function doesn't return unknown dates correctly. VDC-82916*
For Forms with repeating Item Groups, @Form.ILB may return 'False' even when the Form is marked as Intentionally Left Blank ('True'). VDC-82999
CQL returns a "Data too long" error when the CodedTerm column value is longer than 500 characters. VDC-84489
For a UNION with UNION in a subquery, CQL returns a "The used SELECT statements have a different number of columns" error. VDC-84548

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*
Workbench may fail to generate the export package if an Export Definition contains a listing that uses SHOW or DESCRIBE. VDC-78706*
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*
The Intentionally Left Blank reason value in export packages should be in quotations. VDC-79018
Workbench doesn't show the correct error message when the Title and Short Title of a listing are the same. VDC-79024
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
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, export packages expire after 30 days. VDC-80206*
With this release, CDB has returned to treating BIGINT as numeric fields, so that BIGINT fields will use periods (.) for blanks. VDC-80211
If a new Source is added to a Study after a user creates a raw-type Export Definition, Workbench modifies the CQL unexpectedly when the user adds those new Core Listings to the export definition. VDC-81013
In certain studies, Workbench may not use the SDTM Name as the column label when the "Auto generate column labels with EDC SDTM name" option is selected. VDC-81174
With this release, we returned to LF line endings for CSV exports, instead of CRLF. VDC-82011

CDB - Import

Issue Description Issue No.
Transformation of third party data may take longer than usual. VDC-78367*
Workbench may change the timezone to the site's timezone when importing datetimes from third party sources. VDC-78799
Import and study load may fail due to a lockout error. VDC-78843*, VDC-82102
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
When Workbench is importing packages for multiple Studies at the same time, import may fail due a timeout error. VDC-80247
With this release, all number Items for Labs are imported into Workbench as strings. VDC-80583
Workbench may not create TRANSLATED and UOMTRANSLATED columns for low and high Lab Items. VDC-81119
The In Progress filter on the Import > Packages page doesn't display the correct number of results in the filter menu. VDC-82123
When two sources have a listing with the same Name, and one of those sources is deleted, after Workbench imports data for the other source, the listing may be incorrectly marked as Invalid. VDC-82161
Workbench may not display the data from the most recent import even when that import finishes successfully. VDC-84579*

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
Workbench doesn't apply any filters when generating CSVs for Review Listings. VDC-78203*
Workbench may not display the Filter icon on filtered columns when the column is an Item within a repeating Item Group. VDC-78700
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*
The Batch Action buttons may wrap unnecessarily on Review Listings. VDC-85608*

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

CDB - Views

Issue Description Issue No.
Workbench doesn't show the appropriate error message when a user attempts to use @Form or @ItemGroup attributes other than SeqNbr in projection of a View's CQL. VDC-83530*

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*
Propagate Code autocodes the selected Coding Request and matching requests on other forms but doesn't autocode matches in the same form. VDC-81044*
The ID column is in the incorrect position on the Verbatims page when a study uses a third party coding system. VDC-82116*
Some users experience slow performance and backup while autocoding. VDC-82637
Synonym list dictionary releases can be set to reference non-existent records when upversioning. VDC-84460
Users are shown an error message and are unable to lock a study in Coder Tools. VDC-85386

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.
In some cases, outputs resulting from vault comparison jobs are missing rules. VDC-72708
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
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

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
Users receive a server error message when attempting to submit SAE forms. VDC-79377
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
A linked ConMed form shows two ID's for the same link. VDC-80408
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
Lab forms don't autosave in Data Entry. VDC-81375*
Users may receive a server error when attempting to enter dates and datetimes in Japanese. VDC-81651
Users may receive a server error when attempting to enter 12 hour format dates in Japanese. VDC-81652*
Vault creates a new reference instead of a new row within the editable grid when users click "+New Row." VDC-81825
Users are shown an error message when completing a Protocol Deviation form for a subject that was transferred to a new site. VDC-83213
When a user attempts to edit a Form that uses an editable grid Item Group and has a Form Link, Vault may show a blank page. VDC-86857

Deployment

Issue Description Issue No.
Deployment fails in vaults where the Multi-Role Security feature is enabled. VDC-78162*
In multi-role security vaults, deployment may fail if a permission set is assigned to two custom Study Roles, but only one of those roles is on the Deployment List. VDC-78278*
Users are shown an error message when attempting to delete an environment in some cases. VDC-78792
500+ warnings display in Validation reports when users are attempting to deploy to Production. VDC-79130
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 regarding the dictionary release version when using a third party coder. VDC-80712
Study deployments may fail unexpectedly. VDC-85134

Developer Features

Issue Description Issue No.
The Retrieve Queries API doesn't return Item Group or Item details in the response. VDC-76692*
Site and Subject IDs are missing leading zeros in the Retrieve Code Requests response. VDC-78754
Users can't set Items marked as derived via API. VDC-79036
With this release, EDC 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. VDC-78496

Jobs

Issue Description Issue No.
The Preview for the Run Rules job may show queries being opened on the wrong Item for lab panel Items. VDC-70877
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
Closeout PDFs download with multiple issues including incorrect subjects and error messages. VDC-81916
When the Workbench Export job fails, Vault applies the Cancelled status instead of Failed. VDC-82015
The EDC Workbench job fails due to errors and with a "cancelled" status but no errors are identified in the error log. VDC-82361
Study Data Extracts jobs in SAS format may fail if the Name of an Item that is not of the date data type ends with "DT". VDC-82541
Audit Trail Export by Subject jobs fail inexplicably. VDC-82938
Users can only generate audit trails for one subject at a time when using the Audit Trail by Export job. VDC-85193

Labs

Issue Description Issue No.
The Override Normals report doesn't have the columns in the correct order. VDC-75571*
Users are able to run labs reports for locked Studies. VDC-77989*
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
Users are prompted to run the "Update New Lab Locations" job after running the "Outdated Normals Report" but the lab locations job fails. VDC-81075
Lab Managers can't run any normals-related jobs if a restricted form is present in the same event as a form. VDC-81946*
Excel and CSV exports of Lab Locations & Normal Ranges display "0.00" as "0E+00." VDC-82153

Localization

Issue Description Issue No.
Tools > EDC Tools > Safety Configuration doesn't load for users with a non-English language. VDC-80525*

Protocol Deviations

Issue Description Issue No.
Users aren't shown an error message when Summary field text exceeds 250 characters. VDC-81182
When users edit a Protocol Deviation, Vault changes the date of deviation and the date identified by one day. VDC-83782

Publishing Validation

Issue Description Issue No.
Users receive errors when running the validation job. VDC-79062

Randomization

Issue Description Issue No.
The Audit Trail for Unmasked Data should show kits/devices. VDC-69600*
In Internet Explorer™, Treatments don't display, and Vault doesn't allow users to add new Treatments. VDC-75377*
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
The Treatment Arm Data column in the Unmasked Data tab doesn't show any data. VDC-82936*

Review Plan Assignment

Issue Description Issue No.
Review Plan Assignment version 3 doesn't assign review plans to casebooks correctly in some cases. VDC-78029*
Users are shown an error message in the New Assignment Criteria dialog. VDC-79480*
Users are shown an error message when attempting to create a Country review plan after creating a Site review plan using Review Plan Assignment v3. VDC-84448*

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 the "Close Query" permission receive an error when attempting to reply to a query. VDC-79259*
Users with Read permissions can't access Subject records. VDC-79772
Unused sites don't get deleted when the user clicks "Delete." VDC-81595
Vault doesn't clear leading spaces during user import, which can cause issues for Federated ID and SSO. VDC-82730

Rule Editor

Issue Description Issue No.
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*
Rules on common Forms with repeating Item Groups that use only aggregate identifiers return [null]. VDC-78395
Users receive incorrect data validation errors when attempting to execute a rule. VDC-79217

SDS & Annotated PDFs

Issue Description Issue No.
The first section of the Labs tab in the SDS should be titled "Local Lab Configuration" instead of "Randomization Configuration." VDC-81330

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-78411*, VDC-78385

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.
With this release, testing Connections in EDC Tools now performs additional checks. VDC-81209*

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
Extracts going to vaultloader are saved in a new vaultloader folder instead of the user's home directory. VDC-80057*
The Study Data Extract job fails with an error for some users. VDC-80120
The ESEQ column labels should say "Event Group Sequence" in the 21R3 version of the SDE. VDC-81079*
SDE jobs for a UAT3 study include study labels from a UAT6 study. VDC-81669
The SYS_PD dataset should have an integer, not text, data type for the ESEQ column. VDC-81901*
Scheduled SDE jobs fail unexpectedly. VDC-82037
SDE jobs fail when extracting data for Form Links. VDC-82120
The SDE job fails due to duplicate column names when exporting as an SAS file. VDC-82641
Users can still run an SDE job with an invalid zip file name. VDC-82662*
Users are unable to download extract files for certain studies after the SDE job has completed. In addition, when the user chooses SAS with XTP files as the extract type, only CSV files are created. VDC-82890
The SDE job fails when exporting as an SAS file. VDC-82988
The SDE job takes too long to run after another SDE job fails. VDC-83587
The SDE job fails when exporting as an SAS file. VDC-83588
The arms and cohorts columns in the SYS_SUB dataset should show the label, not the Vault ID. VDC-84188*
The COLNAME column should be relabeled as FORMEID. VDC-84783*

Study Design

Issue Description Issue No.
Copying an Event Group fails when that Event Group contains a Form with a Lab Panel. VDC-77927*
Users are shown an error message when attempting to copy a form with rules. VDC-79374
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*
Users are shown an internal exception error message when copying a form in Studio. VDC-81967

Study Import & Export

Issue Description Issue No.
Study imports fail when an environment other than development is selected. VDC-77932

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*
The comparison rules grid in Studio should be able to expand and collapse. VDC-74710
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
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*
The Clinical Assessment text is cut off and the user can't see the full question in Data Entry. VDC-79767
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 correct SDV/DMR status isn't reflected in the Event/Forms tree panel for some forms. VDC-80579
The deployment history page doesn't load in EDC Tools. VDC-81078
In Studio, the "Copy" button doesn't disable after the user clicks it, allowing users to click the button multiple times during the copy. VDC-81423
In EDC Tools > Sites, the "(GMT+03:00) Eastern European Time (Europe/Istanbul)" is incorrectly labeled. VDC-81646
Some users can't close queries in Coder Tools. VDC-81648
Form names and labels disappear when the user scrolls to the right while viewing the schedule in Studio in a windowed browser. VDC-81939
The audit trail UI can be inconsistent when User Defined Rules and Custom Triggers attempt to update the derived value at the same time. VDC-82989
Users are shown a server error message in Coder Tools when attempting to update study settings for studies with Review Plan Assignment v2 that has been individually assigned. VDC-85293

Vault Administration

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