I finially got back to work.. I did some testing today on this migration:: I took ARS 5.12 / Oracle 9.2.0.6 export imported on a 10.2.0.1 DB and used installer upgrade. ---- Got many errors.. I am sure some are fixable.. but below is the transcript... Thought I would Share the possible problems someone will have doing an upgrade..
By the way.. The Reason I was doing the test is because .. Migrator is does not support Migration of 5.12 to a 7.0 DB and so I was attempting another way.. Looks like you have to do a 6.01 a 6.3 then a 7.0 upgrade on your data.. Comments accepted. ---------------------------------------- Updating AR System configuration file /Remedy/conf/ar.conf Your existing AR System tablespace will be upgraded Running DB upgrade. This may take several minutes .... done. Updating AR System monitor file /etc/arsystem/remedy/armonitor.conf Installed language dependent message and samples file. Installed message catalog files in /usr/lib/locale/C/LC_MESSAGES Saving a backup copy of /etc/rpc in /etc/rpc.bak Adding agent definitions to /etc/rpc ... done. Copying arimportcmd to /Remedy/bin Starting the AR System Server: Fri Aug 4 08:34:52 EDT 2006 server: locale=[[ C ]], LANG=[[ C ]]NLS_LANG=[[ AMERICAN_AMERICA.US7ASCII ]] Action Request System(R) Server Version 7.0.00 200604171412 Remedy, a BMC Software company. Copyright (c) 1991 - 2006 BMC Software, Inc. All rights reserved. 390600 : Failure during SQL operation to the database (ARERR 552) ORA-12154: TNS:could not resolve the connect identifier specified 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) 390600 : Error in definition for a filter (ARERR 343) CSC-WP Notify tech Multi 390600 : The file specified for a form does not hold a form definition (ARERR 400) 390600 : A required form for Email is missing. Server will attempt to import the form in place. Please verify the form gets imported or import it manually to ensure the Email Engine will work properly. (ARERR 9804) AR System Email Association ..... the rest of the Email system errors as well.. ---->> More Restarting the AR System Server: Fri Aug 4 08:38:23 EDT 2006 Action Request System beginning the restart process. Action Request System shutdown in progress. Action Request System shutdown process complete. Action Request System initializing. Starting AR System Server (ARNOTE 0) AR Monitor version 7.0.00 200604171412 started. (ARNOTE 0) AR Monitor started. server: locale=[[ C ]], LANG=[[ C ]]NLS_LANG=[[ AMERICAN_AMERICA.US7ASCII ]] Action Request System(R) Server Version 7.0.00 200604171412 Remedy, a BMC Software company. Copyright (c) 1991 - 2006 BMC Software, Inc. All rights reserved. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. 390600 : Failure during SQL operation to the database (ARERR 552) ORA-12154: TNS:could not resolve the connect identifier specified 390600 : Missing data in the SQL database (filter.numActions) (ARERR 556) 390600 : Error in definition for a filter (ARERR 343) CSC-WP Notify tech Multi Action Request System(R) Fork Daemon Version 7.0.00 200604171412 Remedy, a BMC Software company. Copyright (c) 2000 - 2006 BMC Software, Inc. All rights reserved. (ARNOTE 0) Server indicates that it's up. Action Request System AR System Application Command Dispatcher Version 7.0.00 200604171412 Remedy, a BMC Software company. Copyright (c) 1998 - 2006 BMC Software, Inc. All rights reserved. Action Request System(R) Plug-In Server Version 7.0.00 200604171412 Remedy, a BMC Software company. Copyright (c) 2001 - 2006 BMC Software, Inc. All rights reserved. BMC Remedy Email Engine has started Action Request System(R) Approval Server Version 7.0.00 200604171412 Remedy, a BMC Software company. Copyright (c) 1999 - 2006 BMC Software, Inc. All rights reserved. Loaded Web Services plugin properly No Approval Alternate form was found (ARAPPERR 4593) No Approval Details form could be found on the server (ARAPPERR 4560) No Approval Form form was found (ARAPPERR 4513) No Approval More Information form was found (ARAPPERR 4595) No Approval Process Definition form was found (ARAPPERR 4588) No Approval Process Administrator form was found (ARAPPERR 4597) No Approval Role form was found (ARAPPERR 4599) No Approval Rule Definition form was found (ARAPPERR 4591) No Approval Signature Line form was found (ARAPPERR 4586) No Approval Preview Signature Line form was found (ARAPPERR 4620) Name parameter (or name field in a parameter) is empty (ARERR 102) Name parameter (or name field in a parameter) is empty (ARERR 102) Action Request System initialization is complete. Waiting for the AR System Server to respond... Verifying Demo user privileges Upgrading Central Preferences forms Upgrading Business Times forms Loading form definitions from /Remedy/samples/en/adf_BusinessTime.xml Problems encountered while importing some forms and/or data. Please refer to the log in /Remedy/Logs/ for further details. Upgrading Core Server forms and data: Fri Aug 4 08:39:31 EDT 2006 Please wait .... Loading form definitions from /Remedy/samples/en/adf_ServerApps_en.xml Import completed successfully in 0.000000 seconds. 2 Records imported to form ReportType. Problems encountered while importing some forms and/or data. Please refer to the log in /Remedy/Logs/ for further details. Installing Sample Application: Fri Aug 4 08:43:13 EDT 2006 Loading form definitions from /Remedy/samples/en/adf_SampleApps_en.xml Problems encountered while importing some forms and/or data. Please refer to the log in /Remedy/Logs/ for further details. Installing LDAP Configuration: Fri Aug 4 08:44:00 EDT 2006 Loading ardbcconf form definition LDAP Configuration forms successfully installed. Installing ARDBC LDAP ... Loading ardbcldap form definition (ARNOTE 0) Server (pid:15994) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. ARDBC LDAP forms successfully installed. Loading inetorgperson form definition (ARNOTE 0) Server (pid:16284) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16292) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. INET forms successfully installed. Installing AREA LDAP ... Loading arealdap form definition (ARNOTE 0) Server (pid:16386) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16453) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16454) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. AREA LDAP forms successfully installed. Installing Flash Objects: Fri Aug 4 08:45:39 EDT 2006 Loading FlashboardObject form definition (ARNOTE 0) Server (pid:16457) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16469) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. Flash Objects forms failed to import. Problems encountered while importing the form FlashObjects.def Please refer to the log in /Remedy/Logs/ for further details. Installing Server Admin application ... Loading serveradmin form definition (ARNOTE 0) Server (pid:16470) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16478) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16479) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16502) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16543) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. Server Admin application successfully installed. End of Import: Fri Aug 4 08:48:01 EDT 2006 Cleaning up temporary files. AR System Installation Complete: Fri Aug 4 08:48:02 EDT 2006 ===================================================== If you wish to use the Email Daemon and it is not currently installed, you will need to run ed_install. ===================================================== End of Installation: Fri Aug 4 08:48:02 EDT 2006 66 [EMAIL PROTECTED] /export/home/oracle/Remedy/arsystem > (ARNOTE 0) Server (pid:16546) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Server (pid:16577) died with 65280. AR System Assignment Engine Version 7.0.00 200604171412 Remedy, a BMC Software Inc. company. Copyright (c) 2006 BMC Software, Inc. All Rights reserved. (ARNOTE 0) Tried 4 restarts in 30 seconds. I give up at Fri Aug 4 08:48:23 2006 ------------------------------------------------------------------------------------------------------ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

