search

reapit / foundations

Foundations platform mono repo
57 stars 21 forks source link

documents API returning 500 status #10964

Closed chestertons closed 3 months ago

chestertons commented 3 months ago

Attempting to retrieve data from https://platform.reapit.cloud/documents/?PageNumber=1&PageSize=100&sortBy=modified&modifiedFrom=2024-03-26T14:31:37Z

response is ( [statusCode] => 500 [dateTime] => 2024-03-27T11:55:26.7315594Z [description] => An unexpected error has been encountered when fulfilling this request. This incident has been logged and will be investigated. Please try again. )

github-actions[bot] commented 3 months ago

Thank you for taking the time to report a bug. We prioritise bugs depending on the severity and implications, so please ensure that you have provided as much information as possible. If you haven’t already, it really helps us to investigate the bug you have reported if you provide ‘Steps to Replicate’ and any associated screenshots. Please ensure any personal information from the production database is obscured when submitting screenshots. This issue will be reviewed in our weekly refinement sessions and assigned to a specific project board. We may also update the ticket to request additional information, if required. For more information on our processes, please click here

AshDeeming commented 3 months ago

Hi @chestertons Please could you advise which app this is referring to, along with which database i.e. SBOX or production?

chestertons commented 3 months ago

Production

Sent from Outlook for iOShttps://aka.ms/o0ukef

From: Ash @.> Sent: Wednesday, March 27, 2024 3:31:46 PM To: reapit/foundations @.> Cc: Dashboard Admin @.>; Mention @.> Subject: Re: [reapit/foundations] documents API returning 500 status (Issue #10964)

Hi @chestertonshttps://github.com/chestertons Please could you advise which app this is referring to, along with which database i.e. SBOX or production?

— Reply to this email directly, view it on GitHubhttps://github.com/reapit/foundations/issues/10964#issuecomment-2023069603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BC3KZLHTZLTHXXGPVNVCLHDY2LJ5FAVCNFSM6AAAAABFKXGK7CVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMRTGA3DSNRQGM. You are receiving this because you were mentioned.Message ID: @.***>

The contents of this e-mail do not constitute a commitment by Chestertons, unless separately endorsed by an authorized representative of Chestertons. Chestertons believes that this e-mail and any attachments are free of viruses. However, it is the responsibility of the recipient to ensure it is virus free and Chestertons does not accept any responsibility for any loss or damage that may arise from the use of this e-mail or its contents.

UK offices: Registered office Chesterton Global Ltd is 40 Connaught Street, Hyde Park, London, England, W2 2AB Registered in England Company Number 05334580 Chesterton Global Ltd - This e-mail is confidential and may contain legally privileged information; it is intended for the use of the addressee only. If you are not the addressee you must not read, use, distribute copy or rely on this e-mail. If you have received this communication in error please notify us immediately by e-mail or by telephone (+44 (0) 20 3040 8240).

plittlewood-rpt commented 3 months ago

HI @chestertons I'm already aware of this from the logs and actively investigating. Thanks

plittlewood-rpt commented 3 months ago

Hi @chestertons this should now be resolved. There was some very old P2 Gold data lurking in the system which didn't have any record register information against it - one of those documents was amended recently which left the API in a state where it couldn't handle the row presented by the database. I've now populated this based on when the original conversion took place and no longer receive the error when making the same call as you. Please can you confirm the problem is now resolved for you also?

chestertons commented 3 months ago

Thanks Pete, looks like that did it yes.

Can we have an offline chat about this error and recent similar?

Sent from Outlook for iOShttps://aka.ms/o0ukef

From: Pete Littlewood @.> Sent: Wednesday, March 27, 2024 3:55:26 PM To: reapit/foundations @.> Cc: Dashboard Admin @.>; Mention @.> Subject: Re: [reapit/foundations] documents API returning 500 status (Issue #10964)

Hi @chestertonshttps://github.com/chestertons this should now be resolved. There was some very old P2 Gold data lurking in the system which didn't have any record register information against it - one of those documents was amended recently which left the API in a state where it couldn't handle the row presented by the database. I've now populated this based on when the original conversion took place and no longer receive the error when making the same call as you. Please can you confirm the problem is now resolved for you also?

— Reply to this email directly, view it on GitHubhttps://github.com/reapit/foundations/issues/10964#issuecomment-2023124289, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BC3KZLFFTBTFRVXWDJIBVITY2LMV5AVCNFSM6AAAAABFKXGK7CVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMRTGEZDIMRYHE. You are receiving this because you were mentioned.Message ID: @.***>

The contents of this e-mail do not constitute a commitment by Chestertons, unless separately endorsed by an authorized representative of Chestertons. Chestertons believes that this e-mail and any attachments are free of viruses. However, it is the responsibility of the recipient to ensure it is virus free and Chestertons does not accept any responsibility for any loss or damage that may arise from the use of this e-mail or its contents.

UK offices: Registered office Chesterton Global Ltd is 40 Connaught Street, Hyde Park, London, England, W2 2AB Registered in England Company Number 05334580 Chesterton Global Ltd - This e-mail is confidential and may contain legally privileged information; it is intended for the use of the addressee only. If you are not the addressee you must not read, use, distribute copy or rely on this e-mail. If you have received this communication in error please notify us immediately by e-mail or by telephone (+44 (0) 20 3040 8240).

plittlewood-rpt commented 3 months ago

HI @chestertons the easiest thing to do is reach out via sinfo@reapitfoundations.zendesk.com where this can be discussed. Ultimately it's very old data that's causing these issues and it would be something our service desk needed to get involved in to resolve initially.