common ets errors & solutionsets common errors and solutions this document was created by the...

26
Common ETS Errors & Solutions Published: February 8, 2019 Version: 1.4.2 2019 Version: 1.4.2 2/8/2019

Upload: others

Post on 28-Jun-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

Common ETS Errors & Solutions

Published: February 8, 2019 Version: 1.4.2

2019

Version: 1.4.2 2/8/2019

Page 2: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 1 of 25

Federal Deposit Insurance Corporation

Table of Contents

Document Change History ............................................................................................................................ 2

Points of Contact ........................................................................................................................................... 2

New Features in ETS 1.4.2............................................................................................................................. 3

Types of Error Messages – Definitions .......................................................................................................... 4

Setup/Installation ......................................................................................................................................... 5

ETS Click Once Website Error Codes ................................................................................................. 5

Errors Opening ETS ............................................................................................................................ 6

Login Errors ........................................................................................................................................ 7

Collaboration Issues ...................................................................................................................................... 8

Errors Removing an Exam ............................................................................................................................. 9

Exporting/Printing Issues ............................................................................................................................ 11

Archives, Backups and Distribution Files .................................................................................................... 12

Previously Reported “Known” Issues .......................................................................................................... 15

Appendix A: ETS External Access Cheat Sheet ............................................................................................ 22

Appendix B: Steps to Uninstall ETS and Delete the Database .................................................................... 23

Page 3: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 2 of 25

Federal Deposit Insurance Corporation

Document Change History

Date Version Notes:

2/8/2019 1.4.2 ETS Version Number - 1.4.18360.2 (1.4.2)

New Features in 1.4.2

Edited: Errors Removing Exams, Corrupt Backups, Appendix Reformat

Modified document version to reflect the current ETS version

Points of Contact

Please note: All ETS incidents and/or inquiries, should be sent to the Examiner Help Desk so an Incident

Ticket can be created and tracked internally. All email messages are processed in the order received each

day; however, a Service Desk Agent will respond to your message within 1 business day.

Contact Technical Lead: E-mail: Phone:

DIT Sr. Project Management

Diana Imlay Paul Robillard

[email protected]

Examiner Help Desk (Tier 1)

Allison Davis Marcus Hughes

[email protected] [email protected] (DIT)

1 (877) 334-2999, option 2

ETS Tier 2 (Business Process)

Charles Lacek Russell Eckhardt Jeffrey Diebold Corey Cooley

[email protected]

ETS Tier 3 (Technical Errors)

Karina Michael Anthony Harper Khushnaz Bhot Joshua Zastudil Bimo Yusman

[email protected]

Page 4: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 3 of 25

Federal Deposit Insurance Corporation

New Features in ETS 1.4.2

The ETS v1.4.2 release includes several new, significant enhancements in the following areas: **Please see Release Notes for complete details**

Word Processing:

Copying and Pasting – allows user to Paste with Destination Format; Paste with Source Format; or Paste Text Only, which improves the process of copying and pasting from Word

Formatting – paragraph and list formatting have been changed to inches to correlate more closely with Word

Bullets – improves the process for inserting, tabbing, and undoing bullets, along with adding an additional bullet type

Indentation – tabbing has been “matched up” with Word and converted to inches

Thesaurus – added a Thesaurus tool that allows Searching for and Insert/Replace words

Spell Check – added Skip and Add to Dictionary under the Spell Check function

Dictionary – added a Dictionary tab under the Spell Check function, allowing users to Add, Delete, and Delete All words to a Custom Dictionary

Ruler Bar – added ability to view a Ruler Bar under the Text Tools menu, which allows users to adjust the First Line Indent, Hanging Indent, and/or Left Indent

Find and Replace – provided a fix to the Find and Replace function that could potentially result in user losing changes

Print Preview – Print Preview is now available at both the page and document level

Page Numbers – allows user to select whether they want the Print Preview to show the actual ROE page number(s) or not

Manage Columns:

System automatically cleans up your Manage Columns tab and keeps the Custom columns that are used in any exams under your My Exams

System now does not allow user to create duplicate column names, especially system and built-in names

Fixes problems where corrupt archive files were created due to discrepancies in the Manage Columns function, which usually were identified when Retrieving Historical Data and/or Load as Current Exam under the Open Archive function

