Error deleting DBD design schema v_dbd

Jim_Krieger

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

id10t

Hi!

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.

Jim_Krieger

SELECT DESIGNER_DROP_DESIGN ('<design name>',true); did the trick - thank you