Share via

Reporting Server 2012 to 2017

Medina Canton Fernando Maximiliano Jose 1 Reputation point
2021-07-15T18:35:44.263+00:00

I copied reports from reporting server 2012 to reporting server 2018 and some of them doesn't work, they show me this error:
Error al procesar el informe. (rsProcessingAborted)
Error de ejecución de consulta para el conjunto de datos 'SISRED'. (rsErrorExecutingCommand)
Para obtener más información acerca de este error, vaya al servidor de informes en la máquina del servidor local o habilite los errores remotos

I execute the dataset in DB and works fine, is there something that i must install on the new server? or what should i do to fix the error?

Thank you in advanced

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,918 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,581 Reputation points
    2021-07-16T01:51:23.703+00:00

    Hi @Medina Canton Fernando Maximiliano Jose ，

    You could check by the following points:

    • Make sure you could connect your data source.
    • Check if there is anything wrong with your stored procedure, you could run the stored procedure in SSMS.
    • Check if there is something wrong with your report structure design. You could use a useful dataset to test.
    • Make sure the user have enough permission to access the data source. If the SQL Server instance is installed in remote server, please specify the SQL Server allow remote access.
    • Use embedded data sources instead of shared data sources

    Also refer to this link: https://stackoverflow.com/questions/10847054/ssrs-query-execution-failed-for-dataset

    In SSRS2017, you could find detailed error information in the following default path. If the above steps did not resolve your issue, please share the following error log: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.

    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Medina Canton Fernando Maximiliano Jose 1 Reputation point
    2021-07-16T15:59:36.637+00:00

    Hi, thank you for your answer,

    I have tried your recommendations, Data Source is working fine, there aren't store procedures, querys are embeded on the report, the report works fine in my machine, the problem occurs only when i deploy it on the server, and only with a few reports.

    Log File:

    library!ReportServer_0-17!1174!07/13/2021-18:10:11:: i INFO: Call to GetItemTypeAction(/Upstream/SISRED/COMUNES/Reporte Diario de Inyeccion de Agua). User: PEMEX\332715.
    library!ReportServer_0-17!2a8!07/13/2021-18:10:12:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = StyleSheet
    library!ReportServer_0-17!2a8!07/13/2021-18:10:12:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = StyleSheet (success)
    library!ReportServer_0-17!2a8!07/13/2021-18:10:13:: i INFO: Call to GetItemTypeAction(/Upstream/SISRED/COMUNES/Reporte Diario de Inyeccion de Agua). User: PEMEX\332715.
    library!ReportServer_0-17!2a8!07/13/2021-18:10:13:: i INFO: RenderForNewSession('/Upstream/SISRED/COMUNES/Reporte Diario de Inyeccion de Agua')
    processing!ReportServer_0-17!2a8!07/13/2021-18:10:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error de ejecución de consulta para el conjunto de datos 'SISRED'. ---> System.ArgumentException: Enlace de parámetros no válido
    Parameter name: 48
    at OracleInternal.ServiceObjects.OracleCommandImpl.GetBindByPositionBasedParameterCollection(OracleParameterCollection orclParamColl, ArrayList placeHolderCollection)
    at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF)
    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
    --- End of inner exception stack trace ---;
    processing!ReportServer_0-17!2a8!07/13/2021-18:10:13:: e ERROR: An exception has occurred in data set 'SISRED'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error de ejecución de consulta para el conjunto de datos 'SISRED'. ---> System.ArgumentException: Enlace de parámetros no válido
    Parameter name: 48
    at OracleInternal.ServiceObjects.OracleCommandImpl.GetBindByPositionBasedParameterCollection(OracleParameterCollection orclParamColl, ArrayList placeHolderCollection)
    at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF)
    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
    --- End of inner exception stack trace ---
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.<>c__DisplayClass1.<RunLiveQuery>b__0()
    at Microsoft.ReportingServices.Diagnostics.Utilities.DefaultActivitiesFactory.CreateSyncActivityAndReportResult(RSActivityType activityType, Action action)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.RunLiveQuery(List1 queryParams, Object[] paramValues) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(List1 queryParams, Object[] paramValues)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.InitializeAndRunLiveQuery()
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.InitializeRowSourceAndProcessRows(ExecutedQuery existingQuery)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.Process(ExecutedQuery existingQuery)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.ProcessConcurrent(Object threadSet)
    processing!ReportServer_0-17!2a8!07/13/2021-18:10:13:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!ReportServer_0-17!1c5c!07/13/2021-18:10:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RESPONSABLES'. ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-01013: el usuario ha solicitado la cancelación de la operación actual
    at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
    at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF)
    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
    at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
    --- End of inner exception stack trace ---;
    processing!ReportServer_0-17!1c5c!07/13/2021-18:10:13:: e ERROR: An exception has occurred in data set 'RESPONSABLES'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RESPONSABLES'. ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-01013: el usuario ha solicitado la cancelación de la operación actual
    processing!ReportServer_0-17!1c5c!07/13/2021-18:10:13:: i INFO: Some other thread has already aborted processing.
    processing!ReportServer_0-17!1ef4!07/13/2021-18:10:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SISRED'. ---> Oracle.ManagedDataAccess.Client.OracleException: Timeout de solicitud de conexión
    at OracleInternal.ConnectionPool.PoolManager3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, String instanceName) at OracleInternal.ConnectionPool.PoolManager3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
    at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
    at OracleInternal.ConnectionPool.OracleConnectionDispenser3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword) at Oracle.ManagedDataAccess.Client.OracleConnection.Open() at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5.<OpenConnection>b__4() --- End of inner exception stack trace ---; processing!ReportServer_0-17!1ef4!07/13/2021-18:10:28:: e ERROR: An exception has occurred in data set 'ACTIVO'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SISRED'. ---> Oracle.ManagedDataAccess.Client.OracleException: Timeout de solicitud de conexión processing!ReportServer_0-17!1ef4!07/13/2021-18:10:28:: i INFO: Some other thread has already aborted processing. processing!ReportServer_0-17!2a8!07/13/2021-18:10:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: [AbnormalTermination:ReportProcessing], Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error de ejecución de consulta para el conjunto de datos 'SISRED'. ---> System.ArgumentException: Enlace de parámetros no válido Parameter name: 48 at OracleInternal.ServiceObjects.OracleCommandImpl.GetBindByPositionBasedParameterCollection(OracleParameterCollection orclParamColl, ArrayList placeHolderCollection) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText) --- End of inner exception stack trace --- at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.<>c__DisplayClass1.<RunLiveQuery>b__0() at Microsoft.ReportingServices.Diagnostics.Utilities.DefaultActivitiesFactory.CreateSyncActivityAndReportResult(RSActivityType activityType, Action action) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.RunLiveQuery(List1 queryParams, Object[] paramValues)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(List1 queryParams, Object[] paramValues) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.InitializeAndRunLiveQuery() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.InitializeRowSourceAndProcessRows(ExecutedQuery existingQuery) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.Process(ExecutedQuery existingQuery) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.ProcessConcurrent(Obje processing!ReportServer_0-17!2a8!07/13/2021-18:10:28:: w WARN: Data source 'SISRED': Report processing has been aborted. processing!ReportServer_0-17!2a8!07/13/2021-18:10:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: [AbnormalTermination:ReportProcessing], Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error de ejecución de consulta para el conjunto de datos 'SISRED'. ---> System.ArgumentException: Enlace de parámetros no válido Parameter name: 48 at OracleInternal.ServiceObjects.OracleCommandImpl.GetBindByPositionBasedParameterCollection(OracleParameterCollection orclParamColl, ArrayList placeHolderCollection) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText) --- End of inner exception stack trace --- at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.<>c__DisplayClass1.<RunLiveQuery>b__0() at Microsoft.ReportingServices.Diagnostics.Utilities.DefaultActivitiesFactory.CreateSyncActivityAndReportResult(RSActivityType activityType, Action action) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.RunLiveQuery(List1 queryParams, Object[] paramValues)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(List1 queryParams, Object[] paramValues) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.InitializeAndRunLiveQuery() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.InitializeRowSourceAndProcessRows(ExecutedQuery existingQuery) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.Process(ExecutedQuery existingQuery) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.ProcessConcurrent(Obje library!ReportServer_0-17!2a8!07/13/2021-18:10:28:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error de ejecución de consulta para el conjunto de datos 'SISRED'. ---> System.ArgumentException: Enlace de parámetros no válido Parameter name: 48 at OracleInternal.ServiceObjects.OracleCommandImpl.GetBindByPositionBasedParameterCollection(OracleParameterCollection orclParamColl, ArrayList placeHolderCollection) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText) --- End of inner exception stack trace --- at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.<>c__DisplayClass1.<RunLiveQuery>b__0() at Microsoft.ReportingServices.Diagnostics.Utilities.DefaultActivitiesFactory.CreateSyncActivityAndReportResult(RSActivityType activityType, Action action) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.RunLiveQuery(List1 queryParams, Object[] paramValues)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(List`1 queryParams, Object[] paramValues)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.InitializeAndRunLiveQuery()
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.InitializeRowSourceAndProcessRows(ExecutedQuery existingQuery)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.Process(ExecutedQuery existingQuery)
    at Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.ProcessConcurrent(Object threadSet)
    --- End of inner exception stack trace ---
    at Microsoft.ReportingServices.OnDemandProcessing.AbortHe
    library!WindowsService_28!2a8!07/13/2021-18:17:28:: i INFO: Call to CleanBatch()
    library!WindowsService_28!2a8!07/13/2021-18:17:29:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
    library!WindowsService_28!2a8!07/13/2021-18:17:29:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-17!1174!07/13/2021-18:20:35:: i INFO: Call to TestConnectForDataSourceDefinitionAction(). User: PEMEX\314007.
    processing!ReportServer_0-17!1174!07/13/2021-18:20:35:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos ''. ---> System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.
    at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
    at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
    at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
    at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
    at System.Data.OleDb.OleDbConnection.ConnectionString_Set(DbConnectionPoolKey key)
    at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
    at Microsoft.ReportingServices.DataExtensions.ConnectionExtension.Open()
    at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5.<OpenConnection>b__4()
    --- End of inner exception stack trace ---;
    library!ReportServer_0-17!1bac!07/13/2021-18:20:54:: i INFO: Call to TestConnectForDataSourceDefinitionAction(). User: PEMEX\314007.
    library!WindowsService_28!191c!07/13/2021-18:27:29:: i INFO: Call to CleanBatch()
    library!WindowsService_28!191c!07/13/2021-18:27:29:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
    library!WindowsService_28!191c!07/13/2021-18:27:29:: i INFO: Call to CleanBatch() ends

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.