Connection Indicator

An indicator will show whether ETS is connected to Central Peer or not

A Reconnect button is provided in the Connection tab to provide a method of reconnecting to Central Peer, if necessary

Page 5: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 4 of 25

Federal Deposit Insurance Corporation

Types of Error Messages – Definitions

1) Error Message with dialogue box and no details. For example, and error accepting assets.

2) Something Unexpected Happened (SUH): An error within the application that includes event details.

For example, a SUH printing the Report of Examination.

3) Shell Has Stopped Working The entire application freezes, becomes non-responsive, and crashes.

Page 6: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 5 of 25

Federal Deposit Insurance Corporation

Setup/Installation **Before installing ETS, please verify prerequisite software installations using ETS-FREDDY**

ETS Click Once Website Error Codes

The following errors may occur during the Click Once installation (https://ets.fdic.gov/)

Error: Message: Resolution:

300 Unexpected error occurred during installation

Add https://ets.fdic.gov to the trusted zone in Internet Explorer under Tools > Internet Options > Security > Trusted Sites.

Alternatively, the user can save the Setup.exe file to the Desktop and then run. When this error is received, the Virus Protection is set up so that executables are not allowed to run directly from the Click Once website, but can be saved to the desktop and run locally.

This issue may also occur if certain pre-requisites are missing.

301 The deployment manifest URL supplied is not a valid URL

Verify .NET Framework is installed, all Microsoft Updates are installed, and there are no pending restarts on the computer.

Ensure ets.exe is added as a trusted site

302 This program requires Windows 7 or higher with .NET Framework 4.0

Change the LAN settings on the Connections tab in Internet Explorer under Tools > Internet Options > Connections > LAN Settings. Uncheck “Use a proxy server…” and check “Automatically detect settings".

Add https://ets.fdic.gov to the trusted zone in Internet Explorer under Tools > Internet Options > Security > Trusted Sites.

Install recommended .NET Framework from the latest Prerequisite document.

303 Error occurred while accessing web server

Change the LAN settings on the Connections tab in Internet Explorer under Tools > Internet Options > Connections > LAN Settings. Uncheck “Use a proxy server…” and check “Automatically detect settings".

If the above does not work alone, also delete the user’s temporary internet files, restart the browser, and try again.

On some State and Fed user’s machines, antivirus programs may try to block the ets.exe file/communications. The antivirus software needs to be configured to allow the ets.exe file; this may need to be completed by an IT administrator. To verify the antivirus program is blocking the setup, open the Windows Event Viewer and view the application logs.

304 Access to the local file was blocked by the operating system

On some State and Fed user’s machines, antivirus programs may try to block the ets.exe file. The antivirus software needs to be configured to allow the ets.exe file; this may need to be completed by an IT administrator. To verify the antivirus program is blocking the setup, open the Windows Event Viewer and view the application logs.

This may also occur if there are Windows Updates pending or recently installed and require a restart.

305 The installation files are corrupted

Verify .NET Framework is installed, all Microsoft Updates are installed, and

there are no pending restarts on the computer.

Ensure ets.exe is added as a trusted site

306

You don’t have the required level of permissions on the local computer in order to run the application

User permissions on the machine are restricting the ability to run ets.exe. The Click Once website shouldn’t require administrative rights to install.

To test, try running the Setup.exe file with elevated credentials and see if the installation is successful. o If yes, uninstall ETS and delete the ETS database from SQL Server. The

user profile must have read/write access to the installation location. o If no, verify prerequisites using ETS-FREDDY and retry.

For further assistance, please contact the FDIC Help Desk [email protected] or 1 (877) 334-2999, option 2

Page 7: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 6 of 25

Federal Deposit Insurance Corporation

Errors Opening ETS

**Before installing ETS, please verify prerequisite software installations using ETS-FREDDY**

1) Unable to Create Root Container

When starting ETS the error message above is received and ETS will not open. These errors become

more frequent after installing Windows Updates associated with the .NET Framework.

Resolution: Navigate to the folder on the users C:\ drive below and delete the entire Apps\2.0

directory. Then reinstall ETS.

C:\Users\[%LocalUser%]\AppData\Local\Apps\

Warning: This work around will require all ETS applications (ETS, ETS-ALER, ETS-FREDDY, File Transfer

Utility) to be reinstalled, however, their respective databases will remain intact (SQL Server). Desktop

icons will change to a generic icon after deleting the Apps\2.0 folder, and double-clicking on the

generic icon will prompt a reinstall. You do not need to go to the ETS website. You do not need to

uninstall the ETS application from the Control Panel.

2) Something Unexpected Happened (SUH)

Usually, the database (sqlpackage.exe) doesn’t get deployed properly or the entire deployment

process fails.

Page 8: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 7 of 25

Federal Deposit Insurance Corporation

Resolution:

I. Verify ETS Prerequisites are installed using ETS-FREDDY

a. ETS 1.4.2 incoporates changes to the Asset Review Reports. Verify Crystal Reports

Service Pack 18 is installed - Crystal Reports 64 bit (Web Link)

II. Delete the ETS database and try again - Appendix B

III. If another ETS account has been activated under a different Windows profile and the ETS

database is not removed properly, fragments of the database can remain on the local disk.

Within the ApplicationEvents.log you should see:

Exception when installing/updating the database:

*** Could not deploy package

Error SQL72014: .Net SqlClient Data Provider: Msg 5170, Level 16, State 1, Line 1 Cannot

create file ' C:\Program Files\Microsoft SQL

Server\MSSQL11.FDIC2008\MSSQL\DATA\ETS_Primary.mdf' because it already exists.

Change the file path or the file name, and retry the operation.

Error SQL72014: .Net SqlClient Data Provider: Msg 1802, Level 16, State 4, Line 1 CREATE

DATABASE failed. Some file names listed could not be created. Check related errors.

As a workaround, a Windows Administrator will need to navigate to the destination

highlighted above and delete the ETS_Primary.MDF as well as the ETS_Primary_Log.LDF files;

then reopen ETS so a new database can be built.

For additional assistance, please contact the FDIC Help Desk [email protected] or 1 (877) 334-2999, option 2

Login Errors

1) Authentication Failed

When logging into ETS, users should be entering their Extranet e-mail and password to gain access to

the ETS services. ETS does not directly manage these credentials.

Resolution: Verify the user can log into Extranet.

Page 9: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 8 of 25

Federal Deposit Insurance Corporation

For additional assistance, contact the FDIC Help Desk [email protected] or 1 (877) 334-2999, option 2.

See Appendix A for the External Access Cheat Sheet.

2) Cannot Activate User Account

Users must request access to ETS via an FDIC ARCs request. Please contact your Regional Information

Security Advisor or the Examiner Help Desk ([email protected] or 1 (877) 334-2999, option 2) to

facilitate this request.

Collaboration Issues 1) Local Collaboration - Configure URL/ACL

Users are unable to see one another when connecting to a LAN (i.e. Hotspot, MiFi, ARUBA)

From Collaboration.Log file:

Collaboration: [11/26/2018 10:08:18.2375400 -05:00] - Not opening network host:

System.ServiceModel.AddressAccessDeniedException: HTTP could not register URL

http://+:5555/ETSCollaboration/. Your process does not have access rights to this namespace

(see http://go.microsoft.com/fwlink/?LinkId=70353 for details). --->

System.Net.HttpListenerException: Access is denied

Explanation:

ETS can share information two different ways: 1) using Central Peer, and 2) using Local

Collaboration**. In this case, the user could still communicate with ETS’s Central Peer, however an

error on the LAN was occurring while trying to locally collaborate with other users in the office on the

same subnet.

**Local Collaboration communicates using a reserved Namespace. WCF services and clients can

communicate over HTTP and HTTPS. The HTTP/HTTPS settings are configured by using Internet

Information Services (IIS) or through the use of a command-line tool. When a WCF service is hosted

under IIS HTTP or HTTPS settings can be configured within IIS (using the inetmgr.exe tool). If a WCF

service is self-hosted, HTTP or HTTPS settings are configured by using a command-line tool.

Resolution: At a minimum you will want to configure a URL registration, and add a Firewall exception

for the URL service ETS will be using. To configure the URL/ACL, run ETS-FREDDY as an Administrator

Page 10: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 9 of 25

Federal Deposit Insurance Corporation

and execute the check for all 3 sections. Once the checks are complete, the URL/ACL should be red

