HP TRIM 7.1.2(2017) DCI failing on non-existing records (610 Views)
Reply
Highlighted
Frequent Advisor
Posts: 100
Registered: ‎11-14-2012
Message 1 of 7 (610 Views)

HP TRIM 7.1.2(2017) DCI failing on non-existing records

Hi

 

I've been wrestling with the DCI recently (last few weeks). We upgraded from 6.2.5 to 7.1.2(2017), re-ran the DCI manually,  on Date Registered periods. After that, I enabled the DCI event in TES and deployed the changes. The DCI event ran for some time and then stopped, blocked by error. The error message is:

 

 

 

HP TRIM Workgroup Server running on atmp02.main.dva reported the following message:
 Error : VA  User: ATMP22 -  Error processing event on database 'VA' for processor 'Content Indexing', event details: 8234037, boburi=10002640, storeid=001+00A+0E5J0JTV0RM.PDF, error details: Function request (Extract Document) for HP TRIM Workgroup Server 'localhost' failed. Cannot read the file '\\Atmp21\EDMData\VA\5\001\00A\0E5J0JTV0RM.PDF'. The system cannot find the file specified. (0x00000002).

 

I ran the script on the database to find out which records were causing this error and found out that the record with the URI (10002640) was not in TSRECORD table.  Also, there's no file on that URL in our document store.  There were a few more DCI entries which were referring the non-existing records in TSRECORD.

 

Re-starting The workgroup servers did not help. Resuming the DCI event from TES did not help, either - it soon got blocked by the same error without having processed a single DCI event.

 

There are no TRIMpending.bin or TRIMtransactions.bin files in ISYS directories.

 

Our Document stores are fairly large, over 3 Tb, so there are many documents, large and small.

 

 

I suspect that, somehow, the DCI picks up the newly created records and stores those events in TSEVENTDAT. But, then, some things get in a way and delete those records - for which the DCI event has already been created but not processed. Then, at a later stage, those evetns get processed and, because the Records to which they refer, no longer exist in the database, the DCI process aborts....

 

 

It's just unclear to me - would this issue be causing the DCI to fail atogether? I would think that DCI would simply skip those event entries and proceeed with the other events, wouldn't it?

 

 

 

Thanks for help

Alex

HP Expert
Posts: 1,131
Registered: ‎01-02-2002
Message 2 of 7 (600 Views)

Re: HP TRIM 7.1.2(2017) DCI failing on non-existing records

Sounds  a lot like this other post from yesterday:

http://h30499.www3.hp.com/t5/HP-Records-Manager-HP-TRIM-Forum/HP-TRIM-7-1-2-Workgroup-Content-Indexi...

 

7.1.X has had a number of issues already reported with DCI a number of those were addressed in later releases and since then the product as moved from ISYS to IDOL ( new indexing system) which is far more reliable, although can require more hardware to run.

 

Basically if you come across the 'blocked by error' message caused by events looking for documents that do not exist you will need to find the boburi number from the DCI logs, go to the db and use the boburi to find out which record is causing the problem. Then quarantine that document. 
not an ideal scenario but unfortunately in that version this is the only work around.

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard**
Frequent Advisor
Posts: 100
Registered: ‎11-14-2012
Message 3 of 7 (591 Views)

Re: HP TRIM 7.1.2(2017) DCI failing on non-existing records

hi Greg

 

That's what I would have done, if there was a record with that URI in TSRECORD. But, the problem is, that the event seems to be orphaned, referring to a non-existing record in tsrecord. So I even cannot quarantee it. But, because this wrong event is the first one in the TSEVENTDAT, it seems to be picked up and processed first, blocking the rest...

 

Just to clarify - a DCI event 's boburi referrs to a non-existing record (e.g., there is no entry in TSRECORD table with the given URI), trying to content index a non-existing file - e.g., there is no such like file in the specified document store...

 

 

What's worse, our database is managed by someone else and to get that someonelse to run the scripts is problematic, to an extent.

 


Maybe, other suggestions?

 

HP Expert
Posts: 1,131
Registered: ‎01-02-2002
Message 4 of 7 (585 Views)

Re: HP TRIM 7.1.2(2017) DCI failing on non-existing records

You could also remove it from the TSEventdat table.

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard**
Frequent Advisor
Posts: 100
Registered: ‎11-14-2012
Message 5 of 7 (571 Views)

Re: HP TRIM 7.1.2(2017) DCI failing on non-existing records

This is what I have done already. But I don't recall this sort of issue in 6.2.5, when an orpahed DCI event would cause Blocked By Error ...
HP Expert
Posts: 1,131
Registered: ‎01-02-2002
Message 6 of 7 (561 Views)

Re: HP TRIM 7.1.2(2017) DCI failing on non-existing records

You are right it wasn't an issue in 6.2 and it is not an issue in 7.3. Mostly in 7.1 

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard**
Frequent Advisor
Posts: 100
Registered: ‎11-14-2012
Message 7 of 7 (545 Views)

Re: HP TRIM 7.1.2(2017) DCI failing on non-existing records

Thanks, Greg.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.