Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#137986 - 06/13/07 06:03 AM Regd search based on a date field in mid tier
Kalpana K Offline
Stealth Member

Registered: 06/11/07
Posts: 5
Loc: India,Bangalore
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.

Top
#137988 - 06/13/07 06:41 AM Re: Regd search based on a date field in mid tier [Re: Kalpana K]
Vishwas P Offline
Stealth Member

Registered: 01/15/07
Posts: 125
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?

Top
#138012 - 06/14/07 04:32 AM Re: Regd search based on a date field in mid tier [Re: Vishwas P]
Kalpana K Offline
Stealth Member

Registered: 06/11/07
Posts: 5
Loc: India,Bangalore
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.

Top
#138020 - 06/14/07 08:21 AM Re: Regd search based on a date field in mid tier [Re: Kalpana K]
Vishwas P Offline
Stealth Member

Registered: 01/15/07
Posts: 125
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.

Top
#138028 - 06/14/07 09:45 AM Re: Regd search based on a date field in mid tier [Re: Vishwas P]
Kalpana K Offline
Stealth Member

Registered: 06/11/07
Posts: 5
Loc: India,Bangalore
its already checked and i am able to perform other searches.

i really dont know whats the problem?

Top
#138066 - 06/19/07 02:43 AM Re: Regd search based on a date field in mid tier [Re: Kalpana K]
Kalpana K Offline
Stealth Member

Registered: 06/11/07
Posts: 5
Loc: India,Bangalore
Please i am waiting for n reply to my question on failing of date dearch criteria in mid tier.
can anybody help me out?

Top
#138149 - 06/26/07 03:14 AM Re: Regd search based on a date field in mid tier [Re: Kalpana K]
Shark_7-11 Offline
Stealth Member
*****

Registered: 09/26/06
Posts: 267
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
_________________________
Mayhem, Chaos and Anarchy
My job here is complete!

Top
#138164 - 06/27/07 06:15 AM Re: Regd search based on a date field in mid tier [Re: Shark_7-11]
Kalpana K Offline
Stealth Member

Registered: 06/11/07
Posts: 5
Loc: India,Bangalore
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.

Top
#138167 - 06/27/07 08:22 AM Re: Regd search based on a date field in mid tier [Re: Shark_7-11]
Shark_7-11 Offline
Stealth Member
*****

Registered: 09/26/06
Posts: 267
 Originally Posted By: Shark_7-11
Try the following Search in the Web and see what happens:
'3' > $DATE$

So does it work for other date searches? (like for instance the example above)
_________________________
Mayhem, Chaos and Anarchy
My job here is complete!

Top
#138171 - 06/27/07 04:21 PM Re: Regd search based on a date field in mid tier [Re: Shark_7-11]
Joe P Offline
Just Signed Up

Registered: 07/20/06
Posts: 4
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).

Top
#138174 - 06/28/07 01:38 AM Re: Regd search based on a date field in mid tier [Re: Joe P]
Vishwas P Offline
Stealth Member

Registered: 01/15/07
Posts: 125
Try clearing the local cache and also the Mid-tier cache (better if you restart IIS). This could be an issue.

Top
Page 1 of 2 1 2 >