...
The intention would be to identify which are ‘real’ errors and which can safely be ignored, so that we can update the Sentry message filters to be less noisy.
Group | Source | Title | Description | Example link | Ignore/Attend? | Comment | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | No reference found for id 0 | TCS | Exception during find grade id in for ids [0], returning empty list. Here's the error message 404 |
| Attended | 68K events They’re consuming up our quota. | ||||||||||||||||||||||||||
2 | TCS | Exception during find sites id in for ids [0], returning empty list. Here's the error message 404 |
| Attended | 68K events They’re consuming up our quota. | |||||||||||||||||||||||||||
3 | Person Update bulk upload time outs | TCS | HttpRequestMethodNotSupportedException | Request method 'GET' not supported url: http://apps.tis.nhs.uk/tcs/api/documentsIOException | PATCH /api/bulk-people/ Connection reset by peer | https://health-education-england-9v.sentry.io/issues/43129142834325776792/?alert_rule_id=1448641613350188&alert_type=issue&project=5752964&referrer=slack | Ignored | 14 events | ||||||||||||||||||||||||
4 | TCS | NullPointerException | GET /api/placements/overlapping | Attend | dateFrom or dateTo of the placement to be validated is null. | |||||||||||||||||||||||||||
5 | TCS | NullPointerException | DELETE /api/placements/{id} null value in entry: delete=null | https:Attend | Only 1 event on 19th July 11:11:41. It’s very likely to be linked with the stalled Person Update file issue (Andrew Goodhand uploaded a file at 11:03;41)
| |||||||||||||||||||||||||||
4 | get draft placement list by id from PlacementLog table | TCS | IOException | Broken pipe url: http://stage-apps.tis.nhs.uk/tcs/api/placements/draftList/818 | https://health-education-england-9v.sentry.io/issues/43146961554355344968/?alert_rule_id=1448641613350188&alert_type=issue&project=5752964&referrer=slack | Ignored | 3 events, and all related placements were deleted. The exception is thrown in the | 6 | TCS | HystrixRuntimeException | Attend | We have to take a look this endpoint for programmeId 818.
| ||||||||||||||||||||
5 | /api/placements/overlapping | TCS | NullPointerException | GET /api/placements/overlapping | https://health-education-england-9v.sentry.io/issues/42651373944312566059/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | This error has been in TCS for a long time (more than 2 years) | 7 | TCS | GET_USER_PROFILE could not be queued for execution and no fallback available UT005023: Exception handling request to /tcs/api/placements/2409866/esr-exported | Ignored | has been marked as Resoved before. | 8 | TCS | HystrixRuntimeException | GET_USER_PROFILE timed-out and no fallback available. UT005023: Exception handling request to /tcs/api/posts | Ignored | 9 | TCS | MethodArgumentTypeMismatchException DELETE /api/programme-memberships/{id} Failed to convert value of type 'java.lang.String' to required type 'java.lang.Long | Attend | dateFrom or dateTo of the placement to be validated is null.
| ||||||||||
6 | TCS | MethodArgumentTypeMismatchException | GET /api/placements/overlapping
| https://health-education-england-9v.sentry.io/issues/43146898394312901248/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | UI passes underfined as ID to the backend. 29 events | 10 | TCS | MethodArgumentTypeMismatchException | GET /api/people/v2/{id} Failed to convert value of type 'java.lang.String' to required type 'java.lang.Long'; nested exception is java.lang.NumberFormatException: For input string: "undefined"input data format can not be converted to LocalDate
| ||||||||||||||||||||||
7 | TCS | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 |
| https://health-education-england-9v.sentry.io/issues/43256500604314780639/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slackIgnored | Attend | 19 29 events | 11 | TCS | MethodArgumentTypeMismatchException | GET /api/placements/overlapping Failed to convert value of type 'java.lang.String' to required type 'java.time.LocalDate'The user didn’t select an item in the npn dropdown list, so the npn sent to TCS is undefined.
| ||||||||||||||||||||||
8 | TCS | InvalidDataAccessResourceUsageException | could not extract ResultSet; SQL [n/a]; nested exception is org.springframeworkhibernate.core.convert.ConversionFailedException: Failed to convert from type [java.lang.String] to type [@org.springframework.web.bind.annotation.RequestParam @org.springframework.format.annotation.DateTimeFormat java.time.LocalDate] for value '23-06-04'; nested exception is java.lang.IllegalArgumentException: Parse attempt failed for value [23-06-04]exception.SQLGrammarException: could not extract ResultSet | Ignored | related to the above error | |||||||||||||||||||||||||||
9 | GET_USER_PROFILE hystrix runtime exception | TCS | HystrixRuntimeException | GET_USER_PROFILE short-circuited and no fallback available UT005023: Exception handling request to /tcs/api/findByNationalPostNumber | Ignored | This error has been in TCS for a long time (more than 2 years) | ||||||||||||||||||||||||||
10 | TCS | HystrixRuntimeException | GET_USER_PROFILE could not be queued for execution and no fallback available UT005023: Exception handling request to /tcs/api/placements/2409866/esr-exported | https://health-education-england-9v.sentry.io/issues/43129012484265464218/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | input data format can not be converted to LocalDate | 12has been marked as Resoved before. | |||||||||||||||||||||||||
11 | TCS ObjectOptimisticLockingFailureException | PUT /api/programme-memberships optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect)HystrixRuntimeException | GET_USER_PROFILE timed-out and no fallback available. UT005023: Exception handling request to /tcs/api/posts | https://health-education-england-9v.sentry.io/issues/4265137096/events/432041776941b5bc0f03a54dae8a40650cc491442e/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | 14 events The current update is on a stale eneity. | ||||||||||||||||||||||||||
1312 | MethodArgumentTypeMismatchException Related to UI | TCS | ObjectOptimisticLockingFailureExceptionMethodArgumentTypeMismatchException | PUT DELETE /api/personal-detailsObject of class [com.transformuk.hee.tis.tcs.service.model.PersonalDetails] with identifier [314741]: optimistic locking failedprogramme-memberships/{id} Failed to convert value of type 'java.lang.String' to required type 'java.lang.Long'; nested exception is orgjava.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect)lang.NumberFormatException: For input string: "undefined" | https://health-education-england-9v.sentry.io/issues/43205130674314689839/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | 5 events. The current update is on a stale eneity. | 14UI passes underfined as id to the backend. 29 events | ||||||||||||||||||||||||
13 | TCS | ObjectOptimisticLockingFailureExceptionMethodArgumentTypeMismatchException | PUT GET /api/contact-detailsObject of class [com.transformuk.hee.tis.tcs.service.model.ContactDetails] with identifier [301675]: optimistic locking failed/people/v2/{id} Failed to convert value of type 'java.lang.String' to required type 'java.lang.Long'; nested exception is orgjava.hibernatelang.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [com.transformuk.hee.tis.tcs.service.model.ContactDetails#301675]NumberFormatException: For input string: "undefined" | https://health-education-england-9v.sentry.io/issues/43228617494325650060/?alert_rule_id=1335018814486416&alert_type=issue&project=5752964&referrer=slack | Ignored | 1 event | 15 | TCS | Column 'positionNumber' cannot be null | Column 'positionNumber' cannot be null19 events | ||||||||||||||||||||||
14 | ObjectOptimisticLockingFailureException | TCS | ObjectOptimisticLockingFailureException | PUT /api/programme-memberships optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) | https://health-education-england-9v.sentry.io/issues/43128197924320417769/?alert_rule_id=1448644914486416&alert_type=issue&project=5752964&referrer=slack | Ignored | Attend | positionNumber is defined not null in the database, but it seems ESR sends records with null position number to TIS. | 16 | TCS | DataIntegrityViolationException | could not execute statement; SQL [n/a]; constraint [null]14 events The current update is on a stale eneity. | ||||||||||||||||||||
15 | TCS | ObjectOptimisticLockingFailureException | PUT /api/personal-details Object of class [com.transformuk.hee.tis.tcs.service.model.PersonalDetails] with identifier [314741]: optimistic locking failed; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statementurl: /api/posts/219720/esr-changedStaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) | https://health-education-england-9v.sentry.io/issues/43128195784320513067/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | seems to be related to the above error | ||||||||||||||||||||||||||
17 | TCS | HHH000346: Error during managed flush [org.hibernate.exception.LockAcquisitionException: could not execute statement] | transaction | Ignored | Only 1 event | |||||||||||||||||||||||||||
18 | TCS | AccessDeniedException | DELETE /api/placements/{id} Access is denied | 5 events. The current update is on a stale eneity. | ||||||||||||||||||||||||||||
16 | TCS | ObjectOptimisticLockingFailureException | PUT /api/contact-details Object of class [com.transformuk.hee.tis.tcs.service.model.ContactDetails] with identifier [301675]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [com.transformuk.hee.tis.tcs.service.model.ContactDetails#301675] | https://health-education-england-9v.sentry.io/issues/43151222954322861749/?alert_rule_id=1448641613350188&alert_type=issue&project=5752964&referrer=slack | Ignored | 8 events Seems to be permission control. | 19 | TCS | Deadlock found when trying to get lock; try restarting transaction | Deadlock found when trying to get lock; try restarting transaction PUT /api/programme-memberships1 event | ||||||||||||||||||||||
17 | DB not null constraints Related to ESR | TCS | Column 'positionNumber' cannot be null | Column 'positionNumber' cannot be null | https://health-education-england-9v.sentry.io/issues/43286507504312819792/?alert_rule_id=1335018814486449&alert_type=issue&project=5752964&referrer=slack | Ignored | Only 1 event | 20 | TCS | CannotAcquireLockExceptionreferrer=slack | Attend | positionNumber is defined not null in the database, but it seems ESR sends records with null position number to TIS. | ||||||||||||||||||||
18 | TCS | DataIntegrityViolationException | could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.LockAcquisitionExceptionConstraintViolationException: could not execute statement PUT url: /api/posts/219720/programmeesr-membershipschanged | https://health-education-england-9v.sentry.io/issues/43286507524312819578/?alert_rule_id=1335018814486416&alert_type=issue&project=5752964&referrer=slack | IgnoredOnly 1 event | seems to be related to the above error | 21 | TCS | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 |
| 29 events The query works most of the time. So It’s still unknown how to reproduce the issue. | 22 | TCS | InvalidDataAccessResourceUsageException | could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSetbe related to the above error | |||||||||||||||||
19 | Data issue - new/old post references the current post itself Related with ESR | TCS | HttpMessageConversionException | Type definition error: [simple type, class com.transformuk.hee.tis.tcs.service.model.Post]; nested exception is com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Direct self-reference leading to cycle (through reference chain: com.transformuk.hee.tis.tcs.service.model.PlacementEsrEvent["placement"]->com.transformuk.hee.tis.tcs.service.model.Placement["post"]->com.transformuk.hee.tis.tcs.service.model.Post["newPost"]) | https://health-education-england-9v.sentry.io/issues/43147806924312522176/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Ignored | related to the above error | 23 | TCS | IOException | POST /api/documents File is empty | Attend |
| |||||||||||||||||||
20 | Deadlock when “PUT /api/programme-memberships” | TCS | HHH000346: Error during managed flush [org.hibernate.exception.LockAcquisitionException: could not execute statement] | transaction | https://health-education-england-9v.sentry.io/issues/43258835774328652261/?alert_rule_id=13350188&alert_type=issue&project=5752964&referrer=slack | Ignored | 3 events | 24 | TCS | IOException | PATCH /api/bulk-people/ Connection reset by peerOnly 1 event | |||||||||||||||||||||
21 | TCS | Deadlock found when trying to get lock; try restarting transaction | Deadlock found when trying to get lock; try restarting transaction PUT /api/programme-memberships | https://health-education-england-9v.sentry.io/issues/43257767924328650750/?alert_rule_id=13350188&alert_type=issue&project=5752964&referrer=slack | AttendIgnored | Only 1 event on 19th July 11:11:41. It’s very likely to be linked with the stalled Person Update file issue (Andrew Goodhand uploaded a file at 11:03;41) | 25 | TCS | IllegalArgumentException | GET /api/people/v2/{id} Source must not be null seems to be related to the above error | ||||||||||||||||||||||
22 | TCS | CannotAcquireLockException | could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute statement PUT /api/programme-memberships | https://health-education-england-9v.sentry.io/issues/43151434394328650752/?alert_rule_id=1448641613350188&alert_type=issue&project=5752964&referrer=slack | Ignored Won’t handle soon. | 2 events It seems the id user requested doesn’t exist. | 25Only 1 event seems to be related to the above error | |||||||||||||||||||||||||
23 | Elasticsearch Exception about person list | TCS | UncategorizedElasticsearchException | GET /api/people Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]; nested exception is ElasticsearchStatusException[Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]] | Ignored | It’s not very clear why the shards health check failed, but we don’t always get this error, so it should be okay to ignore it. | ||||||||||||||||||||||||||
2624 | TCS | UncategorizedElasticsearchException | GET /api/people Unable to parse response body; nested exception is ElasticsearchStatusException[Unable to parse response body]; nested: ResponseException[method [POST], host [https://vpc-es7-4prod-qyke6r2vwvp2fno6j5iod6ffma.eu-west-2.es.amazonaws.com], URI [/persons/_search?pre_filter_shard_size=128&typed_keys=true&max_concurrent_shard_requests=5&ignore_unavailable=false&expand_wildcards=open&allow_no_indices=true&ignore_throttled=true&search_type=dfs_query_then_fetch&batched_reduce_size=512&ccs_minimize_roundtrips=true], status line [HTTP/1.1 504 Gateway Time-out/_search?pre_filter_shard_size=128&typed_keys=true&max_concurrent_shard_requests=5&ignore_unavailable=false&expand_wildcards=open&allow_no_indices=true&ignore_throttled=true&search_type=dfs_query_then_fetch&batched_reduce_size=512&ccs_minimize_roundtrips=true], status line [HTTP/1.1 504 Gateway Time-out] | Attend | 147 events We might want to take a look what happened. | |||||||||||||||||||||||||||
25 | TCS | DataAccessResourceFailureException | 30,000 milliseconds timeout on connection http-outgoing-281 [ACTIVE]; nested exception is java.lang.RuntimeException: 30,000 milliseconds timeout on connection http-outgoing-281 [ACTIVE] | https://health-education-england-9v.sentry.io/issues/43209129704325361391/?alert_rule_id=1448641613350188&alert_type=issue&project=5752964&referrer=slack | Attend | 147 events We might want to take a look what happened. | 27 | TCS | DataAccessResourceFailureException | 30,000 milliseconds timeout on connection http-outgoing-281 [ACTIVE]; nested exception is java.lang.RuntimeException: 30,000 milliseconds timeout on connection http-outgoing-281 [ACTIVE] | Ignored | Might be hit the windows of snapshot. Only 1 event | ||||||||||||||||||||
26 | /api/documents | TCS | HttpRequestMethodNotSupportedException | Request method 'GET' not supported | https://health-education-england-9v.sentry.io/issues/43253613914312914283/?alert_rule_id=1335018814486416&alert_type=issue&project=5752964&referrer=slack | Ignored | Might be hit the windows of snapshot. Only 1 event | 28 | TCS | HttpMessageNotReadableException | JSON parse error: Cannot deserialize value of type `java.time.LocalDate` from String "24-11-04": Failed to deserialize java.time.LocalDateWon’t handle soon. | 14 events | ||||||||||||||||||||
27 | TCS | IOException | POST /api/documents File is empty | https://health-education-england-9v.sentry.io/issues/43151664004325883577/?alert_rule_id=1448641613350188&alert_type=issue&project=5752964&referrer=slack | Ignored | Programme membership detail page only colours the incorrectly formatted date red, but still allow them to be sent to the backend. | 29Won’t handle soon. | 3 events | ||||||||||||||||||||||||
28 | TCS | HttpMessageConversionException | Type definition error: [simple type, class com.transformuk.hee.tis.tcs.service.model.Post]MultipartException | Failed to parse multipart servlet request; nested exception is com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Direct self-reference leading to cycle (through reference chain: com.transformuk.hee.tis.tcs.service.model.PlacementEsrEvent["placement"]->com.transformuk.hee.tis.tcs.service.model.Placement["post"]->com.transformuk.hee.tis.tcs.service.model.Post["newPost"])java.lang.RuntimeException: java.io.IOException: UT000128: Remote peer closed connection before all data could be read | Ignored Won’t handle soon. | Only 1 event | ||||||||||||||||||||||||||
29 | Date deserialization error. Related to UI. | TCS | HttpMessageNotReadableException | JSON parse error: Cannot deserialize value of type `java.time.LocalDate` from String "24-11-04": Failed to deserialize java.time.LocalDate | Ignored | Programme membership detail page only colours the incorrectly formatted date red, but still allow them to be sent to the backend. | ||||||||||||||||||||||||||
30 | Access denied | TCS | AccessDeniedException | DELETE /api/placements/{id} Access is denied | https://health-education-england-9v.sentry.io/issues/43125221764315122295/?alert_rule_id=14486416&alert_type=issue&project=5752964&referrer=slack | Attend |
| 30Ignored | 8 events Seems to be permission control. | |||||||||||||||||||||||
31 | Entity is not found | TCS | EntityNotFoundException | POST /api/programme-memberships/delete/ Unable to find com.transformuk.hee.tis.tcs.service.model.CurriculumMembership with id 404778 | Ignored | Only 1 event | ||||||||||||||||||||||||||
3132 | TCS | EntityNotFoundException | DELETE /api/placements/{id} | Ignored Won’t handle soon. | Only 1 event | |||||||||||||||||||||||||||
3233 | TCS | MultipartException | Failed to parse multipart servlet request; nested exception is java.lang.RuntimeException: java.io.IOException: UT000128: Remote peer closed connection before all data could be read url: http://apps.tis.nhs.uk/tcs/api/documentsIllegalArgumentException | GET /api/people/v2/{id} Source must not be null | https://health-education-england-9v.sentry.io/issues/43230134924315143439/?alert_rule_id=1335018814486416&alert_type=issue&project=5752964&referrer=slack | Ignored Won’t handle soon. | Only 1 event | 33 | TCS | IOException | Broken pipe url: http://stage-apps.tis.nhs.uk/tcs2 events It seems the id user requested doesn’t exist. | |||||||||||||||||||||
34 | TCS | NullPointerException | DELETE /api/placements/draftList/818{id} null value in entry: delete=null | https://health-education-england-9v.sentry.io/issues/43553449684314696155/?alert_rule_id=1335018814486416&alert_type=issue&project=5752964&referrer=slack | Attend | We have to take a look this endpoint for programmeId 818 | Ignored | 3 events, and all related placements were deleted. The exception is thrown in the |