Closed joeschmit closed 4 years ago
Hey Josh - I'd assumed this was related to HATS being hosted in the cloud, but I just had a peek at this, and am seeing an error in QA as well. The errors are different, though: QA: "Edit Feature - Location - The EXECUTE permission was denied on the object 'usp_HATS_GetStateRoutePointGeographiesForStateRoutePoint', database 'WSDOTDataLibrary', schema 'dbo'." Prod: "Could not find entered Start SR, RRT, RRQ, SRMP on the state route system. Save could not be completed."
I’ll take a look, see if I can figure it out.
Joshua Hudson Applications Modernization Manager, Enterprise Applications [cid:image001.png@01D496DE.F3223B40] hudsonj@wsdot.wa.govmailto:hudsonj@wsdot.wa.gov | 360.705.7778
From: brianblood notifications@github.com Sent: Thursday, October 24, 2019 10:03 AM To: WSDOT/HATS HATS@noreply.github.com Cc: Hudson, Joshua HudsonJ@wsdot.wa.gov; Assign assign@noreply.github.com Subject: Re: [WSDOT/HATS] HATS Web: Editing Feature Location (Region/Area) Bug (#1364)
Hey Josh - I'd assumed this was related to HATS being hosted in the cloud, but I just had a peek at this, and am seeing an error in QA as well. The errors are different, though: QA: "Edit Feature - Location - The EXECUTE permission was denied on the object 'usp_HATS_GetStateRoutePointGeographiesForStateRoutePoint', database 'WSDOTDataLibrary', schema 'dbo'." Prod: "Could not find entered Start SR, RRT, RRQ, SRMP on the state route system. Save could not be completed."
— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/WSDOT/HATS/issues/1364?email_source=notifications&email_token=AAFLP3SMD3NX242U5JEI6Z3QQHILHA5CNFSM4ITXO2B2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECFXQTI#issuecomment-546011213, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAFLP3V2D7BOBZELMBXICTTQQHILHANCNFSM4ITXO2BQ.
This has been migrated to a Work Item in our Dev Ops system.
Edit Feature - Location - The target database ('WSDOTDataLibrary') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent, see SQL Server Books Online.