Infopath form stuck on deleting status

Hi,


If you have an Infopath form which stucks on "Deleting" status and even you try to retract the corresponding wsp file, it stucks on "Retracting" you should delete the solution using stsadm.

People keep saying that I should restart the admin jobs using the "stsadm -o execadmsvcjobs" command but it was not helping.. But please try this before removing everything : ) It s worth to try..

So, since the command was not solving my issue, I ve decided to remove everything and reupload the form from scratch.

To remove the form, you should do 3 things.

1. Cancel the Retracting job
2. Delete the corresponding solution.
3. Delete the form template

Important !!
After cancelling the retraction you should first delete the solution and then you should delete the form template, otherwise it stucks.


Here we go:

Retracting the job:
Central Admin - System Settings - Under Farm Management - Manage farm solutions - Find your solution and Cancel Retracting Job

Then:

Start cmd as Admin, Go to the 14 hive and type the commands below:

DELETE SOLUTION on STSADM
stsadm -o deletesolution -name YOUR_WSP_NAME.wsp -override

REMOVE FORM TEMPLATE on STSADM
stsadm -o removeformtemplate -formid FORM_ID

To see the form id of your form:

Central Administration - Manage Form Templates - Go to Properties of the desired .xsn form
Get the text in Form ID: section (it starts with urn:schemas-microsoft-com: ...)

Now you are good to go..

Try to reupload and publish your form.

Cheers

edit:
Actually, reuploading the  form did not resolve my problem, there is something really weird going on on my machine.. I ll share the resolution if I can find any.

Sharepoint 2010 Run all Administrative Jobs

Sometimes you might need to run all the administrative jobs right away.

In order to do that

Open cmd as admin go to 14 Hıve

type
stsadm -o execadmsvcjobs

With this way, you don't need to wait for the scheduled jobs to run, you run it right away.

It is useful if you deploy some solutions, change an user profile etc. (I ll check user profile again: ) )

Sharepoint 2010 - Infopath Form deployment stuck on installing status

Hi,
Sometimes while deploying an Infopath 2010 form on SP server, it stucks on status "Installing".

Don't wait !

First, Cancel the scheduled job:

Go To Central Administration - System Settings - Manage Farm Solutions - Cancel the scheduled job

Then,

Just restart Sharepoint 2010 Timer and Sharepoint 2010 Administration services

To do that:

Open command line as admin

net stop "Sharepoint 2010 Timer"
net start "Sharepoint 2010 Administration"
net stop "Sharepoint 2010 Timer"
net start "Sharepoint 2010 Administration"

And try to deploy it again, hope it works : )

Cheers

Sharepoint 2010 Uninstall a feature

Sometimes if you restore a site collection, you might need to deactivate and uninstall a infopath form and reupload it.

To do that, first go to your site - Site Settings - Site Collection Administration (Go to "Go to top level site settings" if necessary) - Site collection features - Deactivate the feature.

Get the GUID on the link, you ll need it to uninstall

Then,
Uninstall the corresponding feature using stsadm

stsadm.exe -o uninstallfeature -id 9fd01052-5564-8ed4-e2b7-a563e9898f08 -force

Sometimes, copy-pasting above code does not work, simply write it yourself.


Bye !

Sharepoint 2010 clear the cache

Sometimes if you add new WF activties you might need to refresh your cache to see the changes:

Here is the way to do it:

1. Close SPD.
2. Open “My Computer”.
3. Go to %System Drive%\Documents and Settings\%user%\Local Settings\Application Data\Microsoft\WebSiteCache (If you are running Vista, that path is different - look for %System Drive%\Users\%user%\AppData\Local\Microsoft\WebSiteCache).
4. Go to a directory that looks similar to the name of the website you were connecting to. (Alternatively, you can just delete all these directories and everything should work when you boot SPD).
5. Delete the assembly with the name similar to the one you are changing.
6. Boot SPD.
7. You can now work with your updated activity.

http://blogs.msdn.com/b/sharepointdesigner/archive/2007/03/27/tip-clearing-the-spd-workflow-assembly-cache.aspx

How to run big sql files

To be  able to run big sql files you can use sqlcmd.exe
which is located on:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn

Example
SQLCMD -S SERVERNAME\INSTANCE -P Password -U Username -i C:\sample.sql -o C:\output.txt

For SQL 2014 the directory of sqlcmd.exe has changed:
<INSTALL DIRECTORY> \Client SDK\ODBC\110\Tools\Binn

Reinstall a WSP Package in Sharepoint 2010

Steps:
1. Retract
2. Delete Solution
3. Add Solution
4.Deploy Solution

1.Retract:
Go To Central Admin - System Settings - Manage Farm Solutions - Select and Retract the solution

2.Delete Solution:
Open PowerShell as Admin
Type
Remove-SPSolution –Identity YOUR_WSP_NAME.wsp

3.Add Solution:
Open 14 hive in cmd
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14
Run command:
stsadm.exe -o addsolution -filename D:\YOUR_WSP_NAME.wsp

4. Deploy Solution:
Go To Central Admin - System Settings - Manage Farm Solutions - Select and Deploy solution