Hi Carina, For most of today I have been working on exactly the same problem. I even get the same error message as you. The only difference is I am upgrading from 5.1.2 to 7.0.1 and my database is 9i so I am connecting through the 10g client.
The upgrade goes fine suggesting that during the upgrade process Remedy communicates with the database. But when I try to start the service manually it takes a long time, and uses a lot of memory, before it tells me it hasn't started in a timely manner. I have watched Remedy connecting to the database through Enterprise Manager and every thread gets stuck doing a query to the Role table. I am beginning to suspect that the issue is that I have SLA 6.0 module installed in the database and the processes from this version aren't compatible with 7.0.1 server. Next step is going to be restore a version of the 5.1.2 database without the SLA module, # out the sla programs in monitor.conf and go again. I probably wont do this until tomorrow as the database takes quite a while to restore on my laptop where I am trying this out. Brian Bishop -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carina Burns Sent: 27 December 2006 14:51 To: [email protected] Subject: Upgrade from 5.12 to 7.0 - Service Fails Hey Y'all, I'm doing an upgrade/migration. I have a test instance of my data on Oracle 10g and a test server running Win2003svr. If I run the install fresh against an empty AR schema, all installs fine and the service starts with no issue. I then drop my ARAdmin user, recreate the user, and then import my 5.12 AR schema data. When I run the AR Server install again and choose the upgrade option. It installs successfully, successfully upgrades the database but then the service refuses to start. The arsql.log and dbquery.log contain nothing out of the ordinary. The only error message is in the ar_install.log "The AR System Server could not be started. You can start it manually using the Services icon in the Control Panel." (Uh, no I can't manually start it) "This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory." Well, I would do that if I could start the service so that I could connect with the Admin tool and import the definitions. I've cleared the schema, uninstalled the ARServer, I've tried running the upgrade install unchecking the sample application option, and numerous other variations and I get the same results, the service won't start after upgrade. I remember a few upgrades back, there was an issue with the Demo id not having admin rights. On our system, Demo has only browser permissions. That's the next thing I will try to alter I guess to see if it makes any difference. Has anyone else run in to this? Perhaps I should go to ARS 6.0 before going to 7.0? The tech working my ticket I have open with BMC says that shouldn't be necessary. Thanks ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
