Search results

  1. RealHeavyDude

    Question OOABL, BLOCK-LEVEL ON ERROR UNDO, THROW. & CATCH eAppError

    I would rather throw the app error than return error in the set implementation of the property. Nevertheless, if you assign the properties' values in a single assign statement it will fail when the first assignment fails and won't go any further. Even with the no-error option. You will need...
  2. RealHeavyDude

    Write an ABL which captures the triggers of Customer table and stores it in a table "EventLog" (action,time,date,oldvalue,newvalue).

    Does that help? Progress KB - How to implement an AUDIT within the Progress DB and 4GL? You can easily find such things by Google'ing "site:knowledgebase.progress.com audit trigger"
  3. RealHeavyDude

    Question Backups taking a long time on a server that's been p2v'd

    Do you have a different transaction loads on the different servers during the backup time window. In our case (OE 11.6, Sun Solaris, ZFS file systems residing on an EMC SAN) we found out that the transaction load (batch processing) is a big difference maker. The time to take a full online backup...
  4. RealHeavyDude

    Getting frequent errors from SQL Server 2016 while connecting to progress database using openedge driver

    There is no Progress version 2007. Do you see any error messages in the database log file? Nevertheless here are some results from a Google search ( site:knowledgebase.progress.com error 7399 ) Progress KB - SQL Server linked server "Access denied" error when querying Connect64 for SSIS...
  5. RealHeavyDude

    Getting frequent errors from SQL Server 2016 while connecting to progress database using openedge driver

    Which version of Progress/OpenEdge you are using? Do you get any Progress errror message number?
  6. RealHeavyDude

    Reinstall does not create service

    You should be aware, the configuration file for the AdminServer ( ubroker.properties ) resides in the installation directory unless you've moved it somewhere else. Unlesss you backup the files in the propertties folder, they are lost when you uninstall OpenEdge.
  7. RealHeavyDude

    Reinstall does not create service

    Which platform? Do you mean the entry for the AdminService in the Windows services on Windoze?
  8. RealHeavyDude

    Resolved Slow Initial Client Connection with SSL Enabled AppServer

    I've used SSL/TLS connection from 10.0A to 11.6.3 with no performance problems for connecting whatsoever. Is the client also 11.3 or is the client 11.6+ ?
  9. RealHeavyDude

    Something quirky about OpenEdge 11.7 - "The Phantom Window"

    Just my 2 € cents A hammer is a good tool. Just because it is not really usable for driving a screw does not mean it is a bad tool. The same goes for the PDSOE vs. AppBuilder thing: I use the PDSOE for developing classes and procedures and the AppBuilder for any classic GUI. I am on 11.6.3...
  10. RealHeavyDude

    Resolved about who should start Progress DB and services?

    Exactly. Rogue system admins are the worst nightmare of every serious dba. Only use root privileges when they are absolutely necessary. We run our whole backend on Sun Solaris SPARC under a project user which does not even have interactive login capabilities on the operating system. Only...
  11. RealHeavyDude

    Resolved Before Image buffer waits & After Image buffer waits

    I would almost say "unfortunately" we are able to fullfill our SLAs ;)
  12. RealHeavyDude

    Resolved Before Image buffer waits & After Image buffer waits

    Forgot to mention that we have a batch job in place which runs every Sunday and merges the results from a db analysis with the statistics accessible via VST.
  13. RealHeavyDude

    Resolved Before Image buffer waits & After Image buffer waits

    Actually at the moment we are able to fullfill our SLA so there is immediate need to improve the performance of the day-end processing. During the day-end processing we recieve some 100+ in-bound files which we need to import and then produce a handful of out-bound files which need to be...
  14. RealHeavyDude

    Resolved Before Image buffer waits & After Image buffer waits

    Hi Rob, thanks for your valuable insights. We are running APWs, AIW and BIW and data, before image and after image extents are segregated into their own dedicated file systems on the same SAN ( which is an EMC VMAX 20K with roughly 500 TB capacity ). Unfortunatley I don't have much control...
  15. RealHeavyDude

    Resolved Before Image buffer waits & After Image buffer waits

    OpenEdge 11.3.3, Sun Solaris SPARC 64Bit ( Sun V490+ 1800 Mhz with 64 GB memory - database files residing on ZFS file systems on a SAN ). I know - we should have migrated to a more decent hardware on RHEL a long time ago and I wish I could do something about the SAN but I can't. A migration...
  16. RealHeavyDude

    Please make me Clarify

    Just to be clear: The standard connectivity for the Progress database is their client/networking protocol - which is used by the AVM ( Progress virtual machine ) to talk to the database. It is not ODBC/JDBC. The Progress database supports ODBC/JDBC for other clients.
  17. RealHeavyDude

    Please make me Clarify

    iso8859-1 is a code page. Code pages are the basis of character processing in IT. They map each character of the supported character set ( latin-1 ) to a specific code so that computers can work with text. iso8859-1 is a single-byte code page - meaning each character in the character set is...
  18. RealHeavyDude

    Consuming WebServices in combination with oAuth2.0

    I did with wget. Did not use curl because I was not allowed to.
  19. RealHeavyDude

    Question Does progress need any code changes when web service call changes from Http to Https

    You are most likely missing the CA ( certificate authority ) certificate in the Progress certificate store. You need to import the CA certificate from the issuer of your server certificate in the Progress certificate store ( certs ) so that the Progress client is able to verify the certificate...
Back
Top