Error Mirroring to Fabric: The error is: Exception reading the data file.

[mrrozhall]

I am replicating data from an Oracle 19c database to a mirrored database in Fabric. All Oracle tables are successfully replicating, but I'm getting the same error message on two tables.  Neither table has a NVARCHAR(MAX) column (as I've heard this causes issues).

Here's the schema of one of the failing Oracle tables and the actual error message is below.

lineitemamt	number
lineitemusage	float
adddttm	date
moddttm	date
paidstat	nvarchar2(1)
pendflag	nvarchar2(1)
pendtype	nvarchar2(1)
lineitemkey	number
billkey	number
lineitemunits	float
addby	nvarchar2(30)
modby	nvarchar2(30)
penaltypayorder	number
principalpayorder	number
printtext	nvarchar2(300)
discountexpiredate	date
commentskey	number
lineitemsetupkey	number
penaltydate	date
penalizedflag	nvarchar2(1)
accountservicekey	number
printorder	number
legacylineitemno	number
actualamt	number
budgetedamountflag	nvarchar2(1)
variantflag	nvarchar2(1)

Table (subtask 0 thread 1) is suspended. The Fabric Mirrored database indicate an error, errorStatus: 'Replicating', errorCode: '', errorMessage:

'We encountered an error while parsing data file being used, please fix the file and try again.

The error is: Exception reading the data file. Exception: No data rows available.

Appreciate any suggestions, tips.

Thanks

[v-echaithra]

Hi @mrrozhall ,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.

Warm regards,
Chaithra E.

[v-echaithra]

Hi @mrrozhall ,

Thank you for your response. If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Regards,
Chaithra E.

[AhmedMamdoh]

Send to support 

[v-echaithra]

Hi @mrrozhall ,

Thank you for reaching out to Microsoft Community.

This error typically occurs when Fabric is able to detect the table schema, but cannot extract readable change data from Oracle during the initialization phase. As a result, Fabric receives an empty or non-readable result set and suspends replication with the message “Exception reading the data file. No data rows available.”

Based on similar scenarios, this is usually related to how redo/logging or storage is configured on the Oracle table rather than a datatype issue.

Common causes to validate:

Table was empty when mirroring started. Fabric expects at least one readable rowset during initialization.

SELECT COUNT(*) FROM <schema>.<table_name>;
If the count is 0, insert a temporary row, commit, then delete it and commit again to generate redo.

Table is set to NOLOGGING
NOLOGGING operations do not emit sufficient redo for mirroring.

SELECT table_name, logging
FROM all_tables
WHERE table_name = '<TABLE_NAME>';

If LOGGING = NO, enable it:
ALTER TABLE <schema>.<table_name> LOGGING;

No DML activity since table creation
If no redo was generated, LogMiner cannot capture changes. You can force redo generation with a no-op update:

UPDATE <schema>.<table_name>
SET <any_column> = <same_value>;
COMMIT;

Compression or unsupported storage attributes enabled
Certain compression settings can prevent Fabric from parsing the data blocks.

SELECT table_name, compression, compress_for
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';

If compression is enabled, move the table:
ALTER TABLE <schema>.<table_name> MOVE NOCOMPRESS;

High-watermark issue (table previously emptied)
Rebuilding the segment can help:

ALTER TABLE <schema>.<table_name> MOVE; or ALTER TABLE <schema>.<table_name> SHRINK SPACE;

Supplemental logging not enabled at the database level
SELECT supplemental_log_data_min FROM v$database;
If NO, enable it:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

If the issue continues, please share the following so we can investigate further:

Row count of the table
Table DDL (DBMS_METADATA.GET_DDL)
Logging and compression status from DBA_TABLES

Hope this helps,
Thank you.

[mrrozhall]

Hello, and thanks for the reply.  After verifying all suggestions, the problem persists.  Below is the requested information.

Row count:

2,046,449,413 records

DDL:

