Thanks Dave-
Apparently what happened is on the table/tree property tab someone 2x clicked a column name which removed it from the table. It seems to have only happened on some views, because it was still there on the default user view. When I removed the table from the view where it was missing the column and added it back, the column came back with it. I just don't understand why the server would die when trying to save the form. Hopefully doing it as a .def file will go more smoothly. Chris ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Tuesday, April 01, 2008 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: Poor server performance Hi Chris Hmmm - that's strange. I didn't know you could have a table field column in one view and not another. I thought all table field columns were included in every view that the table field is in. The only thing you could do was to hide or unhide it in different views or change the column order. Someone correct me if I'm wrong. I have seen cases where table fields have 'ghost' columns left that do not point to any field on the current form or source form. The columns are there in the table, but if you look at the table properties they are not there. The only way I have been able to correct this issue is to manually edit the def file and import with the option to delete excess fields from destination server set. If you are sure that your dev server contains an accurate current def, I would export that to a def file and import to production with the delete excess fields option set... outside normal hours of course. The good news is that table fields are display only fields on your form so should not require a table rebuild in the database. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Tuesday, April 01, 2008 3:06 PM To: arslist@ARSLIST.ORG Subject: Poor server performance Hey everyone- Last night I came in at 11 PM when there should be little if any load on our server to make a form change. I was removing a table field from a view and then adding it back (a column was deleted from the view but was on others and that's the best way I know of to get it back). The form is CHG:Infrastructure Change, and it has been customized a little and there is an additional view from the OOTB version. I made my changes and tried to save but the server became unresponsive and after 20 minutes I restarted it. Of course, the phones started ringing as the crazy people logged into Remedy at 11pm started timing out. The changes I made did not get saved. My next step was going to be do it as a definition file save from the dev server, but we decided against it because we did not have a scheduled outage and didn't want to risk the server going down again. Can anyone point me in the right direction or have any suggestions as to why we can't make changes on our server? I tried the same thing Saturday afternoon with the same results, but it was over a VPN so I was hoping being here would make it better. Ver 7.0.1 fully patched, SQL 2005, Windows Server. Thanks, Chris __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
