Stored procedure uc_drop_all leaves the sequence definitions in the database
Article ID: 388449
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Because the stored procedure leaves sequence definitions in the database a subsequent DB Load fails.
Cause
This is a defect
Resolution
Workaround:
The stored procedure has been superseded by the drop_all.sql script, which removes everything and exists for all DB types.
The stored procedure in SQL Server should not be used.
Solution:
The stored procedure will be removed from the database in a future version.
Additional Information
The reference for this is DE165920.
Feedback
Yes
No
Powered by
