Help to investigate DB issues with importing large Edifact files
Screens and logs added to atachemnts:
- Screen with issues for scheduler
- Screen for CPU Utilization for worker:
- CPU Utilization for database:
- Screen dor DB Connection count
In scope of this spike need to check do theses issues still reproduced locally for Hourly scheduling:
MODEXPS-149 For Edifact hourly scheduled jobs in database, Start_date can be greater than End_date MODEXPS-150 For Edifact hourly scheduled jobs in the database, status is mixed with the statuses of the next or previous scheduled jobs MODEXPS-151 For Edifact hourly scheduled jobs in the database, the actual Start_date is changed forever for no reason.
MODEXPS-152 Jobs with no orders can be performed for few hours (up to 4 hours)
We already have an approach to run large Edifact Export performance tests to test FTP loading locally, D_Butramyou can assist with running it.