none
Not able to configure BDC (Business Data connectivity )service in SharePoint 2013 Using Powershell Script RRS feed

  • General discussion

  • HI

    Now there is an  issue while iam running powershell script for BDC service.

    Below is the script i am using to configure BDC service.

    Param(           
        [Parameter(Mandatory=$true,ValueFromPipeline=$true)]           
        [string]$ServiceName = $null,
        [Parameter(Mandatory=$true)]           
        [string]$ServiceProxyName = $null,
        [Parameter(Mandatory=$true)]           
        [string]$AppPoolAccount = $null,
        [Parameter(Mandatory=$true)]           
        [string]$AppPoolName = $null,
        [Parameter(Mandatory=$true)]           
        [string]$DatabaseServer = $null,
        [Parameter(Mandatory=$true)]           
        [string]$DatabaseName = $null
              )

    # check to ensure Microsoft.SharePoint.PowerShell is loaded if not using the SharePoint Management Shell
    $snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'}
    if ($snapin -eq $null) {
        Write-Host "Loading SharePoint Powershell Snapin"
        Add-PSSnapin "Microsoft.SharePoint.Powershell"
    }
    Write-Host "Successfully Sharepoint Powershell snapin Loaded"
    Write-Host "Started executing Powershell script for configuring Business Data Connectivity Service in sharepoint farm ..."


    Write-Host -ForegroundColor Yellow "Checking if Application Pool Accounts exists"
    $AppPoolAccount = Get-SPManagedAccount -Identity $AppPoolAccount -EA 0
    if($AppPoolAccount -eq $null)
    {
    Write-Host "Please supply the password for the Service Account..."
    $AppPoolCred = Get-Credential $AppPoolAccount
    $AppPoolAccount = New-SPManagedAccount -Credential $AppPoolCred -EA 0
    }

    Write-Host -ForegroundColor Yellow "Checking wether the Application Pool exists"
    $AppPool = Get-SPServiceApplicationPool -Identity $AppPoolName -ErrorAction SilentlyContinue

    if (!$AppPool)
    {
    Write-Host -ForegroundColor Green "Creating Application Pool"
    $AppPool = New-SPServiceApplicationPool -Name $AppPoolName -Account $AppPoolAccount -Verbose
    }

    Write-Host -ForegroundColor Yellow "Checking if BDC Service Application exists"
    $ServiceApplication = Get-SPServiceApplication -Name $ServiceName -ErrorAction SilentlyContinue
    if (!$ServiceApplication)
    {
    Write-Host -ForegroundColor Green "Creating BDC Service Application"
    $ServiceApplication = New-SPBusinessDataCatalogServiceApplication –ApplicationPool $AppPool –DatabaseName $DatabaseName –DatabaseServer $DatabaseServer –Name $ServiceName
    }

    Write-Host -ForegroundColor Yellow "Starting the BDC Service"
    #$ServiceInstance = Get-SPServiceInstance | Where-Object { $_.TypeName -like "BDC Service*" }
    #Start-SPServiceInstance $ServiceInstance
    Get-SPServiceInstance | where-object {$_.DisplayName -eq $ServiceName} | Start-SPServiceInstance > $null
    Write-Host -ForegroundColor Green "Done - BDC Service is up and running."

    Error i am getting ->

    Started executing Powershell script for configuring Business Data Connectivity S
    ervice in sharepoint farm ...
    Checking if Application Pool Accounts exists
    Checking wether the Application Pool exists
    Creating Application Pool
    VERBOSE: Leaving BeginProcessing Method of New-SPServiceApplicationPool.
    New-SPServiceApplicationPool : The trust relationship between the primary
    domain and the trusted domain failed.
    At C:\SP2013Service\BDC1.ps1:67 char:12
    + $AppPool = New-SPServiceApplicationPool -Name $AppPoolName -Account
    $AppPoolAcco ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ~~~
        + CategoryInfo          : InvalidData: (Microsoft.Share...ApplicationPool:
       SPCmdletNewIisWebServiceApplicationPool) [New-SPServiceApplicationPool], S 
      ystemException
        + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewIisWe
       bServiceApplicationPool
     
    VERBOSE: Leaving ProcessRecord Method of New-SPServiceApplicationPool.
    VERBOSE: Leaving EndProcessing Method of New-SPServiceApplicationPool.
    Checking if BDC Service Application exists
    Creating BDC Service Application
    New-SPBusinessDataCatalogServiceApplication : Cannot bind argument to
    parameter 'ApplicationPool' because it is null.
    At C:\SP2013Service\BDC1.ps1:75 char:84
    + ... pplicationPool $AppPool –DatabaseName $DatabaseName –DatabaseServer
    $DatabaseSer ...
    +                    ~~~~~~~~
        + CategoryInfo          : InvalidData: (:) [New-SPBusinessD...viceApplicat
       ion], ParameterBindingValidationException
        + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,M
       icrosoft.SharePoint.BusinessData.SharedService.SPNewBusinessDataCatalogSer 
      viceApplication
     


    Wednesday, December 17, 2014 11:13 AM

All replies

  • hi guys,

    same script i have modified with parametes,in below script i have hard corded values for parameters,and it is executing without errors.

    Below is script executing without error->

    Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

    #Settings
    $ServiceName = "BDC Service"
    $ServiceProxyName = "BDC Proxy"
    $AppPoolAccount = "DOMAIN\USERNAME"
    $AppPoolName = "BDC SP Ser App Pool"
    $DatabaseServer = "SPSQL"
    $DatabaseName = "SP2013 BDC"

    Write-Host -ForegroundColor Yellow "Checking if Application Pool Accounts exists"
    $AppPoolAccount = Get-SPManagedAccount -Identity $AppPoolAccount -EA 0
    if($AppPoolAccount -eq $null)
    {
    Write-Host "Please supply the password for the Service Account..."
    $AppPoolCred = Get-Credential $AppPoolAccount
    $AppPoolAccount = New-SPManagedAccount -Credential $AppPoolCred -EA 0
    }

    Write-Host -ForegroundColor Yellow "Checking wether the Application Pool exists"
    $AppPool = Get-SPServiceApplicationPool -Identity $AppPoolName -ErrorAction SilentlyContinue

    if (!$AppPool)
    {
    Write-Host -ForegroundColor Green "Creating Application Pool"
    $AppPool = New-SPServiceApplicationPool -Name $AppPoolName -Account $AppPoolAccount -Verbose
    }

    Write-Host -ForegroundColor Yellow "Checking if BDC Service Application exists"
    $ServiceApplication = Get-SPServiceApplication -Name $ServiceName -ErrorAction SilentlyContinue
    if (!$ServiceApplication)
    {
    Write-Host -ForegroundColor Green "Creating BDC Service Application"
    $ServiceApplication = New-SPBusinessDataCatalogServiceApplication –ApplicationPool $AppPool –DatabaseName $DatabaseName –DatabaseServer $DatabaseServer –Name $ServiceName
    }

    Write-Host -ForegroundColor Yellow "Starting the BDC Service"
    #$ServiceInstance = Get-SPServiceInstance | Where-Object { $_.TypeName -like "BDC Service*" }
    #Start-SPServiceInstance $ServiceInstance
    Get-SPServiceInstance | where-object {$_.DisplayName -eq $ServiceName} | Start-SPServiceInstance > $null
    Write-Host -ForegroundColor Green "Done - BDC Service is up and running."

    if any body want need more information please can u respond me to

    Email id:katuris@hcl.com

    Wednesday, December 17, 2014 11:39 AM