Question

PDF import "General database error [9008]" when generating pages

Import Agent Version 10

Updated February 13, 2017

asked on February 9, 2017 • Show version history

When importing PDFs into the repository, either via Import Agent or the Client (web or desktop), certain ones are throwing a "General database error [9008]". The Import Agent event viewer logs suggested the problem had something to do with the PDF annotations, and after looking at the PDFs themselves -- these are architectural/engineering drawings generated by AutoCAD -- we think the problem has something to do with how AutoCAD's SHX text is written to the PDF.

Please see below for an example Import Agent log. Although I'm pretty sure the problem has something to do with these SHX text comments, I'm not sure why they would be causing a problem with the generation of pages, but if not, we'd appreciate it if anyone can shed light on this.

Log Name: Application
Source: Laserfiche Import Agent Service
Date: 2017-02-07 16:48:54
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
Description:
There was an error running the profile Initial Upload - Engineering Plans while importing the file "\\BGM-LF1.corp.datavu.biz\C\IA\EP\E502 First Floor Plan Fire Alarm---16-1271.pdf". (General database error. [9008])
at Laserfiche.RepositoryAccess.Annotation.SendSaveRequest(HttpUrl url, IEnumerable`1 col, String lockToken, Boolean created, Session session)
at Laserfiche.RepositoryAccess.PageInfo.AddAnnotations(IEnumerable`1 annotations)
at Laserfiche.PdfServices.AnnotsImporter.ConvertRectangleAnnotation(PdfDictionary annotDict, PageInfo page)
at Laserfiche.PdfServices.AnnotsImporter.ImportPDFPageAnnotsWithiTextSharp(PdfDictionary pageDict, DocumentInfo doc, PageInfo page)
at Laserfiche.PdfServices.AnnotsImporter.ImportPDFAnnotsWithiTextSharp(PdfReader pdfReader, DocumentInfo doc)
at Laserfiche.PdfServices.PdfExtractor.ImportPDFPagesFromStream(Stream pdfStream, DocumentInfo doc)
at Laserfiche.PdfServices.PdfExtractor.ImportPDFStream(Stream pdfStream, DocumentInfo doc, DateTime dtLastModified)
at Laserfiche.PdfServices.PdfExtractor.ImportPDFFile(String strPDFFile, DocumentInfo doc)
at Laserfiche.ImportAgent.Service.ExecuteProfileFile.ImportPDFFile(ExecutionContext context, DocumentInfo LFDoc, FileInfo fi, Profile profile)
at Laserfiche.ImportAgent.Service.ExecuteProfileElectFile.ImportFile(ExecutionContext context)
at Laserfiche.ImportAgent.Service.ExecuteProfileFile.Execute(ExecutionContext context) (9008)

0 0

Replies

replied on February 9, 2017

Hi Jesse,

You can open a support case and upload the pdf file and Import Agent profile.

Thanks,

Qinmei

0 0

replied on February 13, 2017

Check the windows event log on the LF server machine, there should be an event with more details about the database error.

0 0

replied on February 13, 2017

I was unable to find the event log associated with the error in the Client. Would you expect to see something dramatically different from the Import Agent event log included in the original post? I'll continue to look to see what I can find.

0 0

replied on February 13, 2017

Yes, the LF server records the specific database error. It should be in the Application event log.

0 0

replied on February 13, 2017

This may have been an annotation parameter out-of-range error.

When importing PDF into Laserfiche, the importer can be configured to extract and convert PDF annotations into Laserfiche annotations. However, Laserfiche annotations contain a set of parameter validations, such as coordinates relative to the page image, as well as data size (e.g. string length) limitations, that are imposed when the Laserfiche annotations are sent to Laserfiche server during document creation.

Please test the specimen PDF with the latest version of Laserfiche (e.g. the latest VAR demo). If the problem can be reproduced in the latest version, please open a support case with us and attach the PDF to the case. (For tracking purpose, please cite this Answers post URL when opening the support case.)

Meanwhile, the customer could try turning off the "convert PDF annotations into LF annotations" option to workaround (bypass) this problem in the short-term.

0 0

replied on February 13, 2017

I have already opened a support case based on Qinmei Zou's response.

For what it's worth, we tried disabling annotations but this did not help.

Also, the files will be imported exclusively through Import Agent -- we only uploaded to the Client to test the PDF upload another way -- so the users will have no control over these settings.

0 0

You are not allowed to follow up in this post.

Question

Question

PDF import "General database error [9008]" when generating pages

Replies

Sign in to reply to this post.