InfoPath Dev

I uploaded a form template whilst waiting for another form to finish upgrading and ran into some problems where the upgrade never completed.

I ended up having to try retract the solution and that still stuck so I used the stsadm.exe command to remove the form template that way. By removing that I managed to break Manage form Templates under Applications in Central Administration.

When I access the page now I get the following debug information

Object reference not set to an instance of an object.   at Microsoft.Office.InfoPath.Server.Administration.FormTemplate.SolutionDeploymentFailed()
   at Microsoft.Office.InfoPath.Server.Administration.FormTemplate.get_FormTemplateStatus()
   at Microsoft.Office.InfoPath.Server.ApplicationPages.FormTemplatePropertiesPage.GetStatusString(FormTemplate template)
   at Microsoft.Office.InfoPath.Server.ApplicationPages.ManageFormTemplatesPage.AddTemplateToTable(FormTemplate template, DataTable table, SPWeb web)
   at Microsoft.Office.InfoPath.Server.ApplicationPages.ManageFormTemplatesPage.FillDataTable(DataTable table)
   at Microsoft.Office.InfoPath.Server.ApplicationPages.GridViewPageBase.GridViewDataSourceView.FillDataTable(DataTable table, DataSourceSelectArguments selectArguments)
   at Microsoft.Office.InfoPath.Server.ApplicationPages.GridViewPageBase.GridViewDataSourceView.Select(DataSourceSelectArguments selectArguments)
   at Microsoft.SharePoint.WebControls.AdministrationDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at Microsoft.Office.InfoPath.Server.ApplicationPages.GridViewPageBase.RefreshDataGrid()
   at Microsoft.Office.InfoPath.Server.ApplicationPages.ManageFormTemplatesPage.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 I found an article which outlines the same problem I'm having http://geekswithblogs.net/HammerTips/archive/2007/12/07/unable-to-manage-form-templates.aspx

Unfortunately they are working locally on the server with Visual Studio whereas I am working remotely. Our development machine is still being built so I am testing on our live box (smart I know...)

Anyone know how I can fix this without losing a)the existing data people have entered b)without reinstalling moss or c)Knows why my connection string isn't working to SQL to try and run the suggestions in the above article?

Quoting my reply to the blog above:-

I am trying

"SPFarm Farm = SPFarm.Open("Data Source=MACHINENAME;Initial Catalog=MOSSSQL;User Id=DOMAIN\\admin;Password=#############");"

instead of the line

"SPFarm Farm = SPFarm.Local;"

What should the initial catalogue be? The Central Admin one or the SharePoint one? Connecting remotely do I need extra parameters in my connection string? I'm familiar with C# and Central Admin but not SQL and the guy I work with who knows is on holiday for a while!

Also, I followed Phil's advice and removed my form template using the command line but it did not fix the issue and my events log is still full of errors saying

"Value cannot be null.
Parameter name: userName"

Thanks in advance,

John

This in the end was fixed using the commandline tool 

stsadm.exe -o RemoveFormTemplate -filename c:\MyFormFolder\MyForm.xsn

then

stsadm.exe -o Execadmsvcjobs

and removing an old content type that was kind of locking things up (couldn't remove the content type because it said it was in use in the form library, so had to remove site columns using that content type)

Remember after uploading a new content type to go into the Re-link document type to fix it for all users.

Hope this helps others who get into a similar situation

I solved this problem. Here is what I did: Step 1: Ran stsadm -o enumformtemplates > c:\formlist.txt to output all the InfoPath form templates uploaded in SharePoint Central Administration Step 2: Due to the fact that I didn’t know which of the form templates is generating the issue I had to delete them all, one by one, by executing the following command: a. stsadm -o removeformtemplate -formid (eg: urn:schemas-microsoft-com:office:infopath:T02-DM-V4-FINAL:-myXSD-2008-07-11T19-40-02) b. I got the following error while trying to remove some form templates: "this form template was deployed as part of the FT-01-65a1d9ae-868d-f975-ddce-cacf6e4d703d feature. This form template should be removed only by uninstalling that feature." c. To solve this error then I removed the solution also. So I had to execute: stsadm -o uninstallfeature -id -force (e.g.: stsadm -o uninstallfeature -id f97dd99b-7ea7-1c56-25e5-eddf7ff6099 -force) In order to determine the id, I navigated to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\FT-01-f97dd99b-7ea7-1c56-25e5-eddf7ff6099b and locate the feature.xml file. The id will be located inside of this file. Here we should find something like Feature Id="50d541c7-d5f4-fa2c-8449-7f3e4e6eaebe" so this is the id we need to use for the stsadm command After I removed one InfoPath form I performed an iisreset and try to open the Manage InfoPath forms page. This way I did refresh the page after removing each form and after removing one particular form the Manage Forms page came up without any error. The form I removed last before the page came up without any error was deployed 2 years back. From this I have to conclude that there was some issue with this forms deployment or some timer job that was supposed to activate or deploy this form was stuck.

 

I have tried the above suggestions but it did not work for me.
I am installing my InfoPath forms via a feature.
What did work was doing a force install. e.g.

“C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm.exe” -o installfeature -filename “Matrix.InfoPathFormV2.0\feature.xml” -force

Then doing uninstall. e.g.

“C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm.exe” -o uninstallfeature -filename “sMatrix.InfoPathFormV2.0\feature.xml”