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