PxPlus User Forum

Main Board => Discussions => Language => Topic started by: James Zukowski on February 21, 2025, 10:35:30 AM

Title: Error 117 in Keyed file
Post by: James Zukowski on February 21, 2025, 10:35:30 AM
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?
Title: Re: Error 117 in Keyed file
Post by: James Zukowski on February 24, 2025, 04:49:06 PM
Still looking for possible answers. Any ideas?
Title: Re: Error 117 in Keyed file
Post by: kunal.malik on February 25, 2025, 02:11:35 PM
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.
Title: Re: Error 117 in Keyed file
Post by: James Zukowski on February 25, 2025, 02:18:15 PM
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.
Title: Re: Error 117 in Keyed file
Post by: gmundt on March 17, 2025, 11:30:54 AM
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.
Title: Re: Error 117 in Keyed file
Post by: James Zukowski on March 17, 2025, 11:36:09 AM
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.