Search results

  1. Rob Fitzpatrick

    Macros, run an Excel macro from 4GL

    Good way to perform code injection in an application. ;)
  2. 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...
  3. 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...
  4. 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...
  5. Rob Fitzpatrick

    Locking up when inactive?

    Agreed, that 778/735 happens when there is a network disruption and the client disconnects from the database.
  6. 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.
  7. Rob Fitzpatrick

    Question After Imaging Files

    I think the "past musings" will suffice for now. However: Amen. The "A" in "DBA" doesn't mean "just lookin' around". We change stuff too.
  8. Rob Fitzpatrick

    Question After Imaging Files

    Some past musings on OE Auditing: https://www.progresstalk.com/threads/progress-auditing.122722/
  9. Rob Fitzpatrick

    Question After Imaging Files

    That tool is related to OE Auditing. My point was that it is just one tiny part of it.
  10. Rob Fitzpatrick

    Question After Imaging Files

    I've written here at some length about OE Auditing in the past. It involves extra work (reads, writes, BI/AI note volume), and work isn't free. It has a computational and storage cost. But that isn't a reason to avoid it; compliance requirements trump performance desires. And performance...
  11. Rob Fitzpatrick

    Question After Imaging Files

    CDC was introduced in 11.7. "Reporting CUDs" isn't much of a business requirement. If you were asking me personally, I'd want much more of an explanation of what you want to accomplish before recommending a solution. But I am confident that solution wouldn't involve parsing aimage scan...
  12. Rob Fitzpatrick

    DB Viewer

    If you want an OpenEdge data viewer, give Patrick Tingen's DataDigger a try. GitHub - patrickTingen/DataDigger: A dynamic dataviewer for your Progress / OpenEdge databases
  13. Rob Fitzpatrick

    Progress Openedge 11.6 with it's own java components

    $DLC/properties/java.properties only exists in OE 12.1 and later, according to the referenced article. It also mentions, for earlier releases, a file called $DLC/properties/JavaTools.properties that must be modified if you use OEE or OEM.
  14. Rob Fitzpatrick

    Question DB user-level password policy implementation OE 11.73

    The takeaway here is: The old OpenEdge RDBMS authentication functionality stores hashed passwords in _User. Passwords are hashed, once, with the encode function, as opposed to a modern, high-quality cryptographic hash function that is suitable for this purpose. There is no possibility to salt...
  15. Rob Fitzpatrick

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

    When you see a message that begins with "**" and ends with a number in brackets, that number is an error number. You can look these up in the Procedure Editor, or in the ']knowledge base, or in ProKB, which is a downloadable application for browsing the knowledge base. Here is the entry on...
  16. Rob Fitzpatrick

    Some questions about Developer Studio

    Another alternative for you is to use VS Code, which is cross-platform. Riverside Software makes an extension for it (called "OpenEdge ABL") that provides features like syntax highlighting, compilation, projects, debugging, etc. It's free.
  17. Rob Fitzpatrick

    Some questions about Developer Studio

    Cool! I learned something new today. :)
  18. Rob Fitzpatrick

    Question DB user-level password policy implementation OE 11.73

    I used to work on a federated application (multiple databases) which, in the past, stored user credentials and attributes in _User in each of the databases, as well as in an application table. It had all of the authentication rules you described, implemented at the application level. Password...
  19. Rob Fitzpatrick

    Some questions about Developer Studio

    I use PDSOE although I am certainly no expert in using and configuring it, and I probably use a fraction of what it can do. My code is CHUI-only; you can certainly use PDSOE for that use case, and in my opinion it is miles better than the character or GUI Procedure Editors, though Eclipse is...
  20. Rob Fitzpatrick

    Answered How to "prodict" without 4GL Development Kit?

    Also, if you're going to reference KB articles that you think are relevant and expect your audience to be aware of, it's helpful to provide links to those articles so it's easier for others to help you.
Back
Top