Search results

  1. KMoody

    Querying LDAP Passwords

    Is it possible to query LDAP through an OpenEdge program? I found code like this: USING System.DirectoryServices.AccountManagement.*. DEFINE VARIABLE objContext AS CLASS PrincipalContext. objContext = NEW PrincipalContext(ContextType:Domain,"YourDomain"). MESSAGE...
  2. KMoody

    Error 16488: Index of Table is Not Active

    I added an inactive index (DATE-PART-LINE) online for a table (INVHIST). I then compiled programs that used INVHIST but didn't reference DATE-PART-LINE. When I ran those compiled programs, I received the following error: Index 'DATE-PART-LINE' of table 'INVHIST' is not active. (16488) Why...
  3. KMoody

    Locking Scope with External Procedures

    I have two programs: test.p FIND item WHERE item.part-num = "4M5" AND item.cto-code = "" EXCLUSIVE-LOCK NO-ERROR. RUN test2. PAUSE. test2.p FIND sysmstr WHERE coname = "NEXTWO" EXCLUSIVE-LOCK NO-ERROR. When test.p pauses, both ITEM and SYSMSTR tables are locked. Why is...
  4. KMoody

    System.Text Namespace Crash

    Version: OpenEdge 11.7.5.00 OS: Windows 10 Pro System Type: 64-bit I'm running the following code: USING System.Text.RegularExpressions.*. message "start...". DEF VAR regexp AS CLASS Regex NO-UNDO. regexp = NEW Regex("^[~\w.!#$%&’*+/=?^_`~{|~}~-]+@[~\w-]+(?:\.[a-zA-Z0-9-]+)*$"). message...
  5. KMoody

    Search Temp-Table by Class Instance Property

    I have two classes: maze_util and point_util (see below). A maze_util contains a temp table (tt) of point_util instances stored as Progress.Lang.Object. In maze_util:getTestValue, I want to find a tt record by looking up the x and y values of the tt's point. I tried to do this by CASTing...
  6. KMoody

    Data Dictionary Display

    How do you change the Data Dictionary display from the first mode to the second (see pictures)? I think you have to use a startup parameter, but I can't remember what it is.
  7. KMoody

    Changing a Field's Extent in 11.7.3

    According to this article, it's not possible to change a field's extent once you commit a database. Is this still true in 11.7.3?
  8. KMoody

    Audit Archive Failure

    We ran the following on Sunday, March 8, at 3 AM: proutil /users/mf/live/db/mffg1 -C auditarchive -directory /users/mf/live/db/audit_archive/ The log shows the following: OpenEdge Release 11.7.5 as of Fri Jun 7 08:29:03 EDT 2019 Archive all the records prior to 2020/03/08@03:00:01.530-0500...
  9. KMoody

    Question Storing Auditing Data in Production Databases

    OpenEdge documentation recommends archiving auditing data separately from production databases. I'd like to get some clarification on the reasons why. (Context: Our production databases are 4.8 GB, and our archive database is 10 GB. We are not legally bound to use auditing; for us, it serves as...
  10. KMoody

    Question PROUTIL AUDITARCHIVE Archive File Overwrite

    The OpenEdge documentation says the following: However, it seems like PROUTIL AUDITARCHIVE doesn't give you the choice to overwrite the existing audit archive (abd). In my cronjob script, I ran the following: yes | proutil /users/mf/live/db/mffg1 -C auditarchive -directory...
  11. KMoody

    Question Online Field/Table Description Changes

    Is it true that changing the description of a table or field is not allowed while its database is in multi-user mode? If so, I'd like to understand why. If users can change the format of existing fields online, then why can't they change descriptions?
  12. KMoody

    Running dump_d with Enterprise License

    Progress: 11.7.5 Server 1: SUSE Linux Enterprise Server 15 SP1, OE Enterprise RDBMS Only Server 2: SUSE Linux Enterprise Server 15 SP1, OE Enterprise RDBMS and 4GL Development System I've compiled prodict/dump_d.p on Server 2 and copied the .r to the same directory on Server 1. However, when I...
  13. KMoody

    Loading Audit Policies Error

    Progress: 11.7.5 Server OS: SUSE Linux Enterprise Server 15 SP1 On the Linux server, we first dump from a database (D1) and load it into another (D2). After loading all non-auditing information into D2, we run the following: /* ... */ /* Load Audit Data Note: Requires a minimum of...
  14. KMoody

    Question Creating Buffer Objects Error

    Progress: 11.7.5 Server OS: SUSE Linux Enterprise Server 15 SP1 We're in the middle of upgrading from Progress 10.2b to 11.7.5. In 10.2b, we were sometimes able to run the following, even when "CONNECTED('mffg1')" was false: DEFINE VARIABLE hPopupBuffer AS HANDLE NO-UNDO. CREATE...
  15. KMoody

    BULKLOAD Across Servers

    Progress: 11.7.5 Server OS: SUSE Linux Enterprise Server 15 SP1 Let's say we have an empty database on Server 1 and an FD file on Server 2. Is it possible to issue a BULKLOAD command to the empty database on Server 1 to load the FD file on Server 2? (It may not be fast or practical, but is it...
  16. KMoody

    Adecomm Library

    Progress: 11.7.5 Server OS: SUSE Linux Enterprise Server 15 SP1 $DLC: /usr/dlc PROPATH: /usr/dlc/tty /usr/dlc/tty/OpenEdge.Core.pl /usr/dlc/tty/adecomm.pl /usr/dlc/tty/adeshar.pl /usr/dlc/tty/adeedit.pl /usr/dlc/tty/adecomp.pl /usr/dlc/tty/dataadmin.pl /usr/dlc/tty/prodict.pl...
  17. KMoody

    OpenEdge 11.7.5 Service Pack

    According to this article, OpenEdge Service Pack 11.7.5 was considered "Mature" as of March 2019. However, I found a product alert from June 20, 2019 announcing 11.7.5's availability. Does this mean 11.7.5 was actually released after March? Should we consider it "Active" or "Mature?"
  18. KMoody

    Audited Table Size Reporting

    Our auditing tables take up almost 10GB, twice as large as the rest of our databases. I want to figure out where all this data is coming from. Is there a way to find out how much space it takes to store auditing information for tables and their fields? For example, if I audit twenty tables, can...
  19. KMoody

    Editing Cell in a Browse

    I have an editable column called "SUB NUM." Let's say I select a row like this: How do I enter the current row's "SUB NUM" field to edit it, like this, without using the mouse?:
  20. KMoody

    Question Logging Error 2624 and STOP Condition

    OpenEdge Release: 10.2B07 When two users try to access the same record using EXCLUSIVE-LOCK, the second user gets the following popup message: <file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624) Is there some way we can log when a user chooses CANCEL? Can we do this...
Top