This content has been marked as final. Show 8 replies
I am not really sure about recordset.
All the adapters are working fine for actuals, I got one requirement to pull the data from EBS for Budget, so I have created new adapters with new data rule & metadata rule for the new location for Budget
Dataload rule works fine , but when I select the import in FDM - I get the error mentioned.
This error generally occurs when you try to read sequentially from a recordset that has no data. (This could be a database or file query)
BOF = Beginning of File
EOF = Ending of File
When you open a file/recordset, you're sitting at BOF which means you then need to read a record.
If you attempt to read a record and hit EOF, that indicates no data.
If this is code you are writing, you should perform a BOF AND EOF check before reading the first row as that would prevent this error from occurring. (Obviously that wouldn't fix the reason there's no data, but it would prevent the 'crash' from occurring)
I can't tell you why there's no data available as we don't have the details of what you are doing.
If you have no idea at all why this is happening, you could try the following :
If this is a file you are attempting to process I would recommend using FileMon from SysInternals to determine which file is being accessed. It may be that the file being read is not what you expected or that the file doesn't really have data. (perhaps there were no valid data Rows found when importing?)
If this is a database query, you could use a tool like SQL Profiler to monitor the queries being executed against the database. This should allow you to at least know what is being queried and that might you in the right direction.
Hope that helps.
I read your post.I also have a simillar problem with the custom scipt to extract data from ODBC - Oracle table to the FDM .I see the data in the staging table however i dont see data in the FDM...so may be i am not sure if i am missing some thing in the script.Can you help me with the script to reslove this issue.