Search results

  1. TomBascom

    Trigerring Progress 4GL Triggers from Java Data Update

    An appserver *is* an API. It might not be written in your favorite language or using your chosen special sauce but it is definitely an API. 4GL triggers need a 4GL runtime. There is no way to run them without that. One way to get that is with an appserver. You could use "classic" appserver or...
  2. TomBascom

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Yes, you can safely ignore the differences in utilization etc. Those are an expected result of dumping and reloading. Unfortunately you cannot binary dump _user. You should be able to do a dictionary dump of it though. I wouldn’t delete the old db until I have thoroughly tested the...
  3. TomBascom

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Correct. It is a two-step process. You want to start with an empty database. (I see that you have already named it "bkuptss1"). prodb prompts for missing arguments. You could skip the prompts by saying: prodb bkuptss1 empty Your next step is to start a session with the new database and...
  4. TomBascom

    Database buffer -B change slow downs QAD programs

    It is also worth noting that if you are using OpenEdge Exploder to adjust -B that it may be silently NOT allowing -hash to be chosen by the broker and is, instead, using an old value that was set to go with the previous, much smaller, -B. Look in conmgr.properties. If hashtableentries does not...
  5. TomBascom

    Buffer with no-lock

    Ideally, yes, you would want to carefully scope even NO-LOCK records. However, the downsides to letting NO-LOCK record scope float around freely are relatively minor and most people don't worry about it very much.
  6. TomBascom

    Question Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server

    Your code sample might be readable, even with the horrid UPPERCASE KEYWORDS and vile Hungarian Notation, if you enclosed it in a CODE tags. But, as is, I can’t be bothered.
  7. TomBascom

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Ah yes, the good old days of 8.2... You do have the character client installed and, with that, %DLC%\bin\_progres.exe and proenv.bat. So you could fire up "proenv" and work from there. Just replace "mpro" with "_progres" and "pro" with "_progres -1" and "Bob's your uncle!" Or at least that...
  8. TomBascom

    Question Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server

    I'm going to guess that it is an attempt to find the record that is about to be updated. Probably with a very "special" WHERE clause.
  9. TomBascom

    Question Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server

    When the process "hangs" you should do a "proGetStack" and obtain a 4gl stack trace for that process. A stack trace from a crashed session is less helpful. That just shows why your session crashed. proenv> progetstack 1234 "1234" is the process id. Do this several times to verify that it is...
  10. TomBascom

    Question Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server

    Is "Import Data" an application specific function? You are apparently importing something with a Windows client and then inserting or updating records via a client/server connection to a Linux host. On the Windows side a great deal depends on the design of the code that is performing this...
  11. TomBascom

    Progress OIB Broker Startup - Port in Use

    You're out of luck. https://knowledgebase.progress.com/articles/Article/P18888 Although there are rumors that that might change in a future release.
  12. TomBascom

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Also: "We have been experiencing lockups when we search for customers..." is awfully vague. What, exactly, is happening? Are there error messages?
  13. TomBascom

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    With 8.3 and no compiler license you need to be extra careful about the r-code CRC. Outline: 0) Make a backup. Or two or three. Make sure that you can restore them properly. This is a good time to make sure that your DR plan works properly. 1) connect to the db and start the data dictionary...
  14. TomBascom

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Well, yes, it is possible to dump and reload an 8.3 database. Actually doing so depends on a lot of details. The two big questions are: 1) What licenses are available? (Run “showcfg” to get a list.) 2) Can you re-compile the application? IOW, do you have all of the source code? If the...
  15. TomBascom

    Odbc connection for Progress 9

    V9 is, of course, ancient, obsolete, unsupported, and it is criminally negligent to be running a mission critical application on it. You should upgrade. Now that we have that out of the way... To use a data server you need a dataserver license. You can check to see if you have such a license...
  16. TomBascom

    Suddenly slow database and sometimes losing connection

    This seems unlikely. Most RDP licenses only allow 2 users to connect. In theory you can buy more but I've yet to stumble across a customer who has done so. Much more likely is that the users are RDP'ing to a terminal server or something that launches a client/server connection. Especially since...
Top