Data Warehousing and Data integration

Log files going to C:\

More
1 year 1 month ago #25225 by pat.mccarty
Hello,
I have a few packages that when they execute the log files for certain tasks go to C:\ of the machine and not the specified log directory " C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\Log"

Also is there a retention you can place on the log files to auto cleanup?

Thank you,
Pat
The following user(s) said Thank You: admin

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

More
1 year 1 month ago #25226 by admin
Replied by admin on topic Log files going to C:\
I have a few packages that when they execute the log files for certain tasks go to C:\

What are the certain tasks?

For example you have a package with 5 actions 

2 actions write to C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\Log
3 actions write to C:\

Or you have two packages 
Package A writes to C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\Log
Package B write to C:\

Or when you use agent logs are written to to C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\Log
and when you run it manually they are written to  C:\

Most likely the problems you are having are related to user profiles. (Roaming profiles)

Eg you login as John Smith run the package and logs are written to C:\Program Files\DB Software Laboratory\Advanced ETL Processor Enterprise\Log
Than you login as a different user and logs are written into a different folder.

It might have something to do with users rights as well.

Eg user might not have access rights to the log folder.

I personally always use C:\Logs directory for logging

Regarding your second question 

You can use use clear log action for that. Just create a separate package and run it weekly

www.etl-tools.com/wiki/advanced-etl-proc...ns/clear-log-action/

 
 

Mike
ETL Architect

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

More
1 year 1 month ago #25231 by prashant
Replied by prashant on topic Log files going to C:\
I had no clues we now have a clear log dynamic action !!

Nice !!

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

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save