VERIFIED SOLUTION i
X

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.
 

Downloads

  • No Downloads