Copied to clipboard

Flag this post as spam?

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


  • Søren Mastrup 122 posts 564 karma points c-trib
    Feb 13, 2017 @ 07:23
    Søren Mastrup
    0

    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:

    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}
    

    Imgur

    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
    
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Feb 13, 2017 @ 07:54
    Richard Soeteman
    100

    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

  • Martin Griffiths 826 posts 1269 karma points c-trib
    Oct 30, 2018 @ 11:31
    Martin Griffiths
    0

    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

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Oct 30, 2018 @ 11:39
    Richard Soeteman
    0

    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

  • Martin Griffiths 826 posts 1269 karma points c-trib
    Oct 30, 2018 @ 11:50
    Martin Griffiths
    0

    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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies