My Oracle Support Banner

E-CA: "Run Create Views Script" Step Fails in Change Assistant with "Error: Reading statement failed: EXECUTE CREATE VIEW <view_name>" that can be noticed in log file "CreateViews_out.log" if the View SQL is Larger than 16k+ Characters. (Doc ID 2937283.1)

Last updated on JANUARY 22, 2024

Applies to:

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

Symptoms

When attempting to apply a non-PUM Change Package, in Change Assistant, the "Run Create Views Script" step is failing with the following error if the SQL query behind a view is larger than 16k+ characters. The error can be noticed in the log file "CreateViews_out.log":

If the project is built through Application Designer, the build is executed successfully.

The issue can be reproduced at will with the following steps:
A. Create/Import a View from file, which has a large SQL query behind (e.g. 16k+ characters)

1. Go to Application Designer (Tools > Copy Project > From File…).
2. Select the Project with a “reformattedproject”.
3. Copy the definitions.
4. Save the changes.

B. Define the non-PUM Change Package from Application Designer on source environment
1. Go to Application Designer on source Database and create a new project.
2. Insert the custom created view that has a very long SQL definition (e.g. 16k+ characters) into the project.
3. Go to File > Project Properties and setup the Project as a Change Project and setup its Update ID.
4. Add the Internal Reference ID to the project and Save the project.
5. Create the Change Package (Go to Tools > Creates Change Package).
6. Setup the Export Directory: (e.g. C:\sources).
7. Finalize the Change Package (Go to Tools > Finalize Change Package).

C. Apply the non-PUM Change Package through Change Assistant
1. Copy the non-PUM Change Package to Change Assistant download directory (e.g. %ps_home%\ca_work_dir\download).
2. Start Change Assistant and choose Tool > Change Actions and choose Apply Updates.
3. Setup your environment and validate your entries.
4. Choose your package to apply and apply it.
5. Start applying package.
6. All the steps validates successfully up to Run Create Views Scripts step where the error occurs.
7. View log: “CreateViews_out.log”.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.