and not configured, simply click the “Fix” button URL/ACL will be configured automatically.

2) Cannot Connect to Central Peer

Users will see this icon in the top right-hand corner when they are disconnected with Central Peer.

Resolution:

1) Verify Network Connectivity

a) Try to access a webpage i.e. www.google.com

2) Click the button from the Connections Tab

3) Restart ETS

4) Restart Computer

5) Reboot Network Device i.e. router, modem, hotspot, MiFi

6) Contact the Examiner Help Desk

a) The user may have temporarily lost access to the ETS Active Directory groups that

provision access to ETS Central Peer.

Errors Removing an Exam 1) Error 276

Resolution

Please contact the Examiner Help Desk to acquire a script that will resolve this issue.

2) Error 280/295

Page 11: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 10 of 25

Federal Deposit Insurance Corporation

Resolution

Please contact the Examiner Help Desk to acquire a script that will resolve this issue.

3) Error 290

Resolution

Please contact the Examiner Help Desk to acquire a script that will resolve this issue.

4) Error 317

Resolution

Please contact the Examiner Help Desk to acquire a script that will resolve this issue.

5) The Selected Examination is Gathering Artifacts and Cannot Be Deleted

Resolution

Please contact the Examiner Help Desk to acquire a script that will resolve this issue.

Page 12: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 11 of 25

Federal Deposit Insurance Corporation

Exporting/Printing Issues 1) One or More Errors Occurred

The user is trying to print a document. The application may freeze or become unresponsive, forcing

users to restart ETS.

Resolution Verify the correct version of Crystal Reports is installed using ETS-FREDDY. Verify the

printer is online and operational. Occasionally, custom ROE templates can cause printing issues.

Contact the Examiner Help Desk for additional assistance.

2) Something Unexpected Happened

With the ROE open, the user is trying to use Print Preview. While browsing through pages the user

may receive a SUH

Resolution Verify the correct version of Crystal Reports is installed using ETS-FREDDY

Page 13: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 12 of 25

Federal Deposit Insurance Corporation

Archives, Backups and Distribution Files 1) Error in archiving: One or more errors occurred

This issue occurs when importing PDF files as a work paper, as opposed to attaching them. When

ETS imports a work paper it gets converted to XAML and, occasionally, imported PDF files do not get

converted properly. When you attempt to open the file, nothing appears, and no error is displayed.

Resolution: You can create an archive without the Team Files, or you can try to identify which

attachments are causing the problem and remove them. As an EIC or Team Member (Reviewers do

not have visibility into Work Papers), go to the Exam Management Tab and locate the Document

Save List (far-right). This will produce a list of all documents in this exam:

Select all exam documents and export (as .pdf)

When the export process finishes, it will identify files that could not be exported. These are the

problematic files and need to be deleted.

Page 14: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 13 of 25

Federal Deposit Insurance Corporation

2) Cannot Share Changes

ETS has a built in feature to prevent an exam team member from becoming “out-of-sync” with the

rest of the exam team. If an ETS team member becomes out of sync, ETS places those users in a

manifested state. If the user wasn’t put in this state, the way ETS shares data implicitly there would

be a possibility of overwriting already completed data. As a result, the out of sync user is placed in

this Cannot Share Changes state.

Resolution: As described in the error message, the user must first remove the exam, and then load an

ETS Distribution Package (file for offline sharing) from the EIC.

**Before creating a new distribution package, the EIC should ensure the out of sync team member is

properly listed as a team member. Only ETS users listed as a team member at the time the file is

created will be able to import this distribution file.

3) Cannot Load Backup/Archive/Distribution Users have been reporting “corrupt” files created by ETS.

Typically users will receive this error message when importing a bad file.

Because these files are generally very large in size (average >250MB per file), there is a relatively

greater risk associated when creating and/or sharing ETS files (i.e. Network Drive, Could, etc.) .

Users should maintain good practice when creating and/or sharing ETS file - validating they actually

work before and after transmit.

Resolution: As a general rule of thumb, users should follow these instructions for creating ETS files:

I. Always save files to your local C:\ drive first, then copy to desired location (i.e. Network

Drive, FDICConnect, Internet Shared Location)

Page 15: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 14 of 25

Federal Deposit Insurance Corporation

