Search results

  1. Rob Fitzpatrick

    Progress with XML or JSON ?

    Any "what can OpenEdge do" question is entirely dependent on which OpenEdge release you are using. We don't know that.
  2. Rob Fitzpatrick

    Connect Windows appserver to a Linux database

    Yes, -Mm affects remote 4GL client connections. In 11.x the default value is 1024 which is quite low, and inadequate for most applications. Try 8192. You can specify it on the database login broker, and you don't have to specify it on the client (App Server) side.
  3. Rob Fitzpatrick

    Connect Windows appserver to a Linux database

    You're welcome. :) The client OpenEdge release may be at or above the database release, up to one major-version different (e.g. 12.x client connecting to 11.x database), provided that the database connection is via TCP and not shared memory. The database release cannot be above the client release.
  4. Rob Fitzpatrick

    Connect Windows appserver to a Linux database

    You and I may have differing opinions on "legitimacy", which is a value judgement, but this is a common and very acceptable configuration. At this point -N exists for backward compatibility. It doesn't hurt but it doesn't help. There is only one supported network protocol which is tcp...
  5. Rob Fitzpatrick

    PASOE resources not getting released

    The watchdog only operates on servers and self-service connections. It only intervenes and removes a connection if it detects a variance between the processes listed in the user connection table (_Connect) and the OS process list. For example, if _Connect shows user 123, type Self/4GL, PID...
  6. Rob Fitzpatrick

    Progress Editor Temporary file

    Exactly. Or the user could run applicationstartprocedure.p, which is the name of the procedure that everyone runs, except that unbeknownst to you their copy is modified to do something different. And the modified copy can be replaced before you get a chance to check it. It sounds like the...
  7. Rob Fitzpatrick

    Question ABL Wordle Application

    Who needs fonts? Make it CHUI. :D
  8. Rob Fitzpatrick

    Progress Editor Temporary file

    This sounds awfully familiar. There was a similar discussion recently, here: https://www.progresstalk.com/threads/progress-editor.202254/ Your options are going to depend on your OpenEdge release, which you haven't mentioned.
  9. Rob Fitzpatrick

    Progress Editor Temporary file

    Procedure Editor unsaved buffers are transient by design. And even if you could get .ped files to stick around, they are files in the user's file system that they have permission to delete, so it still wouldn't fulfill any meaningful audit requirement. So it seems your real requirement is that...
  10. Rob Fitzpatrick

    purge and resize db

    Here is a little more material for your upcoming discussion. OpenEdge 11.7 will be retired in a little over a year from now, in April 2025. https://docs.progress.com/bundle/openedge-life-cycle/page/OpenEdge-Life-Cycle.html Progress has moved OpenEdge to a long-term support (LTS) model, where...
  11. Rob Fitzpatrick

    purge and resize db

    I don't think you have described your database structure in detail yet, e.g. whether your application data is in Type 1 or Type 2 storage areas. This is relevant for this discussion, as they do space management differently. What is the issue that makes you set on freeing space for growth...
  12. Rob Fitzpatrick

    purge and resize db

    Your table and LOB data lives in record blocks (sometimes called "RM blocks"). Once a block is formatted as a record block, it remains a record block. Even if you delete all the record fragments it contains, while the the record block is in a sense logically empty, its block type does not...
  13. Rob Fitzpatrick

    DB Parameters -S

    For future reference, in Windows the services file is %windir%\System32\drivers\etc\services. In Unix systems it is /etc/services. It is a mapping of service names to TCP or UDP port numbers. The -S parameter, when used on a database broker, is what makes it a login broker. The broker binds...
  14. Rob Fitzpatrick

    Macros, run an Excel macro from 4GL

    Good way to perform code injection in an application. ;)
  15. Rob Fitzpatrick

    Ideas for caching a table?

    It should! Accessing data in the buffer pool is of course faster than incurring database server disk I/O to page it into the buffer pool first, but it is far from being free just because it is memory-resident. I doubt that using -B2 will help in this case. Currently, that control record's...
  16. Rob Fitzpatrick

    Audit Trail Functionality in Progress OpenEdge 10.02 B

    It's not clear to me whether your questions are about OpenEdge Auditing capabilities in general, or about some QAD-specific implementation of it. If it is the latter, then this isn't the appropriate forum. It depends on what you mean by "access". OpenEdge Auditing (OEA) can audit system...
  17. Rob Fitzpatrick

    _proapsv high CPU usage in Redhat 6.6 (Resolved)

    Note: proadsv is the Admin service _proapsv is a Classic App Server agent As to what is happening in those App Servers, I don't know. The first thing to do is check your App Server logs. You might also want to revisit your database parameter values. For example, -Mpb larger than -Mn doesn't...
  18. Rob Fitzpatrick

    Locking up when inactive?

    Agreed, that 778/735 happens when there is a network disruption and the client disconnects from the database.
  19. Rob Fitzpatrick

    Error: could not recognize argument: localhost (301) Why?

    Glad to hear it. We've all been there. It's often easier for someone else to see the bug you've been staring at for a while without seeing it. Asking for help is a good way to get unstuck and make more productive use of your time, even if it's a little humbling sometimes.
Back
Top