Parallel Index on MS SQL Server IP2016 Local DB Extract issue (Doc ID 2260064.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

On : 16.9 [IP2016] version, Upgrade

ACTUAL BEHAVIOR
---------------
 
There is an issue while extracting local DB for developer after upgrading from IP2015.4 - IP2016.9 and having a parallel index on MS SQL Server.  This is not an issue with IP15.4 SQL Anywhere.

 While extracting from tools, its failing in creating Table and index steps since its a new oracle Local XE concept it not allowing to 2 different index (parallel) on same column in table.


EXPECTED BEHAVIOR
-----------------------
Local db extract should be successful with parallel index on MS SQL Server

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

1.) On IP2016 MS SQL Server, add an additional index to a column of a table with an existing index (parallel index)

2.) run ddlsync

3.) run genbewdb

4.) run dbxtract

5.) start Siebel tools, should have a dbinit


--
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot extract LocalDb in IP2016

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