I've made a report in TSF DevExpress Report Designer with one sql server data source using two versions of the same view (table). In DevExpress the report works perfectly, however in Thinkwise universal GUI it does not... I'm getting the following error message:
``
2023-11-10T15:30:00.3996411+01:00 80002581-0001-fb00-b63f-84710c7967bb ERR] An unhandled exception occurred while processing the request. (ffba027a)
Prockees.Bootstrapper.ExecutionException: DevExpress.XtraReports.DataRetrievalException: Error when trying to populate the datasource. The following exception was thrown:
Failed to connect to the database. To learn more, see the exception details.
Exception details:
Connection name: localhost_TCNTW_CREDITEUR_Connection
Error message:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
---> DevExpress.DataAccess.Sql.DatabaseConnectionException: Failed to connect to the database. To learn more, see the exception details.
Exception details:
Connection name: localhost_TCNTW_CREDITEUR_Connection
Error message:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
---> Microsoft.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) ---> System.ComponentModel.Win32Exception: The certificate chain was issued by an authority that is not trusted
--- End of inner exception stack trace ---
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParserStateObject.SNIWritePacket(SNIHandle handle, SNIPacket packet, UInt32& sniError, Boolean canAccumulate, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParserStateObject.WriteSni(Boolean canAccumulate)
at Microsoft.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode, Boolean canAccumulate)
at Microsoft.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec, FeatureExtension requestedFeatures, SessionData recoverySessionData, FederatedAuthenticationFeatureExtensionData fedAuthFeatureExtensionData, SqlClientOriginalNetworkAddressInfo originalNetworkAddressInfo, SqlConnectionEncryptOption encrypt)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.Login(ServerInfo server, TimeoutTimer timeout, String newPassword, SecureString newSecurePassword, SqlConnectionEncryptOption encrypt)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover, Boolean isFirstTransparentAttempt, Boolean disableTnir)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, ServerCertificateValidationCallback serverCallback, ClientCertificateRetrievalCallback clientCallback, DbConnectionPool pool, String accessToken, SqlClientOriginalNetworkAddressInfo originalNetworkAddressInfo, Boolean applyTransientFaultHandling)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(IDbConnection conn)
--- End of inner exception stack trace ---
at DevExpress.DataAccess.DataConnectionBase.ProcessException(String connectionName, Exception exception)
at DevExpress.DataAccess.DataConnectionBase.ProcessExceptionInLoop(Exception exception, IDataConnectionParametersService dataConnectionParametersProvider)
at DevExpress.DataAccess.DataConnectionBase.CreateDataStoreCore(IDataConnectionParametersService dataConnectionParametersProvider, CancellationToken token)
at DevExpress.DataAccess.Sql.SqlDataSource.EnsureIsReadyToBuildCore(CancellationToken cancellationToken, Stringg] queriesToFill, Action`2 loadSchema)
at DevExpress.DataAccess.Sql.SqlDataSource.EnsureIsReadyToBuild(CancellationToken cancellationToken, Stringg] queriesToFill)
at DevExpress.DataAccess.Sql.SqlDataSource.DevExpress.Data.IListAdapter2.FillList(IServiceProvider serviceProvider, Stringg] queriesToFill)
at DevExpress.XtraReports.Native.ListAdapterFillerAsync2`1.FillListSynchronously()
at DevExpress.XtraReports.Native.DataSourceFiller.Execute()
--- End of inner exception stack trace ---
at DevExpress.XtraReports.Native.DataSourceFiller.Execute()
at DevExpress.XtraReports.UI.XtraReportBase.FillDataSources(Boolean skipIfFilled)
at DevExpress.XtraReports.UI.XtraReport.DevExpress.XtraReports.IReport.CreateDocumentCore(Single progressRange, Boolean buildForInstantPreview)
at DevExpress.XtraReports.Native.DocumentCreator.Create(Single progressRange, Boolean buildForInstantPreview)
at DevExpress.XtraReports.UI.XtraReport.CreateIfEmpty(Single progressRange, Boolean buildPagesInBackground)
at DevExpress.XtraReports.UI.XtraReport.ExportToPdf(Stream stream, PdfExportOptions options)
at Indicium.Reporting.DevExpress.DevExpressReportProcessor.export(XtraReport xtraReport, ReportAction exportType)
at Indicium.Reporting.DevExpress.DevExpressReportProcessor.ExportReport(DevExpressConnectionInfo info, Dictionary`2 parameters, DevExpressOptions reportOptions)
at lambda_method(Closure , DevExpressConnectionInfo , Dictionary`2 , DevExpressOptions )
at Prockees.Bootstrapper.PluginClientChannel.ExecuteMethodAsynccT](String typeNameSpace, String typeClassName, String methodName, IEnumerable`1 parameters, CancellationToken cancellationToken)
at Prockees.Bootstrapper.PluginBootstrapper.ExecuteMethodAsynccT](String typeNameSpace, String typeClassName, String methodName, IEnumerable`1 parameters, CancellationToken cancellationToken)
at Indicium.Reporting.DevExpress.DevExpressReportDependency.ExportReport(TSFApplication application, TSFUserContext userContext, IEnumerable`1 parameters, ReportOptionsContract reportOptions) in C:\azp\agent\_work\1\s\src\Reporting\Indicium.Reporting.DevExpress\DevExpressReportDependency.cs:line 193
at Indicium.Shared.Telemetry.ServerTimings.ServerTimingsBuilder.CaptureeT](String key, Func`1 action) in C:\azp\agent\_work\1\s\src\Indicium.Shared\Telemetry\ServerTimings\ServerTimingsBuilder.cs:line 94
at Indicium.Controllers.StagingControllerBase.commitSingleReportResource(StagedResource resource, ApiReportVariant reportVariant) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingControllerBase.cs:line 2040
at Indicium.Controllers.StagingControllerBase.CommitStagedResource(StagedResource resource, ApiObjVariant variant, Boolean performAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingControllerBase.cs:line 913
at Indicium.Controllers.StagingControllerBase.CommitActionTriggerProcessFlow(ApiObjVariant variant, String taskReportContextTableID, ProcessActionType processActionType, IProcessFlowResource processFlowResource, Func`1 commitAction) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingControllerBase.cs:line 835
at Indicium.Controllers.StagingControllerBase.CommitResource(StagedResource resource, ApiObjVariant variant, IProcessFlowResource processFlowResource, Boolean requestedAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingControllerBase.cs:line 719
at Indicium.Controllers.StagingControllerBase.CommitResource(StagedResource resource, ApiObjVariant variant, IProcessFlowResource processFlowResource, Boolean requestedAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingControllerBase.cs:line 726
at Indicium.Controllers.StagingController.commit(Boolean requestedAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingController.cs:line 1773
at Indicium.Controllers.StagingController.commit(Boolean requestedAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingController.cs:line 1773
at Indicium.Controllers.StagingController.commit(Boolean requestedAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingController.cs:line 1773
at Indicium.Controllers.StagingController.commit(Boolean requestedAsync) in C:\azp\agent\_work\1\s\src\Indicium\Controllers\StagingController.cs:line 1773
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Objectt] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Indicium.Extensions.ApplicationBuilderExtensions.<>c.<<SameSiteOpenIDConnectInterceptor>b__0_0>d.MoveNext() in C:\azp\agent\_work\1\s\src\Indicium\Extensions\ApplicationBuilderExtensions.cs:line 57
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.InvokeCore(HttpContext context)
at Indicium.Middleware.Security.AuthenticationHeadersMiddleware.InvokeAsync(HttpContext context) in C:\azp\agent\_work\1\s\src\Indicium\Middleware\Authentication\AuthenticationHeadersMiddleware.cs:line 48
at Indicium.Middleware.Security.SecurityHeadersMiddleware.InvokeAsync(HttpContext context, ContentSecurityPolicyBuilder cspBuilder) in C:\azp\agent\_work\1\s\src\Indicium\Middleware\Security\SecurityHeadersMiddleware.cs:line 55
at Indicium.Middleware.Messages.TSFMessagesMiddleware.Invoke(HttpContext context, IRootApplicationLoader rootApplicationLoader, TSFRequestContext requestContext) in C:\azp\agent\_work\1\s\src\Indicium\Middleware\Messages\TSFMessageMiddleware.cs:line 45
at Indicium.Middleware.Telemetry.ServerTimings.ServerTimingsMiddleware.InvokeAsync(HttpContext context, ServerTimingsBuilder serverTimingsBuilder) in C:\azp\agent\_work\1\s\src\Indicium\Middleware\Telemetry\ServerTimings\ServerTimingsMiddleware.cs:line 46
at Indicium.Middleware.ExceptionHandlingMiddleware.Invoke(HttpContext context, TSFRequestContext requestContext) in C:\azp\agent\_work\1\s\src\Indicium\Middleware\ExceptionHandlingMiddleware.cs:line 87
``I've tried making separate reports for each query, that works perfectly fine in the GUI.
I've tried using sub reports, but that does not work as mentioned in: sub reports
I've followed this link mentioned in the sub reports post to create my current report.
Please send help.