August 27, 2003 at 9:28 am
We've got an environment that we need to do date specific testing for accounting. That is, start with today's date and then change the date to simulate month-end and close / balance the books. Then move the date up again the following week to simulate the next month-end.
Does anyone know of any product or tool that would allow us to make the application think it's in the future without having to change the current date on the server?
We encountered problems with the domain controller, licenses, passwords, etc. when we changed the server date.
Thanks,
Gary
August 27, 2003 at 9:48 am
First to answer your question: No, I've never heard of any software that would do that.
However, could you change the way the month end kicks things off?
Meaning how does the application know when to fire off the month end routines? It obviously uses the system date but does it just fire on the 28th, 29th, 30th or 31st depending on the month?
Is it something in the database or an application riding on top of it?
Is there a
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 27, 2003 at 9:50 am
Is there a stored procedure in the database that kicks off the month end routine? If so you'd just be able to muck around with that and fire it off at will.
If it's in an application you'd probably need to talk to the developers.
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 28, 2003 at 12:01 am
I don't know such a tool.
IMO changing the system-date might be no issue on a TEST server, but on a production environment ???
Provide the date with a parameter to your application. Suppose your hardware fails on end-of-month-closure/balance and you're only able to get it back up and running when the date has changed?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 28, 2003 at 8:55 am
This posting brings back some not-so-fond memories of Y2K testing!!! At the time I was working with COBOL on MVS and AS/400 platforms which of course we couldn't change the system date on. So, we aged the data files and modified job input parameters in the JCL. There were tools for both platforms which aged the files automatically, however you should be able to accomplish the same thing by aging the date columns in your SQL database.
More recently, I have conducted batch processing testing by resetting the system time on a test SQL Server (which is part of an Active Directory domain). Yes it's true, some things will no longer work once you've adjusted the datetime more than 10 minutes from the AD controller's datetime. For example you can't use Windows authentication to connect to the SQL Server, nor can you browse to the server's drives. However you can still use SQL authentication (which this particular application solely used) and you can still terminal service to the server. Using this technique we were able to successfully regression test a new build of a vendor product against the production version by running the previous day's files through the system. I've also created some VBScript/ VB dll which I incorporated into a SQL Agent job to schedule resetting the system date on the server (I can send them if you're interested).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply