Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ecolada
Starting Member
1 Post |
 Posted - 2007-10-17 : 19:01:56
|
| I have a simple child table that contains a primary clustered key, two foreign keys and a VarChar(MAX) field. I have that latter field included in a Full Text Catalog that has Tracking Changes set to manual and is scheduled to incrementally populate once a day.At first I was using a custom SSIS package and then I move to a simple Import/Export Wizard-generated package to migrate 7 million records from one database contains this table to another database containing this table.In the source database there is no full text index.In both my custom SSIS and in the Import/Export process, I am unable to get the commit completed. In the Import/Export I am told that all of the rows have been transferred and then it simply hangs indefinitely on that same line. In the custom SSIS package, I will eventually obtain a deadlock excpeption even though the only processes running are the TempDB and this one thread - and there does not appear to be any blocking threads.When I try to open the full text catalog, via Studio Manager, I receive a lock timeout error and am unable to open this catalog. I obtain this same error with any table I try to open that is connected to that catalog.When I eventually force the Import/Export to terminate, I have to reboot the server to free the table. If I drop the table and try to add it in again, I am told that the table already exists even thought I cannot find it in the sysobjects table.I am at a complete loss as to what is cuasing this issue and I would really appreciate some help!Thank you! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 23:49:50
|
| "I am told that the table already exists even thought I cannot find it in the sysobjects table."Probably worth doingDBCC CHECKDB('MyDatabaseName') WITH NO_INFOMSGSjust to check there is no corruption of the database that is causing it to loop etc.Kristen |
 |
|
|
|
|
|
IMport Export Corruption Issue