I've used Progress Developer Studio for years, and I highly recommend it. However, if you need to use Notepad++, consider downloading the OpenEdge UDL here:
In Notepad++, the UDL will highlight and color syntax for Progress files and...
Thanks, Rob. Based on what you've said and what I've figured out, I have an idea what happened:
In cron, our databases run an audit archive at 2:45 AM, and our databases shut down for a cold backup at 3:01 AM. On 2020/03/08 at 1:59 AM, cron ran all jobs between 2:00 and 2:59 right after the...
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...
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...
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...
Sorry, I forgot to mention that we're using Progress 11.7.5.
I'm unable to make any changes online through the Data Dictionary while in multi-user mode. I am able to add fields and tables by loading an incremental df in Data Administration. However, I tried to change an existing field's...
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?
Ah, okay. Looks like it's time to bite the bullet and use binary dump and load. :D Just one problem: I can't use binary dump and load for schema tables like _sec-role:
Binary dump can't dump schema tables (9310)
Binary Dump failed. (6253)
If I can't use binary dump and load and I can't use...
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...
Okay, thanks! I figured out that application level events (events greater than or equal to 32001) weren't dumping and loading. How do I do that programmatically? I sucessfully dumped these events using src/prodict/dump_d.p, but when I ran load_d.p for _aud-event, I got this error:
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...