Heterogeneous Logreader encountered an error in call to LoadReplCmds when processing state 'SYNCINIT_FETCH'

Neeraj Dubey 1 Reputation point
2020-08-21T08:25:23.19+00:00

We are having a Oracle as Publisher and distributor and subscriber is SQL SERVER.

My Log reader Agent is getting failed showing below error :

Error messages:
Query timeout expired (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Heterogeneous Logreader encountered an error in call to LoadReplCmds when processing state 'SYNCINIT_FETCH'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
Please refer screen shots attached below :![19471-log-reader-agent-failure-error.png]1

Please provide your inputs/guidance/suggestion to debug and fix the issue.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,689 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,871 Reputation points Microsoft Vendor
    2020-08-24T05:56:17.287+00:00

    Hi,

    Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using change data capture and SSIS.
    For a list of objects that can be replicated from an Oracle database, see Design Considerations and Limitations for Oracle Publishers.

    Best regards,
    Cathy

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.