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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: "Data types are not appropriate" on MT but not on UT
Restarting the service worked. H, 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"
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. H, 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"
Re: "Data types are not appropriate" on MT but not on UT
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. H, 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"
Re: "Data types are not appropriate" on MT but not on UT
I don't know about the dynamic caching, but if you are using a prefetch.xml file (mandatory with ITSM7) it will not execute until you restart the web service following the manual cache flush. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 04, 2008 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** 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. H, now the research begins as to why it gets "stale" in the first place? Lisa From: Action Request System discussion list(ARSList) __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"
Re: "Data types are not appropriate" on MT but not on UT
I am guessing this is your problem: BasicGuide-630.2006.05.09.pdf Pg 669 " In forms viewed on the Web, if EXTERNAL() references a field that contains a qualification such as $Date 1$ <= 'Date 2', you must add double quotation marks around $Date 1$, like this: "$Date 1$" <= 'Date 2'. " But you did not share your qualification so I am just guessing. :( -- 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 Tue, Jun 3, 2008 at 3:25 PM, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > ** > > 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] > > __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"
Re: "Data types are not appropriate" on MT but not on UT
IMO, this is a bug... I don't care if it is working "as designed"! Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of strauss Sent: Wed 06/04/08 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT I don't know about the dynamic caching, but if you are using a prefetch.xml file (mandatory with ITSM7) it will not execute until you restart the web service following the manual cache flush. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 04, 2008 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** 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. H, now the research begins as to why it gets "stale" in the first place? Lisa From: Action Request System discussion list(ARSList) __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"
Re: "Data types are not appropriate" on MT but not on UT
It seems to be a permission problem. It DOES happen on the UT when I log on as a normal user. But when I log on with my Admin user, I don't get this message. It's just a simple table in my form with this qualification: 'Create Date' >= $Result From Date$ AND 'Create Date' < $Result To Date$ Both Create Date on the other form and the Result From Date and Result To Date are Date/Time fields. Does it have something to do with the Core Field of Create Date? Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 04, 2008 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** IMO, this is a bug... I don't care if it is working "as designed"! Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of strauss Sent: Wed 06/04/08 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT I don't know about the dynamic caching, but if you are using a prefetch.xml file (mandatory with ITSM7) it will not execute until you restart the web service following the manual cache flush. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) __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"
Re: "Data types are not appropriate" on MT but not on UT
Both Fields both have Public (no change) permissions Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, June 06, 2008 11:18 AM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** It seems to be a permission problem. It DOES happen on the UT when I log on as a normal user. But when I log on with my Admin user, I don't get this message. It's just a simple table in my form with this qualification: 'Create Date' >= $Result From Date$ AND 'Create Date' < $Result To Date$ Both Create Date on the other form and the Result From Date and Result To Date are Date/Time fields. Does it have something to do with the Core Field of Create Date? Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 04, 2008 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** IMO, this is a bug... I don't care if it is working "as designed"! Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of strauss Sent: Wed 06/04/08 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT I don't know about the dynamic caching, but if you are using a prefetch.xml file (mandatory with ITSM7) it will not execute until you restart the web service following the manual cache flush. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) __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"
Re: "Data types are not appropriate" on MT but not on UT
Make sure it has allow any user to submit From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, June 06, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT Both Fields both have Public (no change) permissions Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, June 06, 2008 11:18 AM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** It seems to be a permission problem. It DOES happen on the UT when I log on as a normal user. But when I log on with my Admin user, I don't get this message. It's just a simple table in my form with this qualification: 'Create Date' >= $Result From Date$ AND 'Create Date' < $Result To Date$ Both Create Date on the other form and the Result From Date and Result To Date are Date/Time fields. Does it have something to do with the Core Field of Create Date? Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 04, 2008 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** IMO, this is a bug... I don't care if it is working "as designed"! Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of strauss Sent: Wed 06/04/08 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT I don't know about the dynamic caching, but if you are using a prefetch.xml file (mandatory with ITSM7) it will not execute until you restart the web service following the manual cache flush. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: "Data types are not appropriate" on MT but not on UT
Found the problem. Both fields did NOT have Public. Changed the field to have Public and everything is OKEE DOKEE! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, June 06, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** Both Fields both have Public (no change) permissions Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, June 06, 2008 11:18 AM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** It seems to be a permission problem. It DOES happen on the UT when I log on as a normal user. But when I log on with my Admin user, I don't get this message. It's just a simple table in my form with this qualification: 'Create Date' >= $Result From Date$ AND 'Create Date' < $Result To Date$ Both Create Date on the other form and the Result From Date and Result To Date are Date/Time fields. Does it have something to do with the Core Field of Create Date? Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 04, 2008 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT ** IMO, this is a bug... I don't care if it is working "as designed"! Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of strauss Sent: Wed 06/04/08 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: "Data types are not appropriate" on MT but not on UT I don't know about the dynamic caching, but if you are using a prefetch.xml file (mandatory with ITSM7) it will not execute until you restart the web service following the manual cache flush. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"