VERIFIED SOLUTION i
X

ERROR 18037: unable to open index [iguid] in database

Issue

File won't index.  

Cause

10:11:12 start indexing document file [/ARCHIVE/sfwater/docdata/20090917211806-not2-afp-a56885df9b2e004bb1abc7756b41676d.drd]
10:11:12 ERROR 18037: unable to open index [iguid] in database [sfwatercombined]
10:11:12 flushing index cache
10:11:12 /ARCHIVE/sfwater/index/sfwatercombined/account.dri
10:11:12     file size [40960]
10:11:12     disk read [3]
10:11:12     disk write [1]
10:11:12     stack depth [2]
10:11:12     cache read hit [2]
10:11:12     cache read miss [2]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12 /ARCHIVE/sfwater/index/sfwatercombined/address.dri
10:11:12     file size [118784]
10:11:12     disk read [5]
10:11:12     disk write [3]
10:11:12     stack depth [2]
10:11:12     cache read hit [2]
10:11:12     cache read miss [4]
10:11:12     cache write hit [3]
10:11:12     add unique [3]
10:11:12 /ARCHIVE/sfwater/index/sfwatercombined/guid.dri
10:11:12     file size [196608]
10:11:12     disk read [4]
10:11:12     disk write [1]
10:11:12     stack depth [3]
10:11:12     cache read miss [3]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12 /ARCHIVE/sfwater/index/sfwatercombined/invlink.dri
10:11:12     file size [147456]
10:11:12     disk read [3]
10:11:12     disk write [1]
10:11:12     stack depth [2]
10:11:12     cache read miss [2]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12 /ARCHIVE/sfwater/index/sfwatercombined/name.dri
10:11:12     file size [102400]
10:11:12     disk read [4]
10:11:12     disk write [2]
10:11:12     stack depth [2]
10:11:12     cache read hit [1]
10:11:12     cache read miss [3]
10:11:12     cache write hit [2]
10:11:12     add unique [2]
10:11:12 /ARCHIVE/sfwater/index/sfwaternotices/account.dri
10:11:12     file size [8192]
10:11:12     disk read [1]
10:11:12     disk write [3]
10:11:12     stack depth [1]
10:11:12     cache read hit [2]
10:11:12     cache read miss [1]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12     read empty [3]
10:11:12 /ARCHIVE/sfwater/index/sfwaternotices/address.dri
10:11:12     file size [8192]
10:11:12     disk read [1]
10:11:12     disk write [3]
10:11:12     stack depth [1]
10:11:12     cache read hit [4]
10:11:12     cache read miss [1]
10:11:12     cache write hit [3]
10:11:12     add unique [3]
10:11:12     read empty [2]
10:11:12 /ARCHIVE/sfwater/index/sfwaternotices/guid.dri
10:11:12     file size [8192]
10:11:12     disk read [1]
10:11:12     disk write [3]
10:11:12     stack depth [1]
10:11:12     cache read hit [1]
10:11:12     cache read miss [1]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12     read empty [2]
10:11:12 /ARCHIVE/sfwater/index/sfwaternotices/iguid.dri
10:11:12     file size [8192]
10:11:12     disk read [1]
10:11:12     disk write [3]
10:11:12     stack depth [1]
10:11:12     cache read hit [1]
10:11:12     cache read miss [1]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12     read empty [2]
10:11:12 /ARCHIVE/sfwater/index/sfwaternotices/invlink.dri
10:11:12     file size [8192]
10:11:12     disk read [1]
10:11:12     disk write [3]
10:11:12     stack depth [1]
10:11:12     cache read hit [1]
10:11:12     cache read miss [1]
10:11:12     cache write hit [1]
10:11:12     add unique [1]
10:11:12     read empty [2]
10:11:12 /ARCHIVE/sfwater/index/sfwaternotices/name.dri
10:11:12     file size [8192]
10:11:12     disk read [1]
10:11:12     disk write [3]
10:11:12     stack depth [1]
10:11:12     cache read hit [2]
10:11:12     cache read miss [1]
10:11:12     cache write hit [2]
10:11:12     add unique [2]
10:11:12     read empty [2]
10:11:12 finished indexing document file [/ARCHIVE/sfwater/docdata/20090917211806-not2-afp-a56885df9b2e004bb1abc7756b41676d.drd], [1] errors
10:11:12 <connection1> notice.cacheflush request
10:11:12 <connection1> notice.cacheflush returned, elapsed [0]
10:11:12 ERROR 10132: indexing failed for file [20090917211806-not2-afp-a56885df9b2e004bb1abc7756b41676d]

