The other "disturbing" thing is reflushing the mid-tier cache did not fix the problem, it was a restart of the web service that fixed it, which I have also experienced.... Seems to me the reflush/recache of the mid-tier is not 100% reliable... (evevn with a mid-tier 7.1 patch 2). That's the reason why when I recache our mid-tiers, I also restart the service in both web servers
Guillaume -----Original Message----- From: Guillaume Rheault Sent: Wed 06/04/08 1:50 PM To: arslist@ARSLIST.ORG; arslist@ARSLIST.ORG Subject: RE: "Data types are not appropriate" on MT but not on UT Most likely somebody changed something (probably a form, i.e. adding a field, changing field properties or layout), and then forgot to recache the mid-tier... I had that same scenario you are describing just recently, we are using ARS 7.0.1 patch with Mid-tier 7.1 patch 2 -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Kemes, Lisa Sent: Wed 06/04/08 10:43 AM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT Restarting the service worked. Hmmmm, now the research begins as to why it gets "stale" in the first place? Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, June 03, 2008 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** I've flushed the cache, but I'm still getting the error. I'm going to try to recycle the apache/Tomcat service. Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Tuesday, June 03, 2008 3:36 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** looks like the definitions on your mid-tier are stale. I would recache the mid-tier, and as a precautionary step, restart your web server. Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Kemes, Lisa Sent: Tue 06/03/08 3:25 PM To: arslist@ARSLIST.ORG Subject: "Data types are not appropriate" on MT but not on UT I have a form that has a table field. When I pull up a record on the UT everything is OK, but on the MT I get the error "Data types are not appropriate for relational operation (ARERR 313)" I understand what this message means, but not when it works on the UT and not the MT. My qualification on the table is looking for a record with a Date and Time field that equals the Date and Time field data on my form. (same data types if you ask me) :) MT 7.0.1 patch 5 UT 7.1 Patch 1 ARS 7.0.1 Patch 3 Windows 2003 Server..... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"