[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Client Session is writing to windows application event log!

[dbeavon]

Thanks for the tip. I was thinking about this a little more and I'm pretty convinced now that this is vestigial behavior that is not an intentional part of the design of a remote instance of PASOE. Notice that the messages claim to be from the database. The events explicitly say they are a "Message from PROGRESS database lumbertrack". I'm guessing that in a legacy "shared-memory" scenario, where client sessions are running on the **same** machine as the database, the client sessions themselves were responsible for logging some portion of the problems that are considered database-related . The event-log entries coming from the database-server *and* from the client-sessions would be reported into the **same** event source on the same server, thereby giving a "complete" picture of all databases-related errors and warnings. Again the value of this approach is somewhat lost when you are talking about a remote PASOE instance which is pretty far removed from the database server itself. It would be more challenging in that case to see the combined list of database-related errors and warnings. ... If you have a load-balanced PASOE deployment then things get even more peculiar - since you have to harvest all these database-related messages from a number of servers. In general, most client-session errors in PASOE can be found in the msagent logs (including the "Lock wait timeout" one). It is odd to see these so-called "database" errors being treated differently insofar as they are sent to a custom event source in the application logs. I haven't found any examples of other types of error messages being sent to the windows event log on a PASOE server, so I think the messages are limited to errors that are considered to be "database" errors. Hope this is clear. As tpavlovic showed above, it makes more sense if you log messages yourself, rather than relying on the the vestigial behavior from the days of "shared-memory" clients. You probably won't want the eventsource name to appear as if these messages are being written by the database server.

Continue reading...