I am currently having issues with CMSImport on Umbraco Cloud.
I have installed the package via Nuget and it works on my local machine. When I push all my files to the cloud, the backend returns:
Failed to retrieve data for child nodes undefined
{"errorMsg":"Failed to retrieve data for child nodes undefined","data":{"Message":"An error has occurred."},"status":500}
The Trace log returns this:
Database exception occurred
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'CMSImportScheduledTask'.
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, 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 asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar()
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9()
at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy retryPolicy)
at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command)
at Umbraco.Core.Persistence.Database.ExecuteScalar[T](String sql, Object[] args)
ClientConnectionId:2d59d90f-f7b3-4289-8ab8-967ae30718af
Error Number:208,State:1,Class:16
ClientConnectionId before routing:49a12346-f66d-4ce5-afd9-29296b4627af
Routing Destination:f316340b4f01.tr12.westeurope1-a.worker.database.windows.net,11176
I think the installer didn't complete. Database tables are missing. Best to check the manual configuration chapter in the CMSImport manual http://soetemansoftware.nl/cmsimport/downloads to see how to create those.
Problems on Umbraco Cloud
I am currently having issues with CMSImport on Umbraco Cloud.
I have installed the package via Nuget and it works on my local machine. When I push all my files to the cloud, the backend returns:
The Trace log returns this:
Hi,
I think the installer didn't complete. Database tables are missing. Best to check the manual configuration chapter in the CMSImport manual http://soetemansoftware.nl/cmsimport/downloads to see how to create those.
Hope this helps,
Richard
Hi
I'm encountering the same issue on our own remote servers. The product works fine on our local development server.
We've just bought a server licence too.
Kind regards Martin
Hi Martin,
Sorry to hear about the issues, The installer couldn't complete, make sure the database user has enough rights to create the tables.
Best,
Richard
Hi Richard
Yes it's a permissions issue on our QA box. It's not been a problem on our Production server.
I'll create the tables manually.
Thanks Martin
is working on a reply...