Jimmy buenas tardes, te comento que he realizado todo lo que me indicaste y el problema continua, siguiendo tu recomendaciones, cree dos data sources uno dentro de la carpeta de la organizacion conn tipo de conexion Microsoft
SQL Server y que apunta a Data Source=dbyo1\crm;Initial Catalog=Temporal;Integrated Security=SSPI y otro dentro de la carpeta 4.0 que apunta al MSCRM Data Connector Connection String con un tipo de conexion Microsoft CRM Data Extension
estos son los tres log del visor de enventos que arroja el error:
Evento 1
Event Type: Error
Event Source: MSCRMReportingDataConnector
Event Category: None
Event ID: 19972
Date: 10/11/2010
Time: 12:31:12 PM
User: N/A
Computer: SERVIDOR02
Description:
Report data set execution failure. Error: Invalid object name 'dim.Dim_t_Temporal_Account'.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Evento 2
Event Type: Error
Event Source: MSCRMReporting
Event Category: None
Event ID: 19969
Date: 10/11/2010
Time: 12:31:12 PM
User: N/A
Computer: SERVIDOR02
Description:
Web service request SetDataSourceCredentials to Report Server
http://Servidor02:88/reportserver failed with SoapException. Error: Error al procesar el informe. (rsProcessingAborted)
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Evento 3 (Warning)
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 10/11/2010
Time: 12:31:12 PM
User: N/A
Computer: SERVIDOR02
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/11/2010 12:31:12 PM
Event time (UTC): 10/11/2010 5:31:12 PM
Event ID: 5c5777267852448299ddcd6b523eaef1
Event sequence: 759
Event occurrence: 3
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/ROOT-1-129312885651640170
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: SERVIDOR02
Process information:
Process ID: 12308
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: CrmReportingException
Exception message: Error al procesar el informe. (rsProcessingAborted)
Request information:
Request URL:
http://localhost:4040/CRMPRUEBAS/CRMReports/rsviewer/reportviewer.aspx
Request path: /CRMPRUEBAS/CRMReports/rsviewer/reportviewer.aspx
User host address: 127.0.0.1
User: FNGCO\AdminCRM
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 12
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport report)
at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Ya agregue los grupos de ejecucion (Private, User y SQL Group a la base de datos (Temporal) que estoy usando para la ejecucion de los reportes y tampoco me ha funcionado, encontre un kb
http://support.microsoft.com/kb/946585/ que habla de algo que no se si aplique en mi caso teniendo en cuenta que yo no estoy usando la base de datos del CRM sino una temporal, para mejorar el tema de
rendimiento en la ejecucion de los reportes.
Agradezco de antemano la ayuda que me pueda dar.
Saludos
Giovanny
Giovanny Salazar
