Log retrieve

just4u_sharath · Post by **just4u_sharath** » Mon Feb 18, 2008 9:20 pm

When i was running a job, i got an error. After making chages and running job again for 5 or 6 times, no error found. But the log which showed the error is gone. I would like to look into that error. Can i retrieve the error in any way

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 9:29 pm

By "gone" do you mean automatically purged? In that case, the answer is no - it's gone forever.

You might be able to retrieve the log hashed file from system backups and work your way through that, but it would be a tedious process.

chulett · Post by **chulett** » Mon Feb 18, 2008 11:20 pm

Perhaps 'gone' just means 'outside of the current Filter limits'. Do you have a limit on the number of log records you can display? Does the Director show (Filtered) in the status line?

just4u_sharath · Post by **just4u_sharath** » Fri Feb 22, 2008 1:26 am

chulett wrote:Perhaps 'gone' just means 'outside of the current Filter limits'. Do you have a limit on the number of log records you can display? Does the Director show (Filtered) in the status line?

No i mean log is purged. So if purged i can get the log back only through System Backups. Am i right

ray.wurlod · Post by **ray.wurlod** » Fri Feb 22, 2008 2:36 am

Yes, but... Do you have the skills to restore the hashed file to a separate location, create a VOC pointer to it there, and use SQL to inspect it?

Overwriting a hashed file with one of a different structure on backup media is a Bad Idea, and can lead to corruption.