II. Upload files while on an optimal internet connection (i.e. Hard-wired, Field Office LAN)

III. Compare the file size before AND after uploading to its final location. Sizes should be

identical.

IV. Report all corrupted messages that cannot be resolved to the Examiner Help Desk.

Page 16: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 15 of 25

Federal Deposit Insurance Corporation

Previously Reported “Known” Issues

ID Title

417811 Resolve an issue with Central Peer disconnected

416392 Resolve an issue with using bold and other formatting types in Templates

371862 CP-Reconnect button does not establish connection

412400 Ruler - Margins not aligned with editable sections within tables

405808 Bullet List - Deleting selected partial list

287340 08.60 - Multiple Examiner Playlists displayed individually When Loading Archive as Current Exam

405779 Undo - Undoing a highlight or the font color does not reverse to original

405778 Change Case - Changing is the case of the list item does not behave as expected

376641 02.85 - Renaming user-defined migration reductions/additions can result in incorrect figures on

migration ROE pages

376215 02.90 - Additions portion of Loan Migration ROE page disappears after entering user-defined

additions

317573 04.60 - Importing Templates into Admin Site does not work

329534 04.70 - Asset Review Reports - should be 30 days or more not greater than 30

263724 05.25 - Update Purge Script to Implement Workaround

413368 508 Compliance - Manage Columns dialog windows

232831 05.20 - Timeout set to 200 min instead of 30 min

413802 508 Compliance - Asset Review Reports

413806 508 Compliance - Bullet types

413810 508 Compliance - Spell Check dialog window

414130 508 Compliance - Ruler and Print Preview Page number check box

232843 04.55 - DOE Page Bio Alignment Issue

413867 508 Compliance - Thesaurus

402982 Lists: Bullet/Number sub- list remains a sub-list after clicking bullet/number list icon

385726 Accepting ORE Securities -Phantom Assets

387195 Historical Archive - Unable to load a historical exam archive - receive SUH

Page 17: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 16 of 25

Federal Deposit Insurance Corporation

385650 Analysis: Playlist Sorting: sorting in Asset Grid does not refresh

385669 Paste with Source Formatting-List: Pasting Compliance and EA page that contains list numbering

does not preserve the source formatting for the list

385663 Bullet List Formatting after Pasting: Pasting Bullet List from Word not Formatted correctly

385664 Bulleted List - Unable to merge two lists together

385660 Bullets-Sub-Bullets moving independently

385638 Analysis: Thesaurus: Launching the Thesaurus causes shell froze error message

385722 Inconsistent recognition of misspelled words when using Spellcheck "Add to Dictionary" function

385666 Team Member Profile: SUH when changing editing team member role

385732 Inconsistent display of names in Team Member related dialogs

385723 Typing lag when stopping spell check to modify the document

385652 Spell Check - Misspelled possessives are not recognized

379405 Grow/Shrink - Bulleted cell items does not grow/shrink at the same rate

260091 03.25 - ETS SQL consuming hard drive disk space

391146 04.00 - Unable to Find exam when Trust Profile Matrix record is set up in ViSION

368242 Connection submenu from the Connection icon - clicking anywhere on the line causes

Collapse/Expand state to toggle

358156 508 Contrast setting of the Manage Columns dialog window

358790 Mouse is locked when dialog is dragged

342198 Whitespace spill over into the non-editable section of the page

342211 GC - improve on suggestion for two periods separated by a space (. .)

342213 Page Up/Down keys are malfunction inside the second opened editable section

342215 Leadsheet status not updated into complete when loans/linesheets are set to complete

232890 04.90 - Migration Grid Print does not print top header

287987 02.95 - INC0155847 - Migration Analysis Contains Duplicate Loans

368268 03.40 - Migration Analysis Grid (Loan and ORE) - "Edit Migration Data" icon is grayed out

265739 02.80 - ROE Migration Pages Do Not Display Reductions or Additions Categories/Figures

232819 04.30 - Updates to just the loan amount does not save on the TE page because the total is not

automatically updating

Page 18: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 17 of 25

Federal Deposit Insurance Corporation

337992 Tab context menu is broken during editing

232837 04.65 - Cannot save Exam Profile for Independent Type exam when change agency if type previously

was Joint

