- Removing subject, denied.
- Posted by M.M.B. on July 2nd, 2007
I've decided to clean up our subjecttree, thus I created a workflow
that renamed some old subjects to new subjects, afterwards I wanted
to remove the obsolete subjects. This worked for several subjects,
however on one or two subjects I still get the error that I cannot
delete them because Records are still attached to them.
....and I can't seem to figure out which records these could be...
How to find out easily?!
- Posted by David Jennaway on July 2nd, 2007
I think the easiest way is to use Advanced Find, though you have to do this
in turn for each of the entity types that are related to subject (Case, KB
article, Product and Sales Literature)
--
David Jennaway - Microsoft Dynamics CRM MVP
Web: http://www.excitation.co.uk
"M.M.B." wrote:
- Posted by M.M.B. on July 2nd, 2007
David, I've searched every Case, KB (only around 25 items) articles,
products, product info and salesliterature,
as well as all the other entities, but Advanced Find came up with zero
results each time. Still the old subject's
sticking to whatever record.
Any more idea's?
"David Jennaway" <DavidJennaway@discussions.microsoft.com> schreef in
bericht news:FB44BF0C-8108-4207-BFF1-5D4757A2B863@microsoft.com...
- Posted by M.M.B. on July 2nd, 2007
Ok, found 1 item (a servicecontract as a Product that was linked to the
specific subject), coupled that
to another one and so I was able to remove that old subject finally. Strange
that I didn't encounter it
the first time I looked over every entity using Advanced Find, must have
overlooked it or mistyped the query.
Probably one more item left somewhere for the other subject, but I'm sure
I'll nail that shortly.
Thanks.
"M.M.B." <crmuser@newsgroups.com> schreef in bericht
news:5809DC22-BF46-40FA-B88C-C4701692A5CB@microsoft.com...
- Posted by M.M.B. on July 3rd, 2007
Ok, I was wrong. Can't seem to find the last one.
The only thing I can think of is that I have a Service that's named the same
as the Subject I'm trying to remove, but should that have any influence on
each other?
"M.M.B." <crmuser@newsgroups.com> schreef in bericht
news:3ABE31DC-29ED-4E8E-AD2A-5CCB6BCF545C@microsoft.com...
- Posted by Ronald Lemmen on July 3rd, 2007
Hi,
Is there any problem to leave it in crm while it is deactivated?
You could start a database profiler and then delete the record. You will
find that the last query will give an error. Try to run this manual and you
will get a more descriptive error message.
Make a backup ofcourse before executing any query.
Hope this helps,
--
Ronald Lemmen - MSCRM MVP
Avanade Netherlands
http://www.ronaldlemmen.com/
"M.M.B." wrote:
- Posted by M.M.B. on July 4th, 2007
Hmm, I've started the profiler and tried to remove the Subject from the tree
in
CRM (not a single record, but a Subject). I can't really interpret which
line
in SQL Profiler should provide me the query+error you mention.
What traceline to look for?
"Ronald Lemmen" <RonaldL@-REMOVETHIS-avanade.com> schreef in bericht
news:3EC4796C-B649-4521-B4DF-6F051E144AFF@microsoft.com...
