Here is the output,

I'm now further confused as TBLLAMPALARMS doesn't even contain a field
called STATEVALUE, although several other tables do. When I used 1.5 it also
had the same problem with STATEVALUE but gave a table that contains a field
of that name (don't still have the logs from that)


Connecting to: 'localhost' as 'sysdba'...Connected.
Reading charset: UTF8, disconnecting...ok.
Reconnecting with new charset...Connected.
Connecting to: 'localhost' as 'sysdba'...Connected.
Reading charset: UTF8, disconnecting...ok.
Reconnecting with new charset...Connected.
Disabling triggers...done.
New format detected.
Object TBLASSETHISTORY does not exist in destination db, skipping.
Checkpoint at 2000 rows.
Checkpoint at 4000 rows.
Checkpoint at 6000 rows.
Copying table: TBLUSERGROUPS
5 records copied and commited.
Copying table: TBLUSERS
6 records copied and commited.
<snip long list of tables that worked fine>

Copying table: TBLLAMPALARMS
644 recordCheckpoint at 2000 rows.
Checkpoint at 2000 rows.
Checkpoint at 4000 rows.
Checkpoint at 6000 rows.
Checkpoint at 8000 rows.
Checkpoint at 10000 rows.
Checkpoint at 12000 rows.
Checkpoint at 14000 rows.
Checkpoint at 16000 rows.
Checkpoint at 2000 rows.
ERROR!
*** IBPP::WrongType ***
Context: RowImpl::GetValue
Message: Incompatible types.
BLOB and double
Error copying column number: 3, name: STATEVALUE
Checkpoint at 2000 rows.
Checkpoint at 4000 rows.
Checkpoint at 6000 rows.
Checkpoint at 8000 rows.
Checkpoint at 10000 rows.
Checkpoint at 12000 rows.
Checkpoint at 14000 rows.
Checkpoint at 2000 rows.
Checkpoint at 4000 rows.
Checkpoint at 6000 rows.
Checkpoint at 8000 rows.
Checkpoint at 10000 rows.
Checkpoint at 12000 rows.
Checkpoint at 14000 rows.
Checkpoint at 16000 rows.
Checkpoint at 18000 rows.
ERROR!
*** IBPP::WrongType ***
Context: RowImpl::GetValue
Message: Incompatible types.
BLOB and double
Error copying column number: 13, name: MSGBODY
s copied and commited.
Copying table: TBLLAMPSTATUS
1429 records copied and commited.
source defn
CREATE TABLE TBLLAMPALARMS (
ALARMID BIGINT NOT NULL,
ELEMENTID BIGINT,
OUTSTATIONID Integer,
ALARMTYPE Smallint NOT NULL,
ALARMTIME TIMESTAMP,
TARGETBAND Smallint DEFAULT 0,
ACTIVEPOWER Integer DEFAULT 0,
RECVDON TIMESTAMP DEFAULT 'NOW',
CONSTRAINT PK_TBLLAMPALARMS PRIMARY KEY (ALARMID)
);

destination defn
CREATE TABLE TBLLAMPALARMS (
ALARMID BIGINT NOT NULL,
ELEMENTID BIGINT,
OUTSTATIONID Integer,
ALARMTYPE Smallint NOT NULL,
ALARMTIME TIMESTAMP,
TARGETBAND Smallint DEFAULT 0,
ACTIVEPOWER Integer DEFAULT 0,
RECVDON TIMESTAMP DEFAULT 'NOW',
CONSTRAINT PK_TBLLAMPALARMS PRIMARY KEY (ALARMID)
);


[Non-text portions of this message have been removed]