Siebel Remote: DB Extract is Failing With ORA-01422 (Doc ID 2066591.1)

Last updated on JULY 11, 2017

Applies to:

Siebel CRM - Version 8.1.1.14.7 [IP2014] and later
Information in this document applies to any platform.

Symptoms

Database Extract is failing  with error

Trace TracingInfo 3 00000041561e4b3c:0 2015-10-14 19:19:14 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
Trace TracingInfo 3 00000041561e4b3c:0 2015-10-14 19:19:15 ODBC call returned error
Trace TracingInfo 3 00000041561e4b3c:0 2015-10-14 19:19:17 ERROR: 1 client(s) failed with errors, 0 client(s) successful
GenericLog GenericError 1 00000041561e4b3c:0 2015-10-14 19:19:17 (smisched.cpp (923) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms