| Author |
Topic |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2009-10-22 : 09:09:58
|
| Hallo, I am downloading a table from a flat file to SQL server. The download process downloads the file ok and when it approaches the last stages it crashes and generates an error as shown below. Please could someone enlight me of the cause of the failure. Please see the error message below.. Thanks- Copying to [ODSData5].[dbo].[o_pat] (Error)MessagesInformation 0x402090de: Data Flow Task: The total number of data rows processed for file "E:\o_pat.txt" is 118917657.(SQL Server Import and Export Wizard)Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.(SQL Server Import and Export Wizard)Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".(SQL Server Import and Export Wizard)Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.(SQL Server Import and Export Wizard)Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - o_pat" (190) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.(SQL Server Import and Export Wizard)Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.(SQL Server Import and Export Wizard) |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-22 : 09:13:29
|
The transaction log for database 'tempdb' is full
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2009-10-22 : 09:20:31
|
| Why is it full and in my E drive I have 400 GB space still available. The tempdb was just 20GB when it crashed... Can it be because I set the Option Full Recovery to Simple?I also have unrestricted growth, 10% for autogrowth.. I can't see why the tempdb becomes full while the hard drive is still has space |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-22 : 09:39:04
|
Are you sure that the TRANSACTION LOG, not the database file is with unrestricted growth AND it is pointing to drive E:?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2009-10-22 : 10:14:28
|
| how can i check the transaction log ? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-22 : 10:21:24
|
right click on database - options - files
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-10-22 : 11:14:52
|
| Just do a transaction log backup on tempdb |
|
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2009-10-22 : 11:20:57
|
| Ok, I did go to the database - properties - option - files and checked the log file and the following was shown By 10 percent, restricted growth 2097152 MB. I tried to set it to unrestricted growth and selected OK. When I opened the Files again it is reset to By 10 percent, restricted growth 2097152 MB. How can I force the unrestricted growth. I tried to change from Full to Simple recovery and vice versa it couldnt re-enforce the unrestricted growth.. Thanks |
|
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2009-10-22 : 11:21:36
|
| NeilG do u mean I work with FUll recovery rather than Simple ? |
|
|
|
|
Error downloading a table in SQL