Search results

  1. Rob Fitzpatrick

    Best practices working with an .i file & running specific procedures

    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...
  2. Rob Fitzpatrick

    Help with loading a macro into an excel sheet.

    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...
  3. Rob Fitzpatrick

    Error Request for Progress Review – ipurch DB Abnormal Shutdown with WebSpeed Memory Violation and APW/AIW Lock Stack Errors

    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...
  4. Rob Fitzpatrick

    Error Request for Progress Review – ipurch DB Abnormal Shutdown with WebSpeed Memory Violation and APW/AIW Lock Stack Errors

    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.
  5. Rob Fitzpatrick

    Error Request for Progress Review – ipurch DB Abnormal Shutdown with WebSpeed Memory Violation and APW/AIW Lock Stack Errors

    You didn't mention your OpenEdge version. Error 49 indicates a Progress bug. Are you on the latest update for your release?
  6. Rob Fitzpatrick

    Progress schema holder data mapping issue

    You can't change the data type of a field in an OpenEdge database, with one exception: changing an integer field to int64.
  7. Rob Fitzpatrick

    Archive Audit Logs

    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...
  8. Rob Fitzpatrick

    Archive Audit Logs

    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...
  9. Rob Fitzpatrick

    Question Log file truncate and archive startup parameters

    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.
  10. Rob Fitzpatrick

    Question Life after Death (DELETE) - is it a bug or miracle?

    Very interesting analysis George! Thanks for your insights.
  11. Rob Fitzpatrick

    Guidance Required for OpenEdge Replication Plus Implementation and Automatic Failover

    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...
  12. Rob Fitzpatrick

    purge and resize db

    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...
  13. Rob Fitzpatrick

    purge and resize db

    It was also back-ported to late 10.2B (SP06 - 08?). I have confirmed that it is in SP08 HF 48.
  14. Rob Fitzpatrick

    purge and resize db

    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...
  15. Rob Fitzpatrick

    purge and resize db

    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...
  16. Rob Fitzpatrick

    Powerful UI Design for the Maintenance of Parent/Child Dataset

    Conveying signals via colour alone is a potential pitfall if you need to worry about accessibility, i.e. you need to provide colour-blindness support.
  17. Rob Fitzpatrick

    Powerful UI Design for the Maintenance of Parent/Child Dataset

    No, but I think this thread belongs in the Development forum, rather than General Announcements | Chit Chat. You may get more engagement there.
  18. Rob Fitzpatrick

    Dump Reload Level I to II

    Yes it does. Each index on a table contains as many index entries as there are records. Each index entry consists of the key value (the field value or set of fields values, for each of the fields in the index definition) and the rowid. Dumping records from a source database and loading...
  19. Rob Fitzpatrick

    Question Windows Server 2025 Standard - Fill in View

    Here are a related Community discussion and KB article: https://community.progress.com/s/question/0D7Pb00000ROx93KAD/detail https://community.progress.com/s/article/Fill-in-borders-are-displayed-in-white-color-on-Windows-11
  20. Rob Fitzpatrick

    Dump Reload Level I to II

    When you restore from a backup, you are creating a new database. That database will have the same data storage areas, and assignment of objects to those areas, as the source database from which the backup was taken. As to where the extents of those areas are stored, you have two options: You...
Back
Top