visual enterprise

  • Posts: 258
  • Karma: 2
  • Thank you received: 3

visual enterprise was created by alanwjackson

Two topics today
1. I have a process set on infinite loop, using the pause object, to bring data across systems. This works great.
My concern is the log that is being generated. Normally a log is started and completed upon execution, while this one continues to grow.
Is there someway to control or just prevent the log in this type of instance?
Can the log out grow the resources>

the job starts at 4am and ends at 10pm
getting log entries every 1 second

2. maybe a new object.
you have the date object, how about a time object?
with choice of between start time and end time or just end time?
I am using sql code within a data object to test end time, but an object might be cool
2 months 3 weeks ago #20558

Please Log in or Create an account to join the conversation.

  • Posts: 8127
  • Karma: 33
  • Thank you received: 512

Replied by admin on topic visual enterprise

We will have a look at it for you
Mike
2 months 3 weeks ago #20559

Please Log in or Create an account to join the conversation.

  • Posts: 8127
  • Karma: 33
  • Thank you received: 512

Replied by admin on topic visual enterprise

Hi Alan.

Not sure if you are aware but we do have an object dedicated to clearing logs.

www.etl-tools.com/wiki/aetle/packages/clear_log_action?s[]=clear&s[]=log

Please let me know if it is helpful or not
Mike
2 months 3 weeks ago #20576

Please Log in or Create an account to join the conversation.

  • Posts: 258
  • Karma: 2
  • Thank you received: 3

Replied by alanwjackson on topic visual enterprise

I will take a look at it
I manually delete every other week on our production machine so we review if necessary
and have an automated bat file process on a different machine

My issues is if I loop it via etl packages, its takes 3-5 seconds, which is to long, but the log closes
if i turn it on, with start and end times, say for 12 hours straight, the timing is perfect, but the log is huge and can only be purged when complete.

I also believe the huge log causes overall slowness in the etl
2 months 3 weeks ago #20577

Please Log in or Create an account to join the conversation.

  • Posts: 8127
  • Karma: 33
  • Thank you received: 512

Replied by admin on topic visual enterprise

I am confused when you say huge log are you talking about records in the database or the actual log file?

Please post a screeshot
Mike
2 months 3 weeks ago #20578

Please Log in or Create an account to join the conversation.

  • Posts: 258
  • Karma: 2
  • Thank you received: 3

Replied by alanwjackson on topic visual enterprise

let me set it up and i'll send you the info tomorrow
2 months 3 weeks ago #20581

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies