Support Article
Alter DDL changes do not take effect on product import
SA-86586
Summary
When importing a package that includes the Alter scripts for an already existing table, the table changes are not processed though a success message is reported at the end of the Import process.
Error Messages
Not Applicable
Steps to Reproduce
- Create the product file which includes schema changes.
- Import the product file to the QA environment. While importing the file, the system identified the Data Definition Language (DDL) changes.
- Select the Automatic deployment option. The process is completed without an error. Verify the table after deployment. The new columns are not present.
Root Cause
A defect or configuration issue in the operating environment.
User did not have permissions to apply the DDL changes.
Resolution
Perform the following local-change:
Grant the user the DatabaseAdministration role which includes privileges to alter database columns.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.