RE: Anyone Using Kronos?
- From: "Scott Canaan" <srcdco@xxxxxxx>
- To: "M Rafiq" <rafiq9857@xxxxxxxxxxx>, <jbeckstrom@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Sep 2008 12:39:11 -0400
We finally got past the upgrade errors and have done ONE successful
upgrade. We are planning on doing two more before we attempt
production. What I ended up doing was to do an export of the tkcsowner
user from production, drop the test database, create a new, empty test
database as Oracle 10.2.0.4, then import the production export file into
it. Then the Kronos admin ran the upgrade and it worked. There was one
other change made while I was doing all this additional work that may be
the real fix, but we are so far behind schedule that the admin doesn't
want to test the theory. That was that he wiped the windows box clean,
downloaded a fresh copy of Kronos 6 and installed there. I wasn't aware
that he was doing that at the same time that he asked me to "please do
what Kronos says and do the export / import".
I have never been able to get from Kronos why there would be a
difference between doing an export / import and a clone and Oracle
upgrade (or just an Oracle upgrade and then Kronos upgrade in place for
production). Their answer is that it works that way and that's the only
way to do it. This tells me that they also had problems at some point
and stumbled on this "fix" and have no idea why it works (and probably
don't really care). Their support has been adamant that this is the
only way to have a successful upgrade. It only adds about 10 hours to
the whole upgrade.
Scott Canaan '88 (Scott.Canaan@xxxxxxx)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-----Original Message-----
From: M Rafiq [mailto:rafiq9857@xxxxxxxxxxx]
Sent: Friday, September 26, 2008 12:23 PM
To: jbeckstrom@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx; Scott Canaan
Subject: RE: Anyone Using Kronos?
Jeffrey,
What was the issue you identfied during kronos upgrade. I am expecting
upgrade of kronos database from 8.1.7 to 10.2.0.3 for Kronos v6 upgrade
in foreseebale future.
Regards
Rafiq
________________________________
Date: Tue, 9 Sep 2008 07:24:01 -0400
From: JBECKSTROM@xxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx; srcdco@xxxxxxx
Subject: Re: Anyone Using Kronos?
We are in the midst of a v4.3 to v6 upgrade as well. We have been
having problems with the upgrade.sql script getting an "invalid sql
statement" error. We have just identified the problem. Is this the
same error you are getting?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
>>> "Scott Canaan" <srcdco@xxxxxxx> 9/8/08 4:23 PM >>>
I'm looking for anyone else that is using Kronos. We are trying to
upgrade from Workforce Central v5.1 to v6.0 and have been having
problems. They have a script, called upgrade.sql that has an anonymous
PL/SQL block in it that does a lot of dynamic SQL. That block aborts
part way through as they are trying to convert all of their text fields
from varchar2 to nvarchar2 (and char to nchar and clob to nclob). There
is no exception processing in the block and I'm having trouble
determining which table it is aborting on. We are creating the test
database by cloning from production. The vendor says that we have to
copy production to test via export / import to do the upgrade
successfully. My answer to that is that if we can't successfully
upgrade a clone of production, then how can we upgrade production?
My question is: Has anyone successfully done this upgrade?
We are on Oracle 10.2.0.4 Enterprise Edition, upgraded from 9.2.0.6 just
prior to the Kronos upgrade. I know that this is a bit off-topic, but
hopefully someone here has done this and can help point me in the right
direction.
Thank you,
Scott Canaan '88 (Scott.Canaan@xxxxxxx)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
---------------------------------------------------------------------
Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with
virus detection software.
________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live. Learn
Now
<http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-c
ns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_getmore_092008>
Other related posts:
