Hello.
I have a new CSV, comma delimited, with a header row.
It has 182 columns of data.
ODI-15116:
There is not enough data in the target file to proceed with the
reverse-engineering. Please make sure the file has at least one non-empty line
and number of rows to skip is correct.
Okay...
So, I then go and try to narrow down the issue. I remove all rows except for the header row and one (first) data row and reserve-engineer. Same error.
I then remove the header row and reserve-engineer as header-less file with just one row of data. It works and I get 182 attributes in my datastore. The correct count.
I then remove all data rows and only leave the header row in the file and treating it as an actual data row try to reverse-engineer and it does, BUT(!) I only get 62 attributes in my datastore.
So... it is the header row that is tripping up. I should be getting 182 columns, but ODI only reads the first 62.
I tested it by further removing all header names except for the first 62. Reverse-engineer. The datastore properly has 62 attributes.
I then add the 63rd heading (column name). Reverse-engineer. The datastore STILL has only 62 attributes.
There is nothing special about the text in the column headings, especially the 63rd one.
What might be going on? Is there a limit I am hitting in ODI or elsewhere?
Thank you
Boris