Microsoft Dynamics CRM (Archived)

multiple proccess with the same name!

(0) Share

Report

Posted on by ali shoja

227

the "all process" view has only 2000 records.

when i use adevanced find, theae are multiple process with the same name!

the workflowbase table in database has 3 gig disk space! and 9000 rcords.

how could i get rid of these dummy process whit the same name?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

NODAL 860 on at

Like (1)

Report
Copy link

Link copied!

Hi Ali,

Do you have SLAs or routing rules with lot of items.

In background each item creates a process.

Regards,

Ketan

Was this reply helpful? Yes No
ali shoja 227 on at

Like (0)

Report
Copy link

Link copied!

what is SLA ?!!

Was this reply helpful? Yes No
NODAL 860 on at

Like (0)

Report
Copy link

Link copied!

Hi Ali,

SLA means service level agreements.

To find those navigate to Settings --> Service Management --> Service level agreements

Regards,

Ketan

Was this reply helpful? Yes No
ali shoja 227 on at

Like (0)

Report
Copy link

Link copied!

i gooogle it. no.

we have no SLA or outing rules

Was this reply helpful? Yes No
ali shoja 227 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Suggested answer

Arun Vinoth 11,615 Moderator on at

Like (0)

Report
Copy link

Link copied!

Check out if someone did "save as" the process again & again.

Also verify the version number, the deactivation & activation cause duplicate entries.

You can find Activation & Definition types to filter. Check it in advanced find.

Forget the display name, the schema name only matters.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report
Copy link

Link copied!

Hi Ali,

If you query processes without any criteria, it is possible to see same workflow name in your result list multiple times. If you are looking for workflows to get a list or etc, just give "Type" criteria. Type equals Definition.

Type field has 3 options; Definition, Activation, Template. Whenever you activate a workflow, the system takes a snapshot of your workflow. Please check the link to understand more about the Type field.

http://thetindog.com/technotes/2014/1/27/microsoft-dynamics-crm-2011-workflow-type-in-sql

Regards,

Was this reply helpful? Yes No
ali shoja 227 on at

Like (0)

Report
Copy link

Link copied!

tanks! i think you r right.

how could i delete these snapshots? i deleted all workflow jobs. but the records count on advanced find is the same.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report
Copy link

Link copied!

Well, you cannot delete in a support way and you shouldn't. However you can apply this to reduce db size.

https://cloudblogs.microsoft.com/dynamics365/it/2018/06/21/cleaning-up-records-from-the-asyncoperationbase-workflowlogbase-table/

Was this reply helpful? Yes No