Hi all,

I have a copy of the Workstation that has completely stopped functioning.  When I try to load a local study I receive the error:

ClearCanvas was unable to load any of the images you requested.

When I try to search the local datastore i get the error:

Unable to Query server My Studies:  An error occurred while performing the study root query.

I am able to query remote devices but not receive.

I was running a custom build of V1.3 which had been working fine originally.  I don't know exactly when it stopped working, but other software may have been installed in the interim.  I have since unistalled and upgraded to the off the shelf V2 Beta with the same exact problem.  An excerpt from the log is below.

Here are some of the details on my system:

Windows XP English with SP2

SQL Server 2005

Visual C++ 2005 and 2008 9.0.2, and 9.03 Redistributable

It appears that the Shred Host Service is up and running. 

I've tried going through the forums without luck.  Here's the log which I'm not very good at interpretting.  My guess is that there's a problem somewhere with the local database run by NHibernate.  I seem to be running the right version of SQL.  Again, things were working peachy until I left the lab and someone else 'upgraded' another piece of software, but I'm not exactly sure what changed.

 

2009-12-19 03:28:53,021 [1] ERROR - Exception thrown
ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while performing the study root query. ---> NHibernate.ADOException: cannot open connection ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
   at System.ModuleHandle._GetPEKind(Int32& peKind, Int32& machine)
   at System.ModuleHandle.GetPEKind(PortableExecutableKinds& peKind, ImageFileMachine& machine)
   at System.Reflection.Module.GetPEKind(PortableExecutableKinds& peKind, ImageFileMachine& machine)
   at System.Reflection.Assembly.ComputeProcArchIndex()
   at System.Reflection.Assembly.GetName(Boolean copiedName)
   at System.Reflection.Assembly.GetName()
   at System.Data.SqlServerCe.SqlCeRestriction.IsWebHosted()
   at System.Data.SqlServerCe.SqlCeRestriction.CheckExplicitWebHosting()
   at System.Data.SqlServerCe.SqlCeConnection..ctor()
   --- End of inner exception stack trace ---
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at NHibernate.Driver.ReflectionBasedDriver.CreateConnection()
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
   --- End of inner exception stack trace ---
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
   at NHibernate.AdoNet.ConnectionManager.GetConnection()
   at NHibernate.Impl.SessionImpl.get_Connection()
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
   at NHibernate.Transaction.AdoTransaction.Begin()
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.SessionManager.BeginReadTransaction()
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.StudyQuery(QueryCriteria queryCriteria)
   --- End of inner exception stack trace ---
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.StudyQuery(QueryCriteria queryCriteria)
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.Query(DicomAttributeCollection queryCriteria)
   at ClearCanvas.ImageViewer.StudyFinders.LocalDataStore.LocalDataStoreStudyFinder.Query(QueryParameters queryParams, Object targetServer)
   at ClearCanvas.ImageViewer.ImageViewerComponent.FindStudy(QueryParameters queryParameters, Object targetServer, String studyFinderName)
   at ClearCanvas.ImageViewer.Explorer.Dicom.StudyBrowserComponent.ProcessReceivedAndRemovedStudies()
2009-12-19 03:29:05,443 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:05,506 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:05,724 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:31,162 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:40,724 [1] INFO  - No session manager extension found
2009-12-19 03:29:40,896 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:40,912 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:41,177 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:41,177 [1] WARN  - Time provider not found - defaulting to local machine time.
2009-12-19 03:29:41,177 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:43,083 [1] WARN  - No audit sink extensions found - Auditing will be disabled for the remainder of the session.
2009-12-19 03:29:43,224 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:43,583 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:45,958 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider
2009-12-19 03:29:46,005 [1] ERROR - Exception thrown

Failed to load prior study '1.2.124.113532.199.165.153.36.20090306.150302.3359250' from study loader 'DICOM_LOCAL'.
ClearCanvas.ImageViewer.LoadStudyException: An error occurred while attempting to load study '1.2.124.113532.199.165.153.36.20090306.150302.3359250'. ---> ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while attempting to retrieve the study (1.2.124.113532.199.165.153.36.20090306.150302.3359250) from the data store. ---> NHibernate.ADOException: cannot open connection ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
   at System.ModuleHandle._GetPEKind(Int32& peKind, Int32& machine)
   at System.ModuleHandle.GetPEKind(PortableExecutableKinds& peKind, ImageFileMachine& machine)
   at System.Reflection.Module.GetPEKind(PortableExecutableKinds& peKind, ImageFileMachine& machine)
   at System.Reflection.Assembly.ComputeProcArchIndex()
   at System.Reflection.Assembly.GetName(Boolean copiedName)
   at System.Reflection.Assembly.GetName()
   at System.Data.SqlServerCe.SqlCeRestriction.IsWebHosted()
   at System.Data.SqlServerCe.SqlCeRestriction.CheckExplicitWebHosting()
   at System.Data.SqlServerCe.SqlCeConnection..ctor()
   --- End of inner exception stack trace ---
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at NHibernate.Driver.ReflectionBasedDriver.CreateConnection()
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
   --- End of inner exception stack trace ---
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
   at NHibernate.AdoNet.ConnectionManager.GetConnection()
   at NHibernate.Impl.SessionImpl.get_Connection()
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
   at NHibernate.Transaction.AdoTransaction.Begin()
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.SessionManager.BeginReadTransaction()
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.GetStudy(String studyInstanceUid)
   --- End of inner exception stack trace ---
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.GetStudy(String studyInstanceUid)
   at ClearCanvas.ImageViewer.StudyLoaders.LocalDataStore.LocalDataStoreStudyLoader.OnStart(StudyLoaderArgs studyLoaderArgs)
   at ClearCanvas.ImageViewer.StudyManagement.StudyLoader.Start(StudyLoaderArgs studyLoaderArgs)
   --- End of inner exception stack trace ---
   at ClearCanvas.ImageViewer.StudyManagement.StudyLoader.Start(StudyLoaderArgs studyLoaderArgs)
   at ClearCanvas.ImageViewer.ImageViewerComponent.SingleStudyLoader.LoadSops()
   at ClearCanvas.ImageViewer.ImageViewerComponent.SingleStudyLoader.LoadStudy()
