Ok a fresh install of image server 2.0 and workstation. I have sreaming working and everyting seemd to be fine BUT

When ever I open a study I get "search or prior studies has failed" I only have one server and it is my default not sure what is going on here??

 

The reason for the error will be in the logs. If the logs don't answer it for you, post the log message here.

I have since moved the server to a diff PC thinking that might be the issue but I am also geting the errors below. User everyone has full access to the CC install directory. This is a window 7 64 bit unit.

2010-07-27 15:01:15,171 [4] INFO - Starting up in AppDomain [ClearCanvas.Server.ShredHostService.exe]
2010-07-27 15:01:20,818 [Diskspace Manager] INFO - The Diskspace Manager service has started successfully.
2010-07-27 15:01:20,896 [Diskspace Manager] INFO - Starting WCF Shred DiskspaceManager...
2010-07-27 15:01:24,234 [Diskspace Manager] INFO - WCF Shred DiskspaceManager is listening at net.pipe://localhost/DiskspaceManager.
2010-07-27 15:01:24,234 [Diskspace Manager] INFO - The Diskspace Manager WCF service has started successfully.
2010-07-27 15:01:26,465 [4] WARN - Time provider not found - defaulting to local machine time.
2010-07-27 15:01:27,401 [1] INFO - No session manager extension found
n port 0.0.0.0:104
2010-07-27 15:01:27,432 [Dicom Server] INFO - The Dicom Server service has started successfully.
2010-07-27 15:01:27,432 [Dicom Server] INFO - Starting WCF Shred DicomServer...
2010-07-27 15:01:28,212 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:28,275 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:29,881 [Dicom Server] INFO - WCF Shred DicomServer is listening at net.pipe://localhost/DicomServer.
2010-07-27 15:01:29,881 [Dicom Server] INFO - The Dicom Server WCF service has started successfully.
2010-07-27 15:01:29,881 [Dicom Server] INFO - Starting WCF Shred DicomSend...
2010-07-27 15:01:30,006 [Dicom Server] INFO - WCF Shred DicomSend is listening at net.pipe://localhost/DicomSend.
2010-07-27 15:01:30,006 [Dicom Server] INFO - The Dicom Send WCF service has started successfully.
2010-07-27 15:01:30,006 [Dicom Server] INFO - Starting WCF Shred StudyLocator...
2010-07-27 15:01:30,037 [Dicom Server] INFO - unable to load binding configuration BasicHttpBinding_IStudyRootQuery; using default binding configuration
2010-07-27 15:01:30,100 [Dicom Server] INFO - WCF Shred StudyLocator is listening at http://localhost:51122/StudyLocator.
2010-07-27 15:01:30,100 [Dicom Server] INFO - The Study Locator WCF service has started successfully.
2010-07-27 15:01:30,365 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:30,381 [1] WARN - Time provider not found - defaulting to local machine time.
2010-07-27 15:01:30,381 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:30,396 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:30,942 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:31,551 [Local Data Store] WARN - Time provider not found - defaulting to local machine time.
2010-07-27 15:01:31,738 [Local Data Store] INFO - The Local Data Store service has started successfully.
2010-07-27 15:01:31,738 [Local Data Store] INFO - Starting WCF Shred LocalDataStore...
2010-07-27 15:01:32,128 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:01:34,655 [Local Data Store] INFO - WCF Shred LocalDataStore is listening at net.pipe://localhost/LocalDataStore.
2010-07-27 15:01:34,655 [Local Data Store] INFO - The Local Data Store WCF service has started successfully.
2010-07-27 15:01:34,655 [Local Data Store] INFO - Starting WCF Shred LocalDataStoreActivityMonitor...
2010-07-27 15:01:34,749 [Local Data Store] INFO - WCF Shred LocalDataStoreActivityMonitor is listening at net.pipe://localhost/LocalDataStoreActivityMonitor.
2010-07-27 15:01:34,749 [Local Data Store] INFO - The Local Data Store Activity Monitor WCF service has started successfully.
2010-07-27 15:04:47,034 [1] INFO - No session manager extension found
2010-07-27 15:04:47,455 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:04:47,487 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:04:47,955 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:04:47,970 [1] WARN - Time provider not found - defaulting to local machine time.
2010-07-27 15:04:47,970 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:04:47,986 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:04:48,469 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:04:49,827 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:38,587 [1] INFO - No session manager extension found
2010-07-27 15:08:39,009 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:39,056 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:39,524 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:39,524 [1] WARN - Time provider not found - defaulting to local machine time.
2010-07-27 15:08:39,524 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:39,539 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:40,038 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2010-07-27 15:08:40,928 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider

Ok i am getting this on the client

