Well...if Import in Place does it similar to the way removing a column worked in previous versions the way that Remedy took care of it was to rename T123 to T123A...create a new table T123B and then copy the entire table from A to B minus the deleted column...or was it added column...I don't recall...I hope Remedy doesn't do this once for each column it needs to delete. I would almost suggest taking the dataset in production down to a minimal level...
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil Sent: Thursday, December 28, 2006 5:03 AM To: arslist@ARSLIST.ORG Subject: Re: Import In Place - Timeout During Database Update ** ** Isabel, I have never used the in place feature for importing a form, but what is happening at the background, I believe, is that the underlying database table is being copied without the column and once copy has been created, the original table is dropped and the copy renamed to take place of the original table (this is what happens when you delete a field manually). It may be the case, that for every single field which has been removed the in place import goes through this routine. I would suggest switching on SQL logging on the server (if possible) and checking what is happening. You can find out which statement is causing the timeout. Alternatively, you can log in directly to the database and check the underlying table (Txxx) corresponding to the form to see what its status is. You can check its number of columns and also if there is any table with similar name, i.e. something like TxxxTMP. Hope this will give you some hints on where your import currently is. Regards Jiri Pospisil Technology Support Systems ▪T▪ ▪ ▪Mobile UK▪ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.28/605 - Release Date: 12/27/2006 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
