Last Post 29 Dec 2004 10:52 AM by kohli290866. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

12 Dec 2004 05: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
        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.
New Member
New Member

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




Acceptable Use Policy