Search results

  1. P

    Prodataset temp-tables empty after read-xml

    I have an XML I am trying to process using read-xml into a prodataset. The process runs successfully but when I access the temp-tables they are empty. I cannot determine what is causing this. I have used similar code with success in the past. Sample XML My code Let me know what I might be...
  2. P

    Add and read CDATA into and from a XML file

    I am working on generating an XML file for a SOAP API with a vendor. I am using pro-datasets to populate the data to be included in the XML file. One of the fields in the request requires CDATA be sent similar to the following The response also has a CDATA section similar to the following...
  3. P

    Answered Some programs returning "Unable to run Web object" on new server

    We have completed a migration from from an old server to a new server for our webspeed application. Most of the setup is done but we have some pages (no all) that keep returning the error "Unable to run Web object folder/program.r". I cannot determine why these pages are getting this error. They...
  4. P

    Answered Parsing JSON with dynamic keys

    I need to parse and load a JSON object with dynamic keys. Is it possible to do so with OE. I am running OE 11.3 Extract from JSON looks at follows "aircraft": { "319": "AIRBUS A319", "333": "AIRBUS A330-300", "738": "BOEING 737-800", "739": "BOEING 737-900"...
  5. P

    XML-NODE-NAME in temp-table for Prodataset

    I am defining a temp-table using LIKE database a table to be used in a Prodataset for READ-XML. One of the elements in the XML has a name of <Title> which is a Progress Keyword so in the database table definition, it was defined as Title-Pax. It is possible in the temp-table definition to use...
  6. P

    Assign Primary Key and counter in ProDataset when using Read-XML

    I am processing an XML response from a vendor using a ProDataset. 1. The XML does not have the field we utilize as the primary index on our system. I would like to assign this value to the Prodataset before or after the Read-XML but I have not been successful doing so. How can I assign a value...
  7. P

    Answered Reading XML to ProDataset

    I need to consume an XML from a supplier using a ProDataset but have run into a problem due to how the suppliers sends some repeating information. There is section on the XML where data is passed as follows <fare> <class>First</class> <basefare>1000.00</basefare> <taxes>80.00</taxes>...
  8. P

    -mmax exceeded. Automatically increasing from xxxx to yyyy. (5409)

    We are seeing the warning below on our Windows Server 2012 R2 Event Logs. What would cause this warning to occur -mmax exceeded. Automatically increasing from xxxx(num) to yyyy(num). (5409) OS: Windows Server 2012 R2 Progress 11.3
  9. P

    Question Adding HTTP Header Information

    I need to add a content-type <meta> tag to a WebSpeed page the receives a JSON post from a vendor. When I add this under the <header> section I ended up with the following. What is the correct way to get this done on a WebSpeed page <!-- E4GL Disabled: meta http-equiv="Content-Type"...
  10. P

    Question Encrypt Security Credendials

    I have a vendor that requires encryption of security credentials to access their system. I have not done any encryption using OpenEdge and I am not sure if its possible. Our environment is OE 11.3 on Windows Server 2012 R2 and IIS 6.0. The encryption requirements are as follows. M-Pesa Core...
  11. P

    Question Xml Document Partial Load From Memptr

    I have XML data in a memptr and would like to save the file to a document. When I compete the save process only part of the XML document is saved to the file. My code looks as follows DEFINE VARIABLE hDoc AS HANDLE NO-UNDO. CREATE X-DOCUMENT hDoc. hDoc:LOAD("memptr", avariablememptr, FALSE)...
  12. P

    Question Webpage To Receive Payment Notifications/url End-point

    I am working with a vendor that needs to send us notifications when clients complete specific transactions. In order to do so I need to provide the vendor with a URL end-point where they will post a JSON message with transactions details. I am looking to develop a WebSpeed page to act as the URL...
  13. P

    Answered Splitting Database

    I have a database and some of the tables have fairly static business content. I would like to split the database into two with one for static business content and another for dynamic customer content. I have a dump and load utility I use for creating backups of the database. The static and...
  14. P

    Error Error During Database Dump On Oe 11.3

    I am in process of testing a system upgrade from OE 11.1 on Windows 2008 server to OE 11.3 on Windows 2012 server. We currently have a procedure that we run to do a dump data frm our current databases. When I try to run the database dump from the new version I get the following error ** Unable...
  15. P

    Answered New Enterprise Install With Utf-8 Support

    A while back I ran into a problem where I kept getting the error below while processing some JSON that includes several non-English characters. Several languages are supported in the JSON 'Unable to convert JSON to native data type for field 'name' in temp-table 'ttregions'. (15363) I got...
  16. P

    Question Openedge Math Functions

    I need to compute the distance between two locations using their Latitude and Longitude. I found the javascript under the link below that can do this and I am trying to convert this to progress code. Link to Javascript code is Finding distances based on Latitude and Longitude Javascript code...
  17. P

    Answered Lock Table Overflow, Increase -l On Server (915)

    I have a program reading data from a JSON response. The data is initially read into temp-tables and after the JSON has been successfully processed I copy the temp-table data to the database. One of the temp-tables sometimes is getting 7,600+ rows of data which causes the copy from temp-table to...
  18. P

    Question The Character Encoding Of The Html Document Was Not Declared.

    I have a website that redirects a user to a external host for payment processing. When the user is returned to my website depending on the results of the payment processing I need to redirect the user to a final webpage with POST method so their order can be completed. I call the javascript code...
  19. P

    Question Responding To Post Notification

    I have a WebSpeed application that is receiving a POST notification from a vendor that includes an XML document. When the WebSpeed page receives the post the vendor requires a respond back with the word 'OK' as acknowledgement that notification was successfully received. How would I handle such...
  20. P

    Error Load Xml Error: Unsupported Protocal In Url

    I am attempting to process an XML document from a vendor using the LOAD statement as below. ghDocument:LOAD("FILE":u, "c:\sample.xml", FALSE) NO-ERROR. However I am getting the following error X-NODEREF or X-DOCUMENT LOAD got an error: FATAL ERROR: file 'c:\sample.xml', line '1', column '0'...
Top