Thursday, May 23, 2013
Google Custom Search

Our Community

Membership Membership:
Latest New User Latest: Mark24223
New Today New Today: 7
New Yesterday New Yesterday: 10
User Count Overall: 28674

People Online People Online:
Visitors Visitors: 12
Members Members: 0
Total Total: 12

Online Now Online Now:

ClearCanvas Community Forums

Devices Next Page does not work
Last Post 2012-06-01 09:22 AM by Manager. 8 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Manager
Advanced Member
Advanced Member
Posts:39

--
2012-05-29 01:29 PM  

I have a large number of devices that connect to the Image Server.
On the Devices page I can go to the next page to review more devices, but it doesn't work. It responds, "thinks", but stays on the first page.
What am I doing wrong? Any tips ?


Thanks.

steve
Senior Member
Senior Member
Posts:2096

--
2012-05-29 01:43 PM  

This is an old bug as reported here that's been fixed in our open source repository and our commercial products, but hasn't made it into a community edition release.  I believe it is fixed in the Alpha version of ImageServer with the Webstation support.

Live and real-time support available for Personal, Team, and Cleome Edition customers.
Manager
Advanced Member
Advanced Member
Posts:39

--
2012-05-29 02:52 PM  

Thanks Steve.
Is there a possible "backdoor" to access a file that contains the devices (only to review) ?

jcschott
Basic Member
Basic Member
Posts:18

--
2012-05-30 06:10 PM  
If you have access to the SQL database you can query the table [ImageServer].[dbo].[Device] that holds everything displayed in the device page.
Manager
Advanced Member
Advanced Member
Posts:39

--
2012-05-31 12:19 PM  

jcschott,
I have to admit, I am not a SQL programmer.
I have SQL Server Management Studio Express installed and navigated to:

Databases ~ ImageServer ~ Tables ~ dbo.Device

In the top bar I selected the ImageServer and hit Execute right next to it after I entered the device's name in the right top pane.
In the messages pane I see the text "could not find stored procedure.."

I must have done something wrong, can you please help me?
Thanks !

jcschott
Basic Member
Basic Member
Posts:18

--
2012-05-31 01:47 PM  
if you right click on the dbo.device table in the object explorer toolbar (where you navigated to the table) and select Top 1000. will return up to 1000 devices.

If you are looking for a specific aetitle you can always add the following line right after the FROM line

Where [AeTitle] = 'InsertAETitleHere'
Manager
Advanced Member
Advanced Member
Posts:39

--
2012-05-31 02:13 PM  

I did not see the Top 1000 but did see "open table" command which gave me the full list of devices.
I think this is kind of tricky because the item GUID will probably give me problems.
The Server Partition GUID can be copied without issues (if done for the right Server Partition).
Do you know if CC creates the item GUID or is this something SQL creates?

jcschott
Basic Member
Basic Member
Posts:18

--
2012-05-31 03:58 PM  
What are you trying to do with the devices? The Web UI still allows you to search, add or modify devices so I would recommend that route for any updates you want to make.

CC creates the GUID to keep track of the devices.
Manager
Advanced Member
Advanced Member
Posts:39

--
2012-06-01 09:22 AM  

Sometimes I want to look up a device but don't have any information about their AE Title, IP Address etc. and just want to see the complete list of connected devices.
By default I have configured CCIS to use a certain unknown port number for new devices to prevent them from pulling studies from the server. Once I have a list of devices showing this certain port number, I know it is a new device and can go from there.
In CCIS GUI I can't browse through the devices by page (see my first question in this posting) but SQL offers me the complete list which is a great workaround.
I have been messing around with the GUID values in SQL with a test server but I must say, it is pretty stable and hard to make it crash.

You are not authorized to post a reply.

Active Forums 4.1
Copyright 2013 ClearCanvas Inc. All Rights Reserved