Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('c37789a7a10886e9367c8606862a8afd', '23.20.130.128', '1498598402', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1498598402', '0'); (The table 'swsessions' is full)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\support.inm.com\includes\functions.php:410) in C:\Inetpub\support.inm.com\includes\functions.php on line 1612
Searchable Library - Error While Indexing PDF Documents - Support Center
inm logo
Corporate Website | Contact | Store | Support | Login  
     


Knowledgebase
View categorized listing of all common frequently asked questions.
Downloads
View our categorized library of downloads for all necessary manuals, software, etc.
 Article Options
Support Center » Knowledgebase » INM Impressario for Director » Searchable Library - Error While Indexing PDF Documents
Support Page Banner
 Searchable Library - Error While Indexing PDF Documents
Products:Platform:Area:Version:
INM Impressario All Searchable Library 3

Summary

When creating the Searchable Library of PDFs using the "Create Searchable Library Wizard", an error is sometime returned saying that some PDF documents cannot be inserted. We will look at the two main causes of this error.

Solutions

1- The PDF document has no text

If the document to index has no text in it, the searchable library indexer will not insert that document in the database the process will stop on the following document.
Therefore, if the error occurs on the third document, it means that the second document has no text in it.

2- The document has an unsupported date format

Some tools used to generate the PDF documents sometime use a date format that is not supported by the Adobe Library used in INM Impressario. The CreateDate and ModifyDate values don't have the SS (seconds) values in the YYYY-MM-DDTHH:MM:SSZ date format. Then, the ModDate parameter will add 00 as the SS value which crashes the library. Here's an example the the issue when opening the PDF document with any text editor:

In this example the modify date is missing the "SS" values:
2008-06-13T09:59Z

So ModDate will add the 00:
ModDate(D:20080613095900Z)

The solution is to replace the final 00 with any number between 01-59:
ModDate(D:20080613095930Z)

Save the file and restart the indexing.

If the application will not need to filter the Library by their create or modify date, another solution would be to NOT index the dates.To do that, just uncheck these dates in the Step 2 of 3 from the Searchable Library Wizard.



Article Details
Article ID: 129
Created On: 24 Jul 2008 02:42 PM

 This answer was helpful  This answer was not helpful

inm general footer
Services Xtras Go Products Support Gallery Store Download About Us Contact Newsroom