Data Quality: IIR 9.01 : Intermittent 'vrec_read_sql: incorrect recid: requested 1263871, got 1263872' error during UCM Batch Process job (Doc ID 1677326.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Symptoms

SIEBEL VERSION:
Siebel version : 8.1.1.7
Database version : Oracle 11.2.0.2
OS version : Windows 2003

IIR version: 9.01

When running UCMBatchProcess jobs against large numbers of SDH records the following error was intermittently encountered, showing in the 'ids.dbg':

...

[417162459 ssasrsv  15/ 13] errmsg_put 'vrec_read_sql: incorrect recid: requested 1261858, got 1261859'
[417162459 ssasrsv  15/ 13] errmsg_put 'ssaodbc.c   10866 rc  26'
[417162459 ssasrsv  15/ 13] errmsg_put 'dbops.c      2840 rc   9         26*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'dbldr.c      2029 rc   9       2609*1000'
[417162459 ssasrsv  15/ 13] errmsg_put 'utils.c      3504 rc   9    2609009*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c       6994 rc  10  260900909*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c       8716 rc   2   90090910*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c       8885 rc   4    9091002*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c       9403 rc   7  909100204*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'read_set failed'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c      10089 rc  21  910020407*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c      10310 rc  31    2040721*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c      11154 rc  22  204072131*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'MultiSet failed -407213122'
[417162459 ssasrsv  15/ 13] errmsg_put 'apic.c      11565 rc   9  407213122*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'execute search failed'
[417162459 ssasrsv  15/ 13] errmsg_put 'ssasesi.c    1639 rc   3  721312209*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'ssasesi.c    3144 rc   1  131220903*100'
[417162459 ssasrsv  15/ 13] errmsg_put 'ssasesi.c    5790 rc   5  122090301*100'

...

Cause

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