Blog

Cross Domain Error in Dynamic GP 2013 Web Client

The cross domain error would be occurred on Silverlight. Because distinct URL has been configured on session central service, session service and run time service.

Severity: Critical
Summary: An error occurred while initializing communication with the server.
Details:
[CrossDomainError]
Arguments: https://marinerydynamics.cloudapp.net:48652/RuntimeService/3468
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.41212.00&File=System.ServiceModel.dll&Key=CrossDomainError

Scenario 01:
For example I have configured session central and session service with out SSL and runtime service with SLL, in my scenario looks like;
Here the service URL has been configured in same domain.

http://gpserver:48650/SessionCentralService (without SSL)
http://gpserver:48651/SessionService (without SSL)
https://webclient.sathiya.local:48652/ (SSL mandatory for GP web client Runtime service)

Scenario 01:
If suppose the web client is accessible thought internet and configured public url then the Runtime service will be configured like https://public.sathiya.io:48652/.
So the silver light wont communicate between cross domains.

http://gpserver:48650/SessionCentralService (Local url)
http://gpserver:48651/SessionService (Local url)
https://public.sathiya.io:48652/

Resolution:
So you have to configure all three service url should be in same domain. Either it would be local FQDN urls or public urls,
i.e)

https://webclient.sathiya.local:48650/SessionCentralService (without SSL)
https://webclient.sathiya.local:48651/SessionService (without SSL)
https://webclient.sathiya.local:48652/

(or)

https://public.sathiya.io:48650/SessionCentralService (Local url)
https://public.sathiya.io:48651/SessionService (Local url)
https://public.sathiya.io:48652/

Security issue may happen after installed this setup. To resolve Web client error with SSL/TLS
Cheers…!

February 19, 2016

Verifying SMTP SharePoint Outbound mail settings

Once we configured the SharePoint outbound mail server then our responsible to test the setup. Here the small powershell snippet will do!

### The script will return True or False
$toemail = “sathiya@sathiya.io”
$subject = “Test – SharePoint Outbound mail”
$body = “This mail for testing purpose…! Please ignore your action!”
$site = New-Object Microsoft.SharePoint.SPSite “http://sharepoint/”
$web = $site.OpenWeb()
[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$toemail,$subject,$body)

### The script will return True or False

$toemail = “sathiya@sathiya.io”

$subject = “Test – SharePoint Outbound mail”

$body = “This mail for testing purpose…! Please ignore your action!”

$site = New-Object Microsoft.SharePoint.SPSite “http://sharepoint/”

$web = $site.OpenWeb()

[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$toemail,$subject,$body)

If you get “True” the configuration perfectly alright, else you have to check the ULS log to find an issue. Suppose if you are not getting a mail you have to check smtp log or address to exchange/wintel team.

February 10, 2016

Analyse MS-SQL Database Memory Utilization

In most of the development environment or staging server will not be monitored by daily. So the database auto growth can occupy countlessly. Here, we can analyze the memory utilization about the table and we can remove if the database has cache, temp or logs table.

declare @t table (
name nvarchar(100), [rows] int, [reserved] nvarchar(100), [data] nvarchar(100), [index_size] nvarchar(100), [unused] nvarchar(100)
)
declare @name nvarchar(100)

declare tt cursor for
Select name from sys.tables
open tt

fetch next from tt into @name
while @@FETCH_STATUS = 0
begin
  insert into @t
  exec sp_spaceused @name
  fetch next from tt into @name
end

close tt
deallocate tt

select name as table_name, [rows] as rows_count, data + [index] as total_size, data as data_size, [index] as index_size
from (select name,
[rows],
cast (LEFT(data, LEN(data)-3) as int) data,
cast (LEFT(index_size, LEN(index_size)-3) as int) [index]
 from @t
) x
order by 3 desc, 1

declare @t table (

name nvarchar(100), [rows] int, [reserved] nvarchar(100), [data] nvarchar(100), [index_size] nvarchar(100), [unused] nvarchar(100)

)

declare @name nvarchar(100)

declare tt cursor for

Select name from sys.tables

open tt

fetch next from tt into @name

while @@FETCH_STATUS = 0

begin

insert into @t

exec sp_spaceused @name

fetch next from tt into @name

end

close tt

deallocate tt

select name as table_name, [rows] as rows_count, data + [index] as total_size, data as data_size, [index] as index_size

from (select name,

[rows],

cast (LEFT(data, LEN(data)-3) as int) data,

cast (LEFT(index_size, LEN(index_size)-3) as int) [index]

from @t

) x

order by 3 desc, 1

Cheers..!

November 6, 2015

Create claims-based web application from SharePoint PowerShell

Creating claims-based web application is more flexible with SharePoint PowerShell script than CA. Here, the snippet for http and ssl site.

