[#DCMEE-2069] QR-Service throws NullPointerException

[DCMEE-2069] QR-Service throws NullPointerException Created: 21/Aug/14
Updated:
21/Jan/15 Resolved: 07/Nov/14
Status:
Project:
Component/s:
Affects
Version/s:
Fix Version/s:
Resolved
dcm4chee
PIX
dcm4chee-2.18.0
Type:
Reporter:
Resolution:
Labels:
Remaining
Estimate:
Time Spent:
Original
Estimate:
Bug
Simon Schlosser
Duplicate
None
Not Specified
Issue Links:
Related
is related to DCMEE-2081 PIX Query aborts with NullPointerExce... Closed
dcm4chee-2.18.1
Priority:
Assignee:
Votes:
Major
Franz Willer
0
Not Specified
Not Specified
Tracking Status: Config affected - No, Docs - No, Risk Analysis - None, Test Spec - No, Test
State - Not testable
Description
When querying archive with wildcard
findscu -c [email protected]:11112 -L PATIENT -m 00100020='3*'
following exception is thrown:
[org.dcm4chex.archive.dcm.qrscp.QueryRetrieveScpService] Query DB failed:
java.lang.NullPointerException
An other query throws the following:
WARN FINDSCU->EE2001663RAD (TCPServer-1-298)
[org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured:
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@
40372a53[state=NORMAL
mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@47ac639c handles=1
lastUse=1408642161695 permit=true trackByTx=false
mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@781f795
2 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@5a56341a
xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@6bfbb8
txSync=null]
java.sql.SQLRecoverableException: Keine weiteren Daten aus Socket zu lesen
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)
at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.execute(BaseReadCmd.java:88)
at org.dcm4chex.archive.ejb.jdbc.BaseDSQueryCmd.execute(BaseDSQueryCmd.java:78)
at org.dcm4chex.archive.dcm.qrscp.FindScp.newMultiCFindRsp(FindScp.java:305)
at org.dcm4chex.archive.dcm.qrscp.FindScp.doCFind(FindScp.java:187)
at org.dcm4che.net.DcmServiceBase.c_find(DcmServiceBase.java:154)
at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:238)
at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)
at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:164)
at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249)
at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:288)
at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)
at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221)
at java.lang.Thread.run(Thread.java:682)
WARN FINDSCU->EE2001663RAD (TCPServer-1-301) [org.dcm4chex.archive.ejb.jdbc.BaseCmd]
failed to execute sql: SELECT patient.pat_attrs FROM patient WHERE (patient.merge_fk IS
NULL) AND ( ( (patient.pat_id = '100')AND(patient.pat_id_issuer = 'MY') )OR (
(patient.pat_id = '1001')AND(patient.pat_id_issuer = 'YOUR') )OR ( (patient.pat_id =
'1002')AND(patient.pat_id_issuer = 'HER') )OR (
...
Archive has PIX-Query activated.
Other wildcard-queries, such as '2*', work.
Comments
Comment by Franz Willer [ 16/Oct/14 ]
NullPointer Exception is fixed (with ) but the issue with wildcard patientID queries and
PIXQuery is a wont fix! (use other query parameter like institution to get expected results)
Comment by Franz Willer [ 07/Nov/14 ]
Fixed with
Comment by Philipp Halbrainer [ 07/Nov/14 ]
09:34:49,695 ERROR [QueryRetrieveScpService] Query DB failed:
java.sql.SQLException: give up executing SQL statement after all retries: SELECT
patient.pat_attrs, study.stud
y_attrs, study.mods_in_study, study.cuids_in_study, study.study_status_id, study.num_series,
study.num_instanc
es, study.fileset_id, study.fileset_iuid, study.retrieve_aets, study.ext_retr_aet, study.availability
FROM pat
ient INNER JOIN study ON (patient.pk = study.patient_fk) WHERE (patient.merge_fk IS
NULL) AND ( ( (patient.p
at_id = '1006061')AND(patient.pat_id_issuer = 'DCM4CHEE') )OR ( (patient.pat_id =
'4711')AND ) )
at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.execute(BaseReadCmd.java:122)
at org.dcm4chex.archive.ejb.jdbc.BaseDSQueryCmd.execute(BaseDSQueryCmd.java:78)
at org.dcm4chex.archive.dcm.qrscp.FindScp.newMultiCFindRsp(FindScp.java:305)
at org.dcm4chex.archive.dcm.qrscp.FindScp.doCFind(FindScp.java:181)
at org.dcm4che.net.DcmServiceBase.c_find(DcmServiceBase.java:154)
at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:238)
at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)
at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:164)
at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249)
at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:288)
at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)
at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221)
at java.lang.Thread.run(Thread.java:662)
09:34:49,699 INFO [FsmImpl] sending [pc-1] 1:C_FIND_RSP
class: 1.2.840.10008.5.1.4.1.2.2.1/Study Root Query/Retrieve Information Model - FIND
status: c000
error comment: java.sql.SQLException: give up executing SQL statement after all
Generated at Wed Apr 05 12:58:00 CEST 2017 using JIRA 6.3.6#6336sha1:cf1622c62a612607f341bda9491a04918e09ebfd.