2009-12-19 03:29:46,021 [1] ERROR - Exception thrown
ClearCanvas.ImageViewer.LoadStudyException: An error occurred while attempting to load study '1.2.124.113532.199.165.153.36.20090306.150302.3359250'. ---> ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while attempting to retrieve the study (1.2.124.113532.199.165.153.36.20090306.150302.3359250) from the data store. ---> NHibernate.ADOException: cannot open connection ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
   at System.ModuleHandle._GetPEKind(Int32& peKind, Int32& machine)
   at System.ModuleHandle.GetPEKind(PortableExecutableKinds& peKind, ImageFileMachine& machine)
   at System.Reflection.Module.GetPEKind(PortableExecutableKinds& peKind, ImageFileMachine& machine)
   at System.Reflection.Assembly.ComputeProcArchIndex()
   at System.Reflection.Assembly.GetName(Boolean copiedName)
   at System.Reflection.Assembly.GetName()
   at System.Data.SqlServerCe.SqlCeRestriction.IsWebHosted()
   at System.Data.SqlServerCe.SqlCeRestriction.CheckExplicitWebHosting()
   at System.Data.SqlServerCe.SqlCeConnection..ctor()
   --- End of inner exception stack trace ---
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at NHibernate.Driver.ReflectionBasedDriver.CreateConnection()
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
   --- End of inner exception stack trace ---
   at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
   at NHibernate.AdoNet.ConnectionManager.GetConnection()
   at NHibernate.Impl.SessionImpl.get_Connection()
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
   at NHibernate.Transaction.AdoTransaction.Begin()
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.SessionManager.BeginReadTransaction()
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.GetStudy(String studyInstanceUid)
   --- End of inner exception stack trace ---
   at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.GetStudy(String studyInstanceUid)
   at ClearCanvas.ImageViewer.StudyLoaders.LocalDataStore.LocalDataStoreStudyLoader.OnStart(StudyLoaderArgs studyLoaderArgs)
   at ClearCanvas.ImageViewer.StudyManagement.StudyLoader.Start(StudyLoaderArgs studyLoaderArgs)
   --- End of inner exception stack trace ---
   at ClearCanvas.ImageViewer.ImageViewerComponent.LoadStudy(LoadStudyArgs loadStudyArgs)
   at ClearCanvas.ImageViewer.ImageViewerComponent.LoadStudies(IList`1 loadStudyArgs)
   at ClearCanvas.ImageViewer.StudyManagement.OpenStudyHelper.LoadAndOpenStudies()
2009-12-19 03:29:46,021 [1] WARN  - Configuration store not found - defaulting to LocalFileSettingsProvider

 

Thanks!

-Seth

 

PS  I'm very glad the MOVESCU was patched in V2.0 to allow for series moves!  Also, the screencast section of the site is a nice addition.  Too bad my trial of Camtasia studio expired. 

 

Hi Seth,

Could you please verify that the path indicated in ClearCanvas.Dicom.DataStore.cfg.xml still points to the correct file? And if that's not the case, maybe the problem is with the SQL Server CE / SQL Server - I believe the 1.3 version still uses a CE 2005 database, and we've seen that subsequent installations of SQL Server 2008 (at least in 64-bit) can make the CE 2008 assemblies be loaded instead. If you do have 2008 installed, try moving the sqlce*.dll files up one level into the root installation directory.

If neither of these help, let us know and we'll see if we can figure out what else might be the problem.

Hope this helps!

Hi Jasper,

Unfortunately, no luck. The ClearCanvas.Dicom.DataStore.cfg.xml path path points to the correct viewer.sdf file. Moving the sqlce*.dll files from the common subdirectory to the root installation directory did not help either. Also note, I'm having the same problem with V1.3 and now V2.0 Beta on this particular machine.

Another observation is that the local data store database is correctly populated when I open the workstation (as opposed to when I move the viewer.sdf file), but it disappears when I try to search the local database.

Thanks,
Seth

Hi Seth,

Is it possible that there's another installation on the machine with a running shred host service in the Windows Services control panel? A second shred host service running simultaneously might confuse the Workstation client if the service points to a different database.

Only a single shed host service is running.
-Seth

Hi Seth, in your previous post you said it's ok when you first open the workstation, but you can't search? That's definitely strange. Can you answer these questions for me?

1. Is the path to the database in the datastore's cfg.xml file relative or fully qualified?
2. Do you have a custom plugin that changes the working directory of the application? For example, if you ever open a file/open dialog, I believe this would happen.
3. What are the exact build numbers of the C++ runtime(s) installed?
4. Do you have any Visual Studio/Visual C++ or C# Express versions installed?
5. Did the problem start happening after installing a Visual Studio version, or after installing the 2.0 Beta alongside 1.5? Multiple workstations might not play nice together.

Thanks and best regards,
Stewart

Hi Stewart,

Happy new year to you and the team.  Thanks for thinking about the problem.  It is weird because the workstation opens fine, and the local database list actually populates initially, but then I get that error when I try to search either the local or a remote database.

The workstation in question is not one of my development machines, so I haven't changed too many things that could foul up the operation.

1.  The database path is the default, fully qualified path.

2.  I removed all custom plugins from this installatiion.

3.  I wonder if the C++ runtimes could be the culprit.  2005 V 8.0.56336, 2008 x86 9.0.21022  and 2008 x86 9.0.3729.17  I'm not sure why there are 2 versions of the 2008 runtime and I don't know if I could break some other software's dependencies by unistalling one of them.

4.  No versions of visual studio on this PC

5.  Workstation 2.0 is the only version on the pc now.

Thanks for the thoughts, let me know what you think about the c++ runtime versions.

-Seth

Hi Seth, the FileNotFoundException in the logs is normally due to a missing unmanaged dependency, like the correct C++ runtime.  The 2.0 installer installs both the 2008 and 2008SP1 redistributables (9.0.21022 and 9.0.30729.17), so that might be the problem.

Any chance the machine is 64 bit?  The problem described in this ticket also results in a FNF exception, so that's another possibility.

Hope this helps,

Stewart

I am also having this problem on a 64 bit machine running both server 1.5, SQL 2008 express and viewer 2.0 on same machine?

Unexpected error while processing study root query.
ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while performing the study root query. ---> NHibernate.ADOException: cannot open connection ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details.
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at NHibernate.Driver.ReflectionBasedDriver.CreateConnection()
at NHibernate.Connection.DriverConnectionProvider.GetConnection()
at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
--- End of inner exception stack trace ---
at NHibernate.Impl.SessionFactoryImpl.OpenConnection()
at NHibernate.AdoNet.ConnectionManager.GetConnection()
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
at ClearCanvas.Dicom.DataStore.DataAccessLayer.SessionManager.BeginReadTransaction()
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.StudyQuery(QueryCriteria queryCriteria)
--- End of inner exception stack trace ---
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.StudyQuery(QueryCriteria queryCriteria)
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.Query(DicomAttributeCollection queryCriteria)
at ClearCanvas.ImageViewer.StudyFinders.LocalDataStore.LocalDataStoreQueryClient.DoQuery[T](T identifier)
at ClearCanvas.ImageViewer.StudyFinders.LocalDataStore.LocalDataStoreQueryClient.Query[T](T identifier)
2010-08-09 16:41:52,216 [18] ERROR - Exception thrown

Failed to query server .
System.ServiceModel.FaultException`1[ClearCanvas.Dicom.ServiceModel.Query.QueryFailedFault]: Unexpected error while processing study root query. (Fault Detail is equal to ClearCanvas.Dicom.ServiceModel.Query.QueryFailedFault).
2010-08-09 16:41:52,219 [18] ERROR - Exception thrown

The search for prior studies has failed.
System.ServiceModel.FaultException`1[ClearCanvas.Dicom.ServiceModel.Query.QueryFailedFault]: Failed to query server . (Fault Detail is equal to ClearCanvas.Dicom.ServiceModel.Query.QueryFailedFault).
2010-08-09 16:41:52,231 [1] ERROR - Exception thrown
ClearCanvas.ImageViewer.LoadPriorStudiesException: The query for prior studies has failed.
at ClearCanvas.ImageViewer.ImageViewerComponent.AsynchronousPriorStudyLoader.VerifyLoadPriors()
at ClearCanvas.ImageViewer.ImageViewerComponent.AsynchronousPriorStudyLoader.OnComplete(Object nothing)
2010-08-09 16:41:52,235 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-08-09 16:41:53,854 [17] INFO - Large object collection summary: freed 0 MB in 0.009 seconds and 0 iterations, Total Containers: 0, Total Large Objects: 0
2010-08-09 16:42:03,864 [17] INFO - Large object collection summary: freed 0 MB in 0.01 seconds and 0 iterations, Total Containers: 0, Total Large Objects: 0


Any suggestions?

Also no errors in install log?
Strange I get an eror while running the installer?
I also have a server 2008 x64 running server 2.0 and viewer 2.0 that gave me the same error originally, I uninstalled and re installed 3 times and now working fine.

 Hi alara, glad you sorted it out.  This post and this one may be helpful to others with the same problem.