Attunity CDC for Oracle OCI_FETCH error

Perusse, Tim PW 1 Reputation point
2020-09-05T14:25:13.25+00:00

We have setup Oracle CDC by Attunity in a SQL server 2016 environment. From the Designer everything runs fine until an actual change happens in one of the included tables in the Oracle database at which point the operation aborts. When looking at the logs we get the following.

"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Positioning to first change event in log miner session","source","",""
"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Enqueue transaction record","source","","0xE40708000C000D0017003B0000C7D512000000000000000000010020006147020000000DACC281EDBA0100000100000944000384B0017C0000000000"
"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Reading next record","source","",""
"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Reading Complementary records for large log miner SQL_REDO/SQL_UNDO","source","",""
"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Parsing statement","source","update "UNKNOWN"."OBJ# 161091" set "COL 10" = HEXTORAW('31353030'), "COL 12" = NULL, "COL 61" = HEXTORAW('5445535431') where "COL 1" = HEXTORAW('505755455f3645434342314546384633344439303237333845434435314235443135463530') and "COL 2" = HEXTORAW('c2090b') and "COL 3" = HEXTORAW('3e6466') and "COL 4" = HEXTORAW('534f4c554d494e412d4943') and "COL 5" = HEXTORAW('78700b14122f18') and "COL 6" = HEXTORAW('55504441544544') and "COL 7" = HEXTORAW('4e') and "COL 8" = HEXTORAW('4e') and "COL 9" = HEXTORAW('4e') and "COL 10" = HEXTORAW('31353030') and "COL 11" = HEXTORAW('c102') and "COL 12" IS NULL and "COL 13" = HEXTORAW('c102') and "COL 14" = HEXTORAW('47415031') and "COL 15" = HEXTORAW('36353339') and "COL 16" = HEXTORAW('363533392d33') and "COL 17" IS NULL and "COL 18" IS NULL and "COL 19" = HEXTORAW('50454e44494e47') and "COL 20" IS NULL and "COL 21" = HEXTORAW('4d4647') and "COL 22" = HEXTORAW('434c45414e2c20505245484541542c205350524159204c5542452050455220474d4f502d3131352e') and "COL 23" IS NULL and "COL 24" IS NULL and "COL 25" = HEXTORAW('80') and "COL 26" IS NULL and "COL 27" = HEXTORAW('4e') and "COL 28" IS NULL and "COL 29" = HEXTORAW('4e') and "COL 30" = HEXTORAW('4e') and "COL 31" IS NULL and "COL 32" IS NULL and "COL 33" IS NULL and "COL 34" IS NULL and "COL 35" IS NULL and "COL 36" IS NULL and "COL 37" IS NULL and "COL 38" IS NULL and "COL 39" IS NULL and "COL 40" IS NULL and "COL 41" IS NULL and "COL 42" IS NULL and "COL 43" IS NULL and "COL 44" IS NULL and "COL 45" IS NULL and "COL 46" IS NULL and "COL 47" IS NULL and "COL 48" IS NULL and "COL 49" = HEXTORAW('80') and "COL 50" = HEXTORAW('c102') and "COL 51" IS NULL and "COL 52" = HEXTORAW('80') and "COL 53" = HEXTORAW('4e') and "COL 54" = HEXTORAW('80') and "COL 55" = HEXTORAW('c102') and "COL 56" IS NULL and "COL 57" IS NULL and "COL 58" IS NULL and "COL 59" IS NULL and "COL 60" IS NULL and "COL 61" = HEXTORAW('54455354') and "COL 62" = HEXTORAW('2041') and "COL 63" = HEXTORAW('4d4947524154494f4e') and "COL 64" IS NULL and "COL 65" = HEXTORAW('c402151836') and "COL 66" IS NULL and "COL 67" IS NULL and "COL 68" = HEXTORAW('30313636383139373434') and "COL 69" = HEXTORAW('50505031') and "COL 70" IS NULL and "COL 71" IS NULL and "COL 72" IS NULL and "COL 73" IS NULL and "COL 74" IS NULL and "COL 75" IS NULL and "COL 76" IS NULL and "COL 77" IS NULL and "COL 78" IS NULL and "COL 79" IS NULL and "COL 80" IS NULL and "COL 81" IS NULL and "COL 82" IS NULL and "COL 83" IS NULL and "COL 84" IS NULL and "COL 85" IS NULL and "COL 86" = HEXTORAW('5072696d65') and "COL 87" IS NULL and "COL 88" = HEXTORAW('50505031') and "COL 89" IS NULL and "COL 90" IS NULL and "COL 91" = HEXTORAW('4e') and "COL 92" IS NULL and "COL 93" IS NULL and "COL 94" IS NULL and "COL 95" IS NULL and "COL 96" IS NULL and "COL 97" IS NULL and "COL 98" IS NULL and "COL 99" IS NULL and "COL 100" IS NULL and "COL 101" IS NULL and "COL 102" IS NULL and "COL 103" IS NULL and "COL 104" = HEXTORAW('50') and "COL 105" = HEXTORAW('4e') and "COL 106" = HEXTORAW('50') and "COL 107" IS NULL and "COL 108" IS NULL and "COL 109" IS NULL and "COL 110" = HEXTORAW('20584353333333332031312f32302f313220333a32363a3920504d3a0a20436f706965642066726f6d20303030303133365f3953353142343930325f313530302032') and "COL 111" IS NULL and "COL 112" = HEXTORAW('52454c') and "COL 113" IS NULL and "COL 114" IS NULL and "COL 115" IS NULL and "COL 116" IS NULL and "COL 117" IS NULL and "COL 118" IS NULL and "COL 119" IS NULL and "COL 120" IS NULL and "COL 121" IS NULL and "COL 122" IS NULL and "COL 123" IS NULL and "COL 124" IS NULL and "COL 125" IS NULL and "COL 126" IS NULL and "COL 127" IS NULL and "COL 128" IS NULL and "COL 129" IS NULL and "COL 130" IS NULL and "COL 131" IS NULL and "COL 132" IS NULL and "COL 133" IS NULL and "COL 134" IS NULL and "COL 135" IS NULL and "COL 136" IS NULL and "COL 137" IS NULL and "COL 138" IS NULL and "COL 139" IS NULL and "COL 140" IS NULL and "COL 141" IS NULL and "COL 142" IS NULL and "COL 143" = HEXTORAW('4e') and "COL 144" = HEXTORAW('80') and "COL 145" IS NULL and "COL 146" IS NULL and "COL 147" IS NULL and "COL 148" IS NULL and "COL 149" = HEXTORAW('4e') and "COL 150" IS NULL and "COL 151" = HEXTORAW('4e') and "COL 152" = HEXTORAW('4e') and "COL 153" = HEXTORAW('4e') and "COL 154" IS NULL and ROWID = 'AAAnVDAAcAAAAGrAAA';",""
"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Parsing statement","source","update "UNKNOWN"."OBJ# 161091" set "COL 10" = HEXTORAW('31353030'), "COL 12" = NULL, "COL 61" = HEXTORAW('54455354') where "COL 1" = HEXTORAW('505755455f3645434342314546384633344439303237333845434435314235443135463530') and "COL 2" = HEXTORAW('c2090b') and "COL 3" = HEXTORAW('3e6466') and "COL 4" = HEXTORAW('534f4c554d494e412d4943') and "COL 5" = HEXTORAW('78700b14122f18') and "COL 6" = HEXTORAW('55504441544544') and "COL 7" = HEXTORAW('4e') and "COL 8" = HEXTORAW('4e') and "COL 9" = HEXTORAW('4e') and "COL 10" = HEXTORAW('31353030') and "COL 11" = HEXTORAW('c102') and "COL 12" IS NULL and "COL 13" = HEXTORAW('c102') and "COL 14" = HEXTORAW('47415031') and "COL 15" = HEXTORAW('36353339') and "COL 16" = HEXTORAW('363533392d33') and "COL 17" IS NULL and "COL 18" IS NULL and "COL 19" = HEXTORAW('50454e44494e47') and "COL 20" IS NULL and "COL 21" = HEXTORAW('4d4647') and "COL 22" = HEXTORAW('434c45414e2c20505245484541542c205350524159204c5542452050455220474d4f502d3131352e') and "COL 23" IS NULL and "COL 24" IS NULL and "COL 25" = HEXTORAW('80') and "COL 26" IS NULL and "COL 27" = HEXTORAW('4e') and "COL 28" IS NULL and "COL 29" = HEXTORAW('4e') and "COL 30" = HEXTORAW('4e') and "COL 31" IS NULL and "COL 32" IS NULL and "COL 33" IS NULL and "COL 34" IS NULL and "COL 35" IS NULL and "COL 36" IS NULL and "COL 37" IS NULL and "COL 38" IS NULL and "COL 39" IS NULL and "COL 40" IS NULL and "COL 41" IS NULL and "COL 42" IS NULL and "COL 43" IS NULL and "COL 44" IS NULL and "COL 45" IS NULL and "COL 46" IS NULL and "COL 47" IS NULL and "COL 48" IS NULL and "COL 49" = HEXTORAW('80') and "COL 50" = HEXTORAW('c102') and "COL 51" IS NULL and "COL 52" = HEXTORAW('80') and "COL 53" = HEXTORAW('4e') and "COL 54" = HEXTORAW('80') and "COL 55" = HEXTORAW('c102') and "COL 56" IS NULL and "COL 57" IS NULL and "COL 58" IS NULL and "COL 59" IS NULL and "COL 60" IS NULL and "COL 61" = HEXTORAW('5445535431') and "COL 62" = HEXTORAW('2041') and "COL 63" = HEXTORAW('4d4947524154494f4e') and "COL 64" IS NULL and "COL 65" = HEXTORAW('c402151836') and "COL 66" IS NULL and "COL 67" IS NULL and "COL 68" = HEXTORAW('30313636383139373434') and "COL 69" = HEXTORAW('50505031') and "COL 70" IS NULL and "COL 71" IS NULL and "COL 72" IS NULL and "COL 73" IS NULL and "COL 74" IS NULL and "COL 75" IS NULL and "COL 76" IS NULL and "COL 77" IS NULL and "COL 78" IS NULL and "COL 79" IS NULL and "COL 80" IS NULL and "COL 81" IS NULL and "COL 82" IS NULL and "COL 83" IS NULL and "COL 84" IS NULL and "COL 85" IS NULL and "COL 86" = HEXTORAW('5072696d65') and "COL 87" IS NULL and "COL 88" = HEXTORAW('50505031') and "COL 89" IS NULL and "COL 90" IS NULL and "COL 91" = HEXTORAW('4e') and "COL 92" IS NULL and "COL 93" IS NULL and "COL 94" IS NULL and "COL 95" IS NULL and "COL 96" IS NULL and "COL 97" IS NULL and "COL 98" IS NULL and "COL 99" IS NULL and "COL 100" IS NULL and "COL 101" IS NULL and "COL 102" IS NULL and "COL 103" IS NULL and "COL 104" = HEXTORAW('50') and "COL 105" = HEXTORAW('4e') and "COL 106" = HEXTORAW('50') and "COL 107" IS NULL and "COL 108" IS NULL and "COL 109" IS NULL and "COL 110" = HEXTORAW('20584353333333332031312f32302f313220333a32363a3920504d3a0a20436f706965642066726f6d20303030303133365f3953353142343930325f313530302032') and "COL 111" IS NULL and "COL 112" = HEXTORAW('52454c') and "COL 113" IS NULL and "COL 114" IS NULL and "COL 115" IS NULL and "COL 116" IS NULL and "COL 117" IS NULL and "COL 118" IS NULL and "COL 119" IS NULL and "COL 120" IS NULL and "COL 121" IS NULL and "COL 122" IS NULL and "COL 123" IS NULL and "COL 124" IS NULL and "COL 125" IS NULL and "COL 126" IS NULL and "COL 127" IS NULL and "COL 128" IS NULL and "COL 129" IS NULL and "COL 130" IS NULL and "COL 131" IS NULL and "COL 132" IS NULL and "COL 133" IS NULL and "COL 134" IS NULL and "COL 135" IS NULL and "COL 136" IS NULL and "COL 137" IS NULL and "COL 138" IS NULL and "COL 139" IS NULL and "COL 140" IS NULL and "COL 141" IS NULL and "COL 142" IS NULL and "COL 143" = HEXTORAW('4e') and "COL 144" = HEXTORAW('80') and "COL 145" IS NULL and "COL 146" IS NULL and "COL 147" IS NULL and "COL 148" IS NULL and "COL 149" = HEXTORAW('4e') and "COL 150" IS NULL and "COL 151" = HEXTORAW('4e') and "COL 152" = HEXTORAW('4e') and "COL 153" = HEXTORAW('4e') and "COL 154" IS NULL and ROWID = 'AAAnVDAAcAAAAGrAAA';",""
"8/12/2020 1:23:59 PM","TRACE","server","RUNNING","IDLE","ORACDC000T:Getting definition of table 'SFMFG'.'SFWID_OPER_DESC'","source","",""
"8/12/2020 1:23:59 PM","ERROR","server","RUNNING","IDLE","ORACDC508E:Oracle method OCIStmtFetch failed with error: OCI_NO_DATA","source","",""

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-07T08:47:14.113+00:00

    Hi Perusse,

    The following links will be helpful:

    Change Data Capture Service for Oracle by Attunity

    Known errors and resolutions with change data capture for Oracle by Attunity

    Best Regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.