Hello Experts,
Today our CRM server reports started to fail (these had previously been working for 1year+ without issue).
on the CRM server we see the following error when trying to generate any report.
report cannot be generated please contact your administrator
If we go direcly to the SQL reporting server and try to generate a report we see the following:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Other functions of CRM appear to be funtioning normally as do other databases on the database server.
there are no obvious errors in the eventlog of the database server however on the CRM server we see the following in the event log.
Web service request SetParameters to Report Server <server> failed with SoapException. Error: Execution 'mxdk2s451qiukfyvopm5biul'
cannot be found (rsExecutionNotFound)
Report Server (MSSQLSERVER) cannot connect to the report server database.
CrmKeyGenerator encountered an error generating/monitoring key type System.Data.SqlClient.SqlE
xception: The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
at System.Data.ProviderBase.D
bConnectio
nPool.GetC
onnection(
DbConnecti
on owningObject)
at System.Data.ProviderBase.D
bConnectio
nFactory.G
etConnecti
on(DbConne
ction owningConnection)
at System.Data.ProviderBase.D
bConnectio
nClosed.Op
enConnecti
on(DbConne
ction outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlC
onnection.
Open()
at Microsoft.Crm.CrmDbConnect
ion.Open()
at Microsoft.Crm.SharedDataba
se.Databas
eService.R
etrieve(St
ring tableName, String[] columns, PropertyBag[] conditions)
at Microsoft.Crm.SharedDataba
se.Databas
eService.R
etrieveByI
d(String tableName, Object id, String[] columns)
at Microsoft.Crm.CrmKeySettin
g.LoadSett
ingsBag()
at Microsoft.Crm.CrmKeySettin
g.Initiali
ze(Boolean
loadSettingsFromConfigDB, Guid scaleGroupId, ConfigSku configSku)
at Microsoft.Crm.CrmKeySettin
g.LoadKeyS
etting(Crm
KeyType keyType, Boolean useCachedValues, Guid scaleGroupId)
at Microsoft.Crm.CrmKeySettin
g.LoadKeyS
etting(Crm
KeyType keyType, Boolean useCachedValues)
at Microsoft.Crm.CrmKeyGenera
tor.DoMana
geKeys(Gui
d scaleGroupId). Check event log to see if keys are being generated properly. KeySetting : %2. Error : %3
For more information, see Help and Support Center at
vent code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/5/2011 11:15:51 AM
Event time (UTC): 9/5/2011 10:15:51 AM
Event ID: a0592ad60cb64386b9ef84eae4
cd29d3
Event sequence: 22
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/ROOT-1-1295969
1318718750
0
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: <server>
Process information:
Process ID: 3240
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: CrmReportingException
Exception message: Execution 's1xolifz2k5rarbbtocqkazh'
cannot be found (rsExecutionNotFound)
Request information:
Request URL:
http://<server>/CRMReports/rsview
er/reportv
iewer.aspx
Request path: /<folder>CRM/CRMReports/rs
viewer/rep
ortviewer.
aspx
User host address: <iP address>
User: <username>
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Crm.Web.Reportin
g.SrsRepor
tViewer.Co
nfigurePag
e()
at Microsoft.Crm.Application.
Controls.A
ppUIPage.O
nPreRender
(EventArgs
e)
at System.Web.UI.Control.PreR
enderRecur
siveIntern
al()
at System.Web.UI.Page.Process
RequestMai
n(Boolean includeStagesBeforeAsyncPo
int, Boolean includeStagesAfterAsyncPoi
nt)
Custom event details:
For more information, see Help and Support Center at
Our community of experts have been thoroughly vetted for their expertise and industry experience.