User Profile
mrrozhall
New Member
Joined 5 months ago
User Widgets
Contributions
Re: Error Mirroring to Fabric: The error is: Exception reading the data file.
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 readable2.1KViews0likes0CommentsError Mirroring to Fabric: The error is: Exception reading the data file.
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. Thanks2.1KViews1like5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.