Hello,

i cannot setup the Workflow Manager 1.0 - Service Bus Farm Component on my 2012 Server where sharepoint 2013 is installed.

Within my test Environment, anything went smooth, but on Production, it wont work.

http://tinypic.com/r/27zaddl/5

i am logged in as domain admin / sharepoint admin,

want to user a domain user account who also runs the mssql instances (mssql@)

i already installed ServiceBus-KB2799752-x64-EN

http://support.microsoft.com/kb/2799752

i already put my domain admin account and said mssql@ User Account under "wellknownobject" cn=users

http://social.msdn.microsoft.com/Forums/windowsazure/en-US/3d803e15-606a-4f06-96fe-97c23ad3c01a/service-bus-for-windows-server-throws-exception-on-farm-configuration-wizard-and-powershell?forum=servbus

sadly, my sql Server is in german, so i got german error codes (wtf?) it would translate to:

An object or column name is missing or empty. For SELECT INTO statements, verify that 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.

on the Database Server, i see the DB being created, put into "single user mode" if i am not mistaken, and it vanishes afterwards again.

Can the SQL Server be too old ? Its Microsoft Windows Server 2008 R2 Standard Service Pack 1, 10.50.2550.0 (2008 R2 SP1 + MS12-070 Fix (KB 2716440)) Standard Edition

thanks

oh , and the error you see within the wizard window, came up only after i installed message bus kb .. before, it was another error

here some "translated" content of the powershell from the image:

PS C:\Program Files\Workflow Manager\1.0> $SBCertificateAutoGenerationKey = Conv
ertTo-SecureString -AsPlainText  -Force  -String '12345678abcABC' -Verbose;
PS C:\Program Files\Workflow Manager\1.0> New-SBFarm -SBFarmDBConnectionString '
Data Source=mssql1.xxxxxxxxde;Initial Catalog=SbManagementDB;Integrated S
ecurity=True;Encrypt=False' -InternalPortRangeStart 9000 -TcpPort 9354 -MessageB
rokerPort 9356 -RunAsAccount 'mssql@xxxxxxx' -AdminGroup 'BUILTIN\Administrators
' -GatewayDBConnectionString 'Data Source=mssql1.xxxxxxxxx.de;Initial Catal
og=SbGatewayDatabase;Integrated Security=True;Encrypt=False' -CertificateAutoGen
erationKey $SBCertificateAutoGenerationKey -MessageContainerDBConnectionString '
Data Source=mssql1.xxxxxxxx.de;Initial Catalog=SBMessageContainer01;Integr
ated Security=True;Encrypt=False' -Verbose;
New-SBFarm : An object or column name is missing or empty. For SELECT INTO statements, verify that 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 that 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 that 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:1 char:1
+ New-SBFarm -SBFarmDBConnectionString 'Data
Source=mssql1.xxxxxxxx.de;Initi ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
    + CategoryInfo          : NotSpecified: (Data Source=mss...e;Encrypt=False
   :String) [New-SBFarm], SqlException
    + FullyQualifiedErrorId : FailedToDeploySchemaToDatabase,Microsoft.Service
   Bus.Commands.NewSBFarm

• Edited by germansche 2 hours 42 minutes ago

oh , and the error you see within the wizard window, came up only after i installed message bus kb .. before, it was another error

here some "translated" content of the powershell from the image:

PS C:\Program Files\Workflow Manager\1.0> $SBCertificateAutoGenerationKey = Conv
ertTo-SecureString -AsPlainText  -Force  -String '12345678abcABC' -Verbose;
PS C:\Program Files\Workflow Manager\1.0> New-SBFarm -SBFarmDBConnectionString '
Data Source=mssql1.xxxxxxxxde;Initial Catalog=SbManagementDB;Integrated S
ecurity=True;Encrypt=False' -InternalPortRangeStart 9000 -TcpPort 9354 -MessageB
rokerPort 9356 -RunAsAccount 'mssql@xxxxxxx' -AdminGroup 'BUILTIN\Administrators
' -GatewayDBConnectionString 'Data Source=mssql1.xxxxxxxxx.de;Initial Catal
og=SbGatewayDatabase;Integrated Security=True;Encrypt=False' -CertificateAutoGen
erationKey $SBCertificateAutoGenerationKey -MessageContainerDBConnectionString '
Data Source=mssql1.xxxxxxxx.de;Initial Catalog=SBMessageContainer01;Integr
ated Security=True;Encrypt=False' -Verbose;
New-SBFarm : An object or column name is missing or empty. For SELECT INTO statements, verify that 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 that 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 that 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:1 char:1
+ New-SBFarm -SBFarmDBConnectionString 'Data
Source=mssql1.xxxxxxxx.de;Initi ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
    + CategoryInfo          : NotSpecified: (Data Source=mss...e;Encrypt=False
   :String) [New-SBFarm], SqlException
    + FullyQualifiedErrorId : FailedToDeploySchemaToDatabase,Microsoft.Service
   Bus.Commands.NewSBFarm

