Data exports for Windows OS agent fails with "Error 219 happened in endProcessSample"

Technote (troubleshooting)


Problem(Abstract)

Warehouse Proxy Agent (WPA) logs contain the "Error 219" message and the Warehouse Proxy workspace in the TEP client displays "CTX_JavaError" messages.

Example of information in WPA log:
(5058CA36.0026-3F:khdxdaex.cpp,622,"processExport") Error 219 happened
in endProcessSample for originnode Primary:hostname1:NT and object
NT_Logical_Disk (table WTLOGCLDSK appl KNT)

Cause

The data being exported is in a format that does not match the data definition for the column within the database table.

Diagnosing the problem

Using the tablename in the WPA log, confirm the data definition for the columns of the table using the DB2 DESCRIBE command. Focusing on the columns where the "Data Type" is "INTEGER" and the "Column Name" ends with "_64".

Resolving the problem

The DB2 ALTER command can be used to alter the "Data Type" for the offending columns. The DB2 ALTER command should be run by the DB2 Administrator.


ex:
DB2> alter table "NT_LOGICAL_DISK" alter column "File_Control_Bytes/Sec_64" set data type BIGINT;

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Monitoring
Tivoli Distributed Monitoring

Software version:

All Versions

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1615652

Modified date:

2012-10-29

Translate my page

Machine Translation

Content navigation