Developer forum

Forum » CMS - Standard features » SQL Firehose error

SQL Firehose error

Terri Donahue Dynamicweb Employee
Terri Donahue
Reply

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 Dynamicweb Employee
Oleg Rodionov
Reply

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 Dynamicweb Employee
Terri Donahue
Reply

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 Dynamicweb Employee
Oleg Rodionov
Reply

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 Dynamicweb Employee
Kristian Kirkholt
Reply

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

 
Terri Donahue Dynamicweb Employee
Terri Donahue
Reply

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?

 

You must be logged in to post in the forum