Workflow Manager Issues


A few days back, caught something on Workflow manager configuration issue. Workflow Manager has no interlocking with SharePoint and it is entirely independent entity. The script is pretty straight forward. However, after execution the script, following error was generated and seems like Workflow Manager was not able to get installed on VM.
New-SBFarm : The term 'New-SBFarm' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify
that the path is correct and try
again.
At line:38 char:9
+ New-SBFarm -SBFarmDBConnectionString $managementCS -InternalPortRangeSta ...
+ ~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (New-SBFarm:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
New-WFFarm : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change
the alias to a valid name.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a
valid name.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a
valid name.
At line:53 char:9
+ New-WFFarm -WFFarmDBConnectionString $wfManagementCS -RunAsAccount $spSe ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (Data Source=php...e;Encrypt=False:String) [New-WFFarm], SqlException
+ FullyQualifiedErrorId : FailedToDeploySchemaToDatabase,Microsoft.Workflow.Deployment.Commands.NewWFFarm
- Adding Service Bus host...Already Exists
- Creating Workflow Default Namespace...New-SBNamespace : The term 'New-SBNamespace' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was i
ncluded, verify that the path is
correct and try again.
At line:78 char:13
+ New-SBNamespace -Name $sbNamespace -AddressingScheme 'Path' -ManageU ...
+ ~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (New-SBNamespace:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
Get-SBClientConfiguration : The term 'Get-SBClientConfiguration' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify
that the path is correct and try again.
At line:87 char:30
+ $SBClientConfiguration = Get-SBClientConfiguration -Namespaces $sbNamespace;
+ ~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Get-SBClientConfiguration:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
- Adding Workflow Host...Done

Even for the small correction, which was fixed and rerun the script not helped here. Following the script who are interested on using PowerShell.
function WFM-Configure {
#webpicmd /offline /Products:WorkflowManagerRefresh /Path:c:WorkflowManagerFiles
#WebpiCmd.exe /Install /Products:WorkflowManagerRefresh /XML:c:/WorkflowManagerFiles/feeds/latest/webproductlist.xml
cd "F:\DeveloperTools\bin\"
start-process wpilauncher.exe
cd "C:\Program Files\Microsoft\Web Platform Installer\"
WebpiCmd-x64.exe '/Install' '/Products:RequestFiltering,ServiceBus_1_1,ServiceBus_1_1_CU1,URLRewrite2,WDeploy,WorkflowManagerRefresh' '/SuppressPostFinish' '/SuppressReboot' '/AcceptEula'
cd "C:\Program Files\Microsoft\Web Platform Installer\"
start-process WebPlatformInstaller.exe '/passive' | Stop-Process
#cd "F:\DeveloperTools\bin\"
#WebpiCmd.exe /Install /Products:WorkflowManagerRefresh /XML:c:/WorkflowManagerFiles/feeds/latest/webproductlist.xml
WebpiCmd.exe /Install /Products:WorkflowManagerRefresh
#common variables Region starts
$dbServer = "phpdxspsql01"
$dbPrefix = "SP02Test3"
$spServiceAcctName = "AppWFM\svc_sp_sb_Install"
$spServiceAcctPWD = "w0k&R0ll"
$spAdminAcct = " AppWFM \svc_sp_sb_farm"
$passphrase = "Svc-sp-sb-Passphrase"
#common variables Region ends
#addingPS Snapin
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
}
set-executionpolicy -executionpolicy unrestricted
# Create new SB Farm
$SBCertificateAutoGenerationKey = ConvertTo-SecureString -AsPlainText -Force -String $passphrase;
$WFCertAutoGenerationKey = ConvertTo-SecureString -AsPlainText -Force -String $passphrase;
$managementCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFMSB_Management;Integrated Security=True;Encrypt=False';
$gatewayCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFMSB_Gateway;Integrated Security=True;Encrypt=False';
$messageContCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFMSB_MessageContainer;Integrated Security=True;Encrypt=False';
Write-Host -ForegroundColor White ' - Creating new Service Bus farm...' -NoNewline;
try {
$sbFarm = Get-SBFarm -SBFarmDBConnectionString $managementCS;
Write-Host -ForegroundColor White 'Already Exists';
}
catch {
New-SBFarm -SBFarmDBConnectionString $managementCS -InternalPortRangeStart 9000 -TcpPort 9354 -MessageBrokerPort 9356 -RunAsAccount $spServiceAcctName `
-AdminGroup 'BUILTINAdministrators' -GatewayDBConnectionString $gatewayCS -CertificateAutoGenerationKey $SBCertificateAutoGenerationKey `
-MessageContainerDBConnectionString $messageContCS;
Write-Host -ForegroundColor White 'Done';
}
# Create new WF Farm
#Write-Host -ForegroundColor white " - Creating new Workflow Farm..." -NoNewline;
$wfManagementCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFM_Management;Integrated Security=True;Encrypt=False';
$wfInstanceCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFM_InstanceManagement;Integrated Security=True;Encrypt=False';
$wfResourceCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFM_ResourceManagement;Integrated Security=True;Encrypt=False';
try {
$wfFarm = Get-WFFarm -WFFarmDBConnectionString $wfManagementCS;
Write-Host -ForegroundColor White 'Already Exists';
}
catch {
New-WFFarm -WFFarmDBConnectionString $wfManagementCS -RunAsAccount $spServiceAcctName -AdminGroup 'BUILTINAdministrators' -HttpsPort 12290 -HttpPort 12291 `
-InstanceDBConnectionString $wfInstanceCS -ResourceDBConnectionString $wfResourceCS -CertificateAutoGenerationKey $WFCertAutoGenerationKey;
Write-Host -ForegroundColor white 'Done';
}
# Add SB Host
Write-Host -ForegroundColor white ' - Adding Service Bus host...' -NoNewline;
try {
$SBRunAsPassword = ConvertTo-SecureString -AsPlainText -Force -String $spServiceAcctPwd;
Add-SBHost -SBFarmDBConnectionString $managementCS -RunAsPassword $SBRunAsPassword -EnableHttpPort `
-EnableFirewallRules $true -CertificateAutoGenerationKey $SBCertificateAutoGenerationKey;
Write-Host -ForegroundColor white 'Done';
}
catch {
Write-Host -ForegroundColor white 'Already Exists';
}
Write-Host -ForegroundColor white ' - Creating Workflow Default Namespace...' -NoNewline;
$sbNamespace = $dbPrefix + '-WorkflowNamespace';
try {
$defaultNS = Get-SBNamespace -Name $sbNamespace -ErrorAction SilentlyContinue;
Write-Host -ForegroundColor white 'Already Exists';
}
catch {
try {
# Create new SB Namespace
$currentUser = $env:userdomain + '' + $env:username;
New-SBNamespace -Name $sbNamespace -AddressingScheme 'Path' -ManageUsers $spServiceAcctName,$spAdminAcctName,$currentUser;
Start-Sleep -s 90
Write-Host -ForegroundColor white 'Done';
}
catch [system.InvalidOperationException] {
throw;
}
}
# Get SB Client Configuration
$SBClientConfiguration = Get-SBClientConfiguration -Namespaces $sbNamespace;
# Add WF Host
try {
$WFRunAsPassword = ConvertTo-SecureString -AsPlainText -Force -String $spServiceAcctPwd;
Write-Host -ForegroundColor White ' - Adding Workflow Host...' -NoNewline;
Add-WFHost -WFFarmDBConnectionString $wfManagementCS `
-RunAsPassword $WFRunAsPassword -EnableFirewallRules $true `
-SBClientConfiguration $SBClientConfiguration -CertificateAutoGenerationKey $WFCertAutoGenerationKey;
Write-Host -ForegroundColor White 'Done';
}
catch {
#Write-Host -ForegroundColor white "Already Exists";
Write-Host -ForegroundColor white 'Done';
}
#$siteUri = ""
#$credential = [System.Net.CredentialCache]::DefaultNetworkCredentials
#$site = Get-SPSite $siteUri
#$proxy = Get-SPWorkflowServiceApplicationProxy
#$svcAddress = $proxy.GetWorkflowServiceAddress($site)
#Copy-SPActivitiesToWorkflowService -WorkflowServiceAddress $svcAddress -Credential $credential -Force $true
}


The resolution was really greyed to me. I agreed as this was my first experience to play with Workflow Manager and I’m not sure the actual root cause. Anyway, after removing everything and trying on another VM by installing the Web Platform Installer  first. Next, download the files using it and simply install and configure Workflow Manager. Looks like it went successfully. Sharing this info, if anyone facing similar issues, could try on the above path.

Comments

Post a Comment

Popular posts from this blog

How to fix Azure DevOps error MSB4126

Image
Setting up build and release pipeline always tedious and we face many build related issues. Here is one common error I face couple of times while setting app Web or windows apps in Azure DevOps After placing the code in repos, and creating the build pipeline and run it, you can face the following error ##[error]D:\a\8\s\<your solution file>.sln.metaproj(0,0): Error MSB4126: The specified solution configuration "release|$(BuildPlatform)" is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those properties blank to use the default solution configuration. To understand what is target platform defined in your project you need to visit or open the solution(.sln) file and review the following sections. In my case, this has been defined as x86 as target platform.                   GlobalSecti
Read more

SharePoint Admin Center

Image
 SharePoint Admin Center allows you to view your organization's SharePoint site including communication sites, channel sites, and sites that belong to Microsoft 365 group. This is same like Site Admin in earlier days of SharePoint versions. You can search organizational site, sort them or filter sites the way you want. Easy way to find and apply/change site settings. Under Policies, click on Sharing - This will allow you to create rules/ set control sharing at the organization level in SharePoint and OneDrive Here, in this page, you can apply settings to restrict how users are allowed to access content in SharePoint and OneDrive. Term store, the word getting populated from SharePoint 2010. You can feed metadata of metadata information of your organization level, program level, project level in Term store. helps your organization's knowledge better.  AI soon will play a vital role here and using AI, you can acyually find collect and process and finally yoour organization's d
Read more

How to create Custom Visuals in Power BI – Initial few Steps

Image
This post will help you to know the steps to create custom visuals in PowerBI. Microsoft defined them as well at https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools . First things first, and you need to download and install NodeJS , in case if you do not have npm setup in your machine.  Second step is to run couple of npm commands to install Power BI Visual Tools and create & publish the cert. Finally, create your own package and upload with the help of npm. 1.       npm install -g powerbi-visuals-tools 2.       pbiviz --create-cert pbiviz --install-cert 3.       pbiviz new My Visual name – This will create the file under the name of your visual file. 4.      pbiviz start – You need to go to the folder where your custom visual  resides, and run this command. You can change a few things in your pbiviz.json file, like author, display name, icon, style etc. Finally, package your
Read more