Got DV008 Error.

[Gajrajsinh Rathva]

Hello sir, 

I got DV008 : Dashboard could not be viewed due to this error

and Error detail like :

System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)

   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)

   at System.Data.SqlClient.SqlConnection.Open()

   at Syncfusion.DashboardService.DashboardService.<>c__DisplayClass323_5.<FillRelationalDataManager>b__2(Table item)

   at System.Collections.Generic.List`1.ForEach(Action`1 action)

   at Syncfusion.DashboardService.DashboardService.FillRelationalDataManager(String key, Boolean cacheable, String modifiedConnectionStrings, String token, String itemId, String reportId, Boolean hasMultipleDashboard, DashboardParametersModel dashboardParameterSettings)

   at Syncfusion.DashboardService.DashboardService.InitializeControls(DashboardServiceArguments arguments)

   at SyncInvokeInitializeControls(Object , Object[] , Object[] )

   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)

   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

Can you please help in this matter, I installed software on Server but ErrorLog folder is not available  

thank you

[Anandaraj Radhakrishnan]

Hi Gajrajsinh,   

Thanks for contacting Syncfusion support.  

The reported issue occurs due to maximum number of connection opened in your SQL server instance. By increasing the pool size of your SQL server instance, it will be resolved. Please check your maximum pool size in your SQL server and increase it like below stated.   

   

To check the available pool size, please execute the below query.   

   

select * from sys.configurations where name ='user connections'    

                   

     

   

To increase the maximum pool size (number of user connections), please execute the below query and restart your SQL server instance.   

   

GO     

EXEC sp_configure 'show advanced options', 1;     

GO     

RECONFIGURE;     

GO     

EXEC sp_configure 'user connections', 32767;     

GO     

RECONFIGURE;     

GO     

   

Please refer the below link for more information:   

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-user-connections-server-configuration-option?view=sql-server-2017   

   

Regards,   

Anandaraj R 

[Gajrajsinh Rathva]

thank you sir, for your best support.

Thanks a lot 

[Anandaraj Radhakrishnan]

Hi Gajrajsinh, 

 

Most welcome. Please get back to us if you need any further assistance. 

 

Regards, 

Anandaraj R 

[Maulik Patel]

Hi Gajrajsinh, 

 

Most welcome. Please get back to us if you need any further assistance. 

 

Regards, 

Anandaraj R 

I got error DV008 while open Sync fusion report in my browsere.

can you please help me

[Dhivyabharathi Govindaraj]

Hi Maulik, 

 

Please share us the screenshot of error details by clicking Learn More option in DV0008 error to investigate the issue further from our end. 

 

Thanks, 

Dhivya