OnDemand User Group

Support Forums => Report Indexing => Topic started by: Steve C on October 30, 2006, 11:39:03 AM

Title: Index error with AFP - key looks ok, but arsload reports it as ' '
Post by: Steve C on October 30, 2006, 11:39:03 AM

Hi,

  We have a production definition storing AFP.
  Plenty (1000s) of files have been loaded to this definition without problem. However yesterday we had a single file with a problem.
  Looking at the job, it reports that one of the TLEs which should contain an amount actaully contains ' '.
  I've looked at the file and none of the TLEs which contain this amount filed look in valid. Infact all keys in the file look file.

  I've run arsload in indexer mode only against this file and it says processing completed succesfully.

  Any ideas?

Title: Re: Index error with AFP - key looks ok, but arsload reports it as ' '
Post by: geoffwilde on October 30, 2006, 12:31:32 PM

Steve, when we've seen this, there has been a duplicate TLE for a single statement/document, but not for all. Check the failing record for such a condition. (like below where account is duplicated but the rest of the TLEs aren't.

:Lyy   ::::::::  ::  :4::::                                             
:Ly?  :00013005::: PDR-AT0001300500034932::? F2DUMM00                   
:L??  :::: DATE::  20060713                                             
:L??  :::: ACCOUNT::  123456789                                       
:L??  :::: ACCOUNT::  987654321                                       
:L??  :::: NAME1::  AnyAccount