Raymond Kearney (RaymondK2522)
Virgin Media Ireland Limited

Virgin Media Ireland Limited
RaymondK2522 Member since 2017 3 posts
Virgin Media Ireland Limited
Posted: March 6, 2018
Last activity: March 29, 2018
Posted: 6 Mar 2018 10:02 EST
Last activity: 29 Mar 2018 4:07 EDT

Issue with the script generated from the View/Download SQL DDL option when importing products via the Import Wizard

I have been importing a number of products into a new environment setup of Pega 7.31.
It is using a split schema and we are unable to apply the schema changes automatically.

I downloaded the SQL DDL script and executed it on the database using sqlplus.

However the output from the execution had a number of errors and a large number of lines ignored.

The majority errors and ignores were the creation of Indexes, but there were some Alter table statements throwing errors too.

The problem seems to be the script that is generated, all of the Indexes had extra newline characters between the column names and also between the closing bracket and the closing semicolon;

This means i have to manually go through each generated script and validate the statements, adding additional time to the environment creation.

I am not sure if executing the scripts using another tool will help as all I have access to is sqlplus on a linux server that can connect to the database.

Is there any other options that i have here, or is there some other way I can generate the script that will remove these extra characters

Pega Customer Service System Administration Installation and Deployment Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.