Log Retention Period

dataservices administration
1

Hello Every body:
We are trying to make the log retention period to work. When we specyfy the number of days, it accepted unfortunately it never deleted the logs. Because of this our system goes out of space.

Will some one tell us how do we successfully setup this?

Thanks

btallybob (BOB member since 2009-11-17)

2

What is the DI / DS Version ?
what is the value for log retention period that you have set ?
is the repository registered in Managmenet Console ? is the repo connection valid ?
check if you see any errors in web admin log file in %LINK_DIR%\log folder for log deletion

check the history data in AL_HISTORY table, is the value of INST_SERVER, INST_SEVER_PORT, START_TIME, END_TIME set ? is the job server machine name and port number correct, does end_time has a value ?

manoj_d (BOB member since 2009-01-02)

3

Hi Manoj,

We are using DS-12.2.3.1
The log retention is set up as 45 in our dev environment.
The repository is already registered in Managment Console and is valid also.
The webadmin.log.0 file always says there are zero rows to delete. Also it says it is not able to delete the jobs ran on :
In my case in the al_machine info table, the port number is 3500. but in the log file it refers 350.

In al_history table, the INST_SERVER_PORT = 3500.
I do not have any idea why its refering to 350 port.

Can you please give some idea.

Also there were some orphan entries(end_time = null) in the al_history table so I updated the table with a date value . The date comes under 45 days limit then also the logs does not get deleted.
I have checked in alvw_history, the actual log files does exist in the folder.

Thanks for your ideas.

Shivbaba :us: (BOB member since 2010-06-01)

4

Hi Manoj,

Missed to update one thing,
Is it OK if start_time is lesser than end_time in al_history.

Will the log retention work this way.

Thanks.

Shivbaba :us: (BOB member since 2010-06-01)

5

start time should be less that end time, the problem is with the port number, why is it logging it as 350 instead of 3500 can you check the length of the data in the column INST_SERVER_PORT ? may be there is a leading space

manoj_d (BOB member since 2009-01-02)

6

Hi Manoj,

Thanks for your reply.

Sorry but there is no leading space and in al_history table, the datatype for INST_SERVER_PORT is int.
And in al_machine_info, the datatype for PORT filed is nvarchar(65)

Also do you think if start time is less than end time, will the automatic deletion process work?

Thanks,
Ragini

Shivbaba :us: (BOB member since 2010-06-01)