232355 04.00 - ETS does not display an error message when an external user enters incorrect credential

after successful activation

393910 INC0347039 - Custom Template Printing Issues (SUH)

388560 04.70 - Data removed from Applied to Borrowers linesheet templates

232822 04.75 - UBPR image overlays the exams grid in the backstage area

314163 INC0221191 - CSV Export Creates Extra Columns

232826 04.80 - SQL error during import process not properly handled

376926 05.00 - SUH Adding Loan to Relationship After Running Custom Queries and Sorting by Assigned

CIF

232835 05.40 - Display numbering on TE page is skewed after 4th loan to the same borrower is selected

247873 05.80 - Issue with report pages when bank switches filing Form 041 to Form 031

232839 05.80 - ETS does not properly handle attachments in ALERT1.x archives retrieved as secondary

exams

233248 05.99 - Duplicate assets in data packages

232846 06.20 - BreakPageBefore tag inside a table causes SUH

266636 06.50 - Investigate error when retrieving assets from historical archive

301026 06.50 - Investigate Error Loading Archive - SqlException (0x80131904): Violation of PRIMARY KEY

constraint

301024 06.50 - Investigate Error Loading Archive - System.NullReferenceException

(HistoricalDataManager.cs:line 272)

232847 06.60 - Corrupt CSV File created by FREDDY

232852 06.80 - Management List totals are off by 1

260056 07.00 - Loading of Call/UBPR Data on pages takes longer

237073 07.00 - Selecting the same option for Agency and Other Agency cause error when saving

232854 07.00 - Compare to ViSION shows incorrect error message for a new offline exam

235877 07.00 - INC0043408 - Incorrect Duplicate exam indication when modifying exam data

254182 07.00 - Importing admin files for CRE Workprogram - error message

315979 07.00 - Add GL Adjustment button inaccessible after number of GL adjustments added

Page 19: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 18 of 25

Federal Deposit Insurance Corporation

232856 07.40 - Related assets sharing a linesheet are not marked as uncomplete on the leadsheet

413808 508 Compliance - Formatting

233244 07.70 - Reviewer does not see the changed page display name in ROE in Print Preview when user

Previews the Document

232862 07.80 - Inconsistent behavior when selecting all in group linesheets after sort

232864 08.00 - View All Columns View (Alpha) doesn't allow scrolling

232866 08.25 - Sorting error in comments section of linesheet

232867 08.40 - Text truncation and spillover: .RTF version

333445 08.50 - Templates containing scor in their name pulls in SCOR list

232870 08.60 - Multiple Examiner Playlists of Same Name

233048 03.80 - Ratios not populating

344890 08.70 - INC0273017 - ETS Freezes Importing Assets w/ Solo Decimal in Currency Field

233083 08.80 - Errors occurred on Other Loan Findings Report

344526 9.00 - Import File Converter does not convert when the source file had incorrect data format

253669 09.00 - Left-click on Meetings or Committees rows in those grids does not highlight selection

232874 09.00 - Find & Replace function does not work if formatting within a word is varied

265565 09.00 - Additional Loans Display on Team Members' Leadsheet after Another User Discards Portfolio

and Re-Scopes Loans

260489 09.00 - Text cutoff on DOE page in the Document Print Preview

280056 09.10 - Reverted Aliases Don't Share

274125 09.20 - Adjusted Value for removed CDR fields causes OOBI to fail to load

302586 09.30 - Commit to Portfolio/Rescan Data/Discard Data button does not work after hiding the Cleanup

ribbon

232878 09.40 - Portfolio Summary & Import Summary - count of the number of borrowers should be the

number of unique combinations of Borrower IDs and Short Names, not just Borrower IDs

232888 Running script DBReset.bat file under ETS/Scripts folder got errors in PIE/CIE/QA/PROD

232895 10.00 - Open Location on some Call Report elements goes to a different schedule

232815 10.00 - ETS indicates that SAER Comment was uploaded successfully, however, VISION does not

receive the comment for certain exams

307121 10.10 - Call Reports refresh when gathered on different exam

Page 20: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 19 of 25

Federal Deposit Insurance Corporation

232897 10.40 - Editing an Institution Profile via the "Enter" key immediately navigates back to the Recent

Institutions screen

232898 10.50 - Work Paper and Exam Doc Panes render incorrectly when unpinned and then viewed on top

