SQL Firehose error

E-mail notifications

Terri Donahue

Posted on 25/03/2021 15:22:57

Hi guys,

When I try to access SQL Firehose on one of our solutions, I get this error message

Invalid object name 'ProcedureStats_1_2AF2111849E5361DC40E7BF09F09D689'.

How can I resolve this?

Replies

Oleg Rodionov

Posted on 01/04/2021 04:25:03

Hi Terri,

Could you please provide more info about your solution and kind of request you have executed if the issue is still relevant. URL to the solution and related video shot are preferable to have research.

BR, Oleg QA

Terri Donahue

Posted on 07/04/2021 20:43:10

Hi Oleg,

URL is hewittrad.com. The error happens as soon as you try to open SQL Firehose.

https://www.screencast.com/t/l3HmZbbwt

Oleg Rodionov

Posted on 09/04/2021 01:31:29

Hi Terri,

DB of the solution seems to have a table its columns cannot be queried by SQL Firehouse due to no access. I've submitted DevOps 1584 to try fixing the issue. It will be provided in next DW release only. So, try to find the table and delete it by yourself until fixing if urgent.

BR, Oleg QA

Kristian Kirkholt

Posted on 15/04/2021 13:25:08

This post has been marked as an answer

Hi Terri

Problem #1584 regarding SQL exceptions on SQL Firehose

Has been fixed in Dynamicweb version 9.10.7

This version is available in the download section: https://doc.dynamicweb.com/downloads/releases

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Votes for this answer: 1

Terri Donahue

Posted on 15/04/2021 15:25:43

Hi Kristian,

Will this also be available in the 9.9.x branch? Or is there a way for me to manually fix it on the solution that has the problem?

Terri Donahue

Posted on 22/04/2021 15:29:46

Hi Kristian,

I'm all set. Turns out SQL Sentry added that view. Once I removed all SQL Sentry items, SQL Firehose is working again.

You must be logged in to post in the forum

Developer forum