The access token is not valid Sample Log (timeout):

2018-03-16 13:12:26,317 [30   ][ERROR][IzendaBootstraper                   ] The access token is not valid
Izenda.BI.Framework.Exceptions.UnAuthorizeException: The access token is not valid
at Izenda.BI.Logic.Users.StandAloneAuthenticationLogic.(String , Nullable`1  )
at Izenda.BI.Logic.Users.StandAloneAuthenticationLogic.ValidateAccessToken(String accessToken, Nullable`1 selectedTenantId)
at Izenda.BI.Logic.Users.UserLogic.ValidateAccessToken(String accessToken, Nullable`1 selectedTenantId)
at Izenda.BI.API.IzendaModule.GetCurrentUserAccessTokenInfo(String currentAccessToken, String currentAccessTenant)
at Izenda.BI.API.IzendaModule.SetupContext(Boolean runAsAdministrator, String accessToken, String currentTenant)
at Izenda.BI.API.IzendaModule.ExecuteInMornitoringContext(Boolean wrapingExceptionIntoOperationResult, Object paramtersToLog, Func`1 function, Boolean runAsAdministrator, String userAction, String accessToken, String currentTenant)
at Izenda.BI.API.ReportDesigner.ReportModule.<.ctor>b__2_126(Object parameters)
at Nancy.Routing.Route.<>c__DisplayClass4.<Wrap>b__3(Object parameters, CancellationToken context)

• Session timeout due to inactivity

• Incorrect username or password

Invalid column name:

• ‘CreatedById’

• ‘CustomDefinition’

• ‘IsRunningField’

Sample Logs:

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedById'.

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CustomDefinition'.

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'IsRunningField'.

Missing upgrade scripts for config database, please find Schema Migration Assistant here

• If invalid column ‘CreatedById’, apply upgrade script v2.0.1 - 2.1.2

• If invalid column ‘CustomDefinition’ and ‘IsRunningField’, apply upgrade script v2.4.0 - 2.5.0

Subscription failure

Sample Log:

2018-03-07 16:51:32,081 [DefaultQuartzScheduler_Worker-2][INFO ][SubscriptionJob] Start scheduling 0 subscription jobs

2018-03-07 16:51:32,097

[30][INFO ][PingJob] Ping system status failure: The remote server returned an error: (404) Not Found.

Missing upgrade scripts for config database, please find Schema Migration Assistant here

• If invalid column ‘CreatedById’, apply upgrade script v2.0.1 - 2.1.2

• If invalid column ‘CustomDefinition’ and ‘IsRunningField’, apply upgrade script v2.4.0 - 2.5.0

Cannot load fields of remote table

Sample Log:

2018-01-11 09:10:28,701 [23][ERROR][DataModelLogic] Cannot load fields of remote table

System.Data.SqlClient.SqlException (0x80131904): The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Demo" was unable to begin a distributed transaction.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at Izenda.BI.DataAdaptor.RDBMS.SQL.SQLSchemaLoader.

Defect #17033 in our release notes page.

Resolved by new setting added as of version 2.1.5. In the “IzendaSystemSetting” table of the config DB, set the “RollbackSPWhenLoadSchema” value to 0 to avoid distributed transaction errors when system attempts to fetch stored procedure schema data (if using Linked Server and cannot setup DTC).

Export failure

Sample Log (value not set):

2018-03-20 10:22:30,868 [12][ERROR][ExportingLogic] Failed to convert to image: ReportId=8f74023a-4cbd-4f35-92ba-e3c04fa041d9, ReportPartId=29a15ab9-221a-430f-977f-6cf4e125726e

System.ArgumentNullException: Base web url cannot be null or empty

Parameter name: baseUrl

at Izenda.BI.Framework.Contracts.DefaultWebUrlResolver.ResolveUrl(String baseUrl, WebUrlActionLink action, Nullable`1 id, Dictionary`2 parameters)

at Izenda.BI.Exporting.ExportHelper.ConvertToImage(ExportSetting setting, ExportData data, Int32 width, Int32 height, Object separatorValue)

...

2018-03-20 10:22:30,967 [12   ][ERROR][IzendaBootstraper                   ] Izenda exception:

Izenda.BI.Framework.Exceptions.IzendaModelException ---> System.ArgumentNullException: Base web url cannot be null or empty

Parameter name: baseUrl

at Izenda.BI.Framework.Contracts.DefaultWebUrlResolver.ResolveUrl(String baseUrl, WebUrlActionLink action, Nullable`1 id, Dictionary`2 parameters)

at Izenda.BI.Exporting.Html.Builder.HtmlBuilder.Build(ExportContext context)

at Izenda.BI.Exporting.Pdf.PdfExportProvider.Export(ExportContext context)

at Izenda.BI.Logic.Exporting.ExportingLogic.Export(ExportRequest request, ExportType type)

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

at Izenda.BI.Logic.Exporting.ExportingLogic.Export(ExportRequest request, ExportType type)

