ETL Enterprise Log not displaying

Hello:

I seem to have a new bug I have discovered since upgrading ETL Enterprise to the latest addition 5.7.9.27 running on Win 2008 server R2 with the repository on a sql server.

it seems that the logs no longer show todays activities but only show yesterday and earlier. it seems that when querying the logs from sql server it is not evaluating the end date correctly as SQL server automatically assumes 0 hrs as 12am midnight on the date passed. to get todays executions you will need to pass tomorrows raw date or do a simple DateAdd addtions to todays to get items run upto 2359 hrs of current date.

I am attachign screen shots of both the schedule showing exections to run tomororw and the current log view showing yesterdays executions and not todays. I am also attaching an xls file with the results showing todays executions from sql server.

this same behavior is apparent on the new Management console html server interface as well.

thanks

mike

That is expected behavior,

Read this

www.etl-tools.com/articles/repository-structure-changes.html

And that

www.etl-tools.com/articles/repository-patch-script.html

Mike

Mike:


I have already, upgraded the structure of the database and the migration has already occured as we update ETL a couple days ago. the behavior I am talking about is post Repository update. and yes it would be nice to see today's executions in the ETL log either in ETL itself and possibly in the Management console.



thanks

mike

a quick update. if you look at the 2nd image I attached. that is the log file from today, Sept 18. and it only shows executions from the 17th but the first record shows a manually trigered event. but fails to update its status. however in sql server it shows complete. also to note, in the management console if I change the log report view to date. to tomorrows date of Sept. 19th. I can then see today's Sept 18th executions in the view. would it not be better to show executions in the log inclusive of the end date rather then excluding end date....


thanks

mike

"By default monitor screen shows only pending for execution and being executed objects to see full log press 'Show History' button."

Mike

Mike:

strange behavor in the log view then. if the log only shows pending and currently executed events. why is it showing events from Sept 17th and 16th that have completed, however when I select show history as you mention I do get to then see the events form the 18th and 17th. in both cases it is showing completed events and nothing further back into history. Previous versions enabled us to look further back into history and easily view today's activity such as completed or failed executions which was useful should we need to manually go and extract files etc. from clients who transmit files to our server.


thanks

mike