Hi Team,
All of my SSRS post reports keep returning this error. Everything I have researched states I need to uninstall SQL and all its components, clean up the registry and reinstall SQL. I am really trying to avoid that if at all possible.
When I run the reports this is the error I get in Tessitura:
ErrorAn error occurred during the automatic redirect. Error: Object reference not set to an instance of an object.
All of my URL reports run fine and of course all run fine from the report manager.
If there is anyone who can save me the headache of a rebuild, I would appreciate it. I'll even send cookies...
Naomi
Andrew,
I found that it wasn’t the database that was incorrect in the config file it was the user name and password, even a space will throw it off. I had a space where it shouldn’t have been, that is what resolved it for me.
Thank you and have a great day!
Naomi Williams
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Andrew Grady Sent: Wednesday, August 25, 2010 2:34 PM To: Naomi Williams Subject: RE: [Tessitura Technical Forum] SSRS Post Report Error
Naomi, how did you end up resolving the "Object reference not set to an instance of an object" error? I'm getting the same thing and I double-checked the SSRS Proxy web.config and everything appears to be in order.
From: Naomi Williams <bounce-naomiwilliams9587@tessituranetwork.com> Sent: 9/3/2009 4:12:29 PM
This is the error I am getting now. This report does not pass any token parameters. It is the order profile report you have as a sample.
Error
An error occurred during the automatic redirect.
Error:
Keyword not supported: 'userid'.
Thank you have a good day!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps Sent: Thursday, September 03, 2009 4:01 PM To: Naomi Williams Subject: RE: [Tessitura Technical Forum] SSRS Post Report Error
Sounds to me like you may have a data connection issue then. Check the Web.Config for the TessituraSSRSProxy to ensure that it’s set to the proper database. It should be set using a SQL login with rights to the impusers role as it needs to access the report database tables.
______________________________________
Ryan Creps
Network Developer |Tessitura Network, Inc
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Thursday, September 03, 2009 11:31 AM To: Ryan Creps Subject: RE: [Tessitura Technical Forum] SSRS Post Report Error
Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps Sent: Thursday, September 03, 2009 1:21 PM To: Naomi Williams Subject: RE: [Tessitura Technical Forum] SSRS Post Report Error
Are you passing any parameters from the Tessitura report parameters window? Any token environment parameters like User Group or Company Name?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Thursday, September 03, 2009 11:06 AM To: Ryan Creps Subject: [Tessitura Technical Forum] SSRS Post Report Error
Error An error occurred during the automatic redirect. Error: Object reference not set to an instance of an object.
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!
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.75/2341 - Release Date: 09/03/09 05:50:00
Ah, I figured out my problem and thought I'd post it for future reference. I had modified the 'add name = ...' value from 'Tessdb' to 'Tessitura'. Apparently it didn't like that. I was thinking it was asking for the server name there.