at Izenda.BI.API.Export.ExportModule.<>c__DisplayClass0_0.<.ctor>b__1()

at Izenda.BI.API.IzendaModule.ExecuteInMornitoringContext(Boolean wrapingExceptionIntoOperationResult, Object paramtersToLog, Func`1 function, Boolean runAsAdministrator, String userAction, String accessToken, String currentTenant)

at Izenda.BI.API.Export.ExportModule.<>c__DisplayClass0_1.<.ctor>b__0(Object parameters)

at Nancy.Routing.Route.<>c__DisplayClass4.<Wrap>b__3(Object parameters, CancellationToken context)

Sample Log (incorrect value):

2018-03-20 10:44:55,228 [30][INFO ][ExportingLogic] Attempt to convert to image by url: <URL to page with rendered report part>

2018-03-20 10:44:55,464 [30][ERROR][ExportingLogic] Failed to convert to image: ReportId=30db0d8b-1b4b-4b43-8366-ccb04b72fcaa, ReportPartId=29a15ab9-221a-430f-977f-6cf4e125726e

System.Exception: HTML load error. The remote content was not found at the server - HTTP error 404

at EvoPdf.HtmlToImageConverter.?(String A_0, Boolean A_1, ?& A_2, Boolean A_3, Boolean A_4, Boolean A_5)

at EvoPdf.HtmlToImageConverter.ConvertUrlToImageObject(String url)

at EvoPdf.HtmlToImageConverter.ConvertUrl(String url, ImageFormat format)

at Izenda.BI.Exporting.ExportHelper.ConvertToImage(ExportSetting setting, ExportData data, Int32 width, Int32 height, Object separatorValue)

Send email failed, [object Object]

Sample Log:
2018-04-02 14:57:42,679 [55   ][ERROR][IzendaBootstraper                   ] You don't have permission to perform this action

Izenda.BI.Framework.Exceptions.IzendaException: You don't have permission to perform this action
at Izenda.BI.Logic.Authorization.Validators.TenantAccessAuthorizeHandler.Execute(TenantAccessHandlerContext context)
at Izenda.BI.Logic.Authorization.AuthorizationService.Authorize[TContext,THanlder](TContext context)
at Izenda.BI.Logic.Exporting.ExportingLogic.
(ExportRequest , ExportType )
at Izenda.BI.Logic.Exporting.ExportingLogic.Export(ExportRequest request, ExportType type)
at Izenda.BI.Logic.Exporting.ExportingLogic.ExportSubscription(Subscription subscription)
at Izenda.BI.API.Export.ExportModule.<>c__DisplayClass0_3.<.ctor>b__4()
at Izenda.BI.API.IzendaModule.ExecuteInMornitoringContext(Boolean wrapingExceptionIntoOperationResult, Object paramtersToLog, Func`1 function, Boolean runAsAdministrator, String userAction, String accessToken, String currentTenant)

Cannot get LicenseSetting

Sample Log:

2017-11-27 16:03:40,319 [10][ERROR][DatabaseSettingLogic] Cannot get LicenseSetting

System.InvalidOperationException: OracleConnection.ConnectionString is invalid

at Oracle.ManagedDataAccess.Client.OracleConnection.Open()

at Izenda.BI.Oracle.OracleConnection.OpenConnection(String connectionString)

at Izenda.BI.SystemRepository.RDBMS.RDBMSSystemRepository.Query[T](String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout)

at Izenda.BI.SystemRepository.RDBMS.Oracle.OracleSystemRepository.Query[T](String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout)

at Izenda.BI.SystemRepository.RDBMS.RDBMSSystemRepository.GetLicenseSetting()

at Izenda.BI.Logic.DatabaseSetup.DatabaseSettingLogic.VerifyConnection(Guid serverType, String connectionString)

Html conversion failed

Sample Log:

2019-04-17 03:00:50,561 [17][ERROR][IzendaBootstraper] Izenda exception:

Izenda.BI.Framework.Exceptions.IzendaModelException ---> Syncfusion.Pdf.PdfException: Html conversion failed

at Syncfusion.HtmlConverter.HtmlConverter.CheckConversionDone(String tempFilePath)

at Syncfusion.HtmlConverter.HtmlConverter.ConvertHtmlToPdf(String url, Int32 width, Int32 height)

at Syncfusion.HtmlConverter.HtmlToPdfConverter.Convert(String url)

at Syncfusion.HtmlConverter.HtmlToPdfConverter.Convert(String html, String baseurl)

at Izenda.BI.Exporting.HtmlConverterTool.ConvertHtmlToPdf(ExportSetting setting, HtmlDocument htmlDocument)

at Izenda.BI.Exporting.Pdf.PdfExportProvider.Export(ExportContext context)

at Izenda.BI.Logic.Exporting.ExportingLogic.Export(ExportRequest request, ExportType type, Boolean enableWriteStat)