Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
levysanjose

Member
Registered:
Posts: 42
Reply with quote  #1 
Is it okay to delete rows in eFolder, eAlert, Process table using simple DELETE SQL statement?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
Not unless you really, really know what you are doing.

What are you needed to delete and why?


__________________
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
levysanjose

Member
Registered:
Posts: 42
Reply with quote  #3 
I got a project where the process divides an email into multiple sections. You can also set a white list and black list for incoming emails. One user sets an autoreply function to his account thus creating automatic replies to our mailbox into the BPM. These are unnecessary and creates to much clutter. There are exactly 799 rows to be deleted in both process and eFolder table. While the eAlerts have almost 13000+ rows. Manually deleting it could tedious so the best thing I can come up is to create a script to handle the removal of those data. The affected tables are the ProcessTable, eFolder, and eAlert. So is it okay to do this? Or are there another way to delete this? Please advise. Thanks again, Jerome.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
There are also the eEvent and eAttachment (if any attachments) tables. You might want to look at eLog too. None of these are required to be removed, but it is more tidy.

I would just move them to an archive stage (thus removing eAlert records unless you need them) and forget about the 700 records, myself. If they are a problem, stop the Folder being generated on the initial action by checking some value.

Databases (especially Metatsorm) are generally full of data we do not need, but removing it is usually too much risk and effort unless it is impacting performance in some way.

If you really do need to, my advice is to create and thoroughly test a stored procedure that gets all related data, and only ever use that.

__________________
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
levysanjose

Member
Registered:
Posts: 42
Reply with quote  #5 
Yeah, I was thinking that it is too risky to delete those records but it really looks cluttered. Well, if I am going to delete those records, the tables that are affected are eFolder, ProcessTable, eEvent, eLogs, eAlert, and eAttachments. If I am going to just move them to the archive, can I do this manually using SQL, or do I need to update the process and add a conditional action that goes to an archive stage?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #6 
I would do it using 'supported' methods. You will no doubt need the form we supply (somewhere on here) to add eWait records for new flags for existing Folders (as the Designer does not). Future folders can be moved with a conditional action.

__________________
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
levysanjose

Member
Registered:
Posts: 42
Reply with quote  #7 
Hi Jerome,

What is the namespace for these supported methods? What I am planning to do is to create an action conditional or timed, that will automatically move the folders that are not needed into the archive stage. Thanks again for helping me on this one. Really appreciate it.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #8 
What you are suggesting is what I meant by 'supported methods' No code or namespace involved!

__________________
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
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #9 
If there are existing folders you will need to add eWait entries for these. In this case, I would use a flag and the form we have in our admin tools:
http://www.processmapping.com.au/freestuff/freemetastormbpm9solutions/AdminTools.html


__________________
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
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!