Unexpected error when copying dynamics GP share point workflow.

An unexpected error has been encountered in this Web Part. Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. You don’t have Add and Customize Pages permissions required to perform this action.,

The issue was the copy to company was not enabled for work flow type which was being attempted for copy!

Cheers!
Sanjay

Workflow XAML failed validation

Workflow Pairing

Default ports –
12291 – Http
12290 – Https
::obtain the ports from workflow server IIS and check the bindings for the workflow management site

Register-SPWorkflowService –SPSite “Site URL” –WorkflowHostUri “http://workflowhost:12291” –AllowOAuthHttp -Force
::use -Force to re register a already paired workflow.
::Pair the workflow server from the Sharepoint portal

Error message when the pairing is broken:
System.InvalidOperationException: Microsoft.Workflow.Client.ActivityValidationException: Workflow XAML failed validation due

to the following errors: Cannot set unknown member ‘LookupSPListItem.ItemId’. HTTP headers received from the server –

ActivityId: 304fb4ee-901d-43b8-b7ef-a8bcb220d599. NodeId: SP-WFE01. Scope: /SharePoint/default/0f273f2f-d070-4581-869b-

a684dfb4710c/e4b00a05-214e-4b0a-995d-fcd25c56d0c1. Client ActivityId : 3c801e9c-334a-10f4-b8e1-3c6fe1cae7af. —>

System.Net.WebException: The remote server returned an error: (400) Bad Request

Save to Share point icon missing in excel 2013

Save to Share point icon missing in excel 2013

1. open the sharepoint document library in fire fox.
2. navigate to the xl file already updated to document library
3. download the copy of xl
4. Firefox will ask you to open with excel – click ok
5. once the excel is opened, save the excel file – this should make the hidden icon bring back the share point icon.

Thanks
Sanjay

Update share point farm account

Perform the following steps to change the password in SharePoint.

1.Login to the server with the new credentials.

2.Open elevated command prompt .(Run as administrator)

3.Navigate to the following path. (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN)

4.To navigate copy and paste the following in the Command Prompt.
Cd /d “ C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN”

5.Execute the following command
stsadm -o updatefarmcredentials -userlogin corp\SharePoint Account -password NEWPASSWORD
NOTE: Replace NEWPASSWORD with the New Password.

6.Once the below message has been received.
Operation completed successfully.

7.Execute the following command.
iisreset/noforce

8.After receiving the below message, proceed with Step 10.
Attempting stop…
Internet services successfully stopped
Attempting start…
Internet services successfully restarted

9.Execute the following command
stsadm -o execadmsvcjobs

10.After receiving the below output, proceed with step 11.
The administration service is running so all administration jobs will be run in the timer service.

11.Execute the following command
stsadm -o updateaccountpassword -userlogin corp\Sharepoint Account -password Password456 –noadmin

12.Finally the below message appears.
Operation completed successfully.

Auto grow text box info path web browser form

  1. Set the text box height to auto
  2. Set the table row hosting the text box height to auto
  3. Change the format of the form to InfoPath filler form
  4. Mark the display as multi line
  5. Un check page break option
  6. Set option to show and expand all text.
  7. Revert back the setting to web browser form

The text box should auto grow.

Cheers!
Sanjay

 

 

 

Correlation ID – Extract details using powershell

If 550ff19c-b7e8-7068-88c9-51917c1757cd is the correlation ID

get-splogevent | ?{$_.Correlation -eq "550ff19c-b7e8-7068-88c9-51917c1757cd"} | select Area, Category, Level, EventID, Message | Format-Lis

Takes for ever to finish and provide details of error message

Merge-SPLogFile -Path .\error.log -Correlation '550ff19c-b7e8-7068-88c9-51917c1757cd'

Takes relatively shorter time

Cheers!
Sanjay

Open sub report in new window from SSRS – SharePoint integrated mode

For the textbox field in SSRS Tablix set an action to go to URL with following Expression:

javascript:void(window.open(‘” & Globals!ReportServerUrl &“/Pages/ReportViewer.aspx?” & Globals!ReportFolder & “/PO_Lines.rdl&rc:Parameters=False&PONumber=”& Fields!PO_NUMBER.Value & “‘))

Where:

  1. PO_Lines.rdl is the sub report name
  2. PONumber is the Sub report parameter
  3. PO_NUMBER.Value is the main report field containing value for the sub report parameter.

Cheers!
Sanjay