Home » Server Options » Streams & AQ » replication error - LCR contains a column of unsupported type
replication error - LCR contains a column of unsupported type [message #75699] Wed, 21 April 2004 23:00 Go to next message
Shawn Murphy
Messages: 1
Registered: April 2004
Junior Member
I'm getting the following error from my capture process after I've added a table (table def to follow). I already have other tables in this capture process that are replicating fine. Any insight would be appreciated. Thanks!

Error log:
knlcFillRow: LCR contains a column of unsupported type
Dumping internal row LCR
=(0x0001.008.00007dbc,0x0000.3f6b1063,0,,4, 04/21/2004 13:57:02)
knllhdmp: UBA LCR UBA 0X2.0X800021.0X8.0X0.0X2.0X44a7
lob offset = 0, lob size = 0
New column count 0
Old column count 0
error 902 in STREAMS process
ORA-00902: invalid datatype
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00902: invalid datatype

The table looks like this:
create table subscriptions
(id number(10,0) not null,
begin_date date,
active_status_code char(1) not null,
last_updated_date date not null,
subscription_dwnld_bal number(10,0) default 0,
subscription_dwnld_lic_bal number(10,0) default 0,
permanent_dwnld_lic_bal number(10,0) default 0,
stream_lic_bal number(10,0) default 0,
trial_offer_active_ind varchar2(255),
subscription_guid varchar2(255),
purchase_perm_dwnld_lic_bal number(10,0) default 0,
created_date date not null,
subscription_cycle_day_nbr number(10,0) default 0,
prod_offr_id number(10,0),
vd_subscription_dwnld_bal number(10,0) default 0,
vd_subscription_dwnld_lic_bal number(10,0) default 0,
vd_permanent_dwnld_lic_bal number(10,0) default 0,
vd_stream_lic_bal number(10,0) default 0,
vd_purchase_perm_dwnld_lic_bal number(10,0) default 0,
prod_offr_comp_id number(10,0),
renewal_date date,
renewal_prod_offr_comp_id number(10,0),
renewal_prod_offr_id number(10,0),
retailer_customer_id varchar2(255) not null,
retailer_id number(10,0) not null,
mnet_client_guid varchar2(255),
client_active_for_dwnld_ind varchar2(255),
client_can_be_enabled_ind varchar2(255),
session_key_code varchar2(255),
session_id_code varchar2(255),
session_record_time date,
session_status_code varchar2(255),
all_offers_canceled_ind varchar2(255),
login_evt_id number(10,0),
ren_cust_purch_trans_id number(10,0),
last_playcount_report_datetime date)
Re: replication error - LCR contains a column of unsupported type [message #75716 is a reply to message #75699] Mon, 21 June 2004 07:52 Go to previous message
Messages: 1
Registered: June 2004
Junior Member
is this an IOT type tables. Only DDL replication is available in 9i for IOT. Not DML.

IS there a function based index on this table. That also not supported in 9i
Previous Topic: Heterogenous replication using Oracle 9i streams
Next Topic: SQL Server to Oracle replication using Oracle Streams
Goto Forum:

Current Time: Sat Aug 19 07:54:24 CDT 2017

Total time taken to generate the page: 0.05172 seconds