Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sam 26 posts 137 karma points c-trib
    Sep 07, 2017 @ 03:51
    Sam
    0

    NHibernate.Exceptions.GenericADOException: could not execute query

    Hi everyone,

    I have set up Courier on a new project. I have two custom data resolvers. When I am trying to send my data, I am getting an NHibernate timeout:

    When I run the query manually it completes in about a second.

    Here is the error / crash in my log.

    2017-09-06 13:47:29,407 [41] ERROR Umbraco.Courier.Core.Extraction.RevisionExtraction - [Thread 41] There was a problem with extracting database information for the item: CurrentItem is null
    System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NHibernate.Exceptions.GenericADOException: could not execute query
    [ SELECT cmsPropertyData.dataNvarchar, cmsPropertyData.dataNtext, umbracoNode.id, umbracoNode.uniqueID 
                                FROM cmsPropertyData
                                INNER JOIN cmsPropertyType ON cmsPropertyType.id = cmsPropertyData.propertytypeid
                                INNER JOIN umbracoNode ON umbracoNode.id = cmsPropertyData.contentNodeId
                                WHERE cmsPropertyType.Alias = (@p0) AND umbracoNode.nodeObjectType = (@p1)
                                    AND (cmsPropertyData.dataNvarchar IS NOT NULL OR cmsPropertyData.dataNtext IS NOT NULL) ]
      Name:alias - Value:umbracoFile  Name:nodeObjectType - Value:b796f64c-1f99-4ffb-b886-4bf4bc011a9c
    [SQL: SELECT cmsPropertyData.dataNvarchar, cmsPropertyData.dataNtext, umbracoNode.id, umbracoNode.uniqueID 
                                FROM cmsPropertyData
                                INNER JOIN cmsPropertyType ON cmsPropertyType.id = cmsPropertyData.propertytypeid
                                INNER JOIN umbracoNode ON umbracoNode.id = cmsPropertyData.contentNodeId
                                WHERE cmsPropertyType.Alias = (@p0) AND umbracoNode.nodeObjectType = (@p1)
                                    AND (cmsPropertyData.dataNvarchar IS NOT NULL OR cmsPropertyData.dataNtext IS NOT NULL)] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
       --- End of inner exception stack trace ---
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.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)
       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 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       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)
       at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
       at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
       --- End of inner exception stack trace ---
       at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
       at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
       at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
       at NHibernate.Impl.StatelessSessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
       at NHibernate.Impl.StatelessSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
       at NHibernate.Impl.SqlQueryImpl.List(IList results)
       at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.MediaHelper.<>c__DisplayClass2.<GetOrCreateMediaPathCache>b__0(Object x)
       at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
       at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.MediaHelper.GetOrCreateMediaPathCache(Func`2 sqlQueryFactory)
       at Umbraco.Courier.Persistence.V6.NHibernate.Helpers.MediaHelper.GetMediaGuidByPath(String mediaPath)
       at Umbraco.Courier.Persistence.V6.NHibernate.NHibernateProvider.GetUniqueIdFromMediaFile(String filePath)
       at Umbraco.Courier.DataResolvers.Helpers.ImagesResolver.AddImageDependenciesForValue(String value, Item item)
       at Umbraco.Courier.DataResolvers.GridCellDataResolvers.CoreCellEditorResolver.HandleRte(Item item, ContentProperty propertyData, GridValueControlModel cell, Boolean packing)
       at Umbraco.Courier.DataResolvers.GridCellDataResolvers.CoreCellEditorResolver.HandleCoreCellEditors(Item item, ContentProperty propertyData, GridValueControlModel cell, Boolean packing)
       at Umbraco.Courier.DataResolvers.GridCellDataResolvers.CoreCellEditorResolver.ExtractingCell(Item item, ContentProperty propertyData, GridValueControlModel cell)
       at Umbraco.Courier.DataResolvers.PropertyDataResolvers.GridCellResolverProvider.ExtractingProperty(Item item, ContentProperty propertyData)
       at Umbraco.Courier.DataResolvers.PropertyDataResolverProvider.Extracting(Item item)
       at Umbraco.Courier.Core.ResolutionManager.ExecuteResolver(Item item, ItemEvent e, ItemProvider provider)
       at Umbraco.Courier.Core.ItemProvider.Extract(Item item)
       at Umbraco.Courier.RepositoryProviders.Local.ExtractItem(Item item, Boolean overwrite)
       at Umbraco.Courier.RepositoryProviders.Webservices.Repository.ExtractItems(String sessionKey, SerializedItemWrapper[] items, Boolean overWrite)
       --- End of inner exception stack trace ---
       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.EndInvoke(IAsyncResult asyncResult)
       at Umbraco.Courier.RepositoryProviders.WebServiceProvider.RepositoryWebservice.EndExtractItems(IAsyncResult asyncResult)
       at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.ExtractItems(Item[] items, Boolean overWrite)
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractItems(List`1 nodes)
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.ExtractReadyRevisionBatch()
       at Umbraco.Courier.Core.Extraction.RevisionExtraction.Extract()
    2017-09-06 13:47:29,412 [41] DEBUG Umbraco.Courier.Persistence.V6.NHibernate.NHibernateProvider - [Thread 41] Closing session, UseGlobalSession: False, key: 5460a37d-3c6d-4134-a389-279ec55299d6
    

    What are my next steps?

  • Alex Skrypnyk 6150 posts 24110 karma points MVP 8x admin c-trib
    Sep 27, 2017 @ 12:01
    Alex Skrypnyk
    0

    Hi Sam

    I saw the same error on Umbraco 6.2.3 installation, did you solve the issue?

    Thanks,

    Alex

  • Sam 26 posts 137 karma points c-trib
    Oct 11, 2017 @ 02:08
    Sam
    0

    Hi Alex.

    No, we have not solved the issue.

    We have an open issue against courier - http://issues.umbraco.org/issue/COU-627

    No one from the Umbraco team has picked it up unfortunately.

  • Brad Kelley 2 posts 20 karma points
    Feb 07, 2018 @ 22:06
    Brad Kelley
    0

    Had a similar issue today with "There was a problem with extracting database information for the item: CurrentItem is null". In our case we were trying to move PDF files from staging to production and the server was erroring with 500 codes and stack traces.

    The situation was resolved by using Courier to sync the File media type, even though there was no visible difference between the definitions on stage and prod.

Please Sign in or register to post replies

Write your reply to:

Draft