Been there. Done that. In my case, we ran up against not enough temp space and froze the system.
Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: [email protected] Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj <[email protected]> wrote: > Sorry, missed the environment info: > > Server : 5.01.02 Patch 1313 > Hardware : sun4u > OS: SunOS 5.10 > DB: SQL -- Oracle > DB Version : 0.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 atwww.arslist.org > > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug12www.wwrug12.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
