error ITransactionJoin::JoinTransaction

We have job that runs on sql server 2000 every mintute, the job logic is to retrieve data from remote sql 2000 server using link server config. 98% of the time the job run sucessfully, but once in while the job fails with the following error:
'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
Does, anyone know why is this happening?
Thank You,
Jason
Jason,
What version of Windows are you using? If Windows 2000, make sure you
are on SP4. This might solve it. Also, check that there is not a
firewall between the servers, if there is, ensure that RPC traffic is
allowed through.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jason wrote:
> We have job that runs on sql server 2000 every mintute, the job logic is to retrieve data from remote sql 2000 server using link server config. 98% of the time the job run sucessfully, but once in while the job fails with the following error:
> 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
> 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
> [SQLSTATE 01000] (Error 7300). The step failed.
> Does, anyone know why is this happening?
> Thank You,
> Jason
|||All the server that communiate with each other using link config do have sp4 for windows 2000 and there is no firewall between the servers.
|||Jason,
This looks like a case for Microsoft Support.
http://support.microsoft.com/default...d=fh;EN-US;sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
jason wrote:
> All the server that communiate with each other using link config do have sp4 for windows 2000 and there is no firewall between the servers.

error ITransactionJoin::JoinTransaction

We have job that runs on sql server 2000 every mintute, the job logic is to
retrieve data from remote sql 2000 server using link server config. 98% of t
he time the job run sucessfully, but once in while the job fails with the fo
llowing error:
'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
Does, anyone know why is this happening?
Thank You,
JasonJason,
What version of Windows are you using? If Windows 2000, make sure you
are on SP4. This might solve it. Also, check that there is not a
firewall between the servers, if there is, ensure that RPC traffic is
allowed through.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jason wrote:
> We have job that runs on sql server 2000 every mintute, the job logic is t
o retrieve data from remote sql 2000 server using link server config. 98% of
the time the job run sucessfully, but once in while the job fails with the
following error:
> 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provide
r
> 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
> [SQLSTATE 01000] (Error 7300). The step failed.
> Does, anyone know why is this happening?
> Thank You,
> Jason|||All the server that communiate with each other using link config do have sp4
for Windows 2000 and there is no firewall between the servers.|||Jason,
This looks like a case for Microsoft Support.
http://support.microsoft.com/defaul...id=fh;EN-US;sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
jason wrote:
> All the server that communiate with each other using link config do have sp4 for w
indows 2000 and there is no firewall between the servers.

Error In Merge Replication while server syncs

At first we received error like

"The merge process could not retrieve identity range resource for table..."

then after solving this error we again started syncing of servers manually then we got some other error like

"the process could not enumerate changes to the subscriber".

We tried our best to solve this problem but some error appears each time like

"The process could not deliver the snapshot to the Subscriber."

"The schema script 'sync -t"Design" -o"dbo" -d"\\ECOSYSTEM\D$\FTP\MSSQL\EcoSystem\ftp\ECOSYSTEM_MLEcosystem_MLEcosystem\20060619204802\Design_1337.bcp" -hORDER( [intDesignId] ASC)' could not be propagated to the subscriber"

again identity erroe emerges and agin we do the same process.

How to solve these problem?

These look like transitory network issues. Can you set QueryTimeout to something larger and see if this solves the problem.

-- Hilary Cotter