CREATE TABLE "BILLING"."ACCTTRAN" 

   ( "ACCOUNTKEY" NUMBER DEFAULT (1), 

"ADDBY" NVARCHAR2(30), 

"ADDDTTM" DATE DEFAULT (SYSDATE), 

"ADJUSTMENTKEY" NUMBER DEFAULT (1), 

"APPFEEKEY" NUMBER DEFAULT (1), 

"CODESRC" NUMBER DEFAULT (1), 

"COMMENTSKEY" NUMBER DEFAULT (1), 

"DEPOSITTRANSACTIONKEY" NUMBER DEFAULT (1), 

"INTERNALFLAG" NVARCHAR2(1) DEFAULT ('N'), 

"LINEITEMKEY" NUMBER DEFAULT (1) NOT NULL ENABLE, 

"MODBY" NVARCHAR2(30), 

"MODDTTM" DATE, 

"ONEOFFCHARGEKEY" NUMBER DEFAULT (1), 

"PAYKEY" NUMBER DEFAULT (1) NOT NULL ENABLE, 

"PENALTYKEY" NUMBER DEFAULT (1), 

"PROCSRC" NUMBER DEFAULT (1), 

"REFTRANNO" NUMBER DEFAULT (1), 

"REFUNDKEY" NUMBER DEFAULT (1), 

"SOURCELINENUMBER" NUMBER, 

"TRANAMT" NUMBER DEFAULT (0), 

"TRANBY" NVARCHAR2(25) DEFAULT (' '), 

"TRANDATE" DATE, 

"TRANNO" NUMBER NOT NULL ENABLE, 

"TRANSACTIONDESIGNATOR" NUMBER DEFAULT (1) NOT NULL ENABLE, 

"TRANSACTIONTYPE" NUMBER DEFAULT (1) NOT NULL ENABLE, 

"WRITEOFFRUNKEY" NUMBER DEFAULT (1) NOT NULL ENABLE, 

"NEEDSJOURNAL" NVARCHAR2(1) DEFAULT ('Y'), 

"SOURCEKEY" NUMBER DEFAULT (1) NOT NULL ENABLE, 

"SOURCETYPE" NUMBER DEFAULT (0) NOT NULL ENABLE, 

CONSTRAINT "CC_ACCTTRAN_INTFLAG" CHECK ("INTERNALFLAG" IN(N'Y',N'N')) ENABLE NOVALIDATE, 

CONSTRAINT "CC_ATTRANTYPE" CHECK ("TRANSACTIONTYPE" IN(9,8,7,6,5,4,3,2,13,12,11,10,1)) ENABLE NOVALIDATE, 

CONSTRAINT "CC_ATTRANDES" CHECK ("TRANSACTIONDESIGNATOR" IN(9,8,7,6,5,4,3,2,11,10,1,0)) ENABLE NOVALIDATE, 

CONSTRAINT "CC_SOURCETYPE" CHECK ("SOURCETYPE" IN(7,6,5,4,3,2,1,0)) ENABLE NOVALIDATE, 

SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, 

SUPPLEMENTAL LOG GROUP "ATTU_ED6833A8_gr0" ("ACCOUNTKEY", "ADDBY", "ADDDTTM", "ADJUSTMENTKEY", "APPFEEKEY", "CODESRC", "COMMENTSKEY", "DEPOSITTRANSACTIONKEY", "INTERNALFLAG", "LINEITEMKEY", "MODBY", "MODDTTM", "ONEOFFCHARGEKEY", "PAYKEY", "PENALTYKEY", "PROCSRC", "REFTRANNO", "REFUNDKEY", "SOURCELINENUMBER", "TRANAMT", "TRANBY", "TRANDATE", "TRANNO", "TRANSACTIONDESIGNATOR", "TRANSACTIONTYPE", "WRITEOFFRUNKEY") ALWAYS, 

CONSTRAINT "FK_ACCTTRAN_REFUND" FOREIGN KEY ("REFUNDKEY")

  REFERENCES "BILLING"."REFUND" ("REFUNDKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_PENALTY" FOREIGN KEY ("PENALTYKEY")

  REFERENCES "BILLING"."PENALTY" ("PENALTYKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_ONEOFFCHARGEKEY" FOREIGN KEY ("ONEOFFCHARGEKEY")

  REFERENCES "BILLING"."ONEOFFCHARGE" ("ONEOFFCHARGEKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_DEPTRAN" FOREIGN KEY ("DEPOSITTRANSACTIONKEY")

  REFERENCES "BILLING"."DEPTRAN" ("DEPTRANNO") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_COMMENTSKEY" FOREIGN KEY ("COMMENTSKEY")

  REFERENCES "BILLING"."COMMENTS" ("COMMENTSKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_ADJUSTMENTKEY" FOREIGN KEY ("ADJUSTMENTKEY")

  REFERENCES "BILLING"."ADJUSTMENT" ("ADJUSTMENTKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_REFTRANNO" FOREIGN KEY ("REFTRANNO")

  REFERENCES "BILLING"."ACCTTRAN" ("TRANNO") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_APPFEE" FOREIGN KEY ("APPFEEKEY")

  REFERENCES "CDR"."APFEE" ("APFEEKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_PAYKEY" FOREIGN KEY ("PAYKEY")

  REFERENCES "BILLING"."PAYMENT" ("PAYKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_ACCOUNTKEY" FOREIGN KEY ("ACCOUNTKEY")

  REFERENCES "BILLING"."ACCOUNT" ("ACCOUNTKEY") ENABLE NOVALIDATE, 

CONSTRAINT "FK_ACCTTRAN_TRANBY" FOREIGN KEY ("TRANBY")

  REFERENCES "RESOURCES"."EMPLOYEE" ("EMPID") ENABLE, 

CONSTRAINT "FK_ACCTTRAN_LINEITEMKEY" FOREIGN KEY ("LINEITEMKEY")

  REFERENCES "BILLING"."LINEITEM" ("LINEITEMKEY") ENABLE

   ) SEGMENT CREATION IMMEDIATE 

  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 

 NOCOMPRESS LOGGING

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "DATA2_TBS"  ENABLE ROW MOVEMENT 

  CREATE UNIQUE INDEX "BILLING"."PK_ACCTTRAN" ON "BILLING"."ACCTTRAN" ("TRANNO") 

  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "INDX2_TBS" 

ALTER TABLE "BILLING"."ACCTTRAN" ADD CONSTRAINT "PK_ACCTTRAN" PRIMARY KEY ("TRANNO")

  USING INDEX "BILLING"."PK_ACCTTRAN"  ENABLE

Logging/Compression:

TABLE_NAME	LOGGING	COMPRESSION	COMPRESS_FOR
ACCTTRAN	YES	DISABLED

Hope this is all readable