Warning: coding advice below from a DBA ;)
You don't call an include; it isn't a subroutine. It is a way of encapsulating a piece of code so it can be written once and reused in more than one procedure. These days the common use case is for defining data members like temp-tables or datasets...
Having business logic in VBA isn't where you want to be. Can you import and manipulate the data in ABL and then emit the required workbook artifact? That would save you having to deal with macro-enabled workbooks, which are a pain to manage and a vector for malware.
Or alternatively, see if...
You hit a Progress bug in a shared memory client, some data structures in database shared memory were corrupted, and various processes hit fatal errors and stopped. The database performed an abnormal shutdown to protect data integrity. That might be as much root cause as you ever get.
And it...
The latest update to release 11.7 is 11.7.22. So you are missing 13 updates worth of bugs fixes. This is also the last update, since release 11.7 is retired since April 2025.
I strongly suggest that you test and implement 11.7.22.
Yes, the user granted the Audit Data Archiver permission can be an OS user. It is important to protect all credentials, but especially for this account as it has the power to destroy your audit trail.
The docs say you can't do this if you use _User...
You seem to be suggesting that there is data in the source database audit tables that should have been archived that is not in the audit archive database. Is that the problem?
I'm curious why you use -nodelete when you archive. And that date suggests that you do not archive on a regular...
No. But if you need archived two copies of your logs, you could archive to directory A and then set up a cron job to rsync the files there to directory B.
I suggest you start with the following steps:
download the OpenEdge documentation set for your release of OpenEdge;
read the entire OpenEdge Replication user guide manual; some releases have several manuals on this subject;
determine your business requirements:
document the business...
I once had an experience of trying to rebuild indexes of a large table on a resource-constrained machine. I didn't have enough RAM to prevent disk I/O when building all eight indexes at the same time. In the end it was faster to run idxbuild multiple times, with different sets of indexes, to...
Tuning explanation and advice for idxbuild:
https://pugchallenge.org/downloads/2013/261_Index_Rebuild_Perf.pptx (audio recording also available)
-r and -i will give the same performance benefit. -r allows crash recovery in some scenarios where -i does not.
Re: threading, you can also look...
In my experience, binary load followed by idxbuild is faster and easier to optimize than using "build indexes" on the load. Be sure to back up the database between the load and the build, and then again after the build.
-SG has a maximum value of 64. -r gets you the same boost as -i with less...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.