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.


On : 16.9 [IP2016] version, Upgrade

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.

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

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

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


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