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
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.
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.
Hi Paul,
What is the value you map against MNTP?
Best,
Richard
Richard -- I do have an MNTP for Author, which I then removed from the mapping and I now get a different error.
Hi Paul,
Can you check the Umbraco Logfile. Not sure what IndexReader does but think the answer is there.
Best,
Richard
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(IEnumerable
1 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.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
is working on a reply...