PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Devon Austen

Pages: 1 ... 14 15 [16] 17 18 19
226
Another possibility is that the PxPlus install or WindX plugin install was not done cleanly in a new directory but over an old version. This can cause issues like the one you are seeing.

Make sure that you always do a clean install in a new directory.

227
This is only a guess but is the version of the WindX host and WindX client the same?

228
Programming / Re: Backups and corrupted files
« on: November 22, 2018, 03:00:09 PM »
Ed,

Here is an example of the CREATE FILE directive with a channel.

Code: [Select]
OPEN (1, iol=*) "clients"
CREATE FILE "clients.backup" FROM (1)

229
Programming / Re: missing rollback on channel close
« on: November 16, 2018, 09:13:29 AM »
A took a quick look at the code that handles a [mysql] channel close and a [odb] channel close and it looks like by design the [mysql] interface will commit and pending transactions when closing the channel. While the [odb] interface just closes the channel.

As this is by design it is possible this behavior was desired and users may be relying on it. The only option we would have is to add a option to allow you to override the default behavior and have it not do a commit before closing the connection. This I believe would mean that the transaction would get rolled back by the mysql driver when closing the connection.

I will put adding this option for [mysql] onto our wish list for consideration. If others would benefit from this feature let us know here and this would make it more likely we do it and help us determine its priority.

230
Programming / Re: Error 105 & local file
« on: November 14, 2018, 10:41:03 AM »
Has this issue just started recently for systems that were running fine before? If so I would look into what has changed with those systems around the time the issue started i.e. application change, PxPlus upgrade, or Windows OS update.

The problem is likely related to your use of mapped drives and how it handles flushing writes and caching are out of our control and can change with updates to the OS.

Here is an except from a old mail list entry with some general advice about using mapped drives

Quote
Microsoft is logically disconnecting mapped drives that have been idle and reconnecting them when activity resumes.  This disconnect has the unfortunate side-effect that it will drop any outstanding record locks and that causes us some pretty serious problems. 

We generally suggest that sites that are using any sort of mapped devices issue the following command on their workstations/server.

                net config server /autodisconnect:-1

This was documented by Microsoft on http://support.microsoft.com/kb/297684

Another setting that needs to be looked at depending on the servers is to ensure that opportunistic locking is really turned off. There are some links that you can use to confirm it as the method used is different for servers.

http://support.microsoft.com/kb/2696547
http://blogs.technet.com/b/josebda/archive/2012/06/06/windows-server-2012-which-version-of-the-smb-protocol-smb-1-0-smb-2-0-smb-2-1-or-smb-3-0-you-are-using-on-your-file-server.aspx
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html

One option would be to run the KEY LOAD directive on the files prior to running the days end procedure.

Due to these changes in Windows, we have developed a new file IO server that can be used to replace mapped drives -- PxServer.  Not only does this provider safer data file access but tests have shown it to be much faster than mapped drives.

231
Hi Jeff,

Most of the arguments in the BeforeNavigate2 event are read only. The only affect you are allowed to have on the request itself is to allow it or cancel it. This is for security reasons I believe and works the same with Shell.Explorer.

If you want to modify the request you have to cancel it and do a new navigate with the modified URL, headers, or post data.

To read the values of headers and post data you do what it sounds like you are doing.

Code: [Select]
ON_BEFORE_NAVIGATE:
 ENTER pDisp,url,flags,targetFrameName,postData,headers,cancel

 DEF OBJECT url
 DEF OBJECT flags
 DEF OBJECT targetFrameName
 DEF OBJECT headers
 DEF OBJECT postData

 MSGBOX "url="+url'val$+" flags="+STR(flags'val)+" targetFrameName="+targetFrameName'val$+" headers="+headers'val$+" postData="+postData'val$,"INFO"
 RETURN

Note that post data will only be present on a POST request and not a usual GET request. Headers also does not mean response headers as this is being called before the request is issued so there is no response. Headers are any additional headers set when the request is made. This is not something done often and if the navigation happened using our navigate method for *browser then we know for sure it didn't happen because our code does not set any request headers.

232
Programming / Re: journal files size issue
« on: November 07, 2018, 12:02:45 PM »
To start the send process run the program *plus/jrnl/send. No arguments needed if using the default send.conf config file in the same directory. 

233
Programming / Re: journal files size issue
« on: November 07, 2018, 08:50:11 AM »
Are you using the data mirroring configuration utility which you can find on the IDE under data management? From there you should just be able to stop and start the send process.

You also could create the file send.stop to stop the send process.

234
Language / Re: Parameter Questions
« on: October 31, 2018, 08:17:54 AM »
The 'AC' parameter is for general ease of use. With it on you can type numstr$=10 and the system will convert it to numstr$=str(10) for you. It works with both editors from my testing. In ED+ you don't see the conversion until you save it and reload it. In IT you see the conversion right away.

What do you mean when you say it causes both editors to choke?

235
Programming / Re: QR codes
« on: October 23, 2018, 01:42:02 PM »
There was a change to how we hosted the web service that required an update to the program. We missed updating the program when we did the build. You can download the updated program here: http://www.pvxplus.com/downloads/misc/makeqrcode

We will make sure to update the program for the next build as well as document it.

236
Programming / Re: QR codes
« on: October 23, 2018, 11:08:52 AM »
That command work for me.

This utility makes a web request to our server to build the QR code. This means the tool has the following requirement:

-Requires internet access as logic done on our servers
-Serial number must on maintenance/current version

237
Programming / Re: QR codes
« on: October 23, 2018, 10:46:44 AM »
It was discussed at DireXions 2014 but it appears we missed adding it to the documentation. This will be fixed.

238
Programming / Re: QR codes
« on: October 23, 2018, 09:23:36 AM »
If you are using PxPlus 2014 or higher you can use "*tools/makeqrcode"

Code: [Select]
CALL "*tools/makeqrcode","https://home.pvxplus.com","output.png"

239
ODBC / Re: MySQL write via ODBC
« on: October 18, 2018, 08:52:56 AM »
If you know that you are updating a record and not inserting a new one you can use the UPDATE directive instead of the WRITE. This would be more efficient as well as PxPlus would not have to try and do an insert fail and then do an update.

240
ODBC / Re: CatalogName
« on: October 12, 2018, 08:03:27 AM »
Hi Ben,

Check out the pxpsqlsvr.conf.sample file that came with the installation for an example and a description.

You can also read the documentation about the new catalog setup for the server here https://manual.pvxplus.com/?odbc/configuration_procedures/server_settings_unix_linux.htm

Also for clarity here is an example from one of my pxpsqlsvr.conf files

Code: [Select]
catalogs:
default=*[/myapp/data][][]

In this example I defined a catalog named default which pointed to the data dictionary located at /myapp/data and it does not have an INI file or prefixes

In you ODBC client DSN under the server tab you would then specify default as the catalog name to connect to data from the /myapp/data dictionary.

This is so a server could define multiple catalogs and so that clients do not have to know anything about the server or where the data is on the server.

Pages: 1 ... 14 15 [16] 17 18 19