Error 117 in Keyed file

[James Zukowski]

This week, we had an error #117 show up in one of our files that processes thousands of records in and out on any given day. We were able to recover what looks like all of the data in the file using the PxPlus utility.
Are there any insights as to why this would show up?

[James Zukowski]

Still looking for possible answers. Any ideas?

[kunal.malik]

Hi James,

Could you confirm which PxPlus version and ODBC driver version you are using?

I checked the documentation, and this error may occur when running PxPlus versions prior to 4.23 or ODBC driver versions prior to 3.22.

[James Zukowski]

We're currently on v15.1 (but not for long!). ODBC is not involved in this situation. The file is on one of the server drives.

[gmundt]

I was getting this error on a file that was getting too large.  I had to work around it by doing a check and rotating files when they reached a size limit.

[James Zukowski]

We have some files that are HUGE, but this isn't one of them. It just moves a lot of records in and out on a daily/weekly basis, but generally stays around 150-200K or less at any particular time.