3497026 - Error: "Connection closed without message (CM_NO_DATA_RECEIVED)" when refreshing a report in Crystal Reports based on SAP database containing a dot in it's name

• Error: "Connection closed without message (CM_NO_DATA_RECEIVED)"
• When refreshing a report in Crystal Reports, it fails with the error message.
• On the SAP System, a dump is generated for /CRYSTAL/OSQL_EXECUTE
• Can successfully refresh reports based on other SAP database in Crystal Reports.
• When refreshing a report based on an SAP data source, like SAP ECC, ERP,... Crystal Reports fails with the error:
    
     "Failed to retrieve data from database"
  
  Followed by:
  
     "Database Connector Error: Connection closed without message (CM_NO_DATA_RECEIVED)"

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
    
• SAP ECC
• SAP ERP

1. In Crystal Reports, create a new report.
2. In the "Database Expert", expand "Create New Connection"
3. In the list, double click on: "SAP Table, Cluster. or Function"
4. Logon to an SAP ECC System.
5. Add a Table to the report.
6. Add at least one database field to the report.
7. When refreshing the report, it fails with the error:
   
   "Failed to retrieve data from database"
   "Database Connector Error: Connection closed without message (CM_NO_DATA_RECEIVED)"

• It fails because the SAP ECC, or ERP database name selected contained a dot in its name. ( Example: my.database )
• Dot is used as a delimited, and therefore the incorrect database name is used to connect, which causes the error.

• On the SAP System ( Example:  SAP ECC, ERP,... ) rename the database, and remove the dot in the name.
  For example, use an underscore instead of the dot, or simply remove the dot.
  
  

1220084 - Error: 'Connection closed without message', when refreshing a report based on an SAP data source in Crystal Reports

CR, Crystal Report, ECC, Connection Closed without Message, CM_NO_DATA_RECEIVED, DUMP, /CRYSTAL/OSQL_EXECUTE , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem