search

tsgrp / HPI

OpenContent Management Suite (OCMS)
http://www.tsgrp.com/products
17 stars 5 forks source link

When Heads Up Indexing is configured for Bulk Upload, only one document at a time can be scanned #1483

Closed gsteimer closed 6 years ago

gsteimer commented 7 years ago

If you've configured Bulk Upload for Heads Up Indexing as well as OpenCapture, the following files are added to the list:

image

When using Alfresco as a back end, the subsequent upload to the indexing folder causes this error:

### Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "parent_node_id"
  Detail: Key (parent_node_id, type_qname_id, child_node_name_crc, child_node_name)=(1636, 33, 420204962, 104908scanned_document.pdf) already exists.
; SQL []; ERROR: duplicate key value violates unique constraint "parent_node_id"
  Detail: Key (parent_node_id, type_qname_id, child_node_name_crc, child_node_name)=(1636, 33, 420204962, 104908scanned_document.pdf) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "parent_node_id"
  Detail: Key (parent_node_id, type_qname_id, child_node_name_crc, child_node_name)=(1636, 33, 420204962, 104908scanned_document.pdf) already exists.
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)

This could be fixed by adding an index value to the name of the document.

One question however - it looks like the IndexerTemp on release2 has file names like this: 105744Loss Report.pdf. So it seems like we're adding some sort of "dupe node" prevention logic already. Why isn't this working for scanned documents?

nwoodbine commented 6 years ago

Fixed in HPI revision 19188