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 |
|
sathiesh2005
Yak Posting Veteran
85 Posts |
 Posted - 2010-04-13 : 03:17:31
|
| Hi,I am using linked server to transfer data from one SQL server2000 to another SQL server2000. My job fails in a step and returns the below error message. what it means and how to fix it.This occurs when source server inserts a record to the target server for a table which has the same structure.Error:======Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.]. [SQLSTATE 01000] (Error 7300). The step failed.Kindly help me to fix this problem.Thanks.Regards,Sathieshkumar. R |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-15 : 01:36:06
|
| Hi webfred,Thanks. it works now.But I have a new problem, now i am getting the below error.Previously the distributed transactions like begin transaction and commit transaction worked but now i am getting error.Kindly help me to fix this.error:======[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].Server: Msg 7391, Level 16, State 1, Procedure PROC_WM_DATA_TRANSFER, Line 275The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.Regards,Sathieshkumar. R |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-15 : 02:03:19
|
That has to do with distributed transactions which means transactions over more than one server.I am not familiar with this - sorry.Maybe another mate here can help.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-15 : 02:25:56
|
| ok. thanks for the reply.Regards,Sathieshkumar. R |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-28 : 08:11:51
|
| Hi Everyone,My problem was solved. This happened because there is not enough space allocated for the target table.Index occupied a lot of space.Solved it by index defragmentation.Regards,Sathieshkumar. R |
|
|
|
|
|
|
|
|
Linked server Error