Search results

  1. Rob Fitzpatrick

    Can OE12 AI files be applied to an OE11 DB?

    Just curious, are OE Replication or TDE in use?
  2. Rob Fitzpatrick

    Can OE12 AI files be applied to an OE11 DB?

    I'd suggest a follow-up conversation with the auditor about the perceived business risk. If they want the option to invoke a post-migration fallback, after a go/no-go decision has been made for "go" and new writes are happening in OE 12, then that suggests to me that they don't have confidence...
  3. Rob Fitzpatrick

    Getting details from AI Files

    For what it's worth, the text "state", the name of the table from which I deleted the record, was not present in my ai scan verbose output. I wouldn't focus on the table name.
  4. Rob Fitzpatrick

    Getting details from AI Files

    Welcome George! :)
  5. Rob Fitzpatrick

    better way to delete 5millions rows

    "DELETE FROM" looked odd to me too. But it does compile in 10.1B, and it behaves like "DELETE".
  6. Rob Fitzpatrick

    Getting details from AI Files

    The ai scan verbose output won't contain the table name. It contains a summary of the change notes. Let's look at a simple example (from 11.7.16). I created a copy of the sports database. I created four AI areas and two new Type 2 areas: $ cat add.st d "state":20,128;8 . d...
  7. Rob Fitzpatrick

    better way to delete 5millions rows

    Your English is fine. :) (or my Spanglish is improving?) There is a lot to unpack here. If we're seeing all of the purge code here, and not just the bit that does the record deletion, then you are not archiving the data and you are not causing a long-running transaction that would cause BI...
  8. Rob Fitzpatrick

    better way to delete 5millions rows

    Seconded. Do not use -i, ever. I wouldn't even mess around with -r if I were you. You need to know what you're doing and understand the consequences of your actions to be using such things in production. I have seen this many times in the past. Someone decides to delete a large number of...
  9. Rob Fitzpatrick

    Fill-in xx will not fit in frame in program

    Welcome! If you have an issue, I suggest you create a new thread, and do so in the appropriate forum (Development).
  10. Rob Fitzpatrick

    Looking to Purchase

    Look at https://www.progress.com/oedk .
  11. Rob Fitzpatrick

    Question Performance question on a tool library

    Some more detail is required about the problems you are trying to solve. What does "segment it" mean to you? It sounds like a solution that you envision to some problem. If so, what is that problem? The same goes for "more easy to use"? Easier than what? What usability problems are you...
  12. Rob Fitzpatrick

    Error Connections exceeding.

    In your second post it seems like you just ignored what I said. Why would you insist on not specifying -Mpb for a secondary broker when I just told you that you should always specify it, and that the fact that you didn't specify it is contributing to your problem? I already outlined detailed...
  13. Rob Fitzpatrick

    Error Connections exceeding.

    You haven't specified your OpenEdge release. This is important to know when discussing broker parameters. Three major points: Some broker parameters interact with each other. All of their values need to make sense together. Currently, they don't. These include -n, -Mn, and all values of...
  14. Rob Fitzpatrick

    Cyberquery

    Yes, it's from CyberScience. Unless someone here happens to have some expertise and can chime in, the best bet is to follow up with CyberScience tech support.
  15. Rob Fitzpatrick

    Question The open database table is full

    The problem is not with the database. The issue is on the client side. By default, an OpenEdge client can connect to up to five databases concurrently. This is a soft limit, it can be increased by specifying a higher value with the -h client startup parameter. E.g.: mpro -db db1 -db db2 -db...
  16. Rob Fitzpatrick

    Question The open database table is full

    I don't understand what you are doing. This batch file command runs a primary database broker for a database called calldata. You reported that you had a problem with your compile client, that it throws an error that it cannot connect to all of the databases it is attempting to connect to...
  17. Rob Fitzpatrick

    RAID in 2024

    Credit where it's due: that's @TomBascom's message based on his research and consulting; I'm just spreading the word. Agreed on virtualization. It can provide real benefits but it isn't free (computationally) or risk-free. It adds another layer of abstraction and complexity, and can have...
  18. Rob Fitzpatrick

    RAID in 2024

    I don't know your business, or the rate at which your data changes, or how much you can afford to lose. But you should. It sounds like you are modernizing to some extent. If I were you, I would start by modernizing the business continuity plan. Figure out your RPO and RTO and put in place...
  19. Rob Fitzpatrick

    Install Progress 9.1b on Windows 11

    You can try running Process Monitor during the installation. If there is a silent failure, e.g. accessing a registry entry or file, creating a service, spawning a process, you should see it there.
Back
Top