Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
greenej77

Member
Registered:
Posts: 19
Reply with quote  #1 
Okay, one of my users told me about a new problem today.

I have a date control on one of my forms and I have its "Earliest" and "Latest" set to other variables within the same process.  For some reason, when the form comes up it gives me a "Date is out of range" error if either of those is set to today.  Once they acknowledge the error, the form works fine and they still can only select dates between the "Earliest" and "Latest" dates, so the setting still works.

I don't know if it's the fact that it's the current date, or if it just doesn't like March 31, 2011.  I did do some troubleshooting and manually updated those variables to 3/31/2011 @ 12:01 AM and it worked... as soon as I set it back to 3/31/2011 @ 12:00 AM, it started prompting me with the error again.

Anybody else notice this before?

I'll test it again tomorrow and see if it still doesn't like March 31, 2011, or if it just doesn't like whatever day today is.
0
greenej77

Member
Registered:
Posts: 19
Reply with quote  #2 
Did a little more troubleshooting and it seems like the time didn't have the effect I thought it did.  When I changed the time in the database, it set the "Earliest" greater than the "Latest".  Strange that THAT didn't give me an error.

But what I've been able to determine is that it seems as though I get this error anytime the "Earliest" and "Latest" happen to be the same date... AND that date is the last day of the month.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #3 
This may be due to the time being 'adjusted' for time zone. We have had a large number of issues with this 'feature' that seems to have been 'improved' in version 9. It was poorly designed in version 6 & 7, and it has now been seemingly poorly implemented in version 9.

A very interesting issue is that the datbase time is now relevant wheras it used not to be. That ma be as designed, or just bad coding, I am not sure. Either way, it is a complete PIA as if the two drift even slightly you can get these errors. If the earliest date is 1/1/2001 00:01 because of this drift, and the variable comes back from the database as 1/1/2001, it will fail for example.

I have no idea if this is your problem however, as it seems to be an end of month error. Certainly if the date is calculated in any way at all, this issue seems to occur, however. Are your earliest and latest dates calculated?

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
Quote:
Originally Posted by greenej77
... AND that date is the last day of the month.

Let's just hope we have not discovered a whole new acronym: MBPM PMS!

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
greenej77

Member
Registered:
Posts: 19
Reply with quote  #5 
Yeah, I've already had issues with the database and engine times being just a second or two off.  Thankfully I found a temporary workaround for that while Metastorm is trying to resolve it.

Back to this problem... no, the earliest and latest dates are not calculated.  The workflow in question is a training request workflow and the users input the beginning and end date.  Those dates are used in this section so they can request what kind of training they need on day 1, day 2, day 3, etc.

To make sure that wasn't the problem, I took away the earliest and latest selections and the error message went away.  I explicitly set the beginning and end dates to 3/31/2011. Same problem.

I went ahead and opened another support request. Hopefully they'll be able to replicate it and let me know i'm not crazy.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!