Re: SP 2013 setup feature lost when content DB's were cleaned up for qRules injected forms

Hilary Stoupa — Fri, 30 Jun 2017 22:43:57 GMT

Do your forms work in preview? I think you are saying that you entirely removed the forms from the site, then re-uploaded them as admin deployed from Central Admin? I'd expect that to work even if the old versions had issues due to database clean up.

SP 2013 setup feature lost when content DB's were cleaned up for qRules injected forms

Laurie Wheeler — Fri, 30 Jun 2017 19:57:27 GMT

We did a major cleanup of all our content DB's. (Test Content DB)

The content DB that had qRules version 7injected forms, shows (3) errors for a Missing Feature. The Feature was identified as a SharePoint 2010 feature, but we are on SharePoint 2013 - The orphaned features were removed from the content DB. Now, none of the qRules inject forms will open. These are admin approved forms and deployed through Central Administration. I attempted to re-deploy the form, and the errors still occur. I even removed its content type from the site, and re-deployed the form as a new approved form, and added the content type and the error still exists.

I found the feature folders in our 14hive template / features folder on the server.

How to I get my forms back in shape now. Can the forms be re-injected and then re-deploy?

Content DB error from TestContentDB.

File [Features\FT-01-04abf141-7eac-435b-73ba-daac8095f63a\solution.xsn] is referenced [1] times in the database [SP13_Content_CD_CM_8HR], but exists only under Microsoft SharePoint Foundation 2010 setup folder. Consider upgrading the feature/solution which contains this file to the latest version.

One or more setup files are referenced in the database [SP13_Content_CD_CM_8HR], but are not installed on the current farm. Please install any feature or solution which contains these files.

File [Features\FT-01-9ebbebcb-5db1-5b5f-c5fb-ce6bb8bb5f5c\solution.xsn] is referenced [1] times in the database [SP13_Content_CD_CM_8HR], but exists only under Microsoft SharePoint Foundation 2010 setup folder. Consider upgrading the feature/solution which contains this file to the latest version.

One or more setup files are referenced in the database [SP13_Content_CD_CM_8HR], but are not installed on the current farm. Please install any feature or solution which contains these files.

File [Features\FT-01-b368f929-f912-07a6-127d-cf9d66eb855d\solution.xsn] is referenced [1] times in the database [SP13_Content_CD_CM_8HR], but exists only under Microsoft SharePoint Foundation 2010 setup folder. Consider upgrading the feature/solution which contains this file to the latest

version.

One or more setup files are referenced in the database [SP13_Content_CD_CM_8HR], but are not installed on the current farm. Please install any feature or solution which contains these files.

“missing features” where removed through a powershell script

We did not know at the time that these features are attached to the (3) qRules injected forms.

Now when I try to open one of the forms, I get an error with a correlation ID: Here’s the error from our logs

