Groups | Blog | Home
all groups > sql server reporting services > june 2004 >

sql server reporting services : New Subscriptions never show


Bart
6/21/2004 8:37:38 PM
If I select "New Subscription" and I select a delivery method and time and
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?

Bart

Daniel Reib [MSFT]
6/22/2004 10:25:18 AM
Not sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Bart
6/22/2004 2:14:30 PM
I got that fixed, but now I can't deliver the subscription.

The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.

It looks like an AuthZ problem, but I'm not sure how to resolve it.

Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files --->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
[quoted text, click to view]

Bart
6/22/2004 3:17:25 PM
It seems that after installing SP1, the problem was resolved. I will
continue testing.

Bart
[quoted text, click to view]

Roland
6/22/2004 9:57:48 PM
Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:

changed by
<name_of_the_user> [unknown]

For me the "unknown" is the key.

Please refer to news:execmMdVEHA.1472@TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.

r

Roland
6/22/2004 10:42:55 PM
Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.

Roland
6/26/2004 7:46:41 PM
[quoted text, click to view]

Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:

* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly

--- BUT ----

the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"

--- BUT ---- (Again)

if I login as admin I can view and edit the subscription.

I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?

roland

AddThis Social Bookmark Button