“Error in Beas in location... : The conection is not possible [Database Provider Code 10709] ……”

This error can be linked with three main issues:

1. Workstation without crystal report or PDF viewer installed
2. Workstation with crystal report viewer corruptions
3. ODBC connection to server: Failed

For scenario a please proceed with the following steps:

1. On the SAP menu go under: Administration > System Initialization > Configuration Wizard

On the Configuration Wizard menu: Administration > Printing Crystal Reports: Use internal crystal report viewer

This field allows the user to select the option depending on the work station:

• To print as crystal report viewer: Flag checked
• To print as PDF file: Flag unchecked

2. Open SAP and Beas and try to print again the report

It is important to mention that if the workstation to use does not have PDF downloaded, it will not display the report and it will pop an error. The same thing will happen if the workstation does not have installed the report viewer. Please make sure you have PDF or crystal report viewer installed in the workstation

For scenario b please proceed with the following steps:

1. Check if the report viewer is installed:

When clicking clientsetup.exe on the PL installer, the viewer field must give the version number

2. If it is a version on this field, maybe the viewer is damaged. Please repair or reinstall the viewer

The installer is on the Beas folder, under C:\Beas\cdpatch9.2-003-000-000\cd\reportviewer

3. Select the option to repair the installation and follow the steps

4. Open SAP and Beas and try to print again the report

For scenario c please proceed with the following steps:

1. Open ODBC (32bits) on the computer. (ODBC32ad.exe). On the System DSN tab, please make sure that the system data source is created

2. Double click on the data source to check that the server port is written. If not, please write the specific port for HANA (hanab1:30015) and for MSSQL (The specific server address)

3. If the System Data Source is not created please click on ADD

4. Fill all fields with the proper information (For MSSQL the name is BEAS_SAP and for HANA is BEAS_HANA). The server for MSSQL is local and for HANA is hanab1:30015

5. Enter the user name and password to connect on the database

  6. Restart SAP and SAP and try again to print the crystal report