Compare fails with Oracle "Error 904 ORA-00904" as seen in the *declt* log on target (4291754)

Compare processes errors out as seen in "show compare" output. Compare logs on source (*desvr* log) and target (*declt* log), show the following:

*desvr* log:

146: Warning: Call to read 8 bytes (de_sock_read,L909), unexpectedly returned 0 bytes.
146:        Process writing may have exited with an error.
146: The warnings may due to either "compare cancel"command or network errors.
146: Error 1 calling de_sock_read (de_msg_receive_header,L191)
146: Error 1 calling de_msg_receive_header (de_msg_receive_nodata_msg,L1571)
146: Status : Error
146: Error 1 calling de_msg_receive_nodata_msg in de_compare_server (1715)

*declt* log:

000: COMPARE CURRENT STATUS:Thu Dec 11 23:05:17 2008 (elapsed 0.390000 seconds), ready to fetch first batch, including the order by sorting. (de_batch_setup,L1093:de_log_line,L323)
000: Oracle Error 904: ORA-00904: "COLUMN_NAME": invalid identifier

000: Error ORA-904 calling OCIStmtExecute (de_lob_get_length,L1484)
000: Oracle Warning 904: ORA-00904: "COLUMN_NAME": invalid identifier

000: Error ORA-904 calling de_lob_get_length (de_lob_read,L1091)
000: Error 1 calling de_lob_read (de_select_specCol,L398)
000: Error 1 calling de_select_specCol (de_select_fetch_rows,L1823)
000: Error 1 calling de_select_fetch_rows in de_batch_setup