modality worklist query

Trouble during PacsOne Server installations
stejeda
Posts: 6
Joined: Wed Feb 09, 2005 1:11 pm

modality worklist query

Postby stejeda » Thu Feb 10, 2005 3:31 pm

When I perform a modality worklist query for CT as a modality and 'today' as the other parameter, this is what I get:

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38385.4839.304080';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTC',designator='LOCAL',version='',meaning='CT CHEST W',studyuid='1.2.840.113745.101000.1133000.38390.4259.306838';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38377.4331.298320';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPC',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W',studyuid='1.2.840.113745.101000.1133000.38390.5552.307205';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTSFTNECKC',designator='LOCAL',version='',meaning='CT SOFT TISSUE NECK W',studyuid='1.2.840.113745.101000.1133000.38390.5899.307270';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCAC',designator='LOCAL',version='',meaning='CT CHEST & ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38323.6485.266305';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38354.3680.282354';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38360.4272.286275';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDSC',designator='LOCAL',version='',meaning='CT ABDOMEN W & W/O',studyuid='1.2.840.113745.101000.1133000.38390.4498.306949';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38383.3938.302071';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38384.4281.303119';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38390.4647.306990';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTPELVC',designator='LOCAL',version='',meaning='CT PELVIS W',studyuid='1.2.840.113745.101000.1133000.38384.6638.303577';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTC',designator='LOCAL',version='',meaning='CT CHEST W',studyuid='1.2.840.113745.101000.1133000.38384.4799.303247';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTHEADS',designator='LOCAL',version='',meaning='CT BRAIN W/O',studyuid='1.2.840.113745.101000.1133000.38384.5243.303309';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTSC',designator='LOCAL',version='',meaning='CT CHEST W & W/O',studyuid='1.2.840.113745.101000.1133000.38385.3797.303787';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCAC',designator='LOCAL',version='',meaning='CT CHEST & ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38377.6112.298739';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTHEADS',designator='LOCAL',version='',meaning='CT BRAIN W/O',studyuid='1.2.840.113745.101000.1133000.38390.6332.307358';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38382.5286.301407';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDS',designator='LOCAL',version='',meaning='CT ABDOMEN W/O',studyuid='1.2.840.113745.101000.1133000.38384.6758.303600';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTC',designator='LOCAL',version='',meaning='CT CHEST W',studyuid='1.2.840.113745.101000.1133000.38385.4458.303969';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTPELVC',designator='LOCAL',version='',meaning='CT PELVIS W',studyuid='1.2.840.113745.101000.1133000.38385.4784.304069';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPSC',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W & W/O',studyuid='1.2.840.113745.101000.1133000.38377.6845.298955';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38389.4773.305929';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCAC',designator='LOCAL',version='',meaning='CT CHEST & ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38388.4250.304769';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPC',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W',studyuid='1.2.840.113745.101000.1133000.38389.5989.306266';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTHEADS',designator='LOCAL',version='',meaning='CT BRAIN W/O',studyuid='1.2.840.113745.101000.1133000.38388.5070.304991';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPS',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W/O',studyuid='1.2.840.113745.101000.1133000.38388.5476.305072';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTLUMBS',designator='LOCAL',version='',meaning='CT LUMBAR SPINE W/O',studyuid='1.2.840.113745.101000.1133000.38389.5059.306037';: Unknown column 'designator' in 'field list'

Remote Modality Worklist SCP IDXMWS returned 29 worklist items:Patient Identification Patient Demographic Scheduled Procedure Step Scheduled Protocol Code Sequence Requested Procedure Requested Procedure Code Sequence Imaging Service Request
Patient's Name HUNSINGER ALICE
Patient ID 2710200
Patient's Birth Date 19640801
Patient's Sex F
Requested Contrast Agent N/A
Scheduled Station AE Title IDT
Scheduled Procedure Step Start Date 20050210
Scheduled Procedure Step Start Time 072000
Modality CT
Scheduled Performing Physician's Name ADRIANO RUBEN D MD
Scheduled Procedure Step Description CT CHEST W/O
Scheduled Procedure Step ID 17519
Scheduled Station Name Central CT
Scheduled Procedure Step Location N/A
Pre-Medication N/A
Scheduled Procedure Step Status N/A
Code Value

pacsone
Site Admin
Posts: 3083
Joined: Tue Sep 30, 2003 2:47 am

Postby pacsone » Thu Feb 10, 2005 3:59 pm

Yes, this is a bug in the current 2.1.2 version of PacsOne Server premium edition as another user has reported it:

http://www.pacsone.net/forum/viewtopic.php?t=211

To fix this, you can either wait for the next release, or edit the script remoteWorklist.php and modify line 269 and 270 as follows:

designator -> schemedesignator
version -> schemeversion

stejeda
Posts: 6
Joined: Wed Feb 09, 2005 1:11 pm

Postby stejeda » Fri Feb 11, 2005 7:15 pm

It worked; somewhat. I got rid of the error messages but now I'm only getting the details on one item although it's telling me that 12 items were returned. How do I see the others?

pacsone
Site Admin
Posts: 3083
Joined: Tue Sep 30, 2003 2:47 am

Postby pacsone » Fri Feb 11, 2005 9:02 pm

You can click on the Modality Worklist link from the Main Menu.


Return to “Installation Trouble”

Who is online

Users browsing this forum: No registered users and 0 guests

cron