Thank you Mr. Strauss,
I did try this sequence and recieved the same upgrade error. But upon viewing the SQL install log, it shows the following Errors regarding T373 which I believe is 'AR System Email Mailbox Configuration'.
I have forwarded these results to Remedy Support.
Any course of action on these? At the database level I assume?
/* Tue Nov 14 17:56:57 2006 */ ALTER TABLE T373 ADD newencrypted102 varchar(255) NULL
/* Tue Nov 14 17:56:57 2006 */ *** ERROR *** Cannot find the object "T373" because it does not exist or you do not have permissions. (SQL Server 4902)
/* Tue Nov 14 17:56:57 2006 */ ROLLBACK TRANSACTION
/* Tue Nov 14 17:56:57 2006 */ *** ERROR *** The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903)
/* Tue Nov 14 17:56:57 2006 */ OK
/* Tue Nov 14 17:56:57 2006 */ ALTER TABLE T2 DROP COLUMN newencrypted102
/* Tue Nov 14 17:56:57 2006 */ *** ERROR *** ALTER TABLE DROP COLUMN failed because column 'newencrypted102' does not exist in table 'T2'. (SQL Server 4924)
/* Tue Nov 14 17:56:57 2006 */ ALTER TABLE user_cache DROP COLUMN newencrypted102
/* Tue Nov 14 17:56:57 2006 */ *** ERROR *** ALTER TABLE DROP COLUMN failed because column 'newencrypted102' does not exist in table 'user_cache'. (SQL Server 4924)
/* Tue Nov 14 17:56:57 2006 */ ALTER TABLE T373 DROP COLUMN newencrypted102
/* Tue Nov 14 17:56:57 2006 */ *** ERROR *** Cannot find the object "T373" because it does not exist or you do not have permissions. (SQL Server 4902)
/* Tue Nov 14 17:56:57 2006 */ DROP TABLE temp_102_upgrade
/* Tue Nov 14 17:56:57 2006 */ OK
/* Tue Nov 14 17:56:57 2006 */ CLOSE DATABASE
/* Tue Nov 14 17:56:57 2006 */ SQL Trace Log -- OFF
On 11/14/06, strauss <[EMAIL PROTECTED]> wrote:
**I would expect you to have to do this:Backup the existing ARS 5.01.02 ARSystem db in SQL Server 2000 to file.Build a new system on ARS 5.01.02 and SQL Server 2000 (ARS 5 and 6 will not install on SQL Server 2005)Restore the ARSystem database file and change db owner, giving you a clone of productionUpgrade the clone system to ARS 7.00.01Upgrade the db to SQL Server 2005 and back up ARSystem to file - Or- back it up to file from SQL Server 2000 (SQL Server 2005 should be able to restore / upgrade a SQL Server 2000 db in one pass)Keep the backup file, scrub the server, and install SQL Server 2005 and ARS 7.00.01 cleanRestore the AR System database over the newly installed db and change db ownerStart the Remedy service and test... there are variations on this if you are installing the db in Windows-only authentication mode, which ARS 7 handles MUCH better than ARS 5 did.Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/** At this point I do think it is a DBA issue. I have tried running the entire process without upgrading to SQL 2005 server and I recieve the same error whether it's ARS 5.x, 6.x or 7.x. But conversely, I havent found anyone who's sucessfully performed this 5.x to 7.x migration/uprgade on MS SQL.
From: Action Request System discussion list(ARSList) [mailto:[email protected] ] On Behalf Of Marquez Rankin
Sent: Tuesday, November 14, 2006 10:39 AM
To: [email protected]
Subject: Re: Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with clients)
On 11/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:I'll have to defer to MSSQL experts on the list for that one. :-) I'm an
Oracle guy...
--
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
Marquez Rankin < [EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected] >
11/09/2006 01:04 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with
clients)
** Thanks Tony,
I was thinking along the same lines. However, ARS 5.x isn't compatible
with SQL 2005 as far as I know. The actual database restore is backwards
compatible but will this cause an issue with the SQL Server itself?
On 11/9/06, Tony Worthington < [EMAIL PROTECTED]> wrote:
Install ARS 5x on upgrade system
Do database restore from current -> upgrade
Do sp_changedbowner
Start ARS 5.x on upgrade.
Try clients. If everything works identical to current system proceed.
Run 7.0 installer on upgrade, and choose the upgrade option
Try your v7 clients on upgrade.
hth,
tony
--
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
Marquez Rankin < [EMAIL PROTECTED] >
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
11/09/2006 10:31 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with
clients)
**
Current Production System: Windows 2000 Server SP4 / SQL 2000 / ARS
5.01.02
Upgrade Production System: Windows 2003 Server SP1 / SQL 2005 / ARS
7.01.02
Installed ARS 7.01.02 on 'Upgrade System' with defaults.
Logged onto 'Upgrade System' Demo account with both User & Admin clients.
Shutdown ARS 7.01.02 processes on 'Upradge System'
Restored SQL 2000 backup from 'Current System' with corrected paths for
'Upgrade System' database & log file.
Ran query against restored database EXEC sp_changedbowner 'ARAdmin',
'true' to restore ARAdmin as dbo.
Started ARS 7.01.02 processes on 'Upgrade System'
User and Admin client cannot access ARS on 'Upgrade System'
Ran ARS 7.01.02 install again selecting upgrade.
Recieved the following:
****->[ERROR]: AR System Server Database upgrade error. Changes to the
original database may have been commited during this process which would
result in the need to recover data from your database backup. Resolve the
problem that caused the error (Check the installation logfile and contact
Technical Support if necessary).
****->[ERROR]: Failed to complete AR Server installation.
Any ideas?
-SMR
__20060125_______________________This posting was submitted with HTML in
it___
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves
the right to retrieve and read any message created, sent and received.
Kohl's reserves the right to monitor messages to or from authorized Kohl's
Associates at any time
without any further consent.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
__20060125_______________________This posting was submitted with HTML in
it___
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time
without any further consent.
__20060125_______________________This posting was submitted with HTML in it_____20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
