Forum Discussion

Gainer's avatar
Gainer
New Member
3 years ago

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? 

1 Reply