Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.4K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Extract Error for Column Count
Hi!
I am trying to extract and got the following error:
2020-09-10 17:45:12 ERROR OGG-00146 Call to VAMRead returned with error status 600: VAM Client Report <CAUSE OF FAILURE : Column count for the current record does not match with the column count of the table metadata for table TestDB.Person
WHEN FAILED : While Sending Insert and Delete Record
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
I tried to check the table metadata and it seems OK. Would you guys know why extract returned this error?
Thanks!
Gerard
Best Answer
-
Hi,
Was there a recent DDL change on this table ?
Answers
-
Hi,
Was there a recent DDL change on this table ?
-
That I am not sure. Does the extract process read table rows? Is there a log that I can check where the record had column mismatch?
-
Can you share the complete report file.
-
Hi! I was able to verify that there are some tables from the source db were modified without me knowing.
Can DDL Replication be able to resolve these column/table definition updates?
Thanks!
-
Hi
I got the same issue because the source table has DDL changed (Add more column). Anyone can help me with this case, please?