Encore Pro Analyzer - Invalid Column Name

General Discussion on any topic relating to CPAP and/or Sleep Apnea.
stuart1
Posts: 30
Joined: Mon Dec 01, 2008 10:10 pm

Encore Pro Analyzer - Invalid Column Name

Post by stuart1 » Tue May 19, 2009 11:46 pm

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!

stuart1
Posts: 30
Joined: Mon Dec 01, 2008 10:10 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by stuart1 » Wed May 27, 2009 11:16 am

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.

User avatar
feeling_better
Posts: 802
Joined: Sun Jun 01, 2008 7:08 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by feeling_better » Wed May 27, 2009 1:24 pm

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

stuart1
Posts: 30
Joined: Mon Dec 01, 2008 10:10 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by stuart1 » Wed May 27, 2009 1:36 pm

I was referring to Encore Pro 1.8.49, you are correct that Encore Pro Analyzer is separate.

User avatar
jskinner
Posts: 1475
Joined: Sat Aug 26, 2006 9:21 pm
Location: Greenwich, Nova Scotia, Canada
Contact:

Re: Encore Pro Analyzer - Invalid Column Name

Post by jskinner » Wed May 27, 2009 3:28 pm

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\
Last edited by jskinner on Wed May 27, 2009 4:26 pm, edited 1 time in total.
Encore Pro Analyzer Author
Facebook Apnea Group

stuart1
Posts: 30
Joined: Mon Dec 01, 2008 10:10 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by stuart1 » Wed May 27, 2009 4:04 pm

Thanks James!

Jmark
Posts: 10
Joined: Sun Apr 01, 2007 5:16 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by Jmark » Fri Aug 14, 2009 10:42 pm

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.

stuart1
Posts: 30
Joined: Mon Dec 01, 2008 10:10 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by stuart1 » Sun Aug 16, 2009 10:43 am

Look at the post above from jskinner.

Jmark
Posts: 10
Joined: Sun Apr 01, 2007 5:16 pm

Re: Encore Pro Analyzer - Invalid Column Name

Post by Jmark » Sun Aug 16, 2009 2:52 pm

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.