I have an ESS view in my FM Database say vw_ESS.
I have a Local FM table with the same table structure as this ESS view, say FM_Table.
I need to update FM_Table with vw_ESS records in a timely fashion, say ONTimer script.
While importing from vw_ESS to FM_Table, instead of creating a few records it creates empty records.
The data is huge, over 11000 records, so its hard to follow which records are missing etc
While Importing it doesn't give any errors, so I have no idea whats happening.
Any help is appreciated