Re: Mid Tier only, wrong date in results

2007-07-03 Thread Axton 

Ok, in 7.0.1 p3, there was a defect that was addressed that I thought
might be related.  It was impacting our environment in similar ways:

SW00261139: The mid tier fails to load the correct time zone file for
the user's time zone when the user bypasses the login screen.

In our case, the stock login.jsp was bypassed because we use an sso
solution that uses the sso login pages.

Axton Grams

On 7/3/07, Wheeler, Dylan <[EMAIL PROTECTED]> wrote:

Axton,
We're on 6.3 Patch 21. It does the same with our SSO server and a
straight OOB login server.

George,
That's the only ticket after 5pm on that day. I'll manually play with
the dates on a couple test records to see if it's an issue with the
timezone.

Thanks for the advice all, always appreciate it :)

Dylan

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, July 03, 2007 7:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier only, wrong date in results


What version of mid-tier (and patch level)?  Are you using the login.jsp
included with the mid-tier when logging in, or are you using another
method for authentication (url params, sso, customized login.jsp, etc.)?

On 7/3/07, Payne, George <[EMAIL PROTECTED]> wrote:
> **
>
>
>
> Dylan,
>
>
>
> Could it be a TIME ZONE issue on the mid tier either with the server
> or with the user's profile?  Is that the only ticket resolved after
> 5pm on 5/31?
>
>
>
> Gp
>
>
>
>
> George Payne
>
> Assistant Director, User Services
>
> Information Technology Services
>
> University of Texas at Austin
>
> 512.232.7513
>
>  
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
>  Sent: Monday, July 02, 2007 5:34 PM
>  To: arslist@ARSLIST.ORG
>  Subject: Mid Tier only, wrong date in results
>
>
>
>
>
> I have a user that runs an advanced query to get her results. The
> problem I'm seeing is that the same exact query run in the user tool
> gives different results then in the mid tier. I have a date/time field

> I put in called Resolved. The query she runs is
>
>
>
>
>
> 'Resolved' >= "6/1/2007" AND 'Resolved' < "7/01/2007"
>
>
>
>
>
> The user tool will return the correct results, the mid tier pulls up
> an extra one that has the Resolved field set to 5/31/2007 5:26:51 PM
>
>
>
>
>
> Is there something funky that happens with mid tier queries or did I
> find yet another mid tier bug?
>
>
>
>
> -
>
> Dylan Wheeler
>  Production Control Analyst Principal
>  IT Operations
>  Downey Savings & Loan Association, F.A.
>  Email: [EMAIL PROTECTED]
>
> This message and any attachments are for the intended recipient(s)
> only and may contain privileged, confidential and/or proprietary
> information about Downey Savings or its customers, which Downey
> Savings does not intend to disclose to the public. If you received
> this message by mistake, please notify the sender by reply e-mail and
> delete the message and attachments.
>
>
>
>
>
>
> This message and any attachments are for the intended recipient(s)
> only and may contain privileged, confidential and/or proprietary
> information about Downey Savings or its customers, which Downey
> Savings does not intend to disclose to the public.  If you received
> this message by mistake, please notify the sender by reply e-mail and
> delete the message and attachments.
> __20060125___This posting was submitted with HTML
> in it___ __20060125___This
> posting was submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Mid Tier only, wrong date in results

2007-07-03 Thread Wheeler, Dylan 
Axton,
We're on 6.3 Patch 21. It does the same with our SSO server and a
straight OOB login server.

George,
That's the only ticket after 5pm on that day. I'll manually play with
the dates on a couple test records to see if it's an issue with the
timezone.

Thanks for the advice all, always appreciate it :)

Dylan

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, July 03, 2007 7:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid Tier only, wrong date in results


What version of mid-tier (and patch level)?  Are you using the login.jsp
included with the mid-tier when logging in, or are you using another
method for authentication (url params, sso, customized login.jsp, etc.)?

On 7/3/07, Payne, George <[EMAIL PROTECTED]> wrote:
> **
>
>
>
> Dylan,
>
>
>
> Could it be a TIME ZONE issue on the mid tier either with the server 
> or with the user's profile?  Is that the only ticket resolved after 
> 5pm on 5/31?
>
>
>
> Gp
>
>
>
>
> George Payne
>
> Assistant Director, User Services
>
> Information Technology Services
>
> University of Texas at Austin
>
> 512.232.7513
>
>  
>
>
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
>  Sent: Monday, July 02, 2007 5:34 PM
>  To: arslist@ARSLIST.ORG
>  Subject: Mid Tier only, wrong date in results
>
>
>
>
>
> I have a user that runs an advanced query to get her results. The 
> problem I'm seeing is that the same exact query run in the user tool 
> gives different results then in the mid tier. I have a date/time field