Add-PSSnapin Microsoft.SharePoint.Powershell
$ap = New-SPAuthenticationProvider
New-SPWebApplication -Name <Name> -ApplicationPool <ApplicationPool> -ApplicationPoolAccount <ApplicationPoolAccount> -URL <URL> -Port <Port> -AuthenticationProvider $ap
# <Name> is the name of the new web application that uses claims-based authentication.
# <ApplicationPool> is the name of the application pool.
# <ApplicationPoolAccount> is the user account that this application pool will run as.
# <URL> is the public URL for this web application.
# <Port> is the port on which the web application will be created in IIS.

# For Non-SSL
New-SPWebApplication -Name “Web Portal – 80” -ApplicationPool “Web Portal Application Pool – 80” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL http://webportal.sathiya.com -Port 80 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_80 -Path “D:\Web_Portal_80” -AuthenticationProvider $ap 

# For SSL 
New-SPWebApplication -Name “Web Portal – 443” -ApplicationPool “Web Portal Application Pool – 443” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL https://webportal.sathiya.com -Port 443 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_443 -Path “D:\Web_Portal_443” -SecureSocketsLayer -AuthenticationProvider $ap

Add-PSSnapin Microsoft.SharePoint.Powershell

$ap = New-SPAuthenticationProvider

New-SPWebApplication -Name <Name> -ApplicationPool <ApplicationPool> -ApplicationPoolAccount <ApplicationPoolAccount> -URL <URL> -Port <Port> -AuthenticationProvider $ap

# <Name> is the name of the new web application that uses claims-based authentication.

# <ApplicationPool> is the name of the application pool.

# <ApplicationPoolAccount> is the user account that this application pool will run as.

# <URL> is the public URL for this web application.

# <Port> is the port on which the web application will be created in IIS.

# For Non-SSL

New-SPWebApplication -Name “Web Portal – 80” -ApplicationPool “Web Portal Application Pool – 80” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL http://webportal.sathiya.com -Port 80 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_80 -Path “D:\Web_Portal_80” -AuthenticationProvider $ap

# For SSL

New-SPWebApplication -Name “Web Portal – 443” -ApplicationPool “Web Portal Application Pool – 443” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL https://webportal.sathiya.com -Port 443 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_443 -Path “D:\Web_Portal_443” -SecureSocketsLayer -AuthenticationProvider $ap

Cheers…!

October 23, 2015

Delete SharePoint list items from PowerShell

Here the quick solution to clean up/delete SharePoint list items that save a days lot if cleanup required. Manual efforts would take a lot so prefer to go with scripts;

# Enter the site URL instead http://sathiya.io
$weburl = “http://sathiya.io”
$site = new-object Microsoft.SharePoint.SPSite ($weburl)
$web = $site.OpenWeb()
Write-Host “The Web application is : “$web.Title
# Enter name of the List below insted of ProjectList
$oList = $web.Lists[“ProjectList”];
$collListItems = $oList.Items;
$count = $collListItems.Count – 1
$itemCount = $contents.Count;
$currentItem = 1;
Write-Output -NoNewline “Are you sure you want to permanently delete the ‘$oList.ItemCount’ item from the list ‘$oList.Title’ (y/n)? ” -NoNewline;
$con = Read-Host;
if ($con -eq “y”) {
    for($intIndex = $count; $intIndex -gt -1; $intIndex–)
    {
        #Deleting the item from list
        “Deleting record: ” + $intIndex
        $collListItems.Delete($intIndex);
    }
    Write-Host $itemCount “item has been deleted from the list ‘”$oList.Title “‘…!” -ForegroundColor Yellow;
}
else {
    Write-Host “No changes are happened in the list'”$oList.Title “‘…!” -ForegroundColor Black -BackgroundColor Green;
}
#Close the connection
$web.Dispose()

# Enter the site URL instead http://sathiya.io

$weburl = “http://sathiya.io”

$site = new-object Microsoft.SharePoint.SPSite ($weburl)

$web = $site.OpenWeb()

Write-Host “The Web application is : “$web.Title

# Enter name of the List below insted of ProjectList

$oList = $web.Lists[“ProjectList”];

$collListItems = $oList.Items;

$count = $collListItems.Count – 1

$itemCount = $contents.Count;

$currentItem = 1;

Write-Output -NoNewline “Are you sure you want to permanently delete the ‘$oList.ItemCount’ item from the list ‘$oList.Title’ (y/n)? “ -NoNewline;

$con = Read-Host;

if ($con -eq “y”) {

for($intIndex = $count; $intIndex -gt -1; $intIndex—)

{

#Deleting the item from list

“Deleting record: “ + $intIndex

$collListItems.Delete($intIndex);

}

Write-Host $itemCount “item has been deleted from the list ‘”$oList.Title “‘…!” -ForegroundColor Yellow;

}

else {

Write-Host “No changes are happened in the list'”$oList.Title “‘…!” -ForegroundColor Black -BackgroundColor Green;

}

#Close the connection

$web.Dispose()

Cheers…!

September 24, 2015

Export Windows Service to Excel with Filter

Another sample Powershell script to exporting “Running” and “Stopped” windows service to excel by using Powershell Array.

