FIX: Distribution Agent for Oracle subscription fails when you use SQL Server 2008 R2 or SQL Server 2008

Applies to: SQL Server 2008 R2 Service Pack 2SQL Server 2008 R2 EnterpriseSQL Server 2008 R2 Developer

Symptoms


Assume that you have configured a transactional replication together with the distributor by using Microsoft SQL Server 2008 R2 or Microsoft SQL Server 2008. If the subscription is on an Oracle instance, your Distribution Agent fails, and you receive the following error message:
Agent message code 1722. ORA-01722: invalid number
ErrorId = 7563200, SourceTypeId = 16
ErrorCode = '1722'
ErrorText = 'ORA-01722: invalid number'

Resolution


To resolve this problem, install the hotfix package for your version of SQL Server. To do this, see the appropriate corresponding article in the Microsoft Knowledge Base.
Microsoft SQL Server 2008 R2 Service Pack 2 (SP2)
To resolve this issue, apply Microsoft SQL Server 2008 R2 SP3. For more information about how to obtain SQL Server 2008 R2 SP3, click the following article number to view the article in the Microsoft Knowledge Base:
2979597 SQL Server 2008 R2 Service Pack 3 release information
Microsoft SQL Server 2008 Service Pack 3 (SP3)
To resolve this issue, apply Microsoft SQL Server 2008 SP4. For more information about how to obtain SQL Server 2008 SP4, click the following article number to view the article in the Microsoft Knowledge Base:
2979596 SQL Server 2008 Service Pack 4 release information

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.