Finding why files that have been skipped by NXPowerLite for File Servers

NXPowerLite for File Servers can skip files for a variety of reasons. These reasons will appear in the report as per the image below, but what if you want to find out which specific files make up each category.

Skipped_Files_Report.PNG

NXPowerLite for File Servers keeps track of each file it has seen before, regardless of whether it has been successfully or not successfully compressed. It stores this information in a database stored alongside the configuration files. It is possible to query the database in order to find out which files fall into specific categories of skipped files.

Find Skipped file paths for specific categories

  1. Download a SQLite browser tool. We used DB Browser for SQLite.
  2. Ensure the NXPowerLite for File Servers Dashboard is closed
  3. Stop the NXPowerLite File Server Windows service
  4. Open SQLite database file called status at the following location:
    C:\ProgramData\Neuxpower\NXPowerLite for File Servers v8
  5. Switch to the Execute SQL tab. If not seen then select Execute SQL in the View menu.
  6. Find the value of the error in the table below. e.g. The value for File in use is 2005
  7. Execute a SQL query to return paths of files skipped for a reason appearing on the Single Pass report (See example below).

Example

Use the following SQL query you should be able to bring back the full file paths files which have been skipped due to 'PDF processing error' (Value=2027).


SELECT Paths.path||fileName FROM Incompressible INNER JOIN Paths ON Incompressible.pathId= Paths.pathId WHERE status = '2027'

 

Skipped file categories

Report Skipped Reason Status Code Name Value Description
n/a nxstatusOk 2001 Status is Ok.
Unknown error nxstatusErrorOccurred 2002 An error occurred.
Unsupported file format nxstatusUnsupportedFileFormat 2003 The operation requested cannot be performed on the file passed in as it is an unsupported type for that operation.
File in use nxstatusFileInUse 2005 The file is already in use.
Already optimized nxstatusAlreadyOptimized 2006 The file has already been optimized.
Cannot reduce with current settings nxstatusCannotReduce 2007 The file cannot be reduced in size with the optimization settings used.
Fast saved Microsoft Word documents nxstatusOfficeFastSavedDoc 2009 The file is in the Office 'fast saved' format.
Unsupported file type(Wrong extension or corrupted file) nxstatusInvalidFormat 2010 The file looked valid initially but on further investigation turned out to be invalid.
JPEG too small nxstatusJPEGTooSmall 2011 The JPEG being optimized is too small. 
Created with an old version of MS Office (pre Office 97) nxstatusFileVersionTooOld 2012 The version of the file is too old (e.g. pre-Office 97).
Unsupported PDF subset nxstatusUnsupportedPDFSubset 2019 The file being optimized is a PDF subset that is unsupported.
File not saved with Microsoft Office nxstatusNotSavedByMSOffice 2020 The file being optimized was not last saved by Microsoft Office, and MSOfficeOnly is enabled.
Not yet supported (e.g created by a new version of Microsoft Office) nxstatusFileVersionTooNew 2021 The file version is too new (not yet supported).
Digitally signed document nxstatusDigitallySigned 2022 The file being optimized is digitally signed.
Encrypted nxstatusEncryptedOrPassword 2023 The file is encrypted or password protected and cannot be opened because a password is required.
File not found nxstatusFileNotFound 2024 The file specified does not exist.
Could not add tagging data nxstatusTaggingFailed 2026 The operation to tag the optimized file has failed.
PDF processing error nxstatusPDFFailure 2027 An unexpected error was returned by the PDF Library.
Unsupported TIFF file nxstatusUnsupportedTIFFFile 2033 The file being optimized is a TIFF that contains compressed data.  The SDK will only optimize TIFF files with uncompressed data.
Unsupported TIFF tags nxstatusUnsupportedTIFFTags 2034 TIFF files are made up of data structures called tags.  A tag has been encountered that the SDK doesn't recognize.
Neuxpower logo
Neuxpower Support Article Logo
Have more questions? Submit a request