denis | 2009-07-07 00:39:15.0 | |
good day from russia ))
Try get data from file msaccess (locale "cp1251") 2009-07-06 15:24:15,328 ERROR worklist.server.WLFindRsp - Cannot execute query java.lang.ClassCastException: com.hxtt.d.i cannot be cast to java.lang.Boolean at com.hxtt.d.i.if(Unknown Source) at com.hxtt.d.i.a(Unknown Source) CP1251 not supported ? or something else ? names of tables and fields cp1251 | ||
HXTT Support | 2009-07-07 04:10:37.0 | |
>java.lang.ClassCastException: com.hxtt.d.i cannot be cast to java.lang.Boolean
That issue should have not relation with Cp1251. It seems that one function failed to return a bool value. Please check whether you're using the latest package. If yeah, please email us such a mdb file sample. | ||
HXTT Support | 2009-07-08 07:52:33.0 | |
Passed test with "select * from "���ڧէ?��ߧ��ѧ����;". What's your failed sql?
| ||
Denis | 2009-07-09 00:02:20.0 | |
Good day, my query
SELECT ����ާ֧⧳���ѧ秱��ݧڧ�� as accession_number, ���ѧ����䧳�֧�ڧ� as patient_id, ���ѧާڧݧڧ� as patient_name, ���ѧ�ѧ���اէ֧ߧڧ� as patient_bth_date, 'S' as patient_sex, '1.50' as patient_size, '50' as patient_weight, '1.2.801.1231233121' as study_uid, '1' as req_physician, '1' as req_proc_description, 'WLS' as scheduled_ae_title, '11:00' as start_time FROM ���ѧߧߧ�֧��ѧ�ڧ֧ߧ�� WHERE 'WLS' LIKE ? AND ���ѧ�ѧ��ҧ�ݧ֧է�ӧѧߧڧ� BETWEEN ? AND ? AND ����է����ڧݧڧ����� LIKE ? | ||
Denis | 2009-07-09 00:32:19.0 | |
LOG appserv after query
2009-07-09 11:15:06,943 INFO worklist.server.WLServer - Start Server listening on port 5001 2009-07-09 11:15:06,968 INFO ui.listener.WorklistManager - Worklist server is started successfully 2009-07-09 11:25:58,660 INFO worklist.server.WLFindRsp - Called AETitle: WLS 2009-07-09 11:25:58,661 INFO worklist.server.WLFindRsp - keys: (0008,0050) SH #0 [] Accession Number (0010,0010) PN #0 [] Patient's Name (0010,0020) LO #0 [] Patient ID (0010,0030) DA #0 [] Patient's Birth Date (0010,0040) CS #0 [] Patient's Sex (0010,2110) LO #0 [] Contrast Allergies (0020,000D) UI #0 [] Study Instance UID (0032,1032) PN #0 [] Requesting Physician (0032,1060) LO #0 [] Requested Procedure Description (0040,0100) SQ #-1 [1 item] Scheduled Procedure Step Sequence >ITEM #1 @80: >(0008,0060) CS #0 [] Modality >(0032,1070) LO #0 [] Requested Contrast Agent >(0040,0001) AE #0 [] Scheduled Station AE Title >(0040,0002) DA #18 [20000709-20090709] Scheduled Procedure Step Start Date >(0040,0003) TM #0 [] Scheduled Procedure Step Start Time >(0040,0006) PN #0 [] Scheduled Performing Physician's Name >(0040,0007) LO #0 [] Scheduled Procedure Step Description >(0040,0009) SH #0 [] Scheduled Procedure Step ID >(0040,0010) SH #0 [] Scheduled Station Name >(0040,0011) SH #0 [] Scheduled Procedure Step Location >(0040,0012) LO #0 [] Pre-Medication (0040,1001) SH #0 [] Requested Procedure ID (0040,1003) SH #0 [] Requested Procedure Priority 2009-07-09 11:25:58,687 INFO worklist.server.WLFindRsp - facades length: 1 2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - Application Entity Title: WLS 2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - From date: Sun Jul 09 00:00:00 MSD 2000 2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - To date: Thu Jul 09 23:59:59 MSD 2009 2009-07-09 11:25:58,688 INFO server.core.WLServerFacadeImpl - Modality: null 2009-07-09 11:25:58,689 INFO server.core.WLServerFacadeImpl - Date before convert: Sun Jul 09 00:00:00 MSD 2000 2009-07-09 11:25:58,689 INFO server.core.WLServerFacadeImpl - Date after convert: 2000-07-09 00:00:00.0 2009-07-09 11:25:58,689 INFO server.core.WLServerFacadeImpl - Date before convert: Thu Jul 09 23:59:59 MSD 2009 2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Date after convert: 2009-07-09 23:59:59.999 2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed ASTitle: WLS 2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed From Date: 2000-07-09 00:00:00.0 2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed To Date: 2009-07-09 23:59:59.999 2009-07-09 11:25:58,690 INFO server.core.WLServerFacadeImpl - Passed Modality: % 2009-07-09 11:25:58,691 INFO server.core.WLServerFacadeImpl - Param[query]: SELECT ???????????????? as accession_number, ???????????? as patient_id, ??????? as patient_name, ???????????? as patient_bth_date, 'S' as patient_sex, '1.50' as patient_size, '50' as patient_weight, '1.2.801.1231233121' as study_uid, '1' as req_physician, '1' as req_proc_description, 'WLS' as scheduled_ae_title, '11:00' as start_time FROM ?????????????? WHERE 'WLS' LIKE ? AND ???????????????? BETWEEN ? AND ? AND ??????????? LIKE ? 2009-07-09 11:25:59,437 DEBUG server.core.WLServerFacadeImpl - Result: [] 2009-07-09 11:25:59,437 INFO worklist.server.WLFindRsp - dicoms: [] 2009-07-09 11:25:59,437 INFO worklist.server.WLFindRsp - dicoms size: 0 dicomObjects size: 0 | ||
HXTT Support | 2009-07-09 08:20:10.0 | |
>WHERE
>'WLS' LIKE ? AND >���ѧ�ѧ��ҧ�ݧ֧է�ӧѧߧڧ� BETWEEN ? AND ? AND >����է����ڧݧڧ����� LIKE ? Try WHERE 'WLS' LIKE ? AND (���ѧ�ѧ��ҧ�ݧ֧է�ӧѧߧڧ� BETWEEN ? AND ? ) AND ����է����ڧݧڧ����� LIKE ? | ||
Denis | 2009-07-09 22:54:09.0 | |
no changes, why in query "??????????????", m\b config.xml must be "cp1251" ?
2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed ASTitle: WLS 2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed From Date: 2000-07-10 00:00:00.0 2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed To Date: 2009-07-10 23:59:59.999 2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Passed Modality: % 2009-07-10 09:49:37,247 INFO server.core.WLServerFacadeImpl - Param[query]: SELECT ???????????????? as accession_number, ???????????? as patient_id, ??????? as patient_name, ???????????? as patient_bth_date, 'S' as patient_sex, '1.50' as patient_size, '50' as patient_weight, '1.2.801.1231233121' as study_uid, '1' as req_physician, '1' as req_proc_description, 'WLS' as scheduled_ae_title, '11:00' as start_time FROM ?????????????? WHERE 'WLS' LIKE ? AND (???????????????? BETWEEN ? AND ? ) AND ??????????? LIKE ? 2009-07-10 09:49:38,786 DEBUG server.core.WLServerFacadeImpl - Result: [] 2009-07-10 09:49:38,787 INFO worklist.server.WLFindRsp - dicoms: [] 2009-07-10 09:49:38,787 INFO worklist.server.WLFindRsp - dicoms size: 0 dicomObjects size: 0 | ||
Denis | 2009-07-09 22:55:13.0 | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> SELECT ����ާ֧⧳���ѧ秱��ݧڧ�� as accession_number, ���ѧ����䧳�֧�ڧ� as patient_id, ���ѧާڧݧڧ� as patient_name, ���ѧ�ѧ���اէ֧ߧڧ� as patient_bth_date, 'S' as patient_sex, '1.50' as patient_size, '50' as patient_weight, '1.2.801.1231233121' as study_uid, '1' as req_physician, '1' as req_proc_description, 'WLS' as scheduled_ae_title, '11:00' as start_time FROM ���ѧߧߧ�֧��ѧ�ڧ֧ߧ�� WHERE 'WLS' LIKE ? AND (���ѧ�ѧ��ҧ�ݧ֧է�ӧѧߧڧ� BETWEEN ? AND ? ) AND ����է����ڧݧڧ����� LIKE ? | ||
Denis | 2009-07-09 23:01:22.0 | |
config.xml sent by email | ||
Denis | 2009-07-13 04:25:07.0 | |
It works!
Thx |