Start of Content Area

Background documentation Localizing Errors  Locate the document in its SAP Library structure

The preview function that is available when you process a DataSource enables you to identify potential problems before you actually load the data. If you notice in the preview that the data is incorrect, the following options are available to help you localize the error:

...

       1.      In the database management system (DBMS), use a SELECT command for a view to check which data is going to be delivered. Using a command-line tool on the database server, for example SQLPLUS for Oracle or db2 for IBM DB2/390, you can use this same SELECT command to test whether the data that has been read is correct. If you find an error, fix it in the DBMS.

       2.      If the error is not in the DBMS, use one of the command-line tools on the BI application server to establish a connection to the DBMS as a BI user. Use the SELECT command to test whether the DB client on the BI application server can see the data and whether this data is correct. If the DB client cannot see the data, it is likely that there is a connection error.

       3.      If the DB client on the BI application server can see the data and the data is correct, the error is in the BI system.

This graphic is explained in the accompanying text

 

End of Content Area