Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
BFrumolt

Senior Member
Registered:
Posts: 84
Reply with quote  #1 

I once saw a reference to a 'Shredder Stage', where any folders entering that Stage would be removed from the system entirely -- the Stage ran the SQL to completely redact the folder from all tables, as if it never existed.

Does anyone have that map, or the SQL?  Thought I'd try to find it, before writing a stored procedure. 

0
BFrumolt

Senior Member
Registered:
Posts: 84
Reply with quote  #2 

Guess I'll answer my own question... I missed this on the Metastorm site, but it's what we need.  Search for kb600.
 


0
Nappy

Avatar / Picture

Guru
Registered:
Posts: 1,087
Reply with quote  #3 
Hi,

The link you placed does not work (probably unique to your previous session)

How did you find the article?

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.

PS that's for V6/7 for V9 the problem is V9 at the moment ;)
0
BFrumolt

Senior Member
Registered:
Posts: 84
Reply with quote  #4 

Thanks - thought I edited that... search for kb600.


0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #5 
Quote:
Originally Posted by BFrumolt

I once saw a reference to a 'Shredder Stage', where any folders entering that Stage would be removed from the system entirely -- the Stage ran the SQL to completely redact the folder from all tables, as if it never existed.

Does anyone have that map, or the SQL?  Thought I'd try to find it, before writing a stored procedure. 

WE contemplated one at Metastorm amny years ago, but I guess no-one ever wanted it badly enough.

Since then we put our own together in a process in our Metastorm BPM Toolkit. The SQL is something like:
Quote:
SELECT eFolderId FROM eFolder WHERE eMapName='%tMapName' AND eStageName='%tStageName' AND eEntryTime < <your timestamp here>

You then have to delete from:
eWait
eAlert
eEvent
<custom Table>
eAttachment
eFolder

I think that's it....

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Nappy

Avatar / Picture

Guru
Registered:
Posts: 1,087
Reply with quote  #6 
Hi,

Had a quick look at KB600 (thanks BFrumolt)
Jerome besides the tables you mention it also deletes form these tables

eAssignment
eAlertRequest
eAlertGeneratorLock
eLog
eRaisedFlag



__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.

PS that's for V6/7 for V9 the problem is V9 at the moment ;)
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #7 
Thanks for those additions.

Apart from eAssignment, though. Although there is an eFolderId field, is never used.


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
BFrumolt

Senior Member
Registered:
Posts: 84
Reply with quote  #8 

We're returning to this SP as a means of deleting a folder as soon as it hits the final Stage of a process.  Our preference would be to run the stored procedure referenced above on a folder-by-folder basis, rather than a daily job, etc if possible.

The problem is that if you try to set the SP to run on a timed action, etc., you're working with the folder as you try to delete it, so it's locked and the SP fails.

I tried running the SP as part of an Asynch script, but I'm getting a 'catastrophic error' at the point it tries to run the SP, and I see a reference in the Scripting Guide that access to ework functions like ework.execute are not available in Asynch scripts.

I have a sneaky suspicion that there's a simple and elegant solution to this, but it's not coming to mind, at the moment.  Has anyone done this?

0
Rick

Avatar / Picture

Senior Veteran
Registered:
Posts: 259
Reply with quote  #9 
You could raise a flag when the folder hits the final stage which creates another folder to run the SP against it's own parent.

I'm about to impliment this but was planning to go down the batch job route as I want to shred the folders 6 months after they hit the archive stage. I'm planning to have a seperate, simple map with 1 active folder. The folder sits at a stage and once a day/week/whatever a timed action kicks off, runs the SP to delete the appropriate folders and loops-back ready for next time.

In practice it may be a smidgen more complex than that. I may have to build a list of folders to delete and then loop-through the list deleting them one at a time but you get the general idea.

Rick.

__________________

Another full day of doing nothing but rearranging zeros and ones. :)
You know it will be a good day when there is no human interaction on the schedule.

0
BFrumolt

Senior Member
Registered:
Posts: 84
Reply with quote  #10 
Hi Rick,

I thought of the Flag issue, but then I create a folder to delete a folder, and my total folder count stays the same.

I'm leaning toward the batch job, same as you.  The issue I'm seeing is that there are some Administrative features that we need which are made much simpler for the user when they are in a 'real' map, as opposed to an Admin Form.  So, we'd like to maintain the flexibility of a map, but the efficiency of an Admin Form. And a 'Shredder' stage is the nicest solution to that in our minds.

I'll let you know what we come up with, if we do...
0
Nappy

Avatar / Picture

Guru
Registered:
Posts: 1,087
Reply with quote  #11 
If you have one real map running and you flag that with the folderid of the folder you want to shred you have just one folder for as many shreds as you need.

If you have multiple maps you can use a per map shredder or a single map and give the type of the map you want to shred.

Or you can write an entry into a table and have this process eat up the entries at regular intervals

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.

PS that's for V6/7 for V9 the problem is V9 at the moment ;)
0
BFrumolt

Senior Member
Registered:
Posts: 84
Reply with quote  #12 

Thanks Nappy, I think I missed that point completely in Rick's reply...  makes perfect sense, we'll give it a try.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!