Copied to clipboard

Flag this post as spam?

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


  • Paul Marden 233 posts 335 karma points c-trib
    Sep 18, 2020 @ 10:51
    Paul Marden
    0

    Problem importing Wordpress XML posts

    I'm using Umbraco 8.6.4 and CMSImport 4.0.0 cmsimport.DataProviders.Wordpress.

    I'm trying to Import Wordpress Posts via an XML file downloaded from Wordpress.

    When I try to upload the file I get a SQL Exception: "An expression of non-boolean type specified in a context where a condition is expected, near 'order'." and no records imported.

    System.Data.SqlClient.SqlException (0x80131904): An expression of non-boolean type specified in a context where a condition is expected, near 'order'. 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.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, TaskCompletionSource1 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 Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in D:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172 at NPoco.Database.ExecuteReaderHelper(DbCommand cmd) at NPoco.Database.ExecuteDataReader(DbCommand cmd) at NPoco.Database.<QueryImp>d__1641.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source) at CMSImport.Core.Services.NodeService.GetNodeByName(String nodeName) at CMSImport.Providers.AdvancedSettings.MNTPSettings.AdvancedMNTPSettingsProvider.ParseContent(IEnumerable1 values, AdvancedMNTPSettingsOptions options, ImportOptions importOptions) at CMSImport.Providers.AdvancedSettings.MNTPSettings.AdvancedMNTPSettingsProvider.Parse(Object value, IProviderOptions options, ImportOptions importOptions) at CMSImport.Providers.ImportProviders.ContentImport.ContentImportProvider.Import(ImportState state) ClientConnectionId:d10f404b-5e48-430f-b5de-50cc7d1b330a Error Number:4145,State:1,Class:15 ClientConnectionId before routing:57a07dff-ef85-4590-b6ae-63edc326ee42 Routing Destination:e32156f62e2f.tr1593.uksouth1-a.worker.database.windows.net,11007

  • Richard Soeteman 3808 posts 11792 karma points MVP
    Sep 21, 2020 @ 06:39
    Richard Soeteman
    0

    Hi Paul,

    What is the value you map against MNTP?

    Best,

    Richard

  • Paul Marden 233 posts 335 karma points c-trib
    Sep 21, 2020 @ 08:56
    Paul Marden
    0

    Richard -- I do have an MNTP for Author, which I then removed from the mapping and I now get a different error.

    enter image description here

  • Richard Soeteman 3808 posts 11792 karma points MVP
    Sep 21, 2020 @ 08:59
    Richard Soeteman
    0

    Hi Paul,

    Can you check the Umbraco Logfile. Not sure what IndexReader does but think the answer is there.

    Best,

    Richard

  • Paul Marden 233 posts 335 karma points c-trib
    Sep 21, 2020 @ 09:04
    Paul Marden
    0

    Here you go...

    System.AggregateException: Exceptions were thrown by listed actions. ---> Lucene.Net.Store.AlreadyClosedException: this IndexReader is closed at Lucene.Net.Index.IndexReader.EnsureOpen() in d:\Lucene.Net\FullRepo\trunk\src\core\Index\IndexReader.cs:line 204 at Lucene.Net.Index.DirectoryReader.GetFieldNames(FieldOption fieldNames) in d:\Lucene.Net\FullRepo\trunk\src\core\Index\DirectoryReader.cs:line 1055 at Examine.LuceneEngine.Providers.LuceneSearcher.GetAllIndexedFields() in C:\projects\examine-qvx04\src\Examine\LuceneEngine\Providers\LuceneSearcher.cs:line 101 at Examine.LuceneEngine.Providers.BaseLuceneSearcher.CreateQuery(String category, BooleanOperation defaultOperation, Analyzer luceneAnalyzer, LuceneSearchOptions searchOptions) in C:\projects\examine-qvx04\src\Examine\LuceneEngine\Providers\BaseLuceneSearcher.cs:line 64 at Examine.LuceneEngine.Providers.BaseLuceneSearcher.CreateQuery(String category, BooleanOperation defaultOperation) in C:\projects\examine-qvx04\src\Examine\LuceneEngine\Providers\BaseLuceneSearcher.cs:line 49 at Umbraco.Examine.UmbracoContentIndex.PerformDeleteFromIndex(IEnumerable1 itemIds, Action1 onComplete) in D:\a\1\s\src\Umbraco.Examine\UmbracoContentIndex.cs:line 131 at Umbraco.Web.Search.ExamineComponent.DeferedDeleteIndex.Execute(ExamineComponent examineComponent, Int32 id, Boolean keepIfUnpublished) in D:\a\1\s\src\Umbraco.Web\Search\ExamineComponent.cs:line 699 at Umbraco.Web.Search.ExamineComponent.DeferedActions.Execute() in D:\a\1\s\src\Umbraco.Web\Search\ExamineComponent.cs:line 572 at Umbraco.Web.Search.ExamineComponent.DeferedActions.<>c.

  • Richard Soeteman 3808 posts 11792 karma points MVP
    Sep 21, 2020 @ 09:07
    Richard Soeteman
    0

    What I thought indeed, Examine issue. Happened before by someone else. Can you rebuild the Examine index as suggested here

    https://our.umbraco.com/forum/extending-umbraco-and-using-the-api/93263-lucenenetstorealreadyclosedexception-this-indexreader-is-closed

    Hope this helps,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft