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"
