Show TOC

Localizing ErrorsLocate this document in the navigation 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, you can use the following options to 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 IBMDB2/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 BW application server to establish a connection as a BW user to the DBMS. Use the SELECT command to test whether the DB client on the BW application server can see the data and whether this data is correct. If the DB client cannot see the data, there is probably a connection error.
  3. If the DB client on the BW application server can see the data, and this data is correct, the error is in the BW system.