Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SFAS Bridge File Timeout #3836

Open
2 tasks
ninosamson opened this issue Oct 24, 2024 · 0 comments
Open
2 tasks

SFAS Bridge File Timeout #3836

ninosamson opened this issue Oct 24, 2024 · 0 comments
Assignees
@ninosamson @CarlyCotton
Labels
Bug Something isn't working Business Items under Business Consideration

Comments

@ninosamson
Copy link
Collaborator

ninosamson commented Oct 24, 2024 •
edited
Loading

Describe the Bug
In loading the PROD file, the SFAS bridge file import was failing due to duplicate key value on "sfas_restrictions_pkey". As well, the import was taking longer than expected and timing out.

  • Increase "lockduration" on sfas integration process to allow for import of large files
  • Investigate issues with loading records in same file with same ID

Context:

  • Review of the failing lines indicates some duplicates in the SFAS files
  • [Nest] 17 - 10/24/2024, 9:43:48 PM ERROR [SFASIntegrationProcessingService] QueryFailedError: duplicate key value violates unique constraint "sfas_restrictions_pkey"
@ninosamson ninosamson added Bug Something isn't working Business Items under Business Consideration labels Oct 24, 2024
@ninosamson ninosamson changed the title SFAS Bridge File - SFAS Restrictions PKey SFAS Bridge File Timeout Oct 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ninosamson ninosamson

@CarlyCotton CarlyCotton

Labels
Bug Something isn't working Business Items under Business Consideration
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ninosamson @CarlyCotton