Oracle to SQL Replication 1

[ptheriault]

If you apply a service pack or hot fix to a SQL server that participates in Oracle to SQL Replication you may receive the following error.

The version of SQL Server used to download the Oracle package code does not match the version of SQL Server running at the distributor. The replication support code at the Oracle publisher needs to be refreshed (Source MSSQL_REPL, Error number: MSSQL_REPL22202)

The problem is that the HREPL_VERSION table on the Oracle database does not match with the @@version on the SQL Server.

To correct the problem run this update in the HREPL database on the Oracle server.

[COLOR=blue]UPDATE[/color] HREPL_VERSION
[COLOR=blue]SET[/color] SQLSERVERVERSION = [COLOR=red]'Microsoft SQL Server 2005 - 9.00.2164.00 (X64)   Jun 14 2006 12:39:07   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) '[/color]
[COLOR=blue]COMMIT[/color]

Note to change the version to the results you get from running @@version on your SQL Server.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ecobb]

Thanks! While I haven't run into this problem, I'm sure your post will save someone's hind quarters one day!

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[ptheriault]

Thank ECAR.
This really hosed me up last week. So I thought I would save someone else my pain! Also just as an FYI. SQL on looks at the first 40 characters in that string so you really only need to update the first 40.

- Paul
- If at first you don't succeed, find out if the loser gets anything.