This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Apr 4, 2017, 9:11 PM
9 Posts

FT Search and LZ1 compressed attachments

  • Category: Application Development
  • Platform: Windows
  • Release: 9.0
  • Role: Administrator,Developer
  • Tags:
  • Replies: 1

Hello. If you have a minute, I have a large db with one ms word attachment in each record. I found that ft search isn't returning anything after a certain date. Looking closer, the difference is everything before the date is Huffman compression on $FILE and everything after is LZ1. So the FT Search sin't working on LZ1 compressed files. Does anybody have any idea what I could do? Thank you so much for reading.

Apr 5, 2017, 2:43 PM
196 Posts
Perhaps there is a limitation on FT indexing being able to index multiple compression type...

I have applications with LZ1 attachments that are FT-indexed, and searchable by their attachments. I would imagine that there is a limitation for FT indexing based on compression type. The FT index may be limited to indexing Huffman type or LZ1 type but not both simultaneously. 

You may want to make a database copy of the application, and run compact -C -ZU to convert the Huffman compressed documents to LZ1, and then full-text index the application. If the FT index then is able to find documents before and after the date you found to be problematic, then do the same for the application with documents of a mixed compression type.

 


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal