SQLOLEDB Error

Last Post 29 Dec 2004 11:52 AM by kohli290866. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bocha
New Member
New Member

--
12 Dec 2004 06:34 PM
We are getting error as below when we are running a thread which moves records from one database to another. The distributed transaction service is up and is automatic.
 
The sqlserver we have is Windows2000, service pack 4.
 
any help?
 
 
Thread: InterfaceToCRMAccountBal is started at Thu Dec 09 11:44:49 GMT+05:30 200 4.
------------------------------------------------
Starting Account Balance Uploads. Please wait...
Exception in AccBalanceUpload execute : [SERVER1]The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distri buted transaction.
java.sql.SQLException: [SERVER1]The operation could not be performed beca use the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction .
        at com.inet.tds.e.a(Unknown Source)
        at com.inet.tds.b.do(Unknown Source)
        at com.inet.tds.b.execute(Unknown Source)
        at com.infy.intl.upload.FinCRMUploadComponent.accountBalanceUpload(FinCR
MUploadComponent.java:735)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.infy.intl.svc.ParentDaemon.run(ParentDaemon.java:157)
        at java.lang.Thread.run(Unknown Source)
 CREATE  procedure AccBalanceUpload.....
Error Uploading balances:[SERVER1]There is already an object named 'AccBa lanceUpload' in the database.
Thread: InterfaceToCRMAccountBal is sleeping at Thu Dec 09 11:44:54 GMT+05:30 20 04. InterfaceToCRMAccountBal thread stopped successfully
Thread: InterfaceToCRMAccountBal is stopped at Thu Dec 09 11:45:02 GMT+05:30 200 4.
kohli290866
New Member
New Member

--
29 Dec 2004 11:52 AM
If the OS is Windows 2003 ... then KB below might be applicable.

http://support.microsoft.com/defaul...-us;816701

http://support.microsoft.com/defaul...-us;329332

Thanks.
You are not authorized to post a reply.

Acceptable Use Policy