Reducing File Sizes for INITLFILE.LOG & SYACTLOG.BTR

Reducing File Sizes for INITLFILE.LOG & SYACTLOG.BTR

Q - Is there a way to reduce the size of the INITFILE.LOG and SYACTLOG.BTR files? We saved the GL section in a separate folder so we can copy a set of files from the live folder, and we have done so for several years. These files are now several hundred MB in size, so we'd like to reduce them.

A - The simple answer is to just delete them. They will be re-created automatically in Elliott starting from a minimum size. If you want, you can also save these two files to an archive folder somewhere before you delete them. Here is what they do:

  • INITFILE.LOG - This is a log file that records any Elliott data file's initialization activity. If you have not used this file before, you don't really need it. 
  • SYACTLOG.BTR - This is the user login and logout activities, including the eStore website login activities. It also contains the log of mass emails or any emails that you send through the Elliott user interface. 
  • You can view the content in this file by bringing up an eContact  and choosing the Activity tab.  The same tab contains the activities of emails sent to this user through the Elliott user interface. See the first attached sample screen below.
  • You can view the regular Elliott user's login and logout activities by going to Password Setup and bringing up any user in change mode. Then click on the "Special Function" tool bar icon and choose "User Activity." See the second attached sample screen below.
  • If you've never used these functions before, then you don't really need them in my opinion. 
We currently don't have utility programs to purge these two files by date range. To purge INITFILE.LOG by date range, you can use an editor like NOTEPAD.  To purge SYACTLOG.BTR by date range, you will need to use PSQL Control Center and issue a SQL statement like:
   
DELETE from SYACTLOG where SYACTLOG_DATE < 20150101
Keep in mind that after the deletion, the SYACTLOG.BTR file size does not decrease.  Often, it will increase in physical disk size.  This has to do with how PSQL handles data integrity.  To claim your disk space back after using the above DELETE SQL statement, you will have to use the "Rebuild" utility provided by PSQL.

eContact Activities Tab


User Activities Under Password Setup -> Special Function




    • Related Articles

    • 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 ...

    • Feature - Added the Ability to Purge the System Activity Log

      Release date: 8/27/2018 This feature will give the user the ability to selectively purge the data from the System Activity log file (SYLOGFIL). This file stores the following information: Elliott user login Web Services login (from your website) ...

    • Avalara - Log Files

      Release Date: 4/28/23 Version: 8.6 & Above Log files can be very important when investigating why taxes may not be calculated as expected. In particular, the AvalaraAPICalls.xml file is important when you speak with Avalara reps for support. This ...

    • Change - LOG Files in EDI Export Processes Are Now Redirected to LOG Folder

      Release Date: 05/05/2021 Version: 8.5 & Up Currently, Elliott EDI Export Processing may utilize LOG files to store error information. For example, the CPSHPEDI.LOG file is used by "Shipped Data Export" (ASN/856 Export). This file currently resides in ...

    • Feature - Append Re-Apply Cr/Dr Memos Info To Log File

      Release date: 3/13/2018 With this feature addition, when the Global Setup fields have been entered (see below) the Re-Apply Cr/Dr Memos application will optionally create a log file record when a document is reapplied. To use this feature, enter "Y" ...