RDL migration: SSRS to Power I Report Server (PBRS), issue with File Share Subscription
Hi Team, I'm migrating all the Paginated Reports from SSRS to PBRS. I was following the approach layed out in below links. https://github.com/microsoft/sql-server-samples/blob/master/samples/features/reporting-services/ssrs-migration-rss/ssrs_migration.rss https://businesswintelligence.com/content/80/ssrs-simple-migration-script All the reports/rdl are being migrated, but isssue i'm encountering is any reports that have atleast 1 File Share subcriptions those report subscriptions are not being migrated and it throws below error. --- End of inner exception stack trace ---; processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: e ERROR: Data source 'DataSource1': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: e ERROR: An exception has occurred in data source 'DataSource1'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ... processing!ReportServer_0-1!4474!10/14/2022-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: [AbnormalTermination:ReportProcessing], Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] ERROR [28000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 8, HTTP Response Code: 400, Exception Name: MissingAuthenticationTokenException, Error Message: Missing Authentication Token [Execution ID: ] at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) 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.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper.Open() at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5_0.<OpenDataSourceExtensionConnection>b__0() at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction) at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName) --- End of inner exception stack trace --- I see no issues in migrating Email Subscriptions or Reports... only File Share Subscriptions are failing. These reports have no issue and are executing perfecting in SSRS. Any clue's?