Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 18736 invoked from network); 9 Sep 2008 06:26:16 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 9 Sep 2008 06:26:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 027CA93EA9D; Tue, 9 Sep 2008 07:26:16 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20872-07; Tue, 9 Sep 2008 07:26:15 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 71EDB93E9B3; Tue, 9 Sep 2008 07:26:15 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 09 Sep 2008 07:24:17 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8195F93EA73 for ; Tue, 9 Sep 2008 07:24:17 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20493-08 for ; Tue, 9 Sep 2008 07:24:17 -0400 (EDT) Received: from groupwise.gcrta.org (groupwise.gcrta.org [70.238.103.170]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C39E93EA2B for ; Tue, 9 Sep 2008 07:24:16 -0400 (EDT) Received: from Main1-MTA by groupwise.gcrta.org with Novell_GroupWise; Tue, 09 Sep 2008 07:24:08 -0400 Message-Id: <48C62490.3406.000B.0@gcrta.org> Date: Tue, 09 Sep 2008 07:24:01 -0400 From: "Jeffrey Beckstrom" To: , Subject: Re: Anyone Using Kronos? References: In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part7B52F8C1.0__=" X-archive-position: 10692 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-to: JBECKSTROM@gcrta.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --=__Part7B52F8C1.0__= Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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? =20 Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 >>> "Scott Canaan" 9/8/08 4:23 PM >>> I=92m 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=92m 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=92t successfully upgrade a clone of production, then how can we = upgrade production? My question is: Has anyone successfully done this upgrade? =20 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. =20 Thank you, =20 Scott Canaan '88 (Scott.Canaan@rit.edu) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into = it." - Tom Lehrer. =20 --------------------------------------------------------------------- Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with=20 virus detection software. --=__Part7B52F8C1.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
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@rit.edu> 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@rit.edu)

(585) 475-7886

"Life is like a sewer, what you get out of it = depends on what you put into it." - Tom Lehrer.

 



--=__Part7B52F8C1.0__=-- -- http://www.freelists.org/webpage/oracle-l

-------------------------------------------------------------------= --


Scanning of this message and additio= n of this footer is performed
by SurfContr= ol E-mail Filter software in conjunction with=  
virus detection software.