of the UBPR

232899 10.60 - Custom Formulas not refreshing when creating in new template

232903 10.60 - Spelling Error on Collateral Templates - Livestock vs. Live Stock

347956 11.00 - Apostrophe in new BSA violation code shows up as a question mark

240544 11.00 - INC0058993 - Comments and Attachments Pane does not display when user minimize the

ribbon bar.

232904 11.20 - Admin Site: Template drop-down should be in alphabetical order

232906 11.25 - Incorrect error message when inputting template formula fix

232908 11.40 - SUH if an exam is created without a discipline

281194 11.50 - Certain Reserved XML Characters in Editable Fields Cause SUHs

232910 11.60 - Unsaved Changes asterisk appears after adjusting via Drill Down

233053 11.80 - Error 291 Removing Exam

233064 12.20 - Found unknown BAML record Unknown

413871 508 Compliance - Find&Replace dialog window

233065 12.60 - Changing from delimited to fixed width for some import profiles during edit causes malformed

columns

233068 12.80 - Post Exam Survey Document - Pages not sorted by Default order

233069 12.80 - ROE displays expanded after navigating to other tabs when ROE was collapsed

253667 13.00 - Multiple exams/rows highlighted in My Exams tab without using Ctrl or Shift & click keys

233071 13.20 - Importing a loan file with validation errors into a loan portfolio with existing loans results in the

Ln - Scoping tab active instead of the Error tab

233333 13.33 - Keyboard/mouse shortcuts in Management grids not working

242707 13.33 - INC0063215 - TE Page - Descriptions not sorted in alpha order

233073 13.50 - User cannot single-select the top message in a group after choosing a multi-message content

change in version comparison

233074 13.60 - Active tabs change when using Alt+Tab to navigate towards/away from ETS

233075 13.60 - Completed gather artifacts notifications show multiple times in inbox

233077 13.60 - ORE Printed/Saved Linesheet Text Wrapping

Page 21: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 20 of 25

Federal Deposit Insurance Corporation

235038 13.60 - Error when editing invalid tab-delimited import profile

233078 13.80 - Template Designer: Font color should override style type

233079 14.40 - Order of Workpapers

233081 14.50 - Out of scope asset grid remove from playlist is enabled

233085 15.00 - Add New Relationship name is limited to 50 characters

233087 15.00 - Document Locked dialog will appear a second time when a user closes the first appearance of

the dialog

233089 15.20 - Printing Schedule RC-O from the Call Report

233091 15.60 - Scoping Grid is displaying columns of data that it should not

233092 16.20 - Adding a custom column to the All Columns Views does not insert the column in alpha order

252376 16.67 - INC0066144 - LPR percentage calculations incorrect when balance is negative

233123 17.25 - Editing profile of Analysis Only CP exam requires PEP Complete Date

233127 17.80 - User must double-click rather than single-click in Value field of Query Builder

233129 18.20 - Accrued Interest and Unfunded Commitment are in the wrong position in the All Columns

(ILDR) view

233131 18.40 - Export DCP Data dialog does not close when user hits Esc

233213 System fails in removing superscript/subscript operations across table boundaries

233223 Re-format text after copying and pasting into a document

233227 Sometimes spaces at the beginning of a paragraph can get removed upon saving

233228 Crystal Report - Reason for Classification: Superscript does not appear on Printed Linesheets

233230 Deleting one row of table removes all but leftmost borders

233232 ETS has different tab stops for the beginning and middle of a paragraph

233237 Table text added to existing table between versions is not highlighted in green during version

comparison

233268 Text can spill past section boundaries

233288 Crystal Report - Delinquency by loan type report graph is unreadable due to size.

233293 Table borders are missing from the write-up section when the linesheet is in print preview

233312 Borders do not extend to the next page when comparing document/page versions, in print preview,

and when printing

233316 Formatting changes on text reverting to previous formatting

Page 22: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 21 of 25

Federal Deposit Insurance Corporation

233331 Addition of a superscript following a word will result in the word being identified as a spelling error

233334 ETS Header - changes to opaque sometimes

233336 The Change Case formatting function increases the indentation of the list item when used on list text.

233210 508 - Exam Management > Team Screen: Header and Information text is not read to user

