My Oracle Support Banner

Siebel IP17: FlattenWorkspace Erroring Out With [Oracle]ORA-01795 - MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000 (Doc ID 2422642.1)

Last updated on AUGUST 23, 2018

Applies to:

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

Symptoms

On :  17.6 [IP2017] version, System Admin

When attempting to ran FlattenWorkspace on more than 1000 workspaces,the following error occurs.

ERROR
-----------------------
DBCLog DBCLogError 1 000000025af819f8:0 2018-05-14 14:03:41 [tp][ODBC Oracle driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000
GenericLog GenericError 1 000000025af819f8:0 2018-05-14 14:03:41 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to Siebel Tools \ bin

2. Run FlattenWorkspace command "siebdev /c tools_IP17.cfg /l enu /d ServerDataSrc_unx8374 /u SADMIN /p XXXXXXXX /FlattenWorkspace /DisableWorkspace /DropIndexes SIEBEL XXXXXXX ORACLE"

3. Error will report like" ORA-01795: maximum number of expressions in a list is 1000.

Changes

 

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.