Execution '03h0ey55ecsptk55t00aio55' cannot be found.

Discussion:

(too old to reply)

max

2009-03-02 14:14:29 UTC

Hello to everyone,

I'm facing to a problem related to SSRS - when reports are executed I get
following message:

Execution '03h0ey55ecsptk55t00aio55' cannot be found

This problem occurs everytime, for every report (no matter if the report is
data based). SSRS logs the error in this form:

w3wp!session!8!02/27/2009-09:44:34:: i INFO: LoadSnapshot: Item with
session: dejkjg3foperhmaxgcfp0g45, reportPath:
/XYZ_MSCRM/4.0/{796657d5-1d04-de11-a4be-00237d339ab0}, userName: NT
AUTHORITY\NETWORK SERVICE not found in the database
w3wp!library!8!02/27/2009-09:44:34:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found, ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found
w3wp!webserver!8!02/27/2009-09:44:34:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found

I've tried to upload two simple test reports - one with just one static
label and one with a simple one-column list - but the same problem occurs
for both of them. Strange thing is that in Visual Studio are the reports
working without problems, the problem appears as soon as they are deployed
to the Report Server.

You get many hits when searching using Google, but no solution has been
found yet. Does anybody know what could cause such a problem aand to resolve
it?

Thanks,
mac

Elale

2009-03-02 19:56:12 UTC

Permalink

Hi Max,
this part of the error "userName: NT AUTHORITY\NETWORK SERVICE not found in
the database" seems to be security related. Usually the IIS application pool
is configured using the Network Service account. Does this user has access to
the DB your report is using ? if so, does your report uses the loged user to
retrieve information for that user (like user 1 only can see this and that,
user 2 this and that, etc)? perhaps the server is passing the Network Service
account ...

Post by max
Hello to everyone,
I'm facing to a problem related to SSRS - when reports are executed I get
Execution '03h0ey55ecsptk55t00aio55' cannot be found
This problem occurs everytime, for every report (no matter if the report is
w3wp!session!8!02/27/2009-09:44:34:: i INFO: LoadSnapshot: Item with
/XYZ_MSCRM/4.0/{796657d5-1d04-de11-a4be-00237d339ab0}, userName: NT
AUTHORITY\NETWORK SERVICE not found in the database
w3wp!library!8!02/27/2009-09:44:34:: e ERROR: Throwing
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found, ;
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found
w3wp!webserver!8!02/27/2009-09:44:34:: e ERROR: Reporting Services error
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found
I've tried to upload two simple test reports - one with just one static
label and one with a simple one-column list - but the same problem occurs
for both of them. Strange thing is that in Visual Studio are the reports
working without problems, the problem appears as soon as they are deployed
to the Report Server.
You get many hits when searching using Google, but no solution has been
found yet. Does anybody know what could cause such a problem aand to resolve
it?
Thanks,
mac

max

2009-03-03 10:22:43 UTC

Permalink

Thanks for the reply Elale,

unfortunately this is not the case - network service is configured as user
in both the ReportServer and ReportServerTempDB databases (in db_owner and
RSExecRole). Meanwhile I've configured the SSRS service to run under domain
user account as proposed for the Windows 2008 operating system (it's SBS
2008 to be more precious), but with no luck, the problem remains
independently of the account context the service is running under.

I was monitoring the traffic on the SQL server to see it there are some
failed logins audited - but everything seems to work fine, the designated
user has sufficient rights to access the databases and no login failed
appeared.

This situation is driving me crazy, I've checked all possible configuration
settings, generated new SSRS repository, reconfigured the report server
website (created new one), reinstalled & hotfixed Report Viewer
Redistributable package etc. - nothing helps.

Two more facts to point out:
1) When running the reports from Report Server (i.e. not from Report
Manager), the reports are working
2) When running Report Manager in Internet Explorer without administrator
priviledges (it's Windows 2008), access to the SSRS repository is denied:
"The permissions granted to user 'XYZ\myAdministrativeAccount' are
insufficient for performing this operation. (rsAccessDenied) Get Online
Help"

Some ideas?

Thanx,
max

Post by Elale
Hi Max,
this part of the error "userName: NT AUTHORITY\NETWORK SERVICE not found in
the database" seems to be security related. Usually the IIS application pool
is configured using the Network Service account. Does this user has access to
the DB your report is using ? if so, does your report uses the loged user to
retrieve information for that user (like user 1 only can see this and that,
user 2 this and that, etc)? perhaps the server is passing the Network Service
account ...

Elale

2009-03-03 11:39:01 UTC

Permalink

Hey Max, that's weird... It really seems like a security issue. What events
are you collecting wih the SQL profiler ? You won't see failed logins for the
Network Service account because that events are at first logon, not DB
access. You should grab all Errors and Warnings events and there you'll get
an access error or warning...

Post by max
Thanks for the reply Elale,
unfortunately this is not the case - network service is configured as user
in both the ReportServer and ReportServerTempDB databases (in db_owner and
RSExecRole). Meanwhile I've configured the SSRS service to run under domain
user account as proposed for the Windows 2008 operating system (it's SBS
2008 to be more precious), but with no luck, the problem remains
independently of the account context the service is running under.
I was monitoring the traffic on the SQL server to see it there are some
failed logins audited - but everything seems to work fine, the designated
user has sufficient rights to access the databases and no login failed
appeared.
This situation is driving me crazy, I've checked all possible configuration
settings, generated new SSRS repository, reconfigured the report server
website (created new one), reinstalled & hotfixed Report Viewer
Redistributable package etc. - nothing helps.
1) When running the reports from Report Server (i.e. not from Report
Manager), the reports are working
2) When running Report Manager in Internet Explorer without administrator
"The permissions granted to user 'XYZ\myAdministrativeAccount' are
insufficient for performing this operation. (rsAccessDenied) Get Online
Help"
Some ideas?
Thanx,
max

