Skip to main content

Error deleting DBD design schema v_dbd

  • February 7, 2015
  • 2 replies
  • 16 views

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

2 replies

id10t
Forum|alt.badge.img
  • Participating Frequently
  • February 7, 2015
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
  • Author
  • Participating Frequently
  • February 7, 2015
SELECT DESIGNER_DROP_DESIGN ('<design name>',true); did the trick - thank you