Line 22898: 06/30/2017 15:21:15.61 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://sharepoint.us.stoneridge.com:80/ctldev/cm/V6Template/_layouts/15/FormServer.aspx?XsnLocation=http://sharepoint.us.stoneridge.com/ctldev/cm/FormServerTemplates/CM_Master.xsn&SaveLocation=http%3A%2F%2Fsharepoint%2Eus%2Estoneridge%2Ecom%2Fctldev%2Fcm%2FV6Template%2FCM&ClientInstalled=true&DefaultItemOpen=1&Source=http%3A%2F%2Fsharepoint%2Eus%2Estoneridge%2Ecom%2Fctldev%2Fcm%2FV6Template%2FSitePages%2FHome%2Easpx) 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22899: 06/30/2017 15:21:15.62 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ctldev/cm 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22900: 06/30/2017 15:21:15.67 w3wp.exe (0x5E44) 0x3E8C 0x6FB7003 ahjqp High [Forced due to logging gap, cached @ 06/30/2017 15:21:15.65, Original Level: Verbose] SQL connection time: 0.0642539764132034 for Data Source=NAPRODSPDB01\SP2013;Initial Catalog=SP13_Content_CD_CM_8HR;Integrated Security=True;Persist Security Info=False;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Asynchronous Processing=False;Connection Reset=True;MultipleActiveResultSets=False;Replication=False;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;Load Balance Timeout=0;Packet Size=8000;Type System Version=Latest;Application Name=".Net SqlClient Data Provider";User Instance=False;Context Connection=False;Transaction Binding="Implicit Unbind";ApplicationIntent=ReadWrite;MultiSubnetFailover=False;TransparentNetworkIPResolution=True;ConnectRetryCount=1;ConnectRetryInt... 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22901: 06/30/2017 15:21:15.67* w3wp.exe (0x5E44) 0x3E8C 0x6FB7003 ahjqp High ...erval=10;Column Encryption Setting=Disabled 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22902: 06/30/2017 15:21:15.67 w3wp.exe (0x5E44) 0x3E8C InfoPath Forms Services Runtime m1gm High [Forced due to logging gap, Original Level: Medium] EnsureObjectInCache - created object to cache: ProcessId:[{0}] CacheId: {1}. Finished in {2} 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22904: 06/30/2017 15:21:15.69 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation General 8kh7 High Cannot open file "FormServerTemplates/CM_Master.xsn". 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22905: 06/30/2017 15:21:15.69 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation General aix9j High SPRequest.GetFileAsStream: UserPrincipalName=i:0).w|s-1-5-21-1846535688-3630194805-129047095-12287, AppPrincipalName= ,bstrUrl=http://sharepoint.us.stoneridge.com/ctldev/cm ,bstrWebRelativeUrl=FormServerTemplates/CM_Master.xsn ,bHonorLevel=False ,iLevel=1 ,grfob=24 ,bstrEtagNotMatch=<null> ,punkSPFileMgr=<null> ,bHonorCustomIrm=False 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22906: 06/30/2017 15:21:15.75 w3wp.exe (0x5E44) 0x3E8C InfoPath Forms Services Runtime m1sc High [Forced due to logging gap, cached @ 06/30/2017 15:21:15.70, Original Level: Verbose] GlobalStorage.Leave: Old context - {0} Total contexts after Leave - {1} 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22907: 06/30/2017 15:21:15.75 w3wp.exe (0x5E44) 0x3E8C InfoPath Forms Services Runtime m1sc High [Forced due to logging gap, Original Level: Verbose] GlobalStorage.Leave: Old context - {0} Total contexts after Leave - {1} 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22909: 06/30/2017 15:21:15.83 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation General af4yd High [Forced due to logging gap, cached @ 06/30/2017 15:21:15.76, Original Level: Verbose] TenantAppEtag record requested but there is no sitesubscription or tenantId for site {0} so we will use the WebApp Id for the cache. 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22910: 06/30/2017 15:21:15.83 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation Web Controls ad9g2 High [Forced due to logging gap, Original Level: Verbose] QoS data point list: [] 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22911: 06/30/2017 15:21:15.89 w3wp.exe (0x5E44) 0x3E8C 0x6FB7007 6t8h High [Forced due to logging gap, cached @ 06/30/2017 15:21:15.86, Original Level: Verbose] {0} 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22912: 06/30/2017 15:21:15.89 w3wp.exe (0x5E44) 0x3E8C InfoPath Forms Services Runtime m1sf High [Forced due to logging gap, Original Level: Verbose] {0} 01ca009e-d765-f049-893b-86eeb5182cb3

Line 22913: 06/30/2017 15:21:15.89 w3wp.exe (0x5E44) 0x3E8C SharePoint Foundation Micro Trace uls4 Medium Micro Trace Tags: 0 agb9s,49 m1gm,23 aix9j 01ca009e-d765-f049-893b-86eeb5182cb3

Qdabra qRules

Re: SP 2013 setup feature lost when content DB's were cleaned up for qRules injected forms

SP 2013 setup feature lost when content DB's were cleaned up for qRules injected forms