Feature - Alternate Security for Viewing Database Activity
Release Date: 7/9/2021
Versions: 8.5 and Higher
Background
It could be helpful in certain circumstances to view the last several database I/O operations. While
some users are allowed to do this whenever necessary, this generally is not allowed for security reasons.
This new feature allows for an administrator to temporarily give permission for a non-privileged user to employ this feature during the life of an Elliott task.
Using the Feature
Let's say, for example, a process seems to be in a loop that does not end. The user may press Ctrl+Shft+D to try to view the most recent database activity. If they do not have that permission, they will be prompted for the SUPERVISOR password to get temporary permission:
If the user (or more likely an administrator) enters the correct password, the database activity log will appear and the user will continue to have the ability to view it without additional SUPERVISOR password prompts for the duration of the task.
If, however, you enter an incorrect password three times, you no longer will be prompted for a password nor have the ability to view the database activity for the duration of the task.
See the following KB article for related information:
JEG
Related Articles
A Support Case of Investigating Elliott Database Performance Problem
Release Date: 08/14/2018 A user reported that their shipping verification process has become slow. They noticed that the scanning has become slow over time, and are wondering if there is a purge or rebuild or something they could do to speed things ...
Can You Explain How Elliott Stores Serial Numbers in Its Database?
Q - Can you explain the various Lot/Serial files (IMLSHST, IMLSTRXS, IMSERREF, etc) - how/when they are populated/updated by the Elliott application and how they relate to other files? A - Here is a highlight of each one of the Elliott database ...
Feature - View Database Activities Through Control-Shift-D Key
Version 8.5 & Up Release Date: 7/7/2021 Control-Shift-D Support in the Past The Control-Shift-D key has been available in Elliott since V7.x. It is a very useful tool for debugging purposes. For example, let's say you started to notice performance ...
Aging Shows Differently After Database Rebuild
Q - After the database rebuild on A/R Open Item File (AROPNFIL.BTR), the A/R aging shows differently than before. For some reason, the payments are showing before the invoices. Also, they are not in any logical order that we can see. Here are the ...
Btrieve Error 46 on S/M Activity Log File
Last Update: 06/20/2024 Q - I receive the following error message when I start up Elliott and launch a session: Btrieve Error 046 on S/M Activity Log File But this only happens to company 1. When I access another company, I do not receive this ...