Skip to Content

Crystal Closing without Crash Message in Database Expert when browsing connected database tables

Recently changes were made to allow us to run Crystal against a specific database through eVPN from home.

Prior to the change everything worked perfectly from virtual machines or on site but not through the eVPN.

Post change we can now run reports and even modify them using existing tables from virtual machines, on site, or through the eVPN.

However if we try to use the Database Expert to view new tables to pull into reports Crystal closes without any message from virtual machines, onsite or the eVPN.

Crystal still works properly when connecting to other data sources.

Can anyone tell me what might be causing this behavior difference now?

What does Crystal do differently when browsing with the Databse Expert than connecting to run a report?

What might the connection teams have configured incorrectly when modifying the tunnel connecting us to this database.

I am running Crystal Reports 11.5.8.826

Add a comment
10|10000 characters needed characters exceeded

  • Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

    Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

    Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

    Best regards

    Mynyna

    SAP Community moderator

Related questions

2 Answers

  • Posted on Jul 30, 2020 at 02:28 PM

    We used to have similar problem with IBM DB2 ODBC driver:

    https://apps.support.sap.com/sap/support/knowledge/public/en/1621593

    it required Write Access permission.

    Note: look for registry keys

    • For Crystal Reports XI R2:
      • HKEY_LOCAL_MACHINE\Software\Wow6432Node\Business Objects\Suite 11.5\ (on 64 bit OS)
      • HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\ (on 32 bit OS)
      • HKEY_CURRENT_USER\Software\ Business Objects\Suite 11.5\
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 31, 2020 at 06:14 AM


    Unfortunately that is not the current situation. It is not the act of adding tables that causes issues. It is the act of attempting to view the tables in the first place. It is also something that was working prior to tunnel changes and stopped working after though the firewall team cannot determine the cause.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.