January 13, 2009 at 8:41 am
Hi all,
I have published a report on Report Server.
This report is based both on a SSAS (analysis services) cube data source.
On report server, report works correctly (I have added my username in Role=Full Control, in SSAS), but when I try to export it to excel, I have an error.
Other reports, with only relational database data source, are exported correctly to excel.
Thanks in advance for your help.
Best regards,
Arnaud
I had a look in event viewer, on server, there is a warning
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/13/2009 10:07:29 AM
Event time (UTC): 1/13/2009 9:07:29 AM
Event ID: 27506123ae3e46bdb7034a92eb763804
Event sequence: 50
Event occurrence: 3
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ReportServer-2-128763106454175905
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\
Machine name: CH00SR01
Process information:
Process ID: 4004
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: ReportServerException
Exception message: Pour obtenir plus d'informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.
Request information:
Request path: /ReportServer/Reserved.ReportViewerWebControl.axd
User host address: 172.22.6.251
User: EU\bouveresse-1
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace:
January 13, 2009 at 10:24 am
abouver (1/13/2009)
Exception message: Pour obtenir plus d'informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.
I apologize, but could you translate the message to English. I wish I were multi-lingual, but I know English and SQL and that's it.:D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 13, 2009 at 11:28 am
Sorry Jack and thanks for your help
Exception message: to obtain more information, access to report server on server or enable distant errors
this afternoon I have checked my datasource on ssas cube, I user the server service account.
It seems not possible to create a Credential as I did on relational db.
However, if I want to enable snapshots on this ssas report, system ask for Credential
it is very confusing for me ...
Do I add the Credential in Role of Analysis services, strange ...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply