My Oracle Support Banner

Extarct Abends With " OGG-02077 Extract encountered a read error in the asynchronous reader thread and is abending: Error code 1422, error message: ORA-01422: exact fetch returns more than requested number of rows. " (Doc ID 2742336.1)

Last updated on JANUARY 11, 2023

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 to 19.1.0.0.0 [Release 12.2 to 12.3]
Information in this document applies to any platform.

Symptoms

 Extarct Abend with " ERROR OGG-02077 Extract encountered a read error in teh asynchronous reader thread and is abending: Error code 1422, error message: ORA-01422: exact fetch returns more than requested number of rows."

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.