error in uPlan using filter

241 views
Skip to first unread message

efrank

unread,
Nov 18, 2009, 4:48:01 PM11/18/09
to XMPie Interest Group
Generating Proof set ...
Error: There is a type mismatch between the field types of
the recipients database and the Plan file Recipient Information
Schema.
The mismatch occurred between (Plan type - query type):
UID, cod_are, tel_hab, celular, fecha_cita, hora_cita, register_date,
PURL, recomendado, dia_cita.

Proof Set could not be created (1 errors, 0 warnings).


This the error I get if I generate a proof set with a filter on that
contains the following expression:

Select @[prensa].[nombre_prensa], @[prensa].[apellido_prensa], @
[prensa].[correo_prensa]
From @[prensa]
Where (@[prensa].[PURL] is null)
and (@[prensa].[recomendado] is null)

It does not occur if I generate a proof set with the all recipients
filter on.

Any ideas on why the error.

George Marsh

unread,
Nov 18, 2009, 5:26:41 PM11/18/09
to xmpie...@googlegroups.com
try this:

Select *
From @[prensa]
Where [prensa].[PURL] is null and @[prensa].[recomendado] is null

what datasource are you using?

efrank

unread,
Nov 18, 2009, 6:10:50 PM11/18/09
to XMPie Interest Group
This solved it. Thanks
Reply all
Reply to author
Forward
0 new messages