max

2009-03-03 12:12:34 UTC

Permalink

Well, you're probably talking about operating system, where a ticket is
issued to the login, not to the SQLS - the user, in which context the
service runs, logs in to the SQLS everytime when accessing DB. If not, you
would see constantly growing number of connections, signalizing a leak in
the code. That counts also for the situation where connection pooling is in
use (you could just see more open connections waiting to be recycled).

Anyway, I agree that this situation is weird - and there's still no light in
the tunnel...

Post by Elale
Hey Max, that's weird... It really seems like a security issue. What events
are you collecting wih the SQL profiler ? You won't see failed logins for the
Network Service account because that events are at first logon, not DB
access. You should grab all Errors and Warnings events and there you'll get
an access error or warning...

Post by max
Thanks for the reply Elale,
unfortunately this is not the case - network service is configured as user
in both the ReportServer and ReportServerTempDB databases (in db_owner and
RSExecRole). Meanwhile I've configured the SSRS service to run under domain
user account as proposed for the Windows 2008 operating system (it's SBS
2008 to be more precious), but with no luck, the problem remains
independently of the account context the service is running under.
I was monitoring the traffic on the SQL server to see it there are some
failed logins audited - but everything seems to work fine, the designated
user has sufficient rights to access the databases and no login failed
appeared.
This situation is driving me crazy, I've checked all possible
configuration
settings, generated new SSRS repository, reconfigured the report server
website (created new one), reinstalled & hotfixed Report Viewer
Redistributable package etc. - nothing helps.
1) When running the reports from Report Server (i.e. not from Report
Manager), the reports are working
2) When running Report Manager in Internet Explorer without administrator
"The permissions granted to user 'XYZ\myAdministrativeAccount' are
insufficient for performing this operation. (rsAccessDenied) Get Online
Help"
Some ideas?
Thanx,
max

Post by Elale
Hi Max,
this part of the error "userName: NT AUTHORITY\NETWORK SERVICE not
found
in
the database" seems to be security related. Usually the IIS application pool
is configured using the Network Service account. Does this user has
access
to
the DB your report is using ? if so, does your report uses the loged
user
to
retrieve information for that user (like user 1 only can see this and that,
user 2 this and that, etc)? perhaps the server is passing the Network Service
account ...

Post by max
Hello to everyone,
I'm facing to a problem related to SSRS - when reports are executed I get
Execution '03h0ey55ecsptk55t00aio55' cannot be found
This problem occurs everytime, for every report (no matter if the
report
is
w3wp!session!8!02/27/2009-09:44:34:: i INFO: LoadSnapshot: Item with
/XYZ_MSCRM/4.0/{796657d5-1d04-de11-a4be-00237d339ab0}, userName: NT
AUTHORITY\NETWORK SERVICE not found in the database
w3wp!library!8!02/27/2009-09:44:34:: e ERROR: Throwing
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found, ;
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found
w3wp!webserver!8!02/27/2009-09:44:34:: e ERROR: Reporting Services error
Execution 'dejkjg3foperhmaxgcfp0g45' cannot be found
I've tried to upload two simple test reports - one with just one static
label and one with a simple one-column list - but the same problem occurs
for both of them. Strange thing is that in Visual Studio are the reports
working without problems, the problem appears as soon as they are deployed
to the Report Server.
You get many hits when searching using Google, but no solution has been
found yet. Does anybody know what could cause such a problem aand to resolve
it?
Thanks,
mac