Encore Pro Analyzer - Invalid Column Name
Encore Pro Analyzer - Invalid Column Name
I'd really like to fully use Encore Pro Analyzer, but when it starts up I get the message "Invalid column name 'TrendPressureTypeID". This means I can't view some of the reports such as Time in Apnea.
Has anyone else seen this error? I am running 1.8.49.
The relevant stack trace from EPA shows this happens:
at EncoreProAnalyzer.MainForm.LoadPatientPressureData(String pressureTableName, String trendTableName)
at EncoreProAnalyzer.MainForm.LoadPatientPressureData()
at EncoreProAnalyzer.MainForm.LoadDatabaseData()
at EncoreProAnalyzer.MainForm.DoRangeChange()
Thanks!
Has anyone else seen this error? I am running 1.8.49.
The relevant stack trace from EPA shows this happens:
at EncoreProAnalyzer.MainForm.LoadPatientPressureData(String pressureTableName, String trendTableName)
at EncoreProAnalyzer.MainForm.LoadPatientPressureData()
at EncoreProAnalyzer.MainForm.LoadDatabaseData()
at EncoreProAnalyzer.MainForm.DoRangeChange()
Thanks!
Re: Encore Pro Analyzer - Invalid Column Name
For anyone else having this issue, the problem is a missing Version key in the registry. The Version key needs to be at HKEY_LOCAL_MACHINE\SOFTWARE\Respironics\Encore Pro. If Encore Pro Analyzer can't find the Version key, it defaults to assuming Encore Pro is Version 1.4 which used different column names.
I am not quite sure why the registry key was missing in the first place, I think it has something to do with the 64-bit Operating System and 1.8.49. I would love to get a copy of 1.8.65 so I could see if it has the same issue. I can run the full test on Windows 7 RC 64-bit.
I hope this helps anyone else having the same issue.
I am not quite sure why the registry key was missing in the first place, I think it has something to do with the 64-bit Operating System and 1.8.49. I would love to get a copy of 1.8.65 so I could see if it has the same issue. I can run the full test on Windows 7 RC 64-bit.
I hope this helps anyone else having the same issue.
- feeling_better
- Posts: 802
- Joined: Sun Jun 01, 2008 7:08 pm
Re: Encore Pro Analyzer - Invalid Column Name
Encore Pro Analyzer 1.8.49? You sure that is the name? My understanding is that name is for an independent sw utility by James Skinner who is an active member of this forum. And I thought its last version was around 0.8.9.
Resmed S9 Elite cpap mode, H5i Humidifier, Swift FX Bella L nasal pillows
Re: Encore Pro Analyzer - Invalid Column Name
I was referring to Encore Pro 1.8.49, you are correct that Encore Pro Analyzer is separate.
- jskinner
- Posts: 1475
- Joined: Sat Aug 26, 2006 9:21 pm
- Location: Greenwich, Nova Scotia, Canada
- Contact:
Re: Encore Pro Analyzer - Invalid Column Name
Thanks to Stuart's find I was motivated to create a new build of EPA that should work on the 64bit versions of Windows. See the following thread viewtopic/t42234/Encore-Pro-Analyzer-fo ... ndows.html
Turns out on 64bit Windows the registry path for Encore Pro is
HKLM\Software\Wow6432Node\Respironics\Encore Pro\
rather than
HKLM\Software\Respironics\Encore Pro\
Turns out on 64bit Windows the registry path for Encore Pro is
HKLM\Software\Wow6432Node\Respironics\Encore Pro\
rather than
HKLM\Software\Respironics\Encore Pro\
Last edited by jskinner on Wed May 27, 2009 4:26 pm, edited 1 time in total.
Encore Pro Analyzer Author
Facebook Apnea Group
Facebook Apnea Group
Re: Encore Pro Analyzer - Invalid Column Name
Thanks James!
Re: Encore Pro Analyzer - Invalid Column Name
I too have the same 'TrendPressureTypeID' database error message running Vista-64. I have downloaded EPA 0.9, and am running EP 1.8.49. I originally received the error being unable to connect to the DB, but fixed that with the excellent instructions posted here: http://intellipap-aflex-auto.cpaptalk.c ... ndows.html. My registry appears to reflect a value of 1.8 under the version key, but there is no entry at all in the sub-registry key named 1.8. Should there be?
I appreciate any help that can be provided.
I appreciate any help that can be provided.
Re: Encore Pro Analyzer - Invalid Column Name
Look at the post above from jskinner.
Re: Encore Pro Analyzer - Invalid Column Name
Thank you -- however, I had already gone through that post, and I found the registry entry location where identified by Mr. Skinner. Nonetheless, I still receive the error message and it may be that I do not know what the actual entry should be at that registry location.