Running Parallel transforamtion throws an Error
When i start executing multiple transformations in parallel inside a job(A.job) and my each transformation is extracting data from xml and then uploading it into sql server ,
then it throws an error:
"The transaction log is full "To find out why space in the log cannot be reused , see the log_reuse_wait_desc column in sys.databases" .
How can i overcome through this error..
Please help me.
It's been a while I worked with MSSQL, if I remember correctly transaction log holds all uncommitted transactions, so when you've started you transformations in parallel number of uncommitted transaction increased in factor of parallelism and the size of the log is not big enough
1. increase the transaction log size
2. decrease number of rows in your transformation to commit
Tags for this Thread