Hi all
I've just started working in a company who haven't had a database administrator in a very long time, therefore I am starting to use tools that haven't been used before. It's an incredibly frustrating experience, especially given that our network support aren't being every helpful. I would be grateful for any advice or recommendations so I can go back to our network support and tell them exactly what they need to be doing to resolve this. We are on v11.
My first problem is the Web Report Server - it's intermittently working. When running a SSRS report via Tessitura, the user is asked for their login details. When you log in you get an error message - our network support say it's me but other users are experiencing the same problem:
Exception of type 'System.Web.HttpUnhandledException' was thrown.There was an error processing this request. Please check the details below.The authentication token is not valid. Please retry with a valid token.
My next problem is the below error message. This appears when I try to run a new SSRS custom report. I know there is something wrong with the dataset (I don't know exactly what because I can't access the error logs) but I get this error message when first opening the report - any ideas:
Thanking everyone in advance
This may or may not be helpful, but I think you may need to sit down with your network people and figure out exactly who is responsible for what, when it comes to application configuration and support. I'm the sole DBA for my organization, and my network guys' jobs are done when the servers are running and backed up, and the IPs and domain names are pointing to the right place. Everything beyond that, from installing the server applications to getting the client to run on a staff machine, is essentially on me, and so I have a level of access to those servers that allows me to do my job.
Someone may be able to chime in with a "to solve your problem do x" answer, but ultimately if there's an organizational issue here causing "not my job" syndrome, your efforts spent solving that problem will yield results far more valuable.
Hi Lee-Ann,
I have seen the authentication token issue several times before. I initially saw this when generating the Plan Summary standard Tessitura report, and at that point it was a problem with timeout. I opened a ticket with TASK at the time and they helped me change the timeout settings.
However if you're seeing it on multiple reports, it is likely not a timeout problem. I have seen the same error in our Test environment, and TASK again assisted me in resolving it with a number of troubleshooting steps. Ultimately, I had to change the bindings settings on the site running the WebReports service in IIS on the SSRS server.
So I guess I'd say TASK is your best bet! If yuo're an IIS newbie (like myself) they can guide you through the troubleshooting process.
And I agree with Nick on sorting out whose business is whose with network admin! Good luck!
Thanks Nick.
I've already had that discussion with them. Unfortunately this is all their job, they're not open to me having that type of access - it's an external company we use. It's under discussion, internally.
Thanks Frances, I will raise on TASK :)
I had the problem with the login issue before. Try this: https://pinwang611.wordpress.com/2009/10/13/ssrs-2008-website-keep-asking-to-enter-username-and-password/
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Lee-Anne Inglis Sent: Thursday, August 06, 2015 12:26 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] Custom Report Error & Web Report Server Problems
From: Frances O'Connell <bounce-francesoconnell1133@tessituranetwork.com> Sent: 8/6/2015 12:02:28 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!