Resolution

UPDATED: September 18, 2017


PROFILES.INI has the following:
 
[FileMap]
bill=PSBILLS
not=PSNOTICESLEGAL
lh=PSNOTICESLEGAL
lw=PSNOTICESLEGAL
rec=PSNOTICESLETTER
rel=PSNOTICESLETTER
 
[Default]
Format=AFP
Documents=journal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
Tray=ngnm.wmf
 
[PSBILLS]
Format=Postscript
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
SkipHeaderPages=1
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=14
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
CustomIndexing=1
Index1=account,cust.account,wjctul,Account Number
Index2=name,cust.name,jcrtul,Names
Index3=address,cust.address,jcrtul,Addresses
Index4=invlink,hint.date,dhasb,Dates under this ID
Index5=guid,hint.guid+int.null+hint.type,dhi,GUID
Index6=billid,Bill_ID,dhj,Bill ID
Database=SFWATER,SFWATERCOMBINED
 
[PSNOTICESLEGAL]
Format=Postscript
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
SkipHeaderPages=1
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=14
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
Database=SFWATERNOTICES,SFWATERCOMBINED
 
[PSNOTICESLETTER]
Format=Postscript
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
SkipHeaderPages=1
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=11
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
Database=SFWATERNOTICES,SFWATERCOMBINED
 
 
[SFWATEROLD]
Format=AFP
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=14
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
Database=SFWATER
 
[SFWATER]
Format=AFP
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=14
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
CustomIndexing=1
Index1=account,cust.account,wjctul,Account Number
Index2=name,cust.name,jcrtul,Names
Index3=address,cust.address,jcrtul,Addresses
Index4=invlink,hint.date,dhasb,Dates under this ID
Index5=guid,hint.guid+int.null+hint.type,dhi,GUID
Index6=billid,Bill_ID,dhj,Bill ID
Database=SFWATER,SFWATERCOMBINED
 
[SFWATERNOTICES]
Format=AFP
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=14
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
Database=SFWATERNOTICES,SFWATERCOMBINED
 
[SFLETTERS]
Format=AFP
Documents=XMLjournal
Stream=1
LengthDelimited=0
TapeBlockFormat=1
MarginX=0
MarginY=0
PageBreak=0
SkipHeaderPages=1
Tray=
CPIX=25
CPIY=10
PAGEHEIGHT=11
PAGEWIDTH=8.5
IgnoreResourcePacks=1
ResourceSet=Default
ExtractResources=distrib/default/
Database=SFWATERNOTICES,SFWATERCOMBINED
 
 
DATABASE.INI has the following:
 
[SFWATER]
Description=SF Water Bills
Index1=account,cust.account,wjctul,Account Number
Index2=name,cust.name,jcrtul,Names
Index3=address,cust.address,jcrtul,Addresses
Index4=invlink,hint.date,dhasb,Dates under this ID
Index5=guid,hint.guid+int.null+hint.type,dhi,GUID
Index6=billid,Bill_ID,dhj,Bill ID
 
[SFWATERNOTICES]
Description=SF Water Notices
 
[SFWATERCOMBINED]
Description=SF Water Combined
Index1=account,cust.account,wjctul,Account Number
Index2=name,cust.name,jcrtul,Names
Index3=address,cust.address,jcrtul,Addresses
Index4=invlink,hint.date,dhasb,Dates under this ID
Index5=guid,hint.guid+int.null+hint.type,dhi,GUID
Index6=billid,Bill_ID,dhj,Bill ID
 
 
 
 
 
The profile [SFWATERNOTICES] is creating keys for the default set of indexes which includes iguid.
 
However there is no iguid index defined in database [SFWATERCOMBINED].
 
 
If iguid isn't being used, set the list of indexes explicitly in the profile to exclude it:
 
profiles.ini:
 
[SFWATERNOTICES]
...
Index1=account,cust.account,wjctul,Account Numbers
Index2=name,cust.name,jcrtul,Names
Index3=address,cust.address,jcrtul,Addresses
Index4=invlink,doc.date,xdhasb,Dates under this account
Index5=guid,doc.guid+int.null+doc.type,dhi,GUID
; disable iguid
;Index6=iguid,docInstanceID+int.null+doc.type,dhi,Instance GUID
 
(Should this profile has the same index keys as [SFWATER]? e.g. billid)
 
 
If iguid really is being used, add it to the list of searches in the database:
 
database.ini:
 
[SFWATERCOMBINED]
...
Index7=iguid,docInstanceID+int.null+doc.type,dhi,Instance GUID

Downloads

  • No Downloads