233221 508: Some items are not accessible

233245 508 - Keyboard shortcut issues in the Text Tools ribbon bar - 3rd Party Issues Dev Components

233329 508 - ETS Backstage - Need way to get from menu to content area

233332 508: Some items not read by screen reader

342809 SUH when deleting and re-entering text

396532 Complete document Review and sharing asset data

396696 Pop up message inconsistent - Adding or deleting a Page by when user when the another user is

working on the document

402689 OpenFISMA 6323: ETS v1.4.2 - Excessive Permissions on Local Application Files

404493 Central Peer Reconnect Box "Stuck" After Reconnecting

411982 Upgrade - receiving SUH opening a page after upgrade to 1.4.2

413804 508 Compliance - Print Preview pane

413805 508 Compliance - Print

413809 508 Compliance - Ruler

413892 508 Compliance - My Exam tab

Page 23: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 22 of 25

Federal Deposit Insurance Corporation

Appendix A: ETS External Access Cheat Sheet

Users’ access to FDIC services is restricted by their agency and the state and class of the institution:

Access Rights FDIC examiner, any bank

State examiner, same state

State examiner, different state

FRS examiner, any bank

Download Templates, Institution Profile

Yes Yes Yes Yes

Set up exam + Gather Artifacts

Yes Yes No No

Upload to IER Yes Yes No No

Upload to ViSION Yes No No No

Access to SOURCE Restricted No No No

Timing: These external access credentials will expire after 24 hours or when ETS is closed. Secure

Connection Requests between users last for 1 year.

Effects: Without credentials, ETS services will not work, but offline sharing (via local network or

Distribution Package files) can still be used. ETS also needs these credentials to activate a new machine

and add it to the list of possible team members, even if it will be used offline thereafter.

Email that was registered to your FDIC

Extranet token, i.e. [email protected]

PIN is for physical “hard” tokens only;

mobile “soft” tokens don’t need one

OTP is generated by the token

When you open ETS or attempt to

access ETS services with Network

access, this dialog box will appear.

Page 24: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 23 of 25

Federal Deposit Insurance Corporation

Appendix B: Steps to Uninstall ETS and Delete the Database Steps to Uninstall ETS

1. Open the Control Panel and navigate to Programs and Features

2. Find ETS from the list. Highlight and choose to Uninstall.

3. You can elect to completely remove the application, or restore to its previous state*

*Restoring to the previous state is essentially a rollback feature built into ETS. This option will only be

available if the computer had previously “upgraded” from a prior version. When selecting this option,

it will roll back ETS back to the prior version (i.e. ETS 1.4.2 ETS 1.4.1)

4. Once the process is complete, the dialog box (shown above) will close. Please go back to the

Programs and Features list and verify ETS has been uninstalled or rolled back to a prior version.

Page 25: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 24 of 25

Federal Deposit Insurance Corporation

Steps to Delete the ETS Database

1. Open SQL Server Management Studio:

i. Click START > All Programs > Microsoft SQL Server 2012 > SQL Server Management Studio.

ii. Once open, Connect to the Server:

* Server Name should read: [ComputerName]\FDIC2008

* Authentication should read: Windows Authentication

* Username should remain greyed out.

2. Once successfully connected, 5 folders should drop down on the left hand side of the window

3. Expand (+) the Databases folder and you should see the ETS database - simply titled ETS

Page 26: Common ETS Errors & SolutionsETS Common Errors and Solutions This document was created by the FDIC. Please do not alter its contents. Page 3 of 25 Federal Deposit Insurance Corporation

February 8, 2019 ETS Common Errors and Solutions

This document was created by the FDIC. Please do not alter its contents. Page 25 of 25

Federal Deposit Insurance Corporation

4. To delete, right click on the ETS database and navigate to Delete (3rd one up from the bottom)

5. From there a new popup window will appear, you MUST* uncheck the first option (Delete backup and

restore history information for databases) and check the second option (close existing connections),

then click OK.

*Deleting the backup and restore history information will delete all of the automatic backups that SQL

Server creates on a periodic basis; which can be located at: C:\Program Files\Microsoft SQL

Server\MSSQL11.FDIC2008\MSSQL\Backup

*Closing the existing connections, will just ensure that the ETS database is not in use under another

system profile.