• Replies 4 replies
  • Subscribers 415 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Unable to Delete Plan

Naomi Satake
$organization

Hey everyone,

 

Wondering if anyone has figured out a fix to this.  Seems like a V12 glitch. 

 

Long story short, we need to delete a plan from someone's record. Unfortunately, the status had changed in the record, and therefore, a step was created marking the change in status.  Though there is no valuable information in this Plan, "The selected plan cannot be deleted because one or more steps are associated with this plan." There are no steps other than the status change.

 

I've created a null campaign for all of these types so I can track them and fix them down the road, but there's got to be an easier solution.  Our fundraisers can't go into the backend to delete these themselves.

 

Help!

Parents
  • $organization
    Technically you should be able to crea tree a job that runs every night and deletes any plans with the specific step in it.

    Sent from my Android phone using TouchDown (www.nitrodesk.com)

    -----Original Message-----
    From: Naomi Satake [bounce-naomisatake1832@tessituranetwork.com]
    Received: Monday, 29 Jun 2015, 7:51PM
    To: Mendy Sudranski [msudranski@mtc-nyc.org]
    Subject: Re: [Tessitura Development Forum] Unable to Delete Plan


    We've decided to go ahead with using the step type of "Clean Record" assigned with a note for the Information Manager to delete the campaign changes from the backend. Volumewise, I can see this not being a long term solution, but it's a good fix for now
    From: Mendy Sudranski
    Sent: 6/9/2015 3:18:12 PM

    i dealt with this through the following code. this is a manual process that requires you database people.



    USE WITH CAUTION AND TEST TEST TEST FIRST



    declare @customer_no int



    set @customer_no = null



    select

    cmp.description ,pln.*

    from

    T_PLAN pln

    join T_CAMPAIGN cmp on pln.campaign_no = cmp.campaign_no

    where

    customer_no = @customer_no



    declare @plan_no int

    declare @step_no int



    set @plan_no = null

    set @step_no = null



    select

    cmp.description ,pln.*

    from

    T_PLAN pln

    join T_CAMPAIGN cmp on pln.campaign_no = cmp.campaign_no



    where

    customer_no = @customer_no

    and pln.plan_no = @plan_no



    select * from T_STEP where plan_no = @plan_no



    -- delete from T_STEP where step_no = @step_no



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization
    Technically you should be able to crea tree a job that runs every night and deletes any plans with the specific step in it.

    Sent from my Android phone using TouchDown (www.nitrodesk.com)

    -----Original Message-----
    From: Naomi Satake [bounce-naomisatake1832@tessituranetwork.com]
    Received: Monday, 29 Jun 2015, 7:51PM
    To: Mendy Sudranski [msudranski@mtc-nyc.org]
    Subject: Re: [Tessitura Development Forum] Unable to Delete Plan


    We've decided to go ahead with using the step type of "Clean Record" assigned with a note for the Information Manager to delete the campaign changes from the backend. Volumewise, I can see this not being a long term solution, but it's a good fix for now
    From: Mendy Sudranski
    Sent: 6/9/2015 3:18:12 PM

    i dealt with this through the following code. this is a manual process that requires you database people.



    USE WITH CAUTION AND TEST TEST TEST FIRST



    declare @customer_no int



    set @customer_no = null



    select

    cmp.description ,pln.*

    from

    T_PLAN pln

    join T_CAMPAIGN cmp on pln.campaign_no = cmp.campaign_no

    where

    customer_no = @customer_no



    declare @plan_no int

    declare @step_no int



    set @plan_no = null

    set @step_no = null



    select

    cmp.description ,pln.*

    from

    T_PLAN pln

    join T_CAMPAIGN cmp on pln.campaign_no = cmp.campaign_no



    where

    customer_no = @customer_no

    and pln.plan_no = @plan_no



    select * from T_STEP where plan_no = @plan_no



    -- delete from T_STEP where step_no = @step_no



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data