RaymondK2522 Member since 2017 3 posts
Virgin Media Ireland Limited
Posted: 2 years ago
Last activity: 2 years 5 months ago

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 Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn