tag:blogger.com,1999:blog-15200454.post4783128602095204881..comments2023-09-12T09:38:46.195-04:00Comments on SharePoint: Content Type is still in useMorten Marquardhttp://www.blogger.com/profile/07373568346464812598noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-15200454.post-18452919412868333782012-05-22T13:07:35.203-04:002012-05-22T13:07:35.203-04:00Struggled in same issue as well.
Eventually this i...Struggled in same issue as well.<br />Eventually this is my fix : <br />- Empty you own Recycle Bin <br />- then the Site Collection Recycle Bin http://sharepoint/_layouts/AdminRecycleBin.aspx<br />that's not it, now check both views: <br /><br />Select a View <br />End user Recycle Bin items <br />Deleted from end user Recycle Bin <br />and make sure they are both Empty.<br /><br />This did the trick to me and I was able to delete my Infopath Admin Signed form Content Type.Francois Souyrihttp://ghamson.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-55081680742719574242012-03-01T11:47:03.352-05:002012-03-01T11:47:03.352-05:00You should check out the following two sites. Syn...You should check out the following two sites. Synopsis: Use SharePoint Manager to locate the content type then ensure you have deleted them from all the recycle bins.<br /><br />1. http://nickhadlee.wordpress.com/2010/05/24/the-content-type-is-in-use-sharepoint-2010-error-redux/<br /><br />2. http://brendannewell.com/musings/?p=14Mattnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-1833414196866964972012-02-16T18:06:39.184-05:002012-02-16T18:06:39.184-05:00i was able to work around this by going to the lib...i was able to work around this by going to the library using the content types and deleting from there then going to site contenty types gallery to delete.JWhttps://www.blogger.com/profile/17679487575069052608noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-79629925824252941652011-11-10T13:20:05.008-04:002011-11-10T13:20:05.008-04:00I encountered the same issue. I was able to final...I encountered the same issue. I was able to finally remove the content type by not making it visible in the "Content Type Order" setting (uncheck the Visible checkbox). Once that was done, I was able to delete the unused content type.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-28624218623500513312011-11-03T12:17:29.535-04:002011-11-03T12:17:29.535-04:00Should these same queries work on a SharePoint 201...Should these same queries work on a SharePoint 2010 database? I keep getting errors that state invalid columns.<br />================<br />Msg 207, Level 16, State 1, Line 3<br />Invalid column name 'tp_DirName'.<br />Msg 207, Level 16, State 1, Line 4<br />Invalid column name 'tp_ContentType'.<br />Msg 207, Level 16, State 1, Line 5<br />Invalid column name 'tp_DirName'.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-82503593453300989512011-08-26T08:01:13.151-04:002011-08-26T08:01:13.151-04:00I ended up deleting my entire site collection, and...I ended up deleting my entire site collection, and then recreate it.<br /><br />Lucky for me I was in a dev environment, and had nothing important in it.<br /><br />I had a developed a feature that added a content type. My deactivate event didn't manage to delete the content type, and manually deleting throw the error "still in use", even while I never (!) even used the content type in a list or anything.<br /><br />Removing the solution didn't help, it was still in use...<br /><br />But that's what you learn when developing in SharePoint: it will always fail somewhere for some nonsense reason that only Microsoft knows, and before you know it you destroyed your entire environment without any plausible reason.<br /><br />Thank you Microsoft for all the nonsense that we developers come across when developing in SharePoint! Without you my days would be oh so boring...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-74267753540117765292011-06-17T02:46:16.710-04:002011-06-17T02:46:16.710-04:00How in God's name is a stuck solution even rem...How in God's name is a stuck solution even remotely relevant to removing a content type that is in use??Tripwirehttps://www.blogger.com/profile/12664618733681351513noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-84954226661964865412011-06-01T17:57:22.153-04:002011-06-01T17:57:22.153-04:00This worked for me:
Use the following command to ...This worked for me:<br /><br />Use the following command to get a list of all solutions that are being deployed.<br />stsadm -o enumdeployments<br /><br />Use the JobId GUID that comes back from this e.g. Deployment JobId="e99b7304-cfc0-419a-a3f2-18ca5193c838"<br /><br />Cancel the "stuck" deployment (in "Deploying" status" with the following command<br />stsadm -o canceldeployment -id e99b7304-cfc0-419a-a3f2-18ca5193c838<br /><br />Delete the stuck solution once and for all with<br />stsdm -o deletesolution -name mysolution.wsp -override<br />Redeploy your solution.<br /><br />From <br />http://ddkonline.blogspot.com/2010/05/fix-for-sharepoint-2007-solution.htmlLexhttps://www.blogger.com/profile/09303179198185388471noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-47467626430957277732011-02-08T18:39:08.812-05:002011-02-08T18:39:08.812-05:00Most of the time it works - but sometimes SharePoi...Most of the time it works - but sometimes SharePoint act strange as described here.<br /><br />I simply didn't manage to get the record removed using SharePoint API - so had to remove it using SQL - WHICH IS DANGEROUS AND NOT SUPPORTED BY MICROSOFT.Morten Marquardhttps://www.blogger.com/profile/07373568346464812598noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-57573772822398048092011-01-21T11:29:47.662-05:002011-01-21T11:29:47.662-05:00I had the same issue, deleted the library and the ...I had the same issue, deleted the library and the content type was still in use. I cleared the recycle bin, end user recycle bin and site collection recycle bin and then it let me delete itDavid Lozzihttp://about.me/davidlozzinoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-89966800389328758602010-11-03T10:18:00.059-05:002010-11-03T10:18:00.059-05:00You need to disassociate the content type from the...You need to disassociate the content type from the list you were using it in. If its still associated to the list then it will be "in use"Mauro Masuccihttps://www.blogger.com/profile/13569806639377793705noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-15226797860323288772010-06-23T03:30:51.794-04:002010-06-23T03:30:51.794-04:00If this is for SharePoint 2010 then check your rec...If this is for SharePoint 2010 then check your recycle bins to make sure there are no lists using the content type that have been deleted.<br /><br />I <a href="http://nickhadlee.wordpress.com/2010/05/24/the-content-type-is-in-use-sharepoint-2010-error-redux/" rel="nofollow">came across this issue</a> a wee while back!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-13562448265895078202010-05-21T09:45:51.721-04:002010-05-21T09:45:51.721-04:00I ran into the same situation and found that conte...I ran into the same situation and found that contentapproval was enabled on the list. Some items where not approved so the unapproved items still held to the previous contenttype.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-67030398353953798092010-03-19T12:22:27.283-04:002010-03-19T12:22:27.283-04:00If you're using a content type on a workflow, ...If you're using a content type on a workflow, then that content type will be listed in the Tasks list associated with the workflow. It must be deleted from there first, then it's able to be deleted from the site.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-7441609297766951242010-02-09T16:11:16.163-05:002010-02-09T16:11:16.163-05:00I ran into this same problem and had to delete all...I ran into this same problem and had to delete all the documents from the library that were using that content type... and it only took me two days to figure that out! <br /><br />-s!sarcastrohttps://www.blogger.com/profile/00793671957911143772noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-68054785653266249912010-01-15T16:07:49.682-05:002010-01-15T16:07:49.682-05:00I had the same issue. I ran the following query to...I had the same issue. I ran the following query to findout the items using the content type <br><br><br />SELECT *<br />FROM AllUserData<br />WHERE (tp_DirName LIKE '%')<br />AND ((tp_ContentType = '') and tp_ListId='')<br />ORDER BY tp_DirName <br /><br><br><br />I found some items still using content type. So decided to delete these item from table. <br><br><br />DELETE<br />FROM AllUserData<br />WHERE (tp_DirName LIKE '%')<br />AND ((tp_ContentType = '') and tp_ListId='')<br /><br><br><br />and guess what!!!!! It worked. I was able to delete content type.Unknownhttps://www.blogger.com/profile/13591502199353087705noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-64817850765085884432009-08-11T23:08:05.403-04:002009-08-11T23:08:05.403-04:00Thanks Morten. Not really the solution I was looki...Thanks Morten. Not really the solution I was looking for though. :)Tripwirehttps://www.blogger.com/profile/12664618733681351513noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-64854615711784545962009-08-11T10:06:59.401-04:002009-08-11T10:06:59.401-04:00Nope - never got it working.
Well - export all do...Nope - never got it working.<br /><br />Well - export all documents. Delete the document library, import all documents again. Voila.Morten Marquardhttps://www.blogger.com/profile/07373568346464812598noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-44193097222905342692009-07-15T20:59:52.785-04:002009-07-15T20:59:52.785-04:00Did you ever find a solution to this? We're in...Did you ever find a solution to this? We're in the same boat and this is driving me nuts!Tripwirehttps://www.blogger.com/profile/12664618733681351513noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-54530533530846331522009-06-25T11:11:05.861-04:002009-06-25T11:11:05.861-04:00Hi Bryan,
You MUST delete all old versions with th...Hi Bryan,<br />You MUST delete all old versions with the old content type in order to have it released from the database. However, even in this sitaution I have not managed to get all objects released.<br /><br />I tried to change the database by modifying the content class of the object - I didn't delete it (didn't dare to). Unfortunately it didn't help. So I reestablised the solution and created a new document library without the problem.<br /><br />MortenMorten Marquardhttps://www.blogger.com/profile/07373568346464812598noreply@blogger.comtag:blogger.com,1999:blog-15200454.post-3225334519885674052009-06-25T10:50:49.973-04:002009-06-25T10:50:49.973-04:00I'm in the same situation and found the SQL re...I'm in the same situation and found the SQL records using the query that's posted. Did you ever find a solution to this issue? I'm at the point of deleting the SQL records but I don't know if they may exist in other db tables. Any help will be greatly appreciated. Bryan Roberton (ThumperFLA@aol.com)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15200454.post-73242888731655812952009-04-17T13:58:00.000-04:002009-04-17T13:58:00.000-04:00Make sure there are no workflows running on an ite...Make sure there are no workflows running on an item using the Content Type you want to delete.Unknownhttps://www.blogger.com/profile/02058115488532003416noreply@blogger.com