$location = “C:\sathiya.io”;
$service = @(“Running”, “Stopped”);
for ($i=0;$i -ne 2;$i++)
{
	$text = $service[$i];
	#Exporting the result to the text file
	# Append – This keyword is to update the file in the loop
	# Select – To export the field that you want to export
	Get-Service |?{$_.Status -eq “running”} | Select ServiceName, Status | Out-File $location\text1.txt -Append
	#Exporting the result to CSV
	Get-Service |?{$_.Status -eq $text} |  Select ServiceName, Status | export-csv $location\file2.csv -Append
}

$location = “C:\sathiya.io”;

$service = @(“Running”, “Stopped”);

for ($i=0;$i -ne 2;$i++)

{

$text = $service[$i];

#Exporting the result to the text file

# Append – This keyword is to update the file in the loop

# Select – To export the field that you want to export

Get-Service |?{$_.Status -eq “running”} | Select ServiceName, Status | Out-File $location\text1.txt -Append

#Exporting the result to CSV

Get-Service |?{$_.Status -eq $text} | Select ServiceName, Status | export-csv $location\file2.csv -Append

}

Cheers!

September 21, 2015

Creating Managed Metadata Service Application by Powershell Script

As we are all knows, the SharePoint Powershell can be fast and simple. Here the sample script for creating Managed Metadata Service Application;

New-SPServiceApplicationPool -Name “Managed Metadata Service App Pool” -Account sathiya\SPAppPool
New-SPMetadataServiceApplication -Name “Managed Metadata Service Application” -ApplicationPool “Managed Metadata Service App Pool” -DatabaseName “MMD”
New-SPMetadataServiceApplicationProxy -Name “Managed Metadata Service App Pool” -ServiceApplication “Managed Metadata Service Application”

New-SPServiceApplicationPool -Name “Managed Metadata Service App Pool” -Account sathiya\SPAppPool

New-SPMetadataServiceApplication -Name “Managed Metadata Service Application” -ApplicationPool “Managed Metadata Service App Pool” -DatabaseName “MMD”

New-SPMetadataServiceApplicationProxy -Name “Managed Metadata Service App Pool” -ServiceApplication “Managed Metadata Service Application”

Cheers!

September 15, 2015

SharePoint continuous user login prompting with custom host header site

SharePoint site with custom host header will prompting the user login screen on local machine but either you can login or view the site from your local network machines. Because the loop back is enabled by default on each and every machine. To resolve the issue you have to disable it.

Open PowerShell as administrator privilege and run the below script;

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name “DisableLoopbackCheck” -Value “1” -PropertyType dword

1

New–ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa –Name “DisableLoopbackCheck” –Value “1” –PropertyType dword

I hope the things are going good :)Cheers!

July 22, 2015

Import Users in Active Directory Using PowerShell

Today, we are going to discuss about importing bulk users in Active Directory using PowerShell. We are all knows that we can do anything in PowerShell.
You can check the required parameter for adding AD user. But I’m going to import the below sample fields.

Basic Comment
New-ADUser
-Name “Disply Name”
-GivenName “First Name”
-Surname “Last Name”
-SamAccountName “UserName”
-UserPrincipalName “username@sathiya.io”
-Path “OU=OrganizationUnit,DC=sathiya,DC=io”
-Enabled $true
-PasswordNeverExpires $true
-AccountPassword (ConvertTo-SecureString “password” -AsPlainText -force)
-PassThru

The above script is for adding single user.

Script

Import-Module ActiveDirectory
Import-Module ActiveDirectory
Import-Csv .\ImportUser.csv | foreach-object { 
New-ADUser -Name $_.Name -GivenName $_.gn -Surname $_.sn -SamAccountName $_.samAcc -UserPrincipalName $_.UPN -Path $_.Path -Enabled $true -PasswordNeverExpires $true -AccountPassword (ConvertTo-SecureString $_.AccPass -AsPlainText -force) -PassThru
}

Import–Module ActiveDirectory

Import–Csv .\ImportUser.csv | foreach–object {

New–ADUser –Name $_.Name –GivenName $_.gn –Surname $_.sn –SamAccountName $_.samAcc –UserPrincipalName $_.UPN –Path $_.Path –Enabled $true –PasswordNeverExpires $true –AccountPassword (ConvertTo–SecureString $_.AccPass –AsPlainText –force) –PassThru

}

Sample CSV file ImportUser.csv

I hope the things are going good :)Cheers!

June 11, 2015

Application error when access “/_layouts/15/workflow.aspx”

After, I installed and configured the workflow for SharePoint 2013 and register to the web application, it was getting an error while starting the workflow as;
Error:
Message: Application error when access /_layouts/15/workflow.aspx, Error=The pipe endpoint ‘net.pipe://localhost/SecurityTokenServiceApplication/appsts.svc’ could not be found on your local machine.
EventID: 8nca
Solution:
Make sure the Net.Pipe Listener Adapter windows service is running, if not run net start NetPipeActivator. I hope this helps.

April 29, 2015