FATAL NServiceBus.GenericHost Exception when starting endpoint


(AK) #1
2018-10-12 12:17:53.753 FATAL NServiceBus.GenericHost Exception when starting endpoint.
NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.SubscriberEndpoint as Subscrib1_0_0_, this_.MessageType as MessageT2_0_0_, this_.LogicalEndpoint as LogicalE3_0_0_, this_.Version as Version0_0_, this_.TypeName as TypeName0_0_ FROM Subscription this_ WHERE this_.TypeName is null ]
[SQL: SELECT this_.SubscriberEndpoint as Subscrib1_0_0_, this_.MessageType as MessageT2_0_0_, this_.LogicalEndpoint as LogicalE3_0_0_, this_.Version as Version0_0_, this_.TypeName as TypeName0_0_ FROM Subscription this_ WHERE this_.TypeName is null] ---> System.Data.SqlClient.SqlException: Invalid column name 'LogicalEndpoint'.
   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.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
   at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)

Config:

<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Castle.Windsor" publicKeyToken="407dd0808d44fbdc" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Castle.Core" publicKeyToken="407dd0808d44fbdc" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="log4net" publicKeyToken="669e0ddf0bb1aa2a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2.0.8.0" newVersion="2.0.8.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>

(Ramon Smits) #2

The inner exception shows you the reason for failing: Invalid column name ‘LogicalEndpoint’.


(AK) #4

I am upgrading our system from Nservicebus v5 to v7. Database table columns is like [Endpoint] but I have created logical endpoint in Endpoint.config. Is this may be causing issue?


(Ramon Smits) #5

This is a new column in the subscription table introduced in NServiceBus 6 / NServiceBus.NHibernate 7.

If you configure your endpoint to run the installers the column will be added:

endpointConfiguration.EnableInstallers();

You only have to do this once during endpoint deployment of your endpoint.

– Ramon