Error deleting DBD design schema v_dbd
I a cleaning up designs over the past 6 months.
SELECT DESIGNER_DROP_DESIGN ('jim091814');
gives me the error >> ERROR 6110: A design/deployment process is currently executing in this design space
Trying to cancel the design does nothing - I suspect because the underlying schema is gone
SELECT DESIGNER_CANCEL_POPULATE_DESIGN ('jim091814');
select * from v_dbd_jim091814_jim091814.vs_output_event_history order by time_stamp desc limit 10
Last row says >> Design in progress and User requested to cancel design
How can I delete this design ?
jim
SELECT DESIGNER_DROP_DESIGN ('jim091814');
gives me the error >> ERROR 6110: A design/deployment process is currently executing in this design space
Trying to cancel the design does nothing - I suspect because the underlying schema is gone
SELECT DESIGNER_CANCEL_POPULATE_DESIGN ('jim091814');
select * from v_dbd_jim091814_jim091814.vs_output_event_history order by time_stamp desc limit 10
Last row says >> Design in progress and User requested to cancel design
How can I delete this design ?
jim
0
Comments
Try
- dbd_drop_deployment_design
- dbd_cancel_populate_design
I bet on a last one:****
select dbd_cancel_populate_design('<workspace name>','<design name>');
select dbd_cancel_populate_design('<workspace name>','<design name>', '<force>');
****
or
***
select dbd_drop_deployment_design('<workspace name>','<design name>', 'default');
***
(not sure)
Regards.