Search results

  1. rzr

    tool to read LOG-MANAGER output

    Thanks @robert1k ! That's the ticket I created with support today ;) . I also found couple of examples on OEHive. See attached.
  2. rzr

    tool to read LOG-MANAGER output

    Hello, Is there any tool, utility or program that can help with reviewing the output of LOG-MANAGER? I am analyzing a production issue and ran a trace using LOG-MANAGER. The logmgr.log is large and was wondering if there were any options to easily digest this output. For now, I'm working...
  3. rzr

    Question Connect Salesforce to Progress

    Thanks @Cringer . The upgrade path is still in review and as I mentioned at least 8-12 months away. Looking for options on 10.2B version. Will take note of v11 to v12 path. Thanks.
  4. rzr

    Question Connect Salesforce to Progress

    Team, hope you are all keeping safe. We are on OpenEdge 10.2B08. Our current web apps and CRM connect to our OE databases through a custom JAVA Webservice layer. The JAVA layer does AppserverS:// connection into OpenEdge. Both Java (hosted on JBoss) and Progress are in same datacenter on...
  5. rzr

    Question Real Time Data Replication for BI Reporting

    Thanks for your inputs. Would love to upgrade but is unfortunately not an option / priority for stakeholders :(. The need will be to sync specific tables from 15-20 Progress databases into one target SQL database. So, not sure if replication will work given then many-to-1 situation.
  6. rzr

    Question Real Time Data Replication for BI Reporting

    Need inputs / suggestions. We have 15-20 production databases (10.2B). Schema is always in sync across these databases. Currently for BI reporting, we either dump data from specific tables into flat files or a ODBC connections into DB. How have other companies managed BI reporting from...
  7. rzr

    Answered Hung Appserver..

    This is the top section of my screen...If there were a hung appserver where would that show here? Auto Interval Rate JSON 20771 5712 0.832 ProTop Version 3.3nx 2016/12/20 16:36:38 ptxxxx 0 0 /db/xxxx...
  8. rzr

    Answered Hung Appserver..

    Thanks. I was able to configure and run ProTop on my test database
  9. rzr

    Answered Hung Appserver..

    There's isn't one common symptom. The one's I noticed is no updates to appsever log files. The DBA team restarts the appserver and I see activity in the appserver log files. Also the ABL client get's an error "Unable to connect to xxxx appserver..."
  10. rzr

    Answered Hung Appserver..

    I downloaded it this morning from ProTop Monitoring and Alerting Service but it wasn't clear to me how to install and configure it. Is there step by step installation guide for ProTop?
  11. rzr

    Answered Hung Appserver..

    Hello, The DBAs use the OEM interface to check status of the app servers. This does show error state or offline. Unfortunately, this still doesn’t show a state where the app server is online but hung. Is there any other way to identify hung AppServer state?
  12. rzr

    Question Concurrent Appserver Connection

    there is audit coming (I think) ... So, what I found so far is you can get from the database-name.lic file the number of active "interactive" connections. Going to write a quick code to see what the average interactive count is are for a given day and then figure out if our default min and max...
  13. rzr

    Question Concurrent Appserver Connection

    We are working on renewing licensing with Progress. Is there a way to know how many concurrent AppServer connection are being made for a given appserver (from VST or log files)?
  14. rzr

    Question How To Calculate Distance Between Zip Codes

    here's an API that gets you the distance between two zip codes in miles... https://www.zipcodeapi.com/rest/<api_key>/distance.<format>/<zip_code1>/<zip_code2>/<units> Example...
  15. rzr

    Question How To Check Is File Is Writable On Unix

    That worked, thanks Rob !
  16. rzr

    Question How To Check Is File Is Writable On Unix

    Is there an easier / alternate way to check if user has write permission on a file? Here's what I'm doing now. I load the ls -lrt result into cResult and parse it to check permissions. DEFINE VARIABLE cOSCommand AS CHARACTER NO-UNDO. DEFINE VARIABLE cResult AS CHARACTER NO-UNDO. cOSCommand...
  17. rzr

    Tool For Customer Service Reps - Offtopic

    thanks Joey, will try this out...
  18. rzr

    Tool For Customer Service Reps - Offtopic

    In our company, the customer reps skim / scan / search through thousands of warranty PDF documents stored on shared network drive manually each time they get a call warranty call from end customers. Are there any tool, similar to Dr. Watson, that can help them in this search process? What I'm...
  19. rzr

    Answered Chui Debugging

    Found this today! I can use the EXECUTION-LOG attribute on SESSION handle to log execution of procedures, user-define functions, and the publish and subscribe statements. The below code creates a log file name proexec.log. The proexec.log file gets generated into the directory you specified...
  20. rzr

    Question Unix - How To Check If File Is In Use?

    lsof gave below error. I ran command lsof /home/myuserid lsof: can't open /dev/mem: No such file or directory lsof: can't open /dev/kmem: No such file or directory at this moment we are taking the control file route but I do like the approach of doing this lock using a db record. Will try this...
Top