My Oracle Support Banner

DSMatchFetchArraySize = Default And VORD Projected Asset Cache goes in Error (Doc ID 2327049.1)

Last updated on NOVEMBER 20, 2017

Applies to:

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

Symptoms

Customer had to implement DSMatchFetchArraySize = Default
Due to this setting, now he have a secondary issue by running vanilla BS VORD Projected Asset Cache

The issue occur for a big account which has more than 10K assets.

ERROR
-----------------------

ObjMgrBusCompLog Error 1 0000346959a428a9:0 2017-09-01 16:52:47 There were more rows than could be returned. Please refine your query to bring back fewer rows


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run BS VORD Projected Asset Cache
2. Error: There were more rows than could be returned. Please refine your query to bring back fewer 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!


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