E-DM: Data Mover Fails On Creating US And Portuguese Setup With The Error " CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER' " (Doc ID 2104883.1)

Last updated on MARCH 02, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.

Symptoms


PROBLEM STATEMENT:
-----------------------------------
Data Mover fails on creating US and Portuguese setup.

Data Mover is throwing the bellow error:

ERROR:
-----------
"Building required indexes for BNK_BTB_ACT_C
- SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns an

CREATE UNIQUE CLUSTERED INDEX PS_BNK_BTB_ACT_C ON PS_BNK_BTB_ACT_C (MSSCONCATCOL)
Error: Unable to process create statement for BNK_BTB_ACT_C
SQL Spaces: 0 Tables: 384 Triggers: 0 Indexes: 438 Views: 0
Ended: Tue Feb 09 07:07:15 2016
Unsuccessful completion "

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 - Run Data Mover setup script for setting up English and Portuguese
2 - see the above error


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