common ets errors & solutionsets common errors and solutions this document was created by the...
TRANSCRIPT
Common ETS Errors & Solutions
Published: February 8, 2019 Version: 1.4.2
2019
Version: 1.4.2 2/8/2019
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
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
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
ETS Tier 3 (Technical Errors)
Karina Michael Anthony Harper Khushnaz Bhot Joshua Zastudil Bimo Yusman
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
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.
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
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.
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.
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
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
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.
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
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.
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)
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.
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
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
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
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
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
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
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
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.
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.
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
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.