RE: Anyone Using Kronos?
- From: M Rafiq <rafiq9857@xxxxxxxxxxx>
- To: <jbeckstrom@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <srcdco@xxxxxxx>
- Date: Fri, 26 Sep 2008 12:23:05 -0400
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 -0400From: JBECKSTROM@xxxxxxxxxxx:
oracle-l@xxxxxxxxxxxxx; srcdco@xxxxxxxxxxxxxx: 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 BeckstromDatabase AdministratorGreater Cleveland Regional Transit
Authority1240 W. 6th StreetCleveland, 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 performedby SurfControl E-mail
Filter software in conjunction with virus detection software.
_________________________________________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008
Other related posts:
