Error Diagnosis

Diagnostic information including error messages generated during the execution of the ODBC Extension or Oracle Extension is written to log files.

These messages are used by administrators and Micro Focus Product Support representatives.

Extension Technology Log Files

The Data Express Extension Technology generates three log files: dxe_errorlog.txt, dxe_summarylog.txt, and dxe_statistics.txt, which are stored in a subdirectory of the log directory. For details, see Extension Technology Directories.

dxe_errorlog.txt

The dxe_errorlog.txt file contains some processing information as well as information on any errors that have occurred during the processing. The level of detail displayed in this log is controlled by the LogLevel configuration option.

A sample of the dxe_errorlog.txt file with LogLevel set to 1 is shown:

 Initialization: populating Data Express Knowledge Base 
 ----------------------------------------------------------------------------- 
Processing table GSDEMO.SRC.CSTOMER 
SQLCODE=-28,SQLSTATE=S0002:[XDB][Micro Focus XDB ODBC 32-Bit Driver][GSDEMO]X28 
Cannot find table/view/synonym 'SRC.CSTOMER'. 
DE-0074: Unable to SELECT from table in the source database. 
Ensure that the database permissions provide the 'install' user with SELECT
 privileges.
 Summary: TableID=2 TableName=GSDEMO.SRC.CSTOMER TotalCount=0 ReducedTo=0 CpuTime=
170340.391000 ElapTime=0.000000
 ----------------------------------------------------------------------------- 
Processing table GSDEMO.SRC.EMPLOYEE 
Summary: TableID=4 TableName=GSDEMO.SRC.EMPLOYEE TotalCount=10 ReducedTo=10 
CpuTime=1.153000 ElapTime=0.000000

A sample of the dxe_errorlog.txt file with LogLevel set to 3 is shown:

 Initialization: populating Data Express Knowledge Base 
 ------------------------------------------------------------------- 
Processing table GSDEMO.SRC.CSTOMER 
dxestart: executing dxeinit GSDEMO.SRC.CSTOMER | dxeextracter GSDEMO.
CSTOMER 1 1 28216 "DATAEXPRSS" 1 1 1 | UDCZIP5 GSDEMO.SRC.CSTOMER |
dxewriter GSDEMO.SRC.CSTOMER 'N' 1 | dxefinal 0 1 2 "DATAEXPRSS"
"DataExpress_Business_Protection" '0' 'N' 1
SQLCODE=-28,SQLSTATE=S0002:[XDB][Micro Focus XDB ODBC 32-Bit Driver]
[GSDEMO]X28 Cannot find table/view/synonym 'SRC.CSTOMER'. 
DE-0074: Unable to SELECT from table in the source database.
Ensure that the database permissions provide the 'install' user with 
SELECT privileges.
Summary: TableID=2 TableName=GSDEMO.SRC.CSTOMER TotalCount=0 
ReducedTo=0 CpuTime=170340.406000 ElapTime=0.000000
 -------------------------------------------------------------------
Processing table GSDEMO.SRC.EMPLOYEE
dxestart: executing dxeinit GSDEMO.SRC.EMPLOYEE | dxeextracter 
GSDEMO.SRC.EMPLOYEE 1 1 28216 "DATAEXPRSS" 1 1 1 | UDCZIP5 
GSDEMO.SRC.EMPLOYEE | dxewriter GSDEMO.SRC.EMPLOYEE 'N' 1 | 
dxefinal 1 1 4 "DATAEXPRSS" "DataExpress_Business_Protection"
 '0' 'N' 1
Extracter: executing SELECT DSE_TABLE.* FROM SRC.EMPLOYEE DSE_TABLE
Writer: executing DROP TABLE TGT.EMPLOYEE
Writer: executing CREATE TABLE TGT.EMPLOYEE (E_NO SMALLINT 
NOT NULL, LNAME CHAR(10) NOT NULL, FNAME CHAR(10) NOT NULL, STREET 
CHAR(20), CITY CHAR(15), ST CHAR(2), ZIP CHAR(5), DEPT CHAR(4), 
PAYRATE DECIMAL(15, 2), COM DECIMAL(2, 2)) 
Writer: executing INSERT INTO TGT.EMPLOYEE (E_NO, LNAME, FNAME, 
STREET, CITY, ST, ZIP, DEPT, PAYRATE, COM) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?)
Summary: TableID=4 TableName=GSDEMO.SRC.EMPLOYEE TotalCount=10
ReducedTo=10 CpuTime=1.138000 ElapTime=0.000000

Note: Following an abnormal termination, Data Express prompts you to view the dxe_errorlog.txt file. Answer Yes at the prompt to view the file in Notepad (Windows) or cat file |more (UNIX).

The dxe_summarylog.txt file provides a brief summary of the data stores processed during subset extraction with statistics on the number processed and processing time.

A sample of the dxe_summarylog.txt file is shown:

 Machine ID:3 Method:SIMPLE TestRun:'N' Date:20090302 
Description:SIMPLE					 
 STEP   TABLEID   TABLE NAME          ROWS      CPU TIME  ELAPSED TIME
                                ORIGINAL   OUTPUT
 --------------------------------------------------------------------------
 10      2         xdb.SRC.CUSTOMER    21   6    1.23      1.00
 20      6         xdb.SRC.ORDERS       5   3    0.80      0.00 
 30      5         xdb.SRC.ITEMS        8   5    0.75      1.00

The dxe_statistics.txt file provides a brief summary of the data stores processed during subset extraction similar to the dxe_summarylog.txt. However, the dxe_statistics.txt file is used by the Distributed Statistics Loader to populate run-time statistics into Data Subset Extraction and is not intended for viewing even though it is human-readable.