Linda, I have not looked at your search conditions in your Set Field action(s), but I would bet that you are trying to do an equal search on a "long text field" on the remote form. If you look at the fields that your searching on you will likely find that there length is "large". ( I think >4000 will cause the message. )
BTW: This is an RDBMS "thing" and has nothing to do with ARS code. And as such the limits/effect may be varied based on the RDMBS your using. :) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 3/22/07, Linda Blomberg <[EMAIL PROTECTED]> wrote:
I am trying to run a filter on the AR system Email Messages form. This filter will run on all incoming email messages. I'm doing a set field that is reading the value from another form (FCIRT:ConfigRecord) that has 4 different email addresses in it, if anywhere in the To, CC or BCC fields there is an address match in the FCIRT:ConfigRecord then two fields zTmp (Character field) field should be set to the submitter and field zTmpClientName (Character field) should be set to FCIRT, then I have other workflow that should fire if zTmpClientName equals FCIRT. The problem is the email is getting an error in the AR System Email Error Log saying Message Type SEVERE, Message Number 4952 MessageType: 2 MessageNum: 313 MessageText: Data types are not appropriate for relational operation AppendedText: Message will be deleted without logging in email messages form because there is an error on submit. I've been working with Remedy on this for about a week, but we don't seem to be getting anywhere. Can anyone tell me what I might be doing wrong? (I've attached the filter in question) We are running ARS, and aremeail 6.3 patch20. Any help would be greatly appreciated. Thanks, Linda Blomberg Fermi National Accelerator Laboratory [EMAIL PROTECTED]
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"