• Edited by germansche Friday, December 20, 2013 9:20 AM

oh , and the error you see within the wizard window, came up only after i installed message bus kb .. before, it was another error

here some "translated" content of the powershell from the image:

PS C:\Program Files\Workflow Manager\1.0> $SBCertificateAutoGenerationKey = Conv
ertTo-SecureString -AsPlainText  -Force  -String '12345678abcABC' -Verbose;
PS C:\Program Files\Workflow Manager\1.0> New-SBFarm -SBFarmDBConnectionString '
Data Source=mssql1.xxxxxxxxde;Initial Catalog=SbManagementDB;Integrated S
ecurity=True;Encrypt=False' -InternalPortRangeStart 9000 -TcpPort 9354 -MessageB
rokerPort 9356 -RunAsAccount 'mssql@xxxxxxx' -AdminGroup 'BUILTIN\Administrators
' -GatewayDBConnectionString 'Data Source=mssql1.xxxxxxxxx.de;Initial Catal
og=SbGatewayDatabase;Integrated Security=True;Encrypt=False' -CertificateAutoGen
erationKey $SBCertificateAutoGenerationKey -MessageContainerDBConnectionString '
Data Source=mssql1.xxxxxxxx.de;Initial Catalog=SBMessageContainer01;Integr
ated Security=True;Encrypt=False' -Verbose;
New-SBFarm : An object or column name is missing or empty. For SELECT INTO statements, verify that 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 that 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 that 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:1 char:1
+ New-SBFarm -SBFarmDBConnectionString 'Data
Source=mssql1.xxxxxxxx.de;Initi ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
    + CategoryInfo          : NotSpecified: (Data Source=mss...e;Encrypt=False
   :String) [New-SBFarm], SqlException
    + FullyQualifiedErrorId : FailedToDeploySchemaToDatabase,Microsoft.Service
   Bus.Commands.NewSBFarm

• Edited by germansche Friday, December 20, 2013 9:20 AM

Hi ,

Here is a similar post with same error message, please try uninstalling the updates to the Workflow manager and check results, or change the sequence of installation, and then see if it could work.

http://social.technet.microsoft.com/Forums/sharepoint/en-US/0a730b57-d952-4db8-8275-1f73996265d1/configuration-operation-failedplease-drop-the-database-and-use-create-a-new-farm-again?forum=sharepointadmin

Thanks

Hello,

i just reinstalled anything, same Problem. With the update for Message Bus, the other error.

I just took another System, and installed from scratch, same Problems !brand new Install:

