0

Hi,

Few of our dashboards are not showing up any data instead showing an error message like: Internal Server Error – Error Loading Dashboard” with further details as “The Server encountered a problem while retrieving details of the dashboard with ID ‘null'”.

But found that other few dashboards are working/showing data pretty well.

I suspect database because in the log i can see few errors related to SQL.

 

I tried to debug the issue anf below are few work around from my side but none helped to debug:

  • Tried to edit the dashboard to check any settings are broken but found no option
  • Also checked the Sqauredup connection with Data Warehouse and it is successfully connected, screenshot fyi.
  • Checked latest Logs located at two different locations
    • 1) C:\inetpub\logs\LogFiles\W3SVC1  —  found no clues in this logs
    • 2) C:\inetpub\wwwroot\squaredupv3\Transient\Log  — Found few errors realated SQL, below are Log file details

System.ArgumentException: Error: Login failed for user ‘FREMONT\PDTCSQDWEB01$’. (18456)
at SquaredUp.Connector.Sql.SqlController.<>c__DisplayClass6_0.<Execute>b__3()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at SquaredUp.Connector.Sql.SqlController.<Execute>d__6.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<BeginInvokeAsynchronousActionMethod>b__36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)

Let me know if any further information required from my end to debug the issue.

Thanks.

Jelly answered