Developer forum

Forum » CMS - Standard features » Service Cache error for ExternalTranslationProvider

Service Cache error for ExternalTranslationProvider

Scott Forsyth Dynamicweb Employee
Scott Forsyth
Reply

Hello,

After upgrading to 9.10.7 (with a custom Dynamicweb.Ecommerce.dll [1.10.46], but I don't believe that is the problem), I'm getting an exception trying to load the Service Cache admin tool in the backend. It fails right away before being displayed the list of cache providers (Backend -> Settings -> Developer -> Cache -> Service Cache). It's reproducable at sandbox.biolegend.com. 

Server Error in '/' Application.


Invalid object name 'ExternalTranslationProvider'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ExternalTranslationProvider'.

Source Error:

 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:
 

[SqlException (0x80131904): Invalid object name 'ExternalTranslationProvider'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3317868
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4061
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +90
   System.Data.SqlClient.SqlDataReader.get_MetaData() +99
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +604
   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) +3303
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +667
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
   Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior) +557
   Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout) +109
   Dynamicweb.Data.Database.CreateDataReader(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout) +188
   Dynamicweb.Content.ExternalTranslations.TranslationRepository.GetAll() +161
   Dynamicweb.Content.ExternalTranslations.TranslationService.InitializeCache() +71
   Dynamicweb.Caching.DictionaryCache`2.InitializeCacheDictionary() +155
   System.Lazy`1.CreateValue() +708
   System.Lazy`1.LazyInitValue() +431
   Dynamicweb.Caching.DictionaryCache`2.get_CountInternal() +25
   Dynamicweb.Caching.ServiceCache`2.get_Count() +105
   Dynamicweb.Caching.DictionaryCache`2.<.ctor>b__15_1() +65
   Dynamicweb.Admin.CacheOverview.FillServiceCacheList() +391
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785

Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

Hi Scott,

I was able to catch the exception on DW9.10.5 as well. New DevOps Bug 1889 has been submitted against the issue. Thanks for observing.

BR, Oleg QA

 
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Reply

Hi Oleg,

Great, thanks for confirming.

Scott

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Reply
This post has been marked as an answer

Hi Scott

The bug #1889 regarding Service Cache error for ExternalTranslationProvider

Has been fixed in Hotfix version 9.10.9

You are able to get this release from the download section: https://doc.dynamicweb.com/downloads/releases

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Votes for this answer: 1
 
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Reply

Hi Kristian,

Excellent. Thank you!

Scott

 

You must be logged in to post in the forum