Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Universe - Connection Error

Hello,

I created a Universe based on a MySQL 5 database. I used an MySQL ODBC 5 connection to connect to the database. After creating the Universe I exported the universe to our Business Objects system.

Once uploaded I created a Crystal Report using the new universe. The report was developed on my local desktop and was published to the Business Objects system once completed.

The report runs properly when previewing locally in the Crystal Report designer, however, when trying to access the published report in Infoview I receive the following error:

Failed to open the connection. TSSI

Unable to retrieve Object.

Failed to open the connection. TSSI

I made sure I created the ODBC connection on the server, and checked to make sure that the information was identical. I also granted full access to my user within Business Objects, so I wouldn't have any restrictions on the report.

Unfortunately, none of these changes affected the outcome. If anyone is able to help, it would be appreciated.

Thank you,

replied

Hi Roy,

The connection has got stale....or we can say corrupted.

You can open the universe, edit the connection till the "Finish" button, and once again export the universe back to the repository, and try the reports again.

Or you can create a new connection.

-Shreyash.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question