Search results

  1. Rob Fitzpatrick

    0 / 0 = ?

    Division by zero does not result in zero. It is undefined. The bug is in your calculators. Division by zero - Wikipedia
  2. Rob Fitzpatrick

    Question How much RAM does my database and processes use?

    And how might one do that, Tom? :p Download ProTop
  3. Rob Fitzpatrick

    Question How much RAM does my database and processes use?

    This is unfortunate and it is significant: this is not a technology problem. It is a people problem. Your planner has already decided: you need less than 24 GB of RAM; you can't ask for what you want; you must provide proof to justify what you will ask for. Why 24? As opposed to 240? If...
  4. Rob Fitzpatrick

    Question How to retrieve my serial and control number?

    At a proenv prompt, showcfg will show your products, serial numbers, and control numbers.
  5. Rob Fitzpatrick

    table count does not change after importing records

    It sounds like someone is trying to have their cake and eat it too: economize on disk capacity, but have the ability to grow back to a larger size on demand. As Tom pointed out, this is a false economy. I have had a client call me one day because their database wouldn't start. It was...
  6. Rob Fitzpatrick

    table count does not change after importing records

    I don't see a where clause in your import code, although I also wouldn't expect one.
  7. Rob Fitzpatrick

    table count does not change after importing records

    I understand that the user might want the data later. That explains why you want the data. It does not explain why you are choosing to export it, delete it, and then import it. My question, again: why not just leave the data in place? That would also allow the user to read it later. What...
  8. Rob Fitzpatrick

    table count does not change after importing records

    Another possibility that these totals are both correct. For example, if you had another 100 records where cono=888 and they got deleted somehow between the start and end of your test, the total record count of 900 would be correct. I suggest that you query for all distinct values in this field...
  9. Rob Fitzpatrick

    table count does not change after importing records

    What is the point of deleting and then reloading the records? Why not just leave them in place? And have you thought about how you will handle schema changes to this table? How are you exporting and importing the data? What are the indexes on com and are all of them active? What is your...
  10. Rob Fitzpatrick

    cursor-offset on leave of fill-in

    You referenced a problem but you haven't actually explained or shown what it is.
  11. Rob Fitzpatrick

    SAVE THE CLASSIC AppServers campaign.

    The MSAS (multi-session app server) is a process. Each session (AVM) within it is a thread.
  12. Rob Fitzpatrick

    PDSOE refusing to open a file

    Re-read the note above. OE 12.2 and later are supported only with JDK major version 11, as Stefan already said. You are using major version 17.
  13. Rob Fitzpatrick

    PDSOE refusing to open a file

    Progress Documentation
  14. Rob Fitzpatrick

    SAVE THE CLASSIC AppServers campaign.

    I'm not sure what you want. Are you talking about saving the product (Progress OpenEdge AppServer Enterprise/Basic) or your AppServer-based application code? If the latter, you can migrate it to PASOE. If the former, well, good luck. I can't see PSC ever bringing it back, despite PASOE's...
  15. Rob Fitzpatrick

    Archiving AI's to NFS mount storage causing system hang?

    This might depend on OE version. In my case, the AIMD was unresponsive and I couldn't terminate it. Bouncing the DB was my only recourse.
  16. Rob Fitzpatrick

    Archiving AI's to NFS mount storage causing system hang?

    Absolutely. I ran into the same situation on AIX on OE 10.2B. Archiving directly to a DR box, in theory, sounds like a great idea. When it works, it ensures your archived AI extents are away from production as soon as possible, giving you a good recovery position. However as you have seen...
  17. Rob Fitzpatrick

    Question QAD EA 2008 help request

    You may also be able to trace what happens with the client with Process Monitor.
  18. Rob Fitzpatrick

    Question QAD EA 2008 help request

    Check the database log for error messages. If your client uses the -clientlog startup parameter, check the client log for error messages. If it doesn't, add -clientlog <path to client log file> to your client startup parameters.
  19. Rob Fitzpatrick

    PRROWID Pro2 Replication

    I don't know. Isn't that a question for Progress?
  20. Rob Fitzpatrick

    Answered Multiple progspec.ini

    A while back, someone asked about upgrading from 10.1A02 to 11.7. So that's quite similar to your situation. This was my response, I hope you find it useful: Question - Does anyone have a demo of Progress database migration?
Top