Workflow installation error on windows 2012 R2 using Web plateform 5.1

muhammad masood 66 Reputation points
2022-02-15T09:23:50.043+00:00

I am trying to configure Workflow Manager with SharePoint 2013 on a Windows 2012 Server R2. I am following article https://social.technet.microsoft.com/wiki/contents/articles/31477.installing-workflow-manager-offline.aspx?wa=wsignin1.0. When I try to download Service Bus 1.0 then I get following error.

Some operations failed, see the detailed error messages for more information:
Download of product 'ServiceBus failed. Downloaded file failed signature verification and may have been tampered with
To use the new offline feed, please run the following from the command line:

Same is the result, when I try installing it using a server with internet access.

When I install Workflow Manager Refresh (CU2) using online installer then Service bus 1.1 (not service bus 1.0) is installed successfully. When I rung Configuration wizard then following error occurs.

[Error] [2/15/2022 1:44:15 PM]: System.Management.Automation.CmdletInvocationException: 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. ---> System.Data.SqlClient.SqlException: 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 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) at Microsoft.ServiceBus.Commands.Common.ServerManagementStoreDataContext.CreateServerOperatorLogin(String loginName) at Microsoft.ServiceBus.Commands.Common.ManagementDbContext.CreateServerOperatorLogin(String loginName) at Microsoft.ServiceBus.Commands.Common.SecurityHelper.CreateServerOperatorRole(String accountName, String connectionString) at Microsoft.ServiceBus.Commands.NewSBFarmBase.InstallManagementDB(String connectionString) at Microsoft.ServiceBus.Commands.NewSBFarmBase.ProcessRecordImplementation() --- End of inner exception stack trace --- at System.Management.Automation.PowerShell.EndInvoke(IAsyncResult asyncResult) at Microsoft.Workflow.Deployment.ConfigWizard.CommandletHelper.InvokePowershell(Command command, Action3 updateProgress)
at Microsoft.Workflow.Deployment.ConfigWizard.ProgressPageViewModel.CreateSBFarm(FarmCreationModel model)

Then installed CU5 for workflow manager 1.0 but the result is same. Any help in this regard will be a blessing for me. Thanks and Regards,

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,178 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
510 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,194 questions
0 comments
Accepted answer
  1. Yi Lu_MSFT 17,456 Reputation points
    2022-02-16T06:40:53.413+00:00

    Hi @muhammad masood
    According to the error: System.Management.Automation.CmdletInvocationException: 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. The issue apparently was naming convention that you used for the for the user account workflow manager configuration.

    If you used useraccount@AD instead of useraccount @**.com, then all worked fine. Or it may be due to the language of the SQL Server, I find a case here:
    http://blog.pre-system.de/2017/10/21/error-message-installing-workflow-manager-and-service-bus/

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest