VERIFIED SOLUTION i

Vault ERROR 70531: attempt to reference customer record for non-customer linked index

Issue

I get an error when I try to search on an index I just created.  What's wrong?

Cause

Render log and Perl client show this error trying to search under a certain index:
 
Upon searching for a document: 
 
http://localhost/Scripts/interface.pl?K=6&Q=&A=&TA=&S=1&F=1&DB=webndtl&x=14&y=20 
 
The following error is obtained in the render log: 
 
10:28:41 127.0.0.1:1484 <server1> open connection 
10:28:41 127.0.0.1:1484 <authserver1> database.list request 
10:28:41 127.0.0.1:1484 <connection1> database.list request 
10:28:41 127.0.0.1:1484 <connection1> database.list returned record, [3] rows, [2] columns, elapsed [0], cached [4] 
10:28:41 127.0.0.1:1484 <authserver1> database.list returned record, [3] rows, [2] columns, elapsed [0], cached [4] 
10:28:41 127.0.0.1:1484 <connection1> database.info request, database [webndtl] 
10:28:41 127.0.0.1:1484 <connection1> database.info returned record, [6] rows, [5] columns, elapsed [0], cached [4] 
10:28:41 127.0.0.1:1484 <connection1> database.search request, database [webndtl], index [6], prefix [], max [20], first [] 
10:28:41 127.0.0.1:1484 <connection1> <database1> ERROR 70531: attempt to reference customer record for non-customer linked index 
10:28:41 127.0.0.1:1484 <connection1> database.search failed, status [70531] 
10:28:41 127.0.0.1:1484 <server1> remote host closing connection 
10:28:41 127.0.0.1:1484 <server1> close connection, requests [3], read [442], written [1243], duration [549] ms 
10:28:41 [1] listening, [0] open, [0] stopping, [0] stopped, resetlevel [0] 
 
Something is wrong with how the index6 is set up. Can you point me in the right direction? 
 
[indexparam] 
CustomIndexing=1 
Index1=account,cust.account,wjctul,NUMERO DE CUENTA 
Index2=name,cust.name,jctrul,NOMBRE 
Index3=address,cust.address,jctrul,DIRECCION 
Index4=invlink,hint.date,dhasb,FECHAS DE LA CUENTA 
Index5=phone,TEL,jctlm,TELEFONO 
Index6=invnum,INV,dh,NUMERO DE FACTURA 
 
Render1=NUMERO DE CUENTA;NOMBRE;DIRECCION,cust.account;cust.name;cust.address 
Render2=NOMBRE;NUMERO DE CUENTA;DIRECCION,cust.name;cust.account;cust.address 
Render3=DIRECCION;NUMERO DE CUENTA;NOMBRE,cust.address;cust.account;cust.name 
Render4=FECHAS DE LA CUENTA;hint.date 
Render5=TELEFONO;NUMERO DE CUENTA;NOMBRE;DIRECCION,int.match;cust.account;cust.name;cust.address 
Render6=NUMERO DE FACTURA;NUMERO DE CUENTA;NOMBRE;DIRECCION,INV;cust.account;cust.name;cust.address

Resolution

UPDATED: October 18, 2017
Document indexes are not allow to use customer fields in their output columns.
 
Render6=NUMERO DE FACTURA;NUMERO DE CUENTA;NOMBRE;DIRECCION,INV;cust.account;cust.name;cust.address 

needs to be changed to:
 
Render6=NUMERO DE FACTURA;NUMERO DE CUENTA;NOMBRE;DIRECCION,INV;doc.account;doc.name;doc.address 

and then it will work.


See page 90 of the e2 Vault Customizing Guide for more details on each index and how they are to be set up.
 
Environment Details