I would recommend being sure you have enabled the Script logging via Settings\Document Properties\General Tab\Generate Logfile checkbox. This way you can check the number of records fetched from Oracle to confirm it is the same number each time, and if that is the case, the only things of which I can think is you have a script variable or something tied to a where clause that has a date in it, and you are not getting any new data, just the same historical over and over. The only other thing that comes to mind would be a View in Oracle that does not update, but I do not know if such a think even exists, I would think it would more likely be a where clause in your script that is restricting the date range of the load. Hope this may help.
Regards,
Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
