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
(xid,scn,instnum,flags,time)
=(0x0001.008.00007dbc,0x0000.3f6b1063,0,,4, 04/21/2004 13:57:02)
knllhdmp: UBA LCR UBA 0X2.0X800021.0X8.0X0.0X2.0X44a7
gdbnm=QA002.MUSICNET.COM
(obj#,ver,opnum)=(17575,1,1)
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)
|