Search results

  1. ron

    Can OE12 AI files be applied to an OE11 DB?

    No, Rob, neither. TDE is planned to be implemented a few weeks after the upgrades of OE and the change to PASOE. We don't have Replication; we have a 'cold' DR server and ship AI to it every 12 minutes. The business accepts the risk of losing up to 12 mins of transactions. Thanks for the...
  2. ron

    Can OE12 AI files be applied to an OE11 DB?

    Linux 9.2 -- OE 11.7.20 --> OE 12.8.3 We are getting close to the end of a major project upgrading from OE 11 to OE 12 and changing from Classic AppServers (on Windows) to PASOE on the DB server. Conversions/upgrades have been done and thoroughly tested on numerous non-production servers --...
  3. ron

    Getting details from AI Files

    Thank you very much for the replies. One thing that surprised me was that the table name "PUB.bpaytranscode" exists as a plain-text string in the AI file, but that name is not shown in the AI scan. I will study your replies during the next few days and see if I can extract further details. Ron.
  4. ron

    Getting details from AI Files

    Linux 9.2, OE 11.7.20 We switch AI files every 12 minutes. Last Friday a user deleted a record from a small reference table and I need to know who did it. I copied all the AI files from Friday into a temp directory and used strings/grep to find which AI file contained a reference to the table...
  5. ron

    Online schema changes

    Thanks very much Tom! I will experiment with that and see how I go. Ron.
  6. ron

    Online schema changes

    OE 11 allows a number of online schema changes but in my experience they nearly all require no user session connections to be active when the change is made. Getting human users off the system is quite easy, but stopping the various external connections to our other systems and especially to...
  7. ron

    Online schema changes

    The actual schema change rarely takes more than a few minutes -- as you say. That's no problem. "The" problem is coordinating with the external systems and 3rd parties that we connect-to ... then then shutting-down everything -- more than one DB and separate AppServers. (We plan to put PASOE...
  8. ron

    Online schema changes

    Thanks very much for you reply! I guess my post was a bit confusing -- we're all organised as far as the migration from 11.7 to 12.8 -- and PASOE -- and RHEL 7 to 9. It is a very big job and lots of testing is needed -- but I'm sure we can handle that. The actual problem I'm focusing on is...
  9. ron

    Online schema changes

    OE 11.7.17 -- RHEL -- Development on 9.3, Production on 7.9. We are planning to move from OE 11.7.17 with "Classic AS" and RHEL 7.9 to OE 12.8 with PASOE and RHEL 9.3. Since our systems run 24/7, getting any down-time at all is really hard and getting a window of more than about 3 hours is...
  10. ron

    Answered Question on xcoding

    Thank you, Stefan! I will investigate md5.
  11. ron

    Answered Question on xcoding

    RHEL 9.3 -- OE 11.7.18 I have just discovered that Progress documentation mentions "SIGNATURE-VALUE attribute". It says "Use this attribute to determine if a procedure changed between different versions of your application." Can someone explain exactly what this means, please? I understand...
  12. ron

    Answered Question on xcoding

    I tried comparing using just the r-code, but that failed too. I found that if I compile a plain-text program (.p) and save the result r-code -- then do exactly the same thing again a few minutes later -- changing nothing at all, the two r-code files differ. It appears that the compile process...
  13. ron

    Answered Question on xcoding

    I appreciate that, Rob, but close to 50% of all of the source files (2,200 vs 4,790) are in that group. I think that most of those files actually do match-up, but I can't explain how they get different checksums.
  14. ron

    Answered Question on xcoding

    Yes, Rob, diff easily tells you if two binary files are the same or not. The problem, however, is that there are 3,500 individual source files and various copies are in 18 different locations on a Windows server (GIT) -- and two Linux servers and altogether there are 29,000 separate files. The...
  15. ron

    Answered Question on xcoding

    Thank you Stefan -- I will contact them
  16. ron

    Answered Question on xcoding

    Another xcode query. (OE 11.7.18 / RHEL 7.4 ) We have a financials system with about 20 VMs set-up for developers. When code is ready it is promoted to the SIT environment (System Integration Testing), compiled and tested. After testing the new/changed code is promoted to UAT, compiled and...
  17. ron

    Copying a Procedure Library

    Thank you very much ... the Progress code contains no GUI stuff; all GUI is handled through APIs.
  18. ron

    Copying a Procedure Library

    Linux 7.4 -- OE 11.7.18 The system I work on has Linux servers with Progress DBs and (classic) AppServers on Windows that connect to the Linux servers. The exact-same program code set resides on both Linux and Windows, so when compiles occur on Linus the new compiled code-set is copied to the...
  19. ron

    Question Compile a Program in different environment

    11.7.17 on Linux. I have a problem that is a bit similar -- a script to compile a set of programs into multiple environments. There are over 30 environments -- each being a copy of production used by different development teams. Everything works fine except for one thing -- at the completion...
  20. ron

    Copying Changes from one DB to Another

    Tom -- I am embarrassed that I didn't think of dumping/loading the tables that control the menu system! That sounds like the best solution. :) By the way ... what is the "difference tool"?
Back
Top