1. Feedback
  2. Enterprise Reporting
  3. 38743

Welcome to the Enterprise Reporting feedback portal. We’re happy you’re here! If you have feedback on how to improve the Enterprise Reporting, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

SSL connection cannot be established

Please advise as this is an urgent issue. 

I am attempting to create a WebAPI datasource that pulls data from an API over https.


Problem

When I try to create the DataSource I am receiving the following error on bold reports.



Empty


Postman Example

Here is an example of the request working in postman.



curl --location -g --request POST 'https://localhost:3001/api/mongo/aggregate/10?parameters[@eventId]=4YlRb2Nt&parameters[@age]=10&parameters[@score]=54.9&parameters[@date]=2022-09-26T07:31:24.769' \
--header 'dataSource: mongodb://localhost:27017' \
--header 'dataBase: obi' \
--header 'collection: data' \
--header 'Content-Type: text/plain' \
--header 'Authorazation: Bearer eyJhbGciOiJSUzUxMiIsInR5cCI6ImF0K2p3dCJ9.eyJuYmYiOjE2NjY5NTAwOTQsImV4cCI6MTY2Njk1MzY5NCwiaXNzIjoiaHR0cHM6Ly9sb2NhbGhvc3Q6MzAwMSIsImF1ZCI6Im9wc2liaV9hcGkiLCJjbGllbnRfaWQiOiJvcHNpYmlfZG9jcyIsInN1YiI6IjUwOTI2MWU0LTQ1MDMtNDE0Ni05Y2JiLTA5OWQ1NjI1MzNiMCIsImF1dGhfdGltZSI6MTY2Njk1MDA5NCwiaWRwIjoibG9jYWwiLCJyb2xlIjoiYWRtaW5pc3RyYXRvciIsInBlcm1pc3Npb24iOlsidXNlcnMudmlldyIsInVzZXJzLm1hbmFnZSIsInJvbGVzLnZpZXciLCJyb2xlcy5tYW5hZ2UiLCJyb2xlcy5hc3NpZ24iLCJzY3JpcHRzLmV4ZWN1dGUiLCJtb25nby5leGVjdXRlIiwic3FsLmV4ZWN1dGUiXSwibmFtZSI6Ik9wc2lBZG1pbiIsImVtYWlsIjoib2JpLmFkbWluQG9wc2kuY28uemEiLCJwaG9uZV9udW1iZXIiOiIwNzE4NzM1NDIzIiwiZnVsbG5hbWUiOiJBZG1pbmlzdHJhdG9yIEFjY291bnQiLCJqdGkiOiJCRUY2NjIyMjY4OTkwQzlCQjQ5QTU4NjNEMjE0NDEzOSIsImlhdCI6MTY2Njk1MDA5NCwic2NvcGUiOlsib3BzaWJpX2FwaSJdLCJhbXIiOlsicHdkIl19.rjVPGBe3SBKSn4nUTHbRmP-k-5yNtdM0Fp4ncUOc7DBl1eMEkwcJwc0U-Jd7TuqORtSfJjM_HBpU3RlBlVKc4RQk_Bmzbe6gV1UMVt0QsG7RMp1auq9WpMpJC1QggEQWrQlnjYg-WcURspMAZO8C-eOoX5Y3FV-1YiiNFFZq4lOZ3aZ0_22-hLzI_nFL46XHNd3dUM-YSBDKbM79rMaxoWNPsiJ0hIL9AV47ppuicH-VM27sIaezB0BAuDDl_l2QE-I0iedRc6l42cVZa6-vzeGox6wuSsGuXKM6O0jrOXqwceRjRhc7E7VQXCb_cPRSi-a9Vb0PuGeYzzD2WX2gug' \
--data-raw '[{
 $match: {
  eventId: '\''@eventId'\'',
  age: @age,
  score: @score,
  dateAdded: ISODate('\''@date'\'')
 }
}, {
 $unwind: {
  path: '\''$journal'\'',
  includeArrayIndex: '\''string'\''
 }
}]'

Result 200 Ok



Empty


Bold Reports Example

Empty



When I click on "Save" it is throwing the error in the Problem section.



Note: That this call is not even making it to my API, it is failing within Bold Reports. I am hosting Bold Reports locally on IIS.



Please find the error logs attached:



2022-09-16 08:01:04,013 [1] ERROR Unable to generate access token for the client: e2c4a7e9-1518-4a1a-8ea8-a1c2dd756758

System.AggregateException: One or more errors occurred. (The SSL connection could not be established, see inner exception.)

 ---> System.Net.Http.HttpRequestException: The SSL connection could not be established, see inner exception.

 ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid because of errors in the certificate chain: UntrustedRoot

   at System.Net.Security.SslStream.SendAuthResetSignal(ProtocolToken message, ExceptionDispatchInfo exception)

   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](TIOAdapter adapter, Boolean receiveFirst, Byte[] reAuthenticationData, Boolean isApm)

   at System.Net.Http.ConnectHelper.EstablishSslConnectionAsyncCore(Boolean async, Stream stream, SslClientAuthenticationOptions sslOptions, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---

   at System.Net.Http.ConnectHelper.EstablishSslConnectionAsyncCore(Boolean async, Stream stream, SslClientAuthenticationOptions sslOptions, CancellationToken cancellationToken)

   at System.Net.Http.HttpConnectionPool.ConnectAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken)

   at System.Net.Http.HttpConnectionPool.CreateHttp11ConnectionAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken)

   at System.Net.Http.HttpConnectionPool.GetHttpConnectionAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken)

   at System.Net.Http.HttpConnectionPool.SendWithRetryAsync(HttpRequestMessage request, Boolean async, Boolean doRequestAuth, CancellationToken cancellationToken)

   at System.Net.Http.RedirectHandler.SendAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken)

   at System.Net.Http.HttpClient.SendAsyncCore(HttpRequestMessage request, HttpCompletionOption completionOption, Boolean async, Boolean emitTelemetryStartStop, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at System.Threading.Tasks.Task`1.get_Result()

   at Syncfusion.Server.Base.IdPDirectory.Helpers.IdpAuthenticationHelper.GenerateToken(Authentication authentication)