Error 18278: Database log truncated Help?

[checkai]

We have a nightly SQL job that has been running smoothly. It contains about 8 table truncates, then 8 table copies, next a database Copy, then executes 4 Stored procedures and finally does another Database copy. We had 1 field added to a table that gets copied elsewhere. That field was manually added to the other 2 databases that it gets copied to. That's when this SQL job started failing. Here is my properties of the Last steps in the Job History table...

Step that says 'Retry'
======================

Executed as user: VIRCHOWKRAUSE\cluster. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnProgress:  

DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000   DTSRun OnProgress:  

DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000   DTSRun OnProgress:  

DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000   DTSRun OnProgress:  

DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000   DTSRun OnProgress:  

DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000   DTSRun OnProgress:  

DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressC


Final Step that says 'FAILED'
=============================

Executed as user: VIRCHOWKRAUSE\cluster. ...  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun 

OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; 

PercentComplete = 0; ProgressCount = 1000   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; 

PercentComplete = 0; ProgressCount = 2000   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; 

PercentComplete = 0; ProgressCount = 3000   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; 

PercentComplete = 0; ProgressCount = 4000   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; 

PercentComplete = 0; ProgressCount = 5000   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.; 

PercentComplete = 0; ProgressCount = 6000   ...  Process Exit Code 1.  The step failed.

Windows Application Event Log.

18278: Database log truncated: Database: StarReporting.

any clues??? Thanks!

 

[JayKusch]

I'll take a stab at it. This "may" be 2 events that are really happening.

First off, the transformation portion of you data pump may need to be updated since the new field was added. This may correct your step failed issue.

The issue with the error 18278, if I were to quess, is that the DTS Imports "may" have put your database into Simple mode and thus the TLog error is reported.

Thanks

J. Kusch

 

[checkai]

I think it's something with the new field. That's when the Job started failing. However, I'm not sure how to update the DTS because the affected tables are being updated in a COPY SQL SERVER OBJECTS task. So there isn't a field mapping or anything. Is there something else that needs to get refreshed because of the field change?

Thanks,
DLC