Re: Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with clients)

George Jungle Sun, 12 Nov 2006 21:22:52 -0800

Susan (or anyone who is or has upgraded from 5.01.02 -> 7.0.01)

We're currently attempting an upgrade of 5.01.02 to 7.0.01. Although the upgrade went ok, when we attempt to start the AR Server we get the error below. So although the arserverd looks like it started, it's not really functioning and can't accept connections from clients...

390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key.
For unlimited capabilities, contact your sales representative. (ARNOTE 27)

  AR System Server did not start in the allocated time.
  Do you want to continue waiting for the AR System Server to start [y]
  AR System Server did not start in the allocated time.
  Do you want to continue waiting for the AR System Server to start [y]

390600 : Failure during SQL operation to the database : ORA-00942: table or view does not exist (ARERR 552)

390600 : Problem encountered during creation of one of the application forms (ARERR 4550)

  390600 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20)
     11
     Timestamp: Mon Nov 13 2006 13:09:29.6209
     Thread Id: 4
     Version: 7.0.01 200609271856 Sep 27 2006 19:28:30
     ServerName: enrppsyd01
     Database: SQL -- Oracle
     Hardware: sun4u
     OS: SunOS 5.9
     RPC Id: 0
     RPC Call: 0
     RPC Queue: 390600
     Protocol Version: 12
     Client IP Address:
     Logging On: User

On 11/10/06, Susan Palmer <[EMAIL PROTECTED]> wrote:

**
Having originally done that same basic upgrade because support said it could be done and having problems afterwards (group form) and spending 3 weeks troubleshooting with Support it was decided I needed to upgrade from 5.1.2 to 6.3 to 7.x.

I found that even though the fields appeared on the group form they were not actually in the database. And even all the tricks of adding a field, moving a field etc in the Remedy admin tool did not fix the problem. Went against everything we knew and believed about the relationship between the admin tool and the database.

We are on Oracle 10g on that server so that may be a difference between your issues.

hth,

Susan

On 11/9/06, Marquez Rankin <[EMAIL PROTECTED] > wrote:
**
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___

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___

Re: Migration/Uprage from 5.01.02 to 7.01 (cant connect to Remedy with clients)

Reply via email to