[Error] [30.12.2013 08:39:26]: System.Management.Automation.CmdletInvocationException: Ein Objekt- oder Spaltenname fehlt oder ist leer. berprfen Sie fr SELECT INTO-Anweisungen, ob jede Spalte einen Namen aufweist. Suchen Sie fr andere Anweisungen nach leeren Aliasnamen. Mit '' oder [] definierte Aliase sind nicht zulssig. ndern Sie den Alias in einen gltigen Namen.
Ein Objekt- oder Spaltenname fehlt oder ist leer. berprfen Sie fr SELECT INTO-Anweisungen, ob jede Spalte einen Namen aufweist. Suchen Sie fr andere Anweisungen nach leeren Aliasnamen. Mit '' oder [] definierte Aliase sind nicht zulssig. ndern Sie den Alias in einen gltigen Namen.
Ein Objekt- oder Spaltenname fehlt oder ist leer. berprfen Sie fr SELECT INTO-Anweisungen, ob jede Spalte einen Namen aufweist. Suchen Sie fr andere Anweisungen nach leeren Aliasnamen. Mit '' oder [] definierte Aliase sind nicht zulssig. ndern Sie den Alias in einen gltigen Namen. ---> System.Data.SqlClient.SqlException: Ein Objekt- oder Spaltenname fehlt oder ist leer. berprfen Sie fr SELECT INTO-Anweisungen, ob jede Spalte einen Namen aufweist. Suchen Sie fr andere Anweisungen nach leeren Aliasnamen. Mit '' oder [] definierte Aliase sind nicht zulssig. ndern Sie den Alias in einen gltigen Namen.
Ein Objekt- oder Spaltenname fehlt oder ist leer. berprfen Sie fr SELECT INTO-Anweisungen, ob jede Spalte einen Namen aufweist. Suchen Sie fr andere Anweisungen nach leeren Aliasnamen. Mit '' oder [] definierte Aliase sind nicht zulssig. ndern Sie den Alias in einen gltigen Namen.
Ein Objekt- oder Spaltenname fehlt oder ist leer. berprfen Sie fr SELECT INTO-Anweisungen, ob jede Spalte einen Namen aufweist. Suchen Sie fr andere Anweisungen nach leeren Aliasnamen. Mit '' oder [] definierte Aliase sind nicht zulssig. ndern Sie den Alias in einen gltigen Namen.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 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.CreateServerAdministratorLogin(String loginName)
   at Microsoft.ServiceBus.Commands.Common.SecurityHelper.CreateServerAdministratorRole(String accountName, String connectionString)
   at Microsoft.ServiceBus.Commands.NewSBFarmBase.InstallManagementDB(String connectionString, String adminGroup, String runAsName)
   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, Action`3 updateProgress)
   at Microsoft.Workflow.Deployment.ConfigWizard.ProgressPageViewModel.CreateSBFarm(FarmCreationModel model)

then after message bus update:

[Error] [30.12.2013 08:44:26]: System.Management.Automation.CmdletInvocationException: Method not found: 'System.String Microsoft.ServiceBus.Commands.Common.SecurityHelper.CreateServerAdministratorRole(System.String, System.String)'. ---> System.MissingMethodException: Method not found: 'System.String Microsoft.ServiceBus.Commands.Common.SecurityHelper.CreateServerAdministratorRole(System.String, System.String)'.
   at Microsoft.ServiceBus.Commands.NewSBFarmBase.InstallManagementDB(String connectionString)
   at Microsoft.ServiceBus.Commands.NewSBFarmBase.ProcessRecordImplementation()
   at Microsoft.ServiceBus.Commands.ServiceBusBaseCmdlet.ProcessRecord()
   at System.Management.Automation.CommandProcessor.ProcessRecord()
   --- End of inner exception stack trace ---
   at System.Management.Automation.PowerShell.EndInvoke(IAsyncResult asyncResult)
   at Microsoft.Workflow.Deployment.ConfigWizard.CommandletHelper.InvokePowershell(Command command, Action`3 updateProgress)
   at Microsoft.Workflow.Deployment.ConfigWizard.ProgressPageViewModel.CreateSBFarm(FarmCreationModel model)

i am really lost here !

edit: we updated the SQL Server to a supported Service Pack in the meantime

• Edited by germansche 4 hours 16 minutes ago

after installing KB2799754 (cumulative update for workflow manager 1.0) , the "new " error "Method not found: 'System.String .."  is gone and its again the old error. "An object or column name is missing or empty. For SELECT INTO statements, verify that 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."

i checked event viewer and see now:

Faulting application name: Fabric.exe, version: 1.0.960.0, time stamp: 0x50415e97
Faulting module name: Fabric.exe, version: 1.0.960.0, time stamp: 0x50415e97
Exception code: 0xc0000602
Fault offset: 0x00000000001d01e8
Faulting process id: 0x1848
Faulting application start time: 0x01cf0534cd6d1c1a
Faulting application path: C:\Program Files\Windows Fabric\bin\Fabric\Fabric.Code.1.0\Fabric.exe
Faulting module path: C:\Program Files\Windows Fabric\bin\Fabric\Fabric.Code.1.0\Fabric.exe
Report Id: 0b346be7-7128-11e3-93f8-005056daefee
Faulting package full name:
Faulting package-relative application ID:

gonna 'bing this now

Hi germansche,

Did this issue happen after you install the Workflow manager 1.0 web platform installer file and run the configuration wizard?

The old error "An object or column name is missing or empty. For SELECT INTO statements, verify that 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.", seems still needs kb 2799752 to solve, please try installing this kb again.

And also check the following article see if it helps to resolve similar error.

http://davemcmahon81.wordpress.com/2013/10/03/method-not-found-system-string-microsoft-servicebus-commands-common-securityhelper-createserveradministratorrolesystem-string-system-string/

Thanks

Hello Daniel Yang,

yes i did use the web installer v 7.1.40719.0 , the kb2799752 is installed, i did reinstall it right now, no change.

however, i suppose the string not found error shouldn#t be focused here anymore, i think this error comes from a combination of having service bus cumulative update and not workflow manager cumulative update, and i have both now.

M$ must be kidding right ?

after a wireshark trace, i found the sql statements directly before the error(s)

setup is creating database entries for the "Admingroup" , wants to user "BUILTIN\Administrators" , but my sql Server OS is german, there is "VORDFEFINIERT\Administratoren" , so i changed the powershell line to this, was not working either because my english sharepoint Server OS wouldnt know it.

As soon as i chose -AdminGroup 'DOMAIN\DOMAIN admins'  it works ?

wtf are these sanity checks on the wrong system for ??????????????????

thanks for wasting 30hours time  MS , i am really upset