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?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

 

In the connection string of the TessituraSSRSProxy web.config….

connectionString="Data Source=SERVER\DATABASEINSTANCE;Initial Catalog=impresario;User ID=theuser;Password=thepass"

 

do you have “userid” instead of “User ID” as my connection string above?

 

 

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

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!

 

That did it! It was missing the space “UserId”. I must have skimmed right over it.

Thanks Ryan!

 

Naomi Williams

 

In the connection string of the TessituraSSRSProxy web.config….

connectionString="Data Source=SERVER\DATABASEINSTANCE;Initial Catalog=impresario;User ID=theuser;Password=thepass"

 

do you have “userid” instead of “User ID” as my connection string above?

 

 

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

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!

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/04/09 05:51:00

 

That did it! It was missing the space “UserId”. I must have skimmed right over it.

Thanks Ryan!

 

Naomi Williams

 

In the connection string of the TessituraSSRSProxy web.config….

connectionString="Data Source=SERVER\DATABASEINSTANCE;Initial Catalog=impresario;User ID=theuser;Password=thepass"

 

do you have “userid” instead of “User ID” as my connection string above?

 

 

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

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!

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/04/09 05:51:00

 

Fantastic.  Glad it’s working.

 

 

 

That did it! It was missing the space “UserId”. I must have skimmed right over it.

Thanks Ryan!

 

Naomi Williams

 

In the connection string of the TessituraSSRSProxy web.config….

connectionString="Data Source=SERVER\DATABASEINSTANCE;Initial Catalog=impresario;User ID=theuser;Password=thepass"

 

do you have “userid” instead of “User ID” as my connection string above?

 

 

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

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!

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/04/09 05:51:00

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!

 

Where am I sending cookies to?

 

Naomi Williams

 

Fantastic.  Glad it’s working.

 

 

 

That did it! It was missing the space “UserId”. I must have skimmed right over it.

Thanks Ryan!

 

Naomi Williams

 

In the connection string of the TessituraSSRSProxy web.config….

connectionString="Data Source=SERVER\DATABASEINSTANCE;Initial Catalog=impresario;User ID=theuser;Password=thepass"

 

do you have “userid” instead of “User ID” as my connection string above?

 

 

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

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!

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/04/09 05:51:00

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!

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/04/09 05:51:00

 

You can soft credit them to your staff.

J

 

 

Where am I sending cookies to?

 

Naomi Williams

 

Fantastic.  Glad it’s working.

 

 

 

That did it! It was missing the space “UserId”. I must have skimmed right over it.

Thanks Ryan!

 

Naomi Williams

 

In the connection string of the TessituraSSRSProxy web.config….

connectionString="Data Source=SERVER\DATABASEINSTANCE;Initial Catalog=impresario;User ID=theuser;Password=thepass"

 

do you have “userid” instead of “User ID” as my connection string above?

 

 

 

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'.

 

 

Naomi Williams

 

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.

 

 

 

Yes all the reports have parameters in all the reports that pass from the Tessitura report parameter window, and token environment parameters as well.

 

Naomi Williams

 

Are you passing any parameters from the Tessitura report parameters window?  Any token environment parameters like User Group or Company Name?

 

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

 

 

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:

Error
An 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

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

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!

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

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!

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

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!

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/04/09 05:51:00

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!

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/04/09 05:51:00

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!