May 16, 2012 at 6:30 PM
Edited May 18, 2012 at 4:47 PM
I've been using the Import Export module to import content from a WordPress site to Orchard CMS. I have a blog with almost 1700 posts.
I know the recipe XML is fine, because I broke it up into 5 smaller files, any two of which will import correctly, which results in almost 700 posts imported. Once I have this many posts, any subsequent imports fail.
The error log reveals:
Orchard.OrchardCoreException: Recipe execution with id 380005f9efab45f5890b7bcc5821d25b was cancelled because the "Data" step failed to execute. The following exception was thrown: could not execute query
The query in question is apparently:
Exception during Alias refresh NHibernate.ADOException: could not execute query
Of course, if I manually execute the query it lists it works fine. This is clearly some bug with nHybernate, database connections, and queries getting slower as the dataset gets larger.