> I put in called Resolved. The query she runs is
>
>
>
>
>
> 'Resolved' >= "6/1/2007" AND 'Resolved' < "7/01/2007"
>
>
>
>
>
> The user tool will return the correct results, the mid tier pulls up 
> an extra one that has the Resolved field set to 5/31/2007 5:26:51 PM
>
>
>
>
>
> Is there something funky that happens with mid tier queries or did I 
> find yet another mid tier bug?
>
>
>
>
> -
>
> Dylan Wheeler
>  Production Control Analyst Principal
>  IT Operations
>  Downey Savings & Loan Association, F.A.
>  Email: [EMAIL PROTECTED]
>
> This message and any attachments are for the intended recipient(s) 
> only and may contain privileged, confidential and/or proprietary 
> information about Downey Savings or its customers, which Downey 
> Savings does not intend to disclose to the public. If you received 
> this message by mistake, please notify the sender by reply e-mail and 
> delete the message and attachments.
>
>
>
>
>
>
> This message and any attachments are for the intended recipient(s) 
> only and may contain privileged, confidential and/or proprietary 
> information about Downey Savings or its customers, which Downey 
> Savings does not intend to disclose to the public.  If you received 
> this message by mistake, please notify the sender by reply e-mail and 
> delete the message and attachments. 
> __20060125___This posting was submitted with HTML 
> in it___ __20060125___This
> posting was submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


This message and any attachments are for the intended recipient(s) only and may 
contain privileged, confidential and/or proprietary information about Downey 
Savings or its customers, which Downey Savings does not intend to disclose to 
the public.  If you received this message by mistake, please notify the sender 
by reply e-mail and delete the message and attachments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Mid Tier only, wrong date in results

2007-07-03 Thread Axton 

What version of mid-tier (and patch level)?  Are you using the
login.jsp included with the mid-tier when logging in, or are you using
another method for authentication (url params, sso, customized
login.jsp, etc.)?

On 7/3/07, Payne, George <[EMAIL PROTECTED]> wrote:

**



Dylan,



Could it be a TIME ZONE issue on the mid tier either with the server or with
the user's profile?  Is that the only ticket resolved after 5pm on 5/31?



Gp




George Payne

Assistant Director, User Services

Information Technology Services

University of Texas at Austin

512.232.7513

 


From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
 Sent: Monday, July 02, 2007 5:34 PM
 To: arslist@ARSLIST.ORG
 Subject: Mid Tier only, wrong date in results





I have a user that runs an advanced query to get her results. The problem
I'm seeing is that the same exact query run in the user tool gives different
results then in the mid tier. I have a date/time field I put in called
Resolved. The query she runs is





'Resolved' >= "6/1/2007" AND 'Resolved' < "7/01/2007"





The user tool will return the correct results, the mid tier pulls up an
extra one that has the Resolved field set to 5/31/2007 5:26:51 PM





Is there something funky that happens with mid tier queries or did I find
yet another mid tier bug?




-

Dylan Wheeler
 Production Control Analyst Principal
 IT Operations
 Downey Savings & Loan Association, F.A.
 Email: [EMAIL PROTECTED]

This message and any attachments are for the intended recipient(s) only and
may contain privileged, confidential and/or proprietary information about
Downey Savings or its customers, which Downey Savings does not intend to
disclose to the public. If you received this message by mistake, please
notify the sender by reply e-mail and delete the message and attachments.






This message and any attachments are for the intended recipient(s) only and
may contain privileged, confidential and/or proprietary information about
Downey Savings or its customers, which Downey Savings does not intend to
disclose to the public.  If you received this message by mistake, please
notify the sender by reply e-mail and delete the message and attachments.
__20060125___This posting was submitted
with HTML in it___ __20060125___This
posting was submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers 
Are"

Re: Mid Tier only, wrong date in results

2007-07-03 Thread Payne, George 
Dylan,

 

Could it be a TIME ZONE issue on the mid tier either with the server or
with the user's profile?  Is that the only ticket resolved after 5pm on
5/31?

 

Gp

 

George Payne

Assistant Director, User Services

Information Technology Services

University of Texas at Austin

512.232.7513



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan
Sent: Monday, July 02, 2007 5:34 PM
To: arslist@ARSLIST.ORG
Subject: Mid Tier only, wrong date in results

 

I have a user that runs an advanced query to get her results. The
problem I'm seeing is that the same exact query run in the user tool
gives different results then in the mid tier. I have a date/time field I
put in called Resolved. The query she runs is

 

'Resolved' >= "6/1/2007" AND 'Resolved' < "7/01/2007"

 

The user tool will return the correct results, the mid tier pulls up an
extra one that has the Resolved field set to 5/31/2007 5:26:51 PM

 

Is there something funky that happens with mid tier queries or did I
find yet another mid tier bug?

 

- 

Dylan Wheeler
Production Control Analyst Principal 
IT Operations 
Downey Savings & Loan Association, F.A. 
Email: [EMAIL PROTECTED]   

This message and any attachments are for the intended recipient(s) only
and may contain privileged, confidential and/or proprietary information
about Downey Savings or its customers, which Downey Savings does not
intend to disclose to the public. If you received this message by
mistake, please notify the sender by reply e-mail and delete the message
and attachments.

 

 

This message and any attachments are for the intended recipient(s) only
and may contain privileged, confidential and/or proprietary information
about Downey Savings or its customers, which Downey Savings does not
intend to disclose to the public.  If you received this message by
mistake, please notify the sender by reply e-mail and delete the message
and attachments.

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"