Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » DW 9.9.1 SQL Firehose throws error page

DW 9.9.1 SQL Firehose throws error page

E-mail notifications
Peter Leleulya
Peter Leleulya
Reply
Posted on 04/09/2020 11:24:50

I tried to ReRun updates, but that didn't help.

I have this issue on all environments running 9.9.1

Server Error in '/' Application.

Invalid object name 'AggregatedCounter'.

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 'AggregatedCounter'.

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 'AggregatedCounter'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3318624
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4289
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
   System.Data.SqlClient.SqlDataReader.get_MetaData() +101
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
   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) +3392
   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) +725
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
   Dynamicweb.Data.DatabaseSchema.GetTableColumns(IDbConnection connection, String tableName) +200
   Dynamicweb.Admin.Management.QueryAnalyzer.QueryEditor.RenderClientInstance() in E:\agent\_work\150\s\01 - Applications\Dynamicweb.Admin\DW99\Dynamicweb.Admin\Admin\Content\Management\QueryAnalyzer\QueryEditor.aspx.vb:124
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1607

 

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4084.0


Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 07/09/2020 06:27:15
Reply
This post has been marked as an answer

Hi,

It seems to be issue of your specific solution(s). The object seems to be a table (table field) not exists in base db. Perhaps, it's relayted to a specific permission to the table etc. Please, share URL to an your solution and point backend user role you use if possible to have further check. Besides, the mentioned admin version does not yet exist, current one - 9.9.0.  Thanks.

BR, Oleg QA

Votes for this answer: 1
 
Peter Leleulya
Peter Leleulya
Posted on 07/09/2020 08:29:06
Reply

Thanks for your response Oleg,

I've sent the info you requested to Dynamicweb support, asking to forward it to you.

 

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 07/09/2020 08:35:32
Reply

Greate, well done. They will take care about the issue reporting. Thanks.

BR, Oleg QA

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Posted on 09/09/2020 09:24:09
Reply

Hi Peter,

Try from SQL Server Management Studio to pass this query to the database

use [tablename]
declare @name as nvarchar(255)
set @name = 'AggregatedCounter'

SELECT * 
    FROM INFORMATION_SCHEMA.COLUMNS 
    WHERE TABLE_NAME = @name
    OR COLUMN_NAME = @name

That should give you an indication from where the table (most probably) or column derives.

Best regards
Morten Snedker | Helpdesk

 
Peter Leleulya
Peter Leleulya
Posted on 10/09/2020 08:33:18
Reply

@Morten My apologies, it was a bit premature to assume that it was due to a dynamicweb update. It turns out to be caused by a SyncForce scheduler. We are going to handle this internally. Thanks for the support.

 

You must be logged in to post in the forum