Hi.
I'v applied SP3 and then found following error in Application Log:

Event ID: 4104
Description:
Pipeline Error: [centaursubs]Component Execution failed for component	
1;0x0]  hr: 0x80004005
ProgID: Commerce.CSFRecordEvent.1
The attempt to index the column 'date_end' failed.  Columns must be of integ
er, string, or variant array types to be indexable or searchable.

Event is recorded every time a customer clicks on ad and the site tries to r
ecord CLICK event. The same code is used to record discount clicks and works
 fine.

Any ideas?

Best Regards,
Alexander.

[ Post a follow-up to this message ]

The only thing I can think is that somehow the component has cached the
wrong Column ID of the ContentList and is therefore trying to search the
wrong column (in this case it would search for item_id).  That could happen
in the following cases:

1. After the CSF pipeline was already created and loaded, the schema of the
ContentList was changed (e.g. the ad or discount query was changed on the
fly).
2. The same pipeline is being used with two different ContentLists with
different schemas.

The fix: for #1, simply IISReset.  For #2, use different pipelines for
different ContentLists.

I hope this helps.  If not, you may want to contact PSS for help so we can
get to the bottom of this.

-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation.  All rights
reserved.

--------------------
Thread-Topic: error after SP3
thread-index: AcRYRhwG2OQ4RRcwRdKNry23G7SalA==
X-WBNR-Posting-Host: 212.95.252.23
From: examnotes <Alexander@discussions.microsoft.com>
Subject: error after SP3
Date: Tue, 22 Jun 2004 03:46:01 -0700
Lines: 15
Message-ID: <A7FE5232-A3C4-4333-820C-D6C6543143B4@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.campaigns_csf
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl
microsoft.public.commerceserver.campaigns_csf:2726
X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf

Hi.
I'v applied SP3 and then found following error in Application Log:

Event ID: 4104
Description:
Pipeline Error: [centaursubs]Component Execution failed for component	
1;0x0]
hr: 0x80004005
ProgID: Commerce.CSFRecordEvent.1
The attempt to index the column 'date_end' failed.  Columns must be of
integer, string, or variant array types to be indexable or searchable.

Event is recorded every time a customer clicks on ad and the site tries to
record CLICK event. The same code is used to record discount clicks and
works fine.

Any ideas?

Best Regards,
Alexander.

[ Post a follow-up to this message ]