Re: Data types are not appropriate for relational operation, 313, error message

[Brien Dieterle]

** I just started getting this error and happened to notice this thread.  I was definitely fiddling with the enumeration numbers on several fields on a custom form. AR System 7.5 P3, Dev Studio 7.5 P3 on Windows 7 The oddest thing is, I can add any singular clause like "FieldX = 0"  A moment later it will resolve that to "FieldX = "Yes".   I can save it just fine.   However, if I add another clause such as "AND FieldY = 0"  It will resolve that and upon save get the error.  And yet FieldY = 0, by itself, does not produce the error.  In fact, duplicating a clause causes the error as well (FieldX = 0 AND FieldX = 0).  So it seems it is merely having 2 or more clauses that causes the problem, not a resolution or caching problem...   I've deleted my entire devstudio wkspace folder... I've tried making an entirely new filter, same problem I've tried an entirely new filter on a different form that I haven't modified lately-- same problems. I'll have to start down the restarting things path... Brien On 1/7/2010 3:43 PM, Lyle Taylor wrote: Do you have the most recent patch version of Developer Studio?  I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet.   I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk.  I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief.  The fix was to delete the files that DS created in the workspace directory and then reopen the object.  I suspect that there are issues around how DS determines whether the cached object is correct/up to date.   Lyle   From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message   ** Did you change the labels on any of your enums? I hit this all the time if I changed something.   Example - A filter was created with a Qualification of Status < "Work In Progress". You changed the enum 7  from "Work In Progress" to "Development in Progress". Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says "Work In Progress".  As long as you don't touch the qualification you can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status < 7 which will get it to resolve to Development in Progress and now you can happily save..   This is frustrating.. Is it just me or did Admin Tool do this properly and translate the enum label for you when you opened the Filter for editing????   Kelly Deaver kdea...@kellydeaver.com (ARSlist mail)     -------- Original Message -------- Subject: Re: Data types are not appropriate for relational operation, 313, error message From: Kevin Begosh <kbeg...@gmail.com> Date: Thu, January 07, 2010 11:13 am To: arslist@ARSLIST.ORG ** Sorry I meant to say this before I sent it out.  I seems like it is only happening on one of our environments, one developer tool etc...  Any reason anyone know why this would be happening.  What is wrong with that environment that the developer tool would be mistaking on selection values, I guess more so not recognizing them?   Kevin On Thu, Jan 7, 2010 at 12:02 PM, Kevin Begosh <kbeg...@gmail.com> wrote: List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields.  Has anyone else been getting these.  For example I am working with filter   RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor   and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to.  When I try to save my changes I keep getting that error message   Data types are not appropriate for relational operation,  313, It looks like the out of the box code is getting the error message.   For instance if you go in that filter and change one of the selection fields to a different value, such as 'UnknownUser' from False to True I get that error message.   Is there something querky going on with 7.5, is it something with the server I am on, or the developer tool etc....   I never got these on the admin tool prior to 7.5   Env: windows 2003 server, AR Server 7.5, ITSM 7.5 -- Kevin Begosh -- Kevin Begosh _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_