TechNote (Archived)

ColdFusion MX 6.1: Custom Verity collections fail to index

Issue

Custom Verity collections that indexed correctly in Macromedia ColdFusion 5 may no longer index after upgrading to ColdFusion MX. When the indexing fails, the following error will appear in the sysinfo.log located atcf_root\verity\collections\collection_name\custom:

 Wed Dec 17 13:37:11 2003   msg(1): Error E2-0531 (Document Index): Document 1 (3744):   Unable to index document - SKIPPING

This problem occurs when cfindex is used to index a query and the body attribute has a line break between the list of values. This typically occurs when there is a long comma-delimited list of values. For example, thecfindex tag would be similar to this:

 <cfindex action="refresh"   collection="test"   key="empno"   type="custom"      query="MyQuery"   body="empno, ename, job, mgr, hiredate,   sal, comm, deptno">

This has been identified as Macromedia issue 53882.

Solution

To avoid this issue, modify the code so no line breaks occur between the values listed for the body attribute. The code should be modified to look similar to the following example:

 <cfindex action="refresh"   collection="test"   key="empno"   type="custom"      query="MyQuery"   body="empno, ename, job, mgr, hiredate, sal, comm, deptno">