Doing a PS2022 POC for our existing C/S application. Prompting for User info prior to connecting to the DB. Connection is successful, MDI opens and initial sheet opens successfully with retrieved data.
Then a different window (application about window) can be successfully opened 1 or more times, it includes Embedded SQL in the open event. Then on a subsequent attempt to open, it fails on the same Embedded SQL it successfully processed moments before.
I'm getting the "Session Fails to respond (Session does not exist)" error in various places, shortly after the application opens successfully and retrieves data. The PowerServer help says this is normally caused by the Web APIs having been restarted, but I'm running this in IIS on my machine, how would the Web APIs keep being restarted?
Has anyone experienced similar behavior?