Depending on what you were doing ... Yes the application could become unresponsive (Especially if users were still using the system). Did you put your system into Admin mode before doing the change?
Since you are on ARS 5.01.02, If you were doing anything like changing the size of a column or deleting a column on an existing form the system has to rename the table and copy the data over to a new table (with the new structure). Newer versions of the ARS server no longer need to do this (ARS 5.01.02 is from like 2005). Also ... Does your non production system have the same number of records in the table being changed (more records will of course result in an increased time for a change). Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Raj Sent: Friday, March 30, 2012 1:34 PM To: [email protected] Subject: Re: Can remedy code push cause DB crash, etc? Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj <[email protected]> wrote: > Hi All, > > Very recently I performed Remedy code push on our production server. > > This involved importing some new forms and related workflow and also > modifying existing forms like HelpDesk and Change forms.(Using ARAdmin > tool) > > I tested this same on our Dev and QA Servers and the code push was a > success without any issues. > > But when I performed this on our Production server, it caused DB crash > and brought down Remedy. > > The outage was caused by the fact that the database became > unresponsive. > > After we brought back Remedy, we noticed some of the DB view needed to > be recompiled. > > As we are still investigating if it has to do with issues in non > remedy components but we couldn't find any solid clues and ultimately > brings it back to Remedy code push. > > Here are the logs : > > ------------------------------ > > Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server > terminated when a signal was received by the server (ARDSNOTE 3000) > Wed Mar 28 01:09:59 2012 15 > Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server > terminated when a signal was received by the server (ARDSNOTE 3000) > Wed Mar 28 01:09:59 2012 15 > Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. > Please check the spelling (table name is case-sensitive) (ARERR 481) > Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to > the SQL database. > Please ensure the SQL database is running or contact the Database > Administrator for help (ARERR 550) > Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out > Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL > database (ARERR 551) > Wed Mar 28 01:29:29 2012 Thread 67 not handling connection > > ------------------------------- > > At this point, I would like to understand from experts in here to see > if anything like the above mentioned is possible? If yes, what could > be the reasons and what can I look into to find the root cause. > > Thanks, > > Raj _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
