Automic Workload Automation

Hi,

I am not able to automatically deactivate a workflow when it's executed by a schedule. I logged a ticket with the support team. They said that this is a known bug that is fixed in a later version that we have (V10 Build 325). I was suprised as this seems like something that would impact most users and I would have expected it to be fixed at least at the early stages of V10.

It's annoying as I have to go manually clean up my activities window regularly.

Did anyone out there have the same issue?

Thanks,

John.

Yep. I experience this too.

I run a SQL statement to clean out my Activities Window.

Make sure to test this out in a test environment before using in Production.

Here's the SQL Statement I run (replacing <client> with my client):

delete from EJ where EJ_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900); delete from EFC where EFC_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900); delete from EPDC where EPDC_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EPD where EPD_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EPPF where EPPF_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from ESTP where ESTP_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EEC where EEC_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EQT where EQT_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EET where EET_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from ETI where ETI_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPOP where EJPOP_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EOI where EOI_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EEDB where EEDB_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPFV where EJPFV_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPVA where EJPVA_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPPC where EJPPC_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPOV where EJPOV_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPPF where EJPPF_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPPA where EJPPA_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EPUDA where EPUDA_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPCV where EJPCV_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPPO where EJPPO_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPPV where EJPPV_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EV where EV_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from ERB where ERB_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from ECV where ECV_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EJPP where EJPP_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EPUD where EPUD_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from ERET where ERET_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EVP where EVP_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EY where EY_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 ); delete from EH where EH_AH_IDNR in (select EH_AH_IDNR from EH where eh_client = <client> and EH_Status = 1900 );

Thanks, but I don't want to have to do this manually. I spoke to a few guys last night at a usergroup. They are currently on either V8 or V9 and they don't have this problem.

I suppose I could schedule a job to run these delete commands....

I have a SQL job scheduled to run the statement twice a day. (you could do it more, I just don't look at my client very much)

Gotcha, thanks for that...

That worked a treat, thanks :-)

Have you ever seen your SQL job fail with this error.

If so, ho have you fixed it?

"ORA-02292: integrity constraint (UC4.FK_EJPPC_EJPP) violated - child record found"