Search results

  1. A

    Connect openedge client to SSL webservice

    Glad I gave up then after a couple of hours! Ended up proving my client/server certificate config worked with a simple .net app accessing the web services on Tomcat. Worked pretty much out of the box with a bit of tinkering with the application configuration. I think for our purposes this...
  2. A

    Connect openedge client to SSL webservice

    Have just read this...... from http://www.progresstalk.com/showthread.php?109872-how-to-connect-to-a-WEBSERVICE-from-progress-using-ssl-and-certificates And also this post explains http://www.progresstalk.com/showthread.php?117124-Support-for-client-side-digital-certificates-with-SSL So...
  3. A

    Connect openedge client to SSL webservice

    Hello all, I have a simple web service that returns a message. The web service is exposed via tomcat, on 3 ports: - 8080 for cleartext - 8443 for server side SSL (no client certificate required) - 8445 for client/server SSL authentication I can access the WSDL OK on all ports from a browser...
  4. A

    backup strategy

    Thanks Tom, I'll be implementing this into our Development environment this week. We haven't done continuous roll forward for a few years now, as it was decided that the risk was such that we could afford an hour or so down time. You've got me thinking though. We've just purchased some...
  5. A

    backup strategy

    Any thoughts on this as an option? We also run full backups each night and the backup is then transferred off site to 3rd party remote storage. The 3rd party transfer bit is the bottle neck. The DB is about 90gb. What I've considered is running 1 or 2 full backups a week and then just...
  6. A

    Broker process for App Server consumes large amount of memory

    Had a similar issue when we upgraded to 10.2B: http://communities.progress.com/pcom/message/82157 I've left the jvmArgs=-XX:+UseSerialGC flag in with no *noticeable* difference, however I later discovered that our main problem was not tidying up persistent procedures properly within...
  7. A

    Memory Usage After Upgrade to 10.2B

    Had a similar issue a while back: http://communities.progress.com/pcom/message/82157 I've left the jvmArgs=-XX:+UseSerialGC flag in with no *noticeable* difference, however I later discovered that our main problem was not tidying up persistent procedures properly within appserver .p's Chris
  8. A

    Querying Progress DB from MSAccess

    Have a look at the following workaround. Worked for me for Access 2007/10.2b ID: P116845 - Title: "Reserved error -7748 when attempting to link a OpenEdge 10.1x Database table in Microsoft Access" To resolve this error, set WorkArounds2=8192 for the affected data source. This can be done...
  9. A

    Order of where conditions

    Well it took me a while to figure it out and put all the pieces together....but it was worth it in the end: From Solaris root prompt: root@server # sqlexp -db DBName -H HostName -S ServiceName Connecting user "root" to URL "jdbc:datadirect:openedge://HostName:-...
  10. A

    Order of where conditions

    Got it working through MS Query...just about, got to get the table names correct.....nearly there. Getting the following error: Table/View/Synonym not found (7519)
  11. A

    Order of where conditions

    Trying to figure out where to run UPDATE STATISTICS from......can you point me in the right direction? Can't get it to compile in the ABL or run it from MS Query......does it need to run from some other front-end? Thanks
  12. A

    Openedge 32bit running on a sparc 64bit server performance problems.

    You can do things like restrict the process to a particular thread or range of threads (processor set) to prevent it switching from thread to thread/core to core/CPU to CPU etc. You may get some mileage from this but I suspect not a lot (I haven't done enough testing in this area). The compile...
  13. A

    Openedge 32bit running on a sparc 64bit server performance problems.

    What's the server model? If it's a T series you could be limited by the individual thread CPU speed. We run a T5440 (4 CPU * 8 cores per CPU * 8 threads per core = 256 threads). Works great for day to day stuff (appservers/webspeed etc) but for longer running batch processes it doesn't have...
  14. A

    Order of where conditions

    ** Goes off and googles UPDATE STATISTICS. Never run it, so that's the next task then + RTFM. ;)
  15. A

    Order of where conditions

    I've often struggled with this issue...when the SQL is executed from a Progress editor session it is analysed correctly and it uses the correct indexes. But when the same query is executed from Excel for example, it picks a different index and ends up trawling through thousands of records. Can...
Back
Top