Spruce Departmental Detail Dashboard SQL Error Common Issue

Spruce Departmental Detail Dashboard SQL Error Common Issue

If you get ticket with this error message and a user is trying run the departmental detail dashboard from NetSuite

A screenshot of a computer error AI-generated content may be incorrect.

You will need to be on the call with the user when the get the error.

You need to go to the

Dashboard Data Set>AIT_HelperQueries business rule

A screenshot of a computer AI-generated content may be incorrect.

Comment out the entire query starting on line 124-184, and uncomment line 122 and have it just run a TOP 10 *.  Save the business rule.  Then have the user try to access the dashboard again.  The error should not appear after that.

A screenshot of a computer AI-generated content may be incorrect.

 

Then you need to go back to the rule and comment out line 122 and uncomment the whole query lines 124-184 and save the business rule.  Basically what you are doing is just having it run a simple query that can't be used but allows the cache to be cleared.

Clifton originally created the dashboard and if you need any help with these instructions he should be able to help.  Most anyone who knows SQL should also be able to help.