Hi,

when i try to run a search criteria in advanced search bar based on date field('Create Date'>="2/25/2007%"),
it throws an error "unable to setup data connection which is preventing the application from working correctly(ARERR 9351)" and then when i try to exit out of remedy it throws an error "Session is invalid or has timed out. Please reload page to login again(ARERR 9201)"
it works fine from Remedy User tool, but when when we run this from web it gives the above errors.

i need some help on this particular issue.

How can u search when session has expired!

Mid-tier has session logout (Default values), User tool doesnt!

Login again n run d query! betr option wud b 'Create Date' >= "2/25/2007 12:00:00 AM").



why '%' in a query wid date field?

No i just login and immediately i give the search condition and then around after 2 min it throws an error of unable to setup data connection and then when i try to close that window it says session timeout.
i also tried giving 'Create Date' >= "2/25/2007 12:00:00 AM" but it does not work.

check server properties for 'UNQUALIFIED Searches'

Also check if u r able to do other operations (submit, other searches, modify etc) n check ur n/w connectivity.

its already checked and i am able to perform other searches.

i really dont know whats the problem?

Please i am waiting for n reply to my question on failing of date dearch criteria in mid tier.
can anybody help me out?

Oh that looks like a nasty one. It looks like one of them GoatExceptions. Which MidTier, OS, WebServer and Servlet Engine are you using?

How long does this take in the user tool?

Try the following Search in the Web and see what happens:
'3' > $DATE$

You get ARERR 9201 (Timeout or invalid data returned) because of ARERR 9351

Midtier 6.3
os-WINDOWS
webserver-IIS
Servlet engine-New Atlanta 5.0
in less than a min i get the result when i give the search criteria in User tool.

one more thing thing which i would like to tell is this particular date search criteria works from few systems and does not work from few systems.

So does it work for other date searches? (like for instance the example above)

We had a problem related to queries containing "like %00%" -- the solution was to get the latest patch for Servlet Exec (we are on 5.0p6).

Try clearing the local cache and also the Mid-tier cache (better if you restart IIS). This could be an issue.