[Progress Communities] [Progress OpenEdge ABL] Forum Post: PASOE/REST - How to Handle Database Disconnects

[jts-law]

Hello, I have a REST service that uses a Data Object Handler. I'm using a DB connection string on the "Agent startup parameter" to connect to the DB, and code within the agent startup procedures to create/set my initial client principal. The session startup procedure creates a new instance of my DOH event handler, which then runs persistent. As requests My issue is that if the database gets restarted and PASOE does not (currently on different servers), the DOH code errors due to the database having been shutdown. The following are generated to the oepas1.agent.log file: [18/02/16@13:29:12.918-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.InternalWebRouter DEBUG] Request for path "/JTS/web/pdo/UI/ProfitGrp" using template "/pdo/" and handler "OpenEdge.Web.DataObject.DataObjectHandler" [18/02/16@13:29:12.922-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.InternalWebRouter DEBUG] Debug mode: ON [18/02/16@13:29:12.931-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.InternalWebRouter DEBUG] Handler instance OpenEdge.Web.DataObject.DataObjectHandler_4609 used for handler OpenEdge.Web.DataObject.DataObjectHandler [18/02/16@13:29:12.975-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr INFO: Current session client type MULTI-SESSION-AGENT does not support named logs [18/02/16@13:29:12.995-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DataObjectHandler DEBUG] Using mapped operation for GET service path ProfitGrp: OpenEdge.Web.DataObject.MappedOperation_3280: GET svc:UI v1.0.0 urirofitGrp: type:Class ; namerogress.Lang.Object, type-ofrogress.Lang.Object, fn:, numargs:2, num-schemas:1, name: [18/02/16@13:29:13.062-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr INFO: Current session client type MULTI-SESSION-AGENT does not support named logs [18/02/16@13:29:13.074-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DataObjectHandler INFO] Service UI logging performed by OpenEdge.Web.DataObject.DataObjectHandler.UI at DEBUG [18/02/16@13:29:13.132-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DOH.UI DEBUG] "Accept" value: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 [18/02/16@13:29:13.143-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DOH.UI DEBUG] Operation ContentType: application/json [18/02/16@13:29:13.159-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DOH.UI DEBUG] Business entity ProfitGrpBE (type-of Progress.Lang.Object) invoked by OpenEdge.Web.DataObject.DataObjectHandler_4609 as target type Class [18/02/16@13:29:13.228-0600] P-016920 T-018504 1 AS-8 -- (Procedure: 'LoadEntityHandler OpenEdge.Web.DataObject.DataObjectHandler' Line:1389) Error reading socket, ret=10053, errno=2. (778) [18/02/16@13:29:13.228-0600] P-016920 T-018504 1 AS-8 -- (Procedure: 'LoadEntityHandler OpenEdge.Web.DataObject.DataObjectHandler' Line:1389) ** Incomplete write when writing to the server. (735) [18/02/16@13:29:13.228-0600] P-016920 T-018504 1 AS-8 -- (Procedure: 'LoadEntityHandler OpenEdge.Web.DataObject.DataObjectHandler' Line:1389) Failed to acquire requisite lock to read schema (12536) I've tried to add code in a few different spots to either reconnect, or cause the agent to quit so it can restart and reconnect to the database on the next request but nothing I have tried so far has worked. Has anybody had a similar issue and come up with a solution? TIA Louis Winter [18/02/16@13:29:12.918-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.InternalWebRouter DEBUG] Request for path "/JTS/web/pdo/UI/ProfitGrp" using template "/pdo/" and handler "OpenEdge.Web.DataObject.DataObjectHandler"[18/02/16@13:29:12.922-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.InternalWebRouter DEBUG] Debug mode: ON [18/02/16@13:29:12.931-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.InternalWebRouter DEBUG] Handler instance OpenEdge.Web.DataObject.DataObjectHandler_4609 used for handler OpenEdge.Web.DataObject.DataObjectHandler[18/02/16@13:29:12.975-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr INFO: Current session client type MULTI-SESSION-AGENT does not support named logs[18/02/16@13:29:12.995-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DataObjectHandler DEBUG] Using mapped operation for GET service path ProfitGrp: OpenEdge.Web.DataObject.MappedOperation_3280: GET svc:UI v1.0.0 urirofitGrp: type:Class ; namerogress.Lang.Object, type-ofrogress.Lang.Object, fn:, numargs:2, num-schemas:1, name:[18/02/16@13:29:13.062-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr INFO: Current session client type MULTI-SESSION-AGENT does not support named logs[18/02/16@13:29:13.074-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DataObjectHandler INFO] Service UI logging performed by OpenEdge.Web.DataObject.DataObjectHandler.UI at DEBUG[18/02/16@13:29:13.132-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DOH.UI DEBUG] "Accept" value: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8[18/02/16@13:29:13.143-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DOH.UI DEBUG] Operation ContentType: application/json[18/02/16@13:29:13.159-0600] P-016920 T-018504 1 AS-8 LogMgrWrtr [OE.W.DO.DOH.UI DEBUG] Business entity ProfitGrpBE (type-of Progress.Lang.Object) invoked by OpenEdge.Web.DataObject.DataObjectHandler_4609 as target type Class[18/02/16@13:29:13.228-0600] P-016920 T-018504 1 AS-8 -- (Procedure: 'LoadEntityHandler OpenEdge.Web.DataObject.DataObjectHandler' Line:1389) Error reading socket, ret=10053, errno=2. (778)[18/02/16@13:29:13.228-0600] P-016920 T-018504 1 AS-8 -- (Procedure: 'LoadEntityHandler OpenEdge.Web.DataObject.DataObjectHandler' Line:1389) ** Incomplete write when writing to the server. (735)[18/02/16@13:29:13.228-0600] P-016920 T-018504 1 AS-8 -- (Procedure: 'LoadEntityHandler OpenEdge.Web.DataObject.DataObjectHandler' Line:1389) Failed to acquire requisite lock to read schema (12536)

Continue reading...