Count mismatch between app-access.log and log_details

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

1. One particular date is under consideration
2. The app-access.log for that particular date is parsed independently of the 'Tomcat Access Log Import/Analyze Job'
3. The job is also used to import data for this date into the log_details and other related tables
4. It is then observed that there is a mismatch in record count between steps 2 and 3.

Resolution

The job uses a complex set of regex patterns to determine those lines from the app-access.log that are of relevance. It then imports only such lines into the log_details and other related tables. It is not expected for the job to import all lines from the app-access.log as it is.