2010-07-27 15:28:18,182 [DicomServer: 192.168.51.19 [27]] INFO - Received association release request from SVMG-PACS to svmg-it.
2010-07-27 15:28:18,182 [DicomClient: 192.168.51.19:104 [20]] INFO - Success status received in Move Scu!
2010-07-27 15:28:18,244 [DicomClient: 192.168.51.19:104 [20]] INFO - Association released from svmg-it to SVMG-PACS
2010-07-27 15:28:18,307 [DicomServer: 192.168.51.19 [27]] INFO -
2010-07-27 15:28:18,338 [Retrieve from 192.168.51.19/SVMG-PACS:104] WARN - No audit sink extensions found - Auditing will be disabled for the remainder of the session.
2010-07-27 15:28:19,305 [17] ERROR - Exception thrown
System.Exception: Failed to commit a file to the datastore (C:\Program Files\ClearCanvas\ClearCanvas Workstation\filestore\1.2.392.12345.1.2009.4.13.20.28.27.296\1.2.392.12345.1.2009.4.13.20.28.27.672.dcm); This file will need to be imported manually. ---> ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while attempting to retrieve the study (1.2.392.12345.1.2009.4.13.20.28.27.296) from the data store. ---> 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.GetStudy(String studyInstanceUid)
--- End of inner exception stack trace ---
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.GetStudy(String studyInstanceUid)
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DicomPersistentStore.GetStudy(String studyInstanceUid)
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DicomPersistentStore.UpdateSopInstance(DicomFile file)
at ClearCanvas.ImageViewer.Shreds.LocalDataStore.LocalDataStoreService.DicomFileImporter.UpdateDatabase(List`1 items)
--- End of inner exception stack trace ---
2010-07-27 15:28:19,321 [17] ERROR - Exception thrown
System.Exception: Failed to commit a file to the datastore (C:\Program Files\ClearCanvas\ClearCanvas Workstation\filestore\1.2.392.12345.1.2009.4.13.20.28.27.296\1.2.392.12345.1.2009.4.13.20.28.27.297.dcm); This file will need to be imported manually. ---> ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while attempting to retrieve the study (1.2.392.12345.1.2009.4.13.20.28.27.296) from the data store. ---> 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.GetStudy(String studyInstanceUid)
--- End of inner exception stack trace ---
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DataStoreReader.GetStudy(String studyInstanceUid)
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DicomPersistentStore.GetStudy(String studyInstanceUid)
at ClearCanvas.Dicom.DataStore.DataAccessLayer.DicomPersistentStore.UpdateSopInstance(DicomFile file)
at ClearCanvas.ImageViewer.Shreds.LocalDataStore.LocalDataStoreService.DicomFileImporter.UpdateDatabase(List`1 items)
--- End of inner exception stack trace ---
2010-07-27 15:28:19,321 [17] ERROR - Exception thrown
System.Exception: Failed to commit a file to the datastore (C:\Program Files\ClearCanvas\ClearCanvas Workstation\filestore\1.2.392.12345.1.2009.4.13.20.28.27.296\1.2.392.12345.1.2009.4.13.20.28.29.641.dcm); This file will need to be imported manually. ---> ClearCanvas.Dicom.DataStore.DataStoreException: An error occurred while attempting to retrieve the study (1.2.392.12345.1.2009.4.13.20.28.27.296) from the data store. ---> 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 ---

This problem is now fixed I unistalled everyting and reinstalled incuding SQL--- BUT still had the issues resoved with http://support.microsoft.com/kb/974247 needing to install 32 and 64 bit would recomend the install be updated.

Our installer does install both x86 and x64 versions of SQL Server Compact 3.5 SP1, so I'm going to guess this is what happened, not necessarily in this order:

• You already had SQL CE 3.5 SP2 for x86 installed, but not for x64.
• You installed CC x64, which installed x86 and x64 versions of SQL CE 3.5 SP1.
• Microsoft installs a policy file specifying that, when a process tries to load 3.5 SP1, it should actually load 3.5 SP2.
• CC (actually .NET runtime) tries to load 3.5 SP2 based on the policy, but only x86 version exists.
• You get an error.

This is actually Microsoft's issue and I wish they'd fix it.  The problem is that their "x86" version of SQL CE is not compiled for x86 specifically, but is compiled for "Any CPU" (aka MSIL), but it references unmanaged binaries that are compiled for x86, so when a managed app tries to load SQL CE on a 64-bit machine, if the x64 version of SQL CE isn't installed, it will use the "x86 version" because it's MSIL, so why wouldn't it work, right?  Wrong.  As soon as the app actually tries to use SQL CE, blammo, it doesn't work because the unmanaged binaries it references are for x86.  What they should do, and there may be some technical reason why they can't, is compile the .NET assemblies for x86 specifically, then the x86 and x64 versions of SQL CE could be installed independently instead of having to install both.

Anyway, chances are this may keep happening as long as MS keeps issuing service packs with policy files without fixing the MSIL/x86 issue.  The really unfortunate thing is we can't actually do anything about it.  Even when we put the SQL CE binaries in the CC install folder, the policy file still takes over and forces the installed version to be loaded from the GAC.  We can force CC to use a specific version of SQL CE via the config file, but then we wouldn't get critical fixes addressed by service packs.  It's a catch 22.

 What I've stated here is just an educated guess based on a previous investigation with SP1 when we first found this problem with x64 where you have to install both the x86 and x64 versions.  I'll test out my theory before we release the next version of CC.

FYI, we will be distributing SP2 with the next release of CC.