[02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getConnection(): Resource id #1 [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200352722' AND ACCESS_CODE = '23343428' [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200352722' AND ACCESS_CODE = '23343428' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631431' [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getPatientReportsDetail() entered [02 Sep 2020 01:01:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200352722', 'M0100000631431', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 01:01:13] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200352722', 'M0100000631431', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 01:01:13] (index) p_Stop=N [02 Sep 2020 01:01:13] (index) p_Alert= [02 Sep 2020 01:01:13] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 01:01:13] (index) database connection response [02 Sep 2020 01:01:13] (index) getConnectionClose() called.... [02 Sep 2020 01:01:13] (index) getConnectionClose() called.... [02 Sep 2020 01:23:35] (index) database connection response [02 Sep 2020 01:23:35] (index) getConnection(): Resource id #1 [02 Sep 2020 01:23:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 01:23:35] (index) database connection response [02 Sep 2020 01:23:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 01:23:35] (index) database connection response [02 Sep 2020 01:23:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 01:23:35] (index) database connection response [02 Sep 2020 01:23:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '6005' AND ACCESS_CODE = '6005' [02 Sep 2020 01:23:36] (index) database connection response [02 Sep 2020 01:23:36] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '6005' AND ACCESS_CODE = '6005' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 01:23:36] (index) database connection response [02 Sep 2020 01:23:36] (index) getConnectionClose() called.... [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getConnection(): Resource id #1 [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593995' [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getPatientReportsDetail() entered [02 Sep 2020 04:57:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 04:57:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 04:57:00] (index) p_Stop=N [02 Sep 2020 04:57:00] (index) p_Alert= [02 Sep 2020 04:57:00] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 04:57:00] (index) database connection response [02 Sep 2020 04:57:00] (index) getConnectionClose() called.... [02 Sep 2020 04:57:00] (index) getConnectionClose() called.... [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getConnection(): Resource id #1 [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348693' AND ACCESS_CODE = '13321009' [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200348693' AND ACCESS_CODE = '13321009' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631202' [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getPatientReportsDetail() entered [02 Sep 2020 09:19:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348693', 'M0100000631202', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:19:55] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200348693', 'M0100000631202', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:19:55] (index) p_Stop=N [02 Sep 2020 09:19:55] (index) p_Alert= [02 Sep 2020 09:19:55] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 09:19:55] (index) database connection response [02 Sep 2020 09:19:55] (index) getConnectionClose() called.... [02 Sep 2020 09:19:55] (index) getConnectionClose() called.... [02 Sep 2020 09:20:27] (viewOnlineReports) database connection response [02 Sep 2020 09:20:27] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:27] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:27] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:27] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '1', '001000000000085025', 'M0100000631202_M01HEM20011861_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:27] (viewOnlineReports) database connection response [02 Sep 2020 09:20:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 09:20:27] (viewOnlineReports) database connection response [02 Sep 2020 09:20:27] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:20:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599020427M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:20:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599020427M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:20:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:27] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599020427M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:20:33] (viewOnlineReports) database connection response [02 Sep 2020 09:20:33] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:33] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:33] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:33] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '2', '001000000000081028', 'M0100000631202_M01RCH20016048_2.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:33] (viewOnlineReports) database connection response [02 Sep 2020 09:20:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [02 Sep 2020 09:20:33] (viewOnlineReports) database connection response [02 Sep 2020 09:20:33] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:20:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599020433M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:20:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599020433M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:20:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:33] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1599020433M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:20:35] (viewOnlineReports) database connection response [02 Sep 2020 09:20:35] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '3', '001000000000080003', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:35] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:35] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:35] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:35] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '3', '001000000000080003', 'M0100000631202_M01RCH20016048_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:35] (viewOnlineReports) database connection response [02 Sep 2020 09:20:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [02 Sep 2020 09:20:35] (viewOnlineReports) database connection response [02 Sep 2020 09:20:35] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:20:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599020435M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:20:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599020435M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:20:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:35] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1599020435M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:20:38] (viewOnlineReports) database connection response [02 Sep 2020 09:20:38] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '4', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:38] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:38] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:38] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:38] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '4', '001000000000084460', 'M0100000631202_M01RCH20016048_7.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:38] (viewOnlineReports) database connection response [02 Sep 2020 09:20:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [02 Sep 2020 09:20:38] (viewOnlineReports) database connection response [02 Sep 2020 09:20:38] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:20:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599020438M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:20:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599020438M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:20:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599020438M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:20:40] (viewOnlineReports) database connection response [02 Sep 2020 09:20:40] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '5', '001000000000082560', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:40] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:40] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:40] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:40] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '5', '001000000000082560', 'M0100000631202_M01RCH20016048_5.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:40] (viewOnlineReports) database connection response [02 Sep 2020 09:20:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [02 Sep 2020 09:20:40] (viewOnlineReports) database connection response [02 Sep 2020 09:20:40] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:20:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599020440M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:20:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599020440M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:20:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:40] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599020440M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:20:42] (viewOnlineReports) database connection response [02 Sep 2020 09:20:42] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:42] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '6', '001000000000084100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:42] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:42] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:42] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:42] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '6', '001000000000084100', 'M0100000631202_M01RCH20016048_6.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:42] (viewOnlineReports) database connection response [02 Sep 2020 09:20:42] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [02 Sep 2020 09:20:42] (viewOnlineReports) database connection response [02 Sep 2020 09:20:42] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:42] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:42] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:42] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:20:42] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599020442M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:20:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599020442M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:20:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:42] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599020442M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:20:45] (viewOnlineReports) database connection response [02 Sep 2020 09:20:45] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '7', '001000000000082040', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:45] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:45] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:45] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:45] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '7', '001000000000082040', 'M0100000631202_M01RCH20016048_3.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:45] (viewOnlineReports) database connection response [02 Sep 2020 09:20:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [02 Sep 2020 09:20:45] (viewOnlineReports) database connection response [02 Sep 2020 09:20:45] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:20:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599020445M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:20:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599020445M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:20:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:45] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599020445M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:20:47] (viewOnlineReports) database connection response [02 Sep 2020 09:20:47] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '8', '001000000000083970', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:47] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:47] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:47] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:47] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '8', '001000000000083970', 'M0100000631202_M01SCH20008873_2.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:47] (viewOnlineReports) database connection response [02 Sep 2020 09:20:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [02 Sep 2020 09:20:47] (viewOnlineReports) database connection response [02 Sep 2020 09:20:47] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:20:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599020447M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:20:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599020447M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:20:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:47] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599020447M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:20:49] (viewOnlineReports) database connection response [02 Sep 2020 09:20:49] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '9', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:49] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:49] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:49] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:49] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '9', '001000000000087100', 'M0100000631202_M01MIC20006368_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:49] (viewOnlineReports) database connection response [02 Sep 2020 09:20:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [02 Sep 2020 09:20:49] (viewOnlineReports) database connection response [02 Sep 2020 09:20:49] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:20:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599020449M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:20:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599020449M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:20:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:50] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1599020449M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:20:52] (viewOnlineReports) database connection response [02 Sep 2020 09:20:52] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '10', '001000000000082374', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:52] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:52] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:52] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:52] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '10', '001000000000082374', 'M0100000631202_M01RCH20016048_4.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:52] (viewOnlineReports) database connection response [02 Sep 2020 09:20:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '10' [02 Sep 2020 09:20:52] (viewOnlineReports) database connection response [02 Sep 2020 09:20:52] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:52] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:52] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:20:52] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599020452M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:20:52] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599020452M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:20:52] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:52] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599020452M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:20:54] (viewOnlineReports) database connection response [02 Sep 2020 09:20:54] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:20:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '12', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:20:54] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:20:54] (viewOnlineReports) p_Alert= [02 Sep 2020 09:20:54] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:20:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '12', '001000000000082306', 'M0100000631202_M01SCH20008873_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:20:54] (viewOnlineReports) database connection response [02 Sep 2020 09:20:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '12' [02 Sep 2020 09:20:54] (viewOnlineReports) database connection response [02 Sep 2020 09:20:54] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:20:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:20:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:20:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599020454M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:20:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599020454M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:20:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:20:54] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1599020454M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:46:17] (viewOnlineReports) database connection response [02 Sep 2020 09:46:17] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:46:17] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:46:17] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:46:17] (viewOnlineReports) p_Alert= [02 Sep 2020 09:46:17] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:46:17] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '1', '001000000000085025', 'M0100000631202_M01HEM20011861_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:46:17] (viewOnlineReports) database connection response [02 Sep 2020 09:46:17] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 09:46:17] (viewOnlineReports) database connection response [02 Sep 2020 09:46:17] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:46:17] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:17] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:17] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:17] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021976M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:17] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021976M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:17] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Sep 2020 09:46:17] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376337/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021976M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:27] (viewOnlineReports) database connection response [02 Sep 2020 09:46:27] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:46:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:46:27] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:46:27] (viewOnlineReports) p_Alert= [02 Sep 2020 09:46:27] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:46:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '1', '001000000000085025', 'M0100000631202_M01HEM20011861_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:46:27] (viewOnlineReports) database connection response [02 Sep 2020 09:46:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 09:46:27] (viewOnlineReports) database connection response [02 Sep 2020 09:46:27] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:46:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599021987M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599021987M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Sep 2020 09:46:27] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200376337/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599021987M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:34] (viewOnlineReports) database connection response [02 Sep 2020 09:46:34] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:46:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:46:34] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:46:34] (viewOnlineReports) p_Alert= [02 Sep 2020 09:46:34] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:46:34] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '1', '001000000000085025', 'M0100000631202_M01HEM20011861_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:46:34] (viewOnlineReports) database connection response [02 Sep 2020 09:46:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 09:46:34] (viewOnlineReports) database connection response [02 Sep 2020 09:46:34] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:46:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021994M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021994M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 09:46:34] (viewOnlineReports) Converting PDF to JPG with name as M0100000631202_M01HEM20011861_1.jpg [02 Sep 2020 09:46:34] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021994M0100000631202_M01HEM20011861_1.PDF ../../TEMP_PDF/200376337/M0100000631202_M01HEM20011861_1.jpg [02 Sep 2020 09:46:34] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599021994M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:45] (viewOnlineReports) database connection response [02 Sep 2020 09:46:45] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:46:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:46:45] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:46:45] (viewOnlineReports) p_Alert= [02 Sep 2020 09:46:45] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:46:45] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '1', '001000000000085025', 'M0100000631202_M01HEM20011861_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:46:45] (viewOnlineReports) database connection response [02 Sep 2020 09:46:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 09:46:45] (viewOnlineReports) database connection response [02 Sep 2020 09:46:45] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:46:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022005M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022005M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:46:45] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022005M0100000631202_M01HEM20011861_1.PDF [02 Sep 2020 09:46:49] (viewOnlineReports) database connection response [02 Sep 2020 09:46:49] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:46:49] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '2', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:46:49] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:46:49] (viewOnlineReports) p_Alert= [02 Sep 2020 09:46:49] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:46:49] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '2', '001000000000081028', 'M0100000631202_M01RCH20016048_2.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:46:49] (viewOnlineReports) database connection response [02 Sep 2020 09:46:49] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [02 Sep 2020 09:46:49] (viewOnlineReports) database connection response [02 Sep 2020 09:46:49] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:46:49] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:49] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:46:49] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:46:49] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1599022009M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:46:49] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1599022009M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:46:49] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:46:49] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1599022009M0100000631202_M01RCH20016048_2.PDF [02 Sep 2020 09:47:04] (viewOnlineReports) database connection response [02 Sep 2020 09:47:04] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:04] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '3', '001000000000080003', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:04] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:04] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:04] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:04] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '3', '001000000000080003', 'M0100000631202_M01RCH20016048_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:04] (viewOnlineReports) database connection response [02 Sep 2020 09:47:04] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [02 Sep 2020 09:47:04] (viewOnlineReports) database connection response [02 Sep 2020 09:47:04] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:04] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:04] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:04] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:47:04] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022024M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:47:04] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022024M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:47:04] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:04] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022024M0100000631202_M01RCH20016048_1.PDF [02 Sep 2020 09:47:07] (viewOnlineReports) database connection response [02 Sep 2020 09:47:07] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:07] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '4', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:07] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:07] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:07] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:07] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '4', '001000000000084460', 'M0100000631202_M01RCH20016048_7.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:07] (viewOnlineReports) database connection response [02 Sep 2020 09:47:07] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [02 Sep 2020 09:47:07] (viewOnlineReports) database connection response [02 Sep 2020 09:47:07] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:07] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:07] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:07] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:47:07] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022027M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:47:07] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022027M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:47:07] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:07] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022027M0100000631202_M01RCH20016048_7.PDF [02 Sep 2020 09:47:09] (viewOnlineReports) database connection response [02 Sep 2020 09:47:09] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '5', '001000000000082560', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:10] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:10] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:10] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:10] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '5', '001000000000082560', 'M0100000631202_M01RCH20016048_5.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:10] (viewOnlineReports) database connection response [02 Sep 2020 09:47:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [02 Sep 2020 09:47:10] (viewOnlineReports) database connection response [02 Sep 2020 09:47:10] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:47:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599022029M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:47:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599022029M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:47:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:10] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSUVWXYZ1599022029M0100000631202_M01RCH20016048_5.PDF [02 Sep 2020 09:47:12] (viewOnlineReports) database connection response [02 Sep 2020 09:47:12] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:12] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '6', '001000000000084100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:12] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:12] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:12] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:12] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '6', '001000000000084100', 'M0100000631202_M01RCH20016048_6.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:12] (viewOnlineReports) database connection response [02 Sep 2020 09:47:12] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [02 Sep 2020 09:47:12] (viewOnlineReports) database connection response [02 Sep 2020 09:47:12] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:12] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:12] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:12] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:47:12] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1599022032M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:47:12] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1599022032M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:47:12] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:12] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1599022032M0100000631202_M01RCH20016048_6.PDF [02 Sep 2020 09:47:15] (viewOnlineReports) database connection response [02 Sep 2020 09:47:15] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '7', '001000000000082040', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:15] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:15] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:15] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:15] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '7', '001000000000082040', 'M0100000631202_M01RCH20016048_3.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:15] (viewOnlineReports) database connection response [02 Sep 2020 09:47:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [02 Sep 2020 09:47:15] (viewOnlineReports) database connection response [02 Sep 2020 09:47:15] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:47:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022035M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:47:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022035M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:47:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:15] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599022035M0100000631202_M01RCH20016048_3.PDF [02 Sep 2020 09:47:18] (viewOnlineReports) database connection response [02 Sep 2020 09:47:18] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '8', '001000000000083970', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:18] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:18] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:18] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '8', '001000000000083970', 'M0100000631202_M01SCH20008873_2.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:18] (viewOnlineReports) database connection response [02 Sep 2020 09:47:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [02 Sep 2020 09:47:18] (viewOnlineReports) database connection response [02 Sep 2020 09:47:18] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:47:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599022038M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:47:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599022038M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:47:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:18] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABDEFGHIJKLMNOPQRSTUVWXYZ1599022038M0100000631202_M01SCH20008873_2.PDF [02 Sep 2020 09:47:21] (viewOnlineReports) database connection response [02 Sep 2020 09:47:21] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '9', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:21] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:21] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:21] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:21] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '9', '001000000000087100', 'M0100000631202_M01MIC20006368_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:21] (viewOnlineReports) database connection response [02 Sep 2020 09:47:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [02 Sep 2020 09:47:21] (viewOnlineReports) database connection response [02 Sep 2020 09:47:21] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:47:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599022041M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:47:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599022041M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:47:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:21] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599022041M0100000631202_M01MIC20006368_1.PDF [02 Sep 2020 09:47:24] (viewOnlineReports) database connection response [02 Sep 2020 09:47:24] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '10', '001000000000082374', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:24] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:24] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:24] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:24] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '10', '001000000000082374', 'M0100000631202_M01RCH20016048_4.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:24] (viewOnlineReports) database connection response [02 Sep 2020 09:47:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '10' [02 Sep 2020 09:47:24] (viewOnlineReports) database connection response [02 Sep 2020 09:47:24] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:47:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599022044M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:47:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599022044M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:47:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:24] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599022044M0100000631202_M01RCH20016048_4.PDF [02 Sep 2020 09:47:27] (viewOnlineReports) database connection response [02 Sep 2020 09:47:27] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 09:47:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631202', '001', '200376337', '12', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 09:47:27] (viewOnlineReports) p_Stop=N [02 Sep 2020 09:47:27] (viewOnlineReports) p_Alert= [02 Sep 2020 09:47:27] (viewOnlineReports) Flag = 1 [02 Sep 2020 09:47:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200376337', 'M01', '047', '12', '001000000000082306', 'M0100000631202_M01SCH20008873_1.PDF', 'M0100000631202', SYSDATE) [02 Sep 2020 09:47:27] (viewOnlineReports) database connection response [02 Sep 2020 09:47:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200376337' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '12' [02 Sep 2020 09:47:27] (viewOnlineReports) database connection response [02 Sep 2020 09:47:27] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 09:47:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200376337/ [02 Sep 2020 09:47:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:47:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599022047M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:47:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599022047M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 09:47:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 09:47:27] (viewOnlineReports) Downloading file ../../TEMP_PDF/200376337/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1599022047M0100000631202_M01SCH20008873_1.PDF [02 Sep 2020 10:06:21] (index) database connection response [02 Sep 2020 10:06:21] (index) getConnection(): Resource id #1 [02 Sep 2020 10:06:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 10:06:21] (index) database connection response [02 Sep 2020 10:06:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 10:06:21] (index) database connection response [02 Sep 2020 10:06:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '79' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 10:06:21] (index) database connection response [02 Sep 2020 10:06:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '00000056918' AND ACCESS_CODE = 'arbYKEvrFOmxqCvr' [02 Sep 2020 10:06:21] (index) database connection response [02 Sep 2020 10:06:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '00000056918' AND ACCESS_CODE = 'arbYKEvrFOmxqCvr' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 10:06:21] (index) database connection response [02 Sep 2020 10:06:21] (index) getConnectionClose() called.... [02 Sep 2020 10:45:31] (index) database connection response [02 Sep 2020 10:45:31] (index) getConnection(): Resource id #1 [02 Sep 2020 10:45:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 10:45:31] (index) database connection response [02 Sep 2020 10:45:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 10:45:31] (index) database connection response [02 Sep 2020 10:45:31] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 10:45:31] (index) database connection response [02 Sep 2020 10:45:31] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200356996' AND ACCESS_CODE = '20140623' [02 Sep 2020 10:45:32] (index) database connection response [02 Sep 2020 10:45:32] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200356996' AND ACCESS_CODE = '20140623' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 10:45:32] (index) database connection response [02 Sep 2020 10:45:32] (index) getConnectionClose() called.... [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getConnection(): Resource id #1 [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200356996' AND ACCESS_CODE = '20140823' [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200356996' AND ACCESS_CODE = '20140823' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631609' [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getPatientReportsDetail() entered [02 Sep 2020 10:46:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200356996', 'M0100000631609', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:46:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200356996', 'M0100000631609', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:46:42] (index) p_Stop=N [02 Sep 2020 10:46:42] (index) p_Alert= [02 Sep 2020 10:46:42] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 10:46:42] (index) database connection response [02 Sep 2020 10:46:42] (index) getConnectionClose() called.... [02 Sep 2020 10:46:42] (index) getConnectionClose() called.... [02 Sep 2020 10:46:59] (viewOnlineReports) database connection response [02 Sep 2020 10:46:59] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 10:46:59] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378327', '1', '001000000000084999', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:46:59] (viewOnlineReports) p_Stop=N [02 Sep 2020 10:46:59] (viewOnlineReports) p_Alert= [02 Sep 2020 10:46:59] (viewOnlineReports) Flag = 1 [02 Sep 2020 10:46:59] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378327', 'M01', '047', '1', '001000000000084999', 'M0100000631609_M01SCH20008859_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 10:46:59] (viewOnlineReports) database connection response [02 Sep 2020 10:46:59] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378327' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 10:46:59] (viewOnlineReports) database connection response [02 Sep 2020 10:46:59] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 10:46:59] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378327/ [02 Sep 2020 10:46:59] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378327/ [02 Sep 2020 10:46:59] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:46:59] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378327/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599025619M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:46:59] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378327/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599025619M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:46:59] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 10:46:59] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:46:59] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378327/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599025619M0100000631609_M01SCH20008859_1.PDF ../../TEMP_PDF/200378327/M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:46:59] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378327/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599025619M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:16] (viewOnlineReports) database connection response [02 Sep 2020 10:47:16] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 10:47:16] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378327', '1', '001000000000084999', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:47:16] (viewOnlineReports) p_Stop=N [02 Sep 2020 10:47:16] (viewOnlineReports) p_Alert= [02 Sep 2020 10:47:16] (viewOnlineReports) Flag = 1 [02 Sep 2020 10:47:16] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378327', 'M01', '047', '1', '001000000000084999', 'M0100000631609_M01SCH20008859_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 10:47:16] (viewOnlineReports) database connection response [02 Sep 2020 10:47:16] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378327' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 10:47:16] (viewOnlineReports) database connection response [02 Sep 2020 10:47:16] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 10:47:16] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378327/ [02 Sep 2020 10:47:16] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378327/ [02 Sep 2020 10:47:16] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:16] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378327/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599025636M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:16] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378327/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599025636M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:16] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 10:47:16] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:47:16] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378327/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599025636M0100000631609_M01SCH20008859_1.PDF ../../TEMP_PDF/200378327/M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:47:16] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378327/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599025636M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:24] (viewOnlineReports) database connection response [02 Sep 2020 10:47:24] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 10:47:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378327', '1', '001000000000084999', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:47:24] (viewOnlineReports) p_Stop=N [02 Sep 2020 10:47:24] (viewOnlineReports) p_Alert= [02 Sep 2020 10:47:24] (viewOnlineReports) Flag = 1 [02 Sep 2020 10:47:24] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378327', 'M01', '047', '1', '001000000000084999', 'M0100000631609_M01SCH20008859_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 10:47:24] (viewOnlineReports) database connection response [02 Sep 2020 10:47:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378327' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 10:47:24] (viewOnlineReports) database connection response [02 Sep 2020 10:47:24] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 10:47:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378327/ [02 Sep 2020 10:47:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378327/ [02 Sep 2020 10:47:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599025644M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599025644M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Sep 2020 10:47:24] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599025644M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:35] (viewOnlineReports) database connection response [02 Sep 2020 10:47:35] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 10:47:35] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378327', '1', '001000000000084999', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:47:35] (viewOnlineReports) p_Stop=N [02 Sep 2020 10:47:35] (viewOnlineReports) p_Alert= [02 Sep 2020 10:47:35] (viewOnlineReports) Flag = 1 [02 Sep 2020 10:47:35] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378327', 'M01', '047', '1', '001000000000084999', 'M0100000631609_M01SCH20008859_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 10:47:35] (viewOnlineReports) database connection response [02 Sep 2020 10:47:35] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378327' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 10:47:35] (viewOnlineReports) database connection response [02 Sep 2020 10:47:35] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 10:47:35] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378327/ [02 Sep 2020 10:47:35] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378327/ [02 Sep 2020 10:47:35] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:35] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599025655M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:35] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599025655M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:47:35] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 10:47:35] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:47:35] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599025655M0100000631609_M01SCH20008859_1.PDF ../../TEMP_PDF/200378327/M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:47:35] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378327/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1599025655M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:54:18] (viewOnlineReports) database connection response [02 Sep 2020 10:54:18] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 10:54:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378327', '1', '001000000000084999', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:54:18] (viewOnlineReports) p_Stop=N [02 Sep 2020 10:54:18] (viewOnlineReports) p_Alert= [02 Sep 2020 10:54:18] (viewOnlineReports) Flag = 1 [02 Sep 2020 10:54:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378327', 'M01', '047', '1', '001000000000084999', 'M0100000631609_M01SCH20008859_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 10:54:18] (viewOnlineReports) database connection response [02 Sep 2020 10:54:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378327' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 10:54:18] (viewOnlineReports) database connection response [02 Sep 2020 10:54:18] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 10:54:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378327/ [02 Sep 2020 10:54:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378327/ [02 Sep 2020 10:54:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:54:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378327/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599026058M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:54:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378327/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599026058M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:54:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 10:54:18] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:54:18] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378327/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599026058M0100000631609_M01SCH20008859_1.PDF ../../TEMP_PDF/200378327/M0100000631609_M01SCH20008859_1.jpg [02 Sep 2020 10:54:19] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378327/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599026058M0100000631609_M01SCH20008859_1.PDF [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getConnection(): Resource id #1 [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200352700' AND ACCESS_CODE = '83359130' [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200352700' AND ACCESS_CODE = '83359130' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000525533' [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getPatientReportsDetail() entered [02 Sep 2020 10:56:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200352700', 'M0100000525533', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:56:34] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200352700', 'M0100000525533', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 10:56:34] (index) p_Stop=N [02 Sep 2020 10:56:34] (index) p_Alert= [02 Sep 2020 10:56:34] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 10:56:34] (index) database connection response [02 Sep 2020 10:56:34] (index) getConnectionClose() called.... [02 Sep 2020 10:56:34] (index) getConnectionClose() called.... [02 Sep 2020 11:30:14] (index) database connection response [02 Sep 2020 11:30:14] (index) getConnection(): Resource id #1 [02 Sep 2020 11:30:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 11:30:14] (index) database connection response [02 Sep 2020 11:30:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 11:30:14] (index) database connection response [02 Sep 2020 11:30:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 11:30:14] (index) database connection response [02 Sep 2020 11:30:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' [02 Sep 2020 11:30:14] (index) database connection response [02 Sep 2020 11:30:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 11:30:15] (index) database connection response [02 Sep 2020 11:30:15] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593995' [02 Sep 2020 11:30:15] (index) database connection response [02 Sep 2020 11:30:15] (index) getPatientReportsDetail() entered [02 Sep 2020 11:30:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:30:15] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:30:15] (index) p_Stop=N [02 Sep 2020 11:30:15] (index) p_Alert= [02 Sep 2020 11:30:15] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 11:30:15] (index) database connection response [02 Sep 2020 11:30:15] (index) getConnectionClose() called.... [02 Sep 2020 11:30:15] (index) getConnectionClose() called.... [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getConnection(): Resource id #1 [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200356949' AND ACCESS_CODE = '81403785' [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200356949' AND ACCESS_CODE = '81403785' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000631609' [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getPatientReportsDetail() entered [02 Sep 2020 11:32:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200356949', 'M0100000631609', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:32:37] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200356949', 'M0100000631609', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:32:37] (index) p_Stop=N [02 Sep 2020 11:32:37] (index) p_Alert= [02 Sep 2020 11:32:37] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 11:32:37] (index) database connection response [02 Sep 2020 11:32:37] (index) getConnectionClose() called.... [02 Sep 2020 11:32:37] (index) getConnectionClose() called.... [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getConnection(): Resource id #1 [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200342471' AND ACCESS_CODE = '27532338' [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200342471' AND ACCESS_CODE = '27532338' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000510212' [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getPatientReportsDetail() entered [02 Sep 2020 11:32:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200342471', 'M0100000510212', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:32:45] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200342471', 'M0100000510212', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:32:45] (index) p_Stop=N [02 Sep 2020 11:32:45] (index) p_Alert= [02 Sep 2020 11:32:45] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 11:32:45] (index) database connection response [02 Sep 2020 11:32:45] (index) getConnectionClose() called.... [02 Sep 2020 11:32:45] (index) getConnectionClose() called.... [02 Sep 2020 11:32:46] (viewOnlineReports) database connection response [02 Sep 2020 11:32:46] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:32:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '2', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:32:46] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:32:46] (viewOnlineReports) p_Alert= [02 Sep 2020 11:32:46] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:32:46] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '2', '001000000000085025', 'M0100000631609_M01HEM20011837_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:32:47] (viewOnlineReports) database connection response [02 Sep 2020 11:32:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [02 Sep 2020 11:32:47] (viewOnlineReports) database connection response [02 Sep 2020 11:32:47] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:32:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:32:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:32:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01HEM20011837_1.PDF [02 Sep 2020 11:32:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599028366M0100000631609_M01HEM20011837_1.PDF [02 Sep 2020 11:32:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599028366M0100000631609_M01HEM20011837_1.PDF [02 Sep 2020 11:32:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:32:47] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01HEM20011837_1.jpg [02 Sep 2020 11:32:47] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599028366M0100000631609_M01HEM20011837_1.PDF ../../TEMP_PDF/200378302/M0100000631609_M01HEM20011837_1.jpg [02 Sep 2020 11:32:47] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1599028366M0100000631609_M01HEM20011837_1.PDF [02 Sep 2020 11:36:24] (viewOnlineReports) database connection response [02 Sep 2020 11:36:24] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:36:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '3', '001000000000084949', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:36:24] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:36:24] (viewOnlineReports) p_Alert= [02 Sep 2020 11:36:24] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:36:24] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '3', '001000000000084949', 'M0100000631609_M01RCH20016019_2.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:36:24] (viewOnlineReports) database connection response [02 Sep 2020 11:36:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [02 Sep 2020 11:36:24] (viewOnlineReports) database connection response [02 Sep 2020 11:36:24] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:36:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:36:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:36:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01RCH20016019_2.PDF [02 Sep 2020 11:36:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028584M0100000631609_M01RCH20016019_2.PDF [02 Sep 2020 11:36:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028584M0100000631609_M01RCH20016019_2.PDF [02 Sep 2020 11:36:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:36:24] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01RCH20016019_2.jpg [02 Sep 2020 11:36:24] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028584M0100000631609_M01RCH20016019_2.PDF ../../TEMP_PDF/200378302/M0100000631609_M01RCH20016019_2.jpg [02 Sep 2020 11:36:24] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028584M0100000631609_M01RCH20016019_2.PDF [02 Sep 2020 11:37:25] (viewOnlineReports) database connection response [02 Sep 2020 11:37:25] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:37:25] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '4', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:37:25] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:37:25] (viewOnlineReports) p_Alert= [02 Sep 2020 11:37:25] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:37:25] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '4', '001000000000081028', 'M0100000631609_M01RCH20016019_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:37:25] (viewOnlineReports) database connection response [02 Sep 2020 11:37:25] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [02 Sep 2020 11:37:25] (viewOnlineReports) database connection response [02 Sep 2020 11:37:25] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:37:25] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:37:25] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:37:25] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:37:25] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028645M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:37:25] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028645M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:37:25] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:37:25] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01RCH20016019_1.jpg [02 Sep 2020 11:37:25] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028645M0100000631609_M01RCH20016019_1.PDF ../../TEMP_PDF/200378302/M0100000631609_M01RCH20016019_1.jpg [02 Sep 2020 11:37:25] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/012345789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028645M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:38:06] (viewOnlineReports) database connection response [02 Sep 2020 11:38:06] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:38:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '5', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:38:06] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:38:06] (viewOnlineReports) p_Alert= [02 Sep 2020 11:38:06] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:38:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '5', '001000000000086287', 'M0100000631609_M01SCH20008858_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:38:06] (viewOnlineReports) database connection response [02 Sep 2020 11:38:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [02 Sep 2020 11:38:06] (viewOnlineReports) database connection response [02 Sep 2020 11:38:06] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:38:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:38:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:38:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:38:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599028686M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:38:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599028686M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:38:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:38:06] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008858_1.jpg [02 Sep 2020 11:38:06] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599028686M0100000631609_M01SCH20008858_1.PDF ../../TEMP_PDF/200378302/M0100000631609_M01SCH20008858_1.jpg [02 Sep 2020 11:38:06] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1599028686M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:39:36] (viewOnlineReports) database connection response [02 Sep 2020 11:39:36] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:39:36] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '4', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:39:36] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:39:36] (viewOnlineReports) p_Alert= [02 Sep 2020 11:39:36] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:39:36] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '4', '001000000000081028', 'M0100000631609_M01RCH20016019_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:39:36] (viewOnlineReports) database connection response [02 Sep 2020 11:39:36] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [02 Sep 2020 11:39:36] (viewOnlineReports) database connection response [02 Sep 2020 11:39:36] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:39:36] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:39:36] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:39:36] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:39:36] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028776M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:39:36] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028776M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:39:36] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:39:36] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01RCH20016019_1.jpg [02 Sep 2020 11:39:36] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028776M0100000631609_M01RCH20016019_1.PDF ../../TEMP_PDF/200378302/M0100000631609_M01RCH20016019_1.jpg [02 Sep 2020 11:39:36] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599028776M0100000631609_M01RCH20016019_1.PDF [02 Sep 2020 11:40:18] (viewOnlineReports) database connection response [02 Sep 2020 11:40:18] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:40:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '5', '001000000000086287', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:40:18] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:40:18] (viewOnlineReports) p_Alert= [02 Sep 2020 11:40:18] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:40:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '5', '001000000000086287', 'M0100000631609_M01SCH20008858_1.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:40:18] (viewOnlineReports) database connection response [02 Sep 2020 11:40:18] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [02 Sep 2020 11:40:18] (viewOnlineReports) database connection response [02 Sep 2020 11:40:18] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:40:18] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:40:18] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:40:18] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:40:18] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599028818M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:40:18] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599028818M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:40:18] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:40:18] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008858_1.jpg [02 Sep 2020 11:40:18] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599028818M0100000631609_M01SCH20008858_1.PDF ../../TEMP_PDF/200378302/M0100000631609_M01SCH20008858_1.jpg [02 Sep 2020 11:40:18] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1599028818M0100000631609_M01SCH20008858_1.PDF [02 Sep 2020 11:40:44] (viewOnlineReports) database connection response [02 Sep 2020 11:40:44] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 11:40:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000631609', '001', '200378302', '6', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:40:44] (viewOnlineReports) p_Stop=N [02 Sep 2020 11:40:44] (viewOnlineReports) p_Alert= [02 Sep 2020 11:40:44] (viewOnlineReports) Flag = 1 [02 Sep 2020 11:40:44] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378302', 'M01', '047', '6', '001000000000086302', 'M0100000631609_M01SCH20008858_2.PDF', 'M0100000631609', SYSDATE) [02 Sep 2020 11:40:44] (viewOnlineReports) database connection response [02 Sep 2020 11:40:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378302' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [02 Sep 2020 11:40:44] (viewOnlineReports) database connection response [02 Sep 2020 11:40:44] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 11:40:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378302/ [02 Sep 2020 11:40:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378302/ [02 Sep 2020 11:40:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000631609_M01SCH20008858_2.PDF [02 Sep 2020 11:40:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378302/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599028844M0100000631609_M01SCH20008858_2.PDF [02 Sep 2020 11:40:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378302/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599028844M0100000631609_M01SCH20008858_2.PDF [02 Sep 2020 11:40:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 11:40:44] (viewOnlineReports) Converting PDF to JPG with name as M0100000631609_M01SCH20008858_2.jpg [02 Sep 2020 11:40:44] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378302/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599028844M0100000631609_M01SCH20008858_2.PDF ../../TEMP_PDF/200378302/M0100000631609_M01SCH20008858_2.jpg [02 Sep 2020 11:40:44] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378302/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1599028844M0100000631609_M01SCH20008858_2.PDF [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getConnection(): Resource id #1 [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200349939' AND ACCESS_CODE = '73170536' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000593995' [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getPatientReportsDetail() entered [02 Sep 2020 11:49:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:49:56] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200349939', 'M0100000593995', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 11:49:56] (index) p_Stop=N [02 Sep 2020 11:49:56] (index) p_Alert= [02 Sep 2020 11:49:56] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 11:49:56] (index) database connection response [02 Sep 2020 11:49:56] (index) getConnectionClose() called.... [02 Sep 2020 11:49:56] (index) getConnectionClose() called.... [02 Sep 2020 13:36:01] (index) database connection response [02 Sep 2020 13:36:01] (index) getConnection(): Resource id #1 [02 Sep 2020 13:36:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 13:36:01] (index) database connection response [02 Sep 2020 13:36:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 13:36:01] (index) database connection response [02 Sep 2020 13:36:01] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 13:36:01] (index) database connection response [02 Sep 2020 13:36:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '2008001889' AND ACCESS_CODE = '5232' [02 Sep 2020 13:36:01] (index) database connection response [02 Sep 2020 13:36:01] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = '2008001889' AND ACCESS_CODE = '5232' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 13:36:01] (index) database connection response [02 Sep 2020 13:36:01] (index) getConnectionClose() called.... [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getConnection(): Resource id #1 [02 Sep 2020 14:16:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200352700' AND ACCESS_CODE = '83359130' [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200352700' AND ACCESS_CODE = '83359130' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000525533' [02 Sep 2020 14:16:06] (index) database connection response [02 Sep 2020 14:16:06] (index) getPatientReportsDetail() entered [02 Sep 2020 14:16:06] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200352700', 'M0100000525533', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 14:16:07] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200352700', 'M0100000525533', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 14:16:07] (index) p_Stop=N [02 Sep 2020 14:16:07] (index) p_Alert= [02 Sep 2020 14:16:07] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 14:16:07] (index) database connection response [02 Sep 2020 14:16:07] (index) getConnectionClose() called.... [02 Sep 2020 14:16:07] (index) getConnectionClose() called.... [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getConnection(): Resource id #1 [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200359328' AND ACCESS_CODE = '59704474' [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200359328' AND ACCESS_CODE = '59704474' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000503727' [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getPatientReportsDetail() entered [02 Sep 2020 15:39:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200359328', 'M0100000503727', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 15:39:14] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200359328', 'M0100000503727', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 15:39:14] (index) p_Stop=N [02 Sep 2020 15:39:14] (index) p_Alert= [02 Sep 2020 15:39:14] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 15:39:14] (index) database connection response [02 Sep 2020 15:39:14] (index) getConnectionClose() called.... [02 Sep 2020 15:39:14] (index) getConnectionClose() called.... [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getConnection(): Resource id #1 [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200359328' AND ACCESS_CODE = '59704474' [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200359328' AND ACCESS_CODE = '59704474' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000503727' [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getPatientReportsDetail() entered [02 Sep 2020 16:22:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200359328', 'M0100000503727', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 16:22:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200359328', 'M0100000503727', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 16:22:04] (index) p_Stop=N [02 Sep 2020 16:22:04] (index) p_Alert= [02 Sep 2020 16:22:04] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 16:22:04] (index) database connection response [02 Sep 2020 16:22:04] (index) getConnectionClose() called.... [02 Sep 2020 16:22:04] (index) getConnectionClose() called.... [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getConnection(): Resource id #1 [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200359328' AND ACCESS_CODE = '59704474' [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200359328' AND ACCESS_CODE = '59704474' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000503727' [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getPatientReportsDetail() entered [02 Sep 2020 17:11:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200359328', 'M0100000503727', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:11:46] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200359328', 'M0100000503727', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:11:46] (index) p_Stop=N [02 Sep 2020 17:11:46] (index) p_Alert= [02 Sep 2020 17:11:46] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 17:11:46] (index) database connection response [02 Sep 2020 17:11:46] (index) getConnectionClose() called.... [02 Sep 2020 17:11:46] (index) getConnectionClose() called.... [02 Sep 2020 17:11:52] (viewOnlineReports) database connection response [02 Sep 2020 17:11:52] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:11:52] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000503727', '001', '200378971', '1', '001000000000085018', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:11:52] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:11:52] (viewOnlineReports) p_Alert= [02 Sep 2020 17:11:52] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:11:52] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378971', 'M01', '047', '1', '001000000000085018', 'M0100000503727_M01HEM20011910_1.PDF', 'M0100000503727', SYSDATE) [02 Sep 2020 17:11:52] (viewOnlineReports) database connection response [02 Sep 2020 17:11:52] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378971' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:11:52] (viewOnlineReports) database connection response [02 Sep 2020 17:11:52] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:11:52] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378971/ [02 Sep 2020 17:11:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378971/ [02 Sep 2020 17:11:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200902\M01\M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:11:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378971/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599048712M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:11:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378971/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599048712M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:11:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Sep 2020 17:11:53] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200378971/0123456789ABCDEFGHIJKLMNOPQRTUVWXYZ1599048712M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:03] (viewOnlineReports) database connection response [02 Sep 2020 17:12:03] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:12:03] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000503727', '001', '200378971', '1', '001000000000085018', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:12:03] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:12:03] (viewOnlineReports) p_Alert= [02 Sep 2020 17:12:03] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:12:03] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378971', 'M01', '047', '1', '001000000000085018', 'M0100000503727_M01HEM20011910_1.PDF', 'M0100000503727', SYSDATE) [02 Sep 2020 17:12:03] (viewOnlineReports) database connection response [02 Sep 2020 17:12:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378971' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:12:03] (viewOnlineReports) database connection response [02 Sep 2020 17:12:03] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:12:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378971/ [02 Sep 2020 17:12:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378971/ [02 Sep 2020 17:12:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200902\M01\M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378971/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599048722M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378971/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599048722M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Sep 2020 17:12:03] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200378971/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1599048722M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:22] (viewOnlineReports) database connection response [02 Sep 2020 17:12:22] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:12:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000503727', '001', '200378971', '1', '001000000000085018', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:12:22] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:12:22] (viewOnlineReports) p_Alert= [02 Sep 2020 17:12:22] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:12:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378971', 'M01', '047', '1', '001000000000085018', 'M0100000503727_M01HEM20011910_1.PDF', 'M0100000503727', SYSDATE) [02 Sep 2020 17:12:22] (viewOnlineReports) database connection response [02 Sep 2020 17:12:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378971' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:12:22] (viewOnlineReports) database connection response [02 Sep 2020 17:12:22] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:12:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378971/ [02 Sep 2020 17:12:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378971/ [02 Sep 2020 17:12:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200902\M01\M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378971/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599048742M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378971/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599048742M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:12:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 17:12:22] (viewOnlineReports) Converting PDF to JPG with name as M0100000503727_M01HEM20011910_1.jpg [02 Sep 2020 17:12:22] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200378971/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599048742M0100000503727_M01HEM20011910_1.PDF ../../TEMP_PDF/200378971/M0100000503727_M01HEM20011910_1.jpg [02 Sep 2020 17:12:22] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200378971/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1599048742M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:13:13] (viewOnlineReports) database connection response [02 Sep 2020 17:13:13] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:13:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000503727', '001', '200378971', '1', '001000000000085018', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:13:13] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:13:13] (viewOnlineReports) p_Alert= [02 Sep 2020 17:13:13] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:13:13] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200378971', 'M01', '047', '1', '001000000000085018', 'M0100000503727_M01HEM20011910_1.PDF', 'M0100000503727', SYSDATE) [02 Sep 2020 17:13:13] (viewOnlineReports) database connection response [02 Sep 2020 17:13:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200378971' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:13:13] (viewOnlineReports) database connection response [02 Sep 2020 17:13:13] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:13:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200378971/ [02 Sep 2020 17:13:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200378971/ [02 Sep 2020 17:13:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200902\M01\M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:13:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200378971/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599048793M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:13:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200378971/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599048793M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:13:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 17:13:13] (viewOnlineReports) Downloading file ../../TEMP_PDF/200378971/0123456789ABCDEFGHIKLMNOPQRSTUVWXYZ1599048793M0100000503727_M01HEM20011910_1.PDF [02 Sep 2020 17:37:57] (viewOnlineReports) database connection response [02 Sep 2020 17:37:57] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:37:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '001', '00100000000000', '001', '200377842', '1', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:37:57] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:37:57] (viewOnlineReports) p_Alert= [02 Sep 2020 17:37:57] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:37:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200377842', 'M01', '001', '1', '001000000000087100', 'M0100000618514_M01MIC20006349_2.PDF', '00100000000000', SYSDATE) [02 Sep 2020 17:37:57] (viewOnlineReports) database connection response [02 Sep 2020 17:37:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200377842' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '001' AND TRANSACTION_NO = '1' [02 Sep 2020 17:37:57] (viewOnlineReports) database connection response [02 Sep 2020 17:37:57] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:37:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200377842/ [02 Sep 2020 17:37:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200377842/ [02 Sep 2020 17:37:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200901\M01\M0100000618514_M01MIC20006349_2.PDF [02 Sep 2020 17:37:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200377842/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZM0100000618514_M01MIC20006349_2.PDF [02 Sep 2020 17:37:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200377842/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZM0100000618514_M01MIC20006349_2.PDF [02 Sep 2020 17:37:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Sep 2020 17:37:57] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200377842/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZM0100000618514_M01MIC20006349_2.PDF [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getConnection(): Resource id #1 [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '13' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200355359' AND ACCESS_CODE = '05976755' [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200355359' AND ACCESS_CODE = '05976755' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000618514' [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getPatientReportsDetail() entered [02 Sep 2020 17:38:26] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200355359', 'M0100000618514', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:38:26] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200355359', 'M0100000618514', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:38:26] (index) p_Stop=N [02 Sep 2020 17:38:26] (index) p_Alert= [02 Sep 2020 17:38:26] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 17:38:26] (index) database connection response [02 Sep 2020 17:38:26] (index) getConnectionClose() called.... [02 Sep 2020 17:38:26] (index) getConnectionClose() called.... [02 Sep 2020 17:56:58] (index) database connection response [02 Sep 2020 17:56:58] (index) getConnection(): Resource id #1 [02 Sep 2020 17:56:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 17:56:58] (index) database connection response [02 Sep 2020 17:56:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 17:56:58] (index) database connection response [02 Sep 2020 17:56:58] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 17:56:58] (index) database connection response [02 Sep 2020 17:56:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M0120032397' AND ACCESS_CODE = '22481888' [02 Sep 2020 17:56:58] (index) database connection response [02 Sep 2020 17:56:58] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M0120032397' AND ACCESS_CODE = '22481888' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 17:56:59] (index) database connection response [02 Sep 2020 17:56:59] (index) getConnectionClose() called.... [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getConnection(): Resource id #1 [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '85' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200323497' AND ACCESS_CODE = '22481888' [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200323497' AND ACCESS_CODE = '22481888' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000629773' [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getPatientReportsDetail() entered [02 Sep 2020 17:58:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200323497', 'M0100000629773', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:58:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200323497', 'M0100000629773', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:58:00] (index) p_Stop=N [02 Sep 2020 17:58:00] (index) p_Alert= [02 Sep 2020 17:58:00] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 17:58:00] (index) database connection response [02 Sep 2020 17:58:00] (index) getConnectionClose() called.... [02 Sep 2020 17:58:00] (index) getConnectionClose() called.... [02 Sep 2020 17:58:21] (viewOnlineReports) database connection response [02 Sep 2020 17:58:21] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:58:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000629773', '001', '200369453', '1', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:58:21] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:58:21] (viewOnlineReports) p_Alert= [02 Sep 2020 17:58:21] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:58:21] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200369453', 'M01', '047', '1', '001000000000084296', 'M0100000629773_M01RCH20014412_1.PDF', 'M0100000629773', SYSDATE) [02 Sep 2020 17:58:21] (viewOnlineReports) database connection response [02 Sep 2020 17:58:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200369453' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:58:21] (viewOnlineReports) database connection response [02 Sep 2020 17:58:21] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:58:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200369453/ [02 Sep 2020 17:58:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200369453/ [02 Sep 2020 17:58:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200810\M01\M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200369453/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051501M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200369453/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051501M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Sep 2020 17:58:21] (viewOnlineReports) Downloading file ../../TEMP_PDF/200369453/012356789ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051501M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:43] (viewOnlineReports) database connection response [02 Sep 2020 17:58:43] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:58:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000629773', '001', '200369453', '1', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:58:43] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:58:43] (viewOnlineReports) p_Alert= [02 Sep 2020 17:58:43] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:58:43] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200369453', 'M01', '047', '1', '001000000000084296', 'M0100000629773_M01RCH20014412_1.PDF', 'M0100000629773', SYSDATE) [02 Sep 2020 17:58:43] (viewOnlineReports) database connection response [02 Sep 2020 17:58:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200369453' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:58:43] (viewOnlineReports) database connection response [02 Sep 2020 17:58:43] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:58:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200369453/ [02 Sep 2020 17:58:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200369453/ [02 Sep 2020 17:58:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200810\M01\M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200369453/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599051523M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200369453/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599051523M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 17:58:43] (viewOnlineReports) Converting PDF to JPG with name as M0100000629773_M01RCH20014412_1.jpg [02 Sep 2020 17:58:43] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200369453/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599051523M0100000629773_M01RCH20014412_1.PDF ../../TEMP_PDF/200369453/M0100000629773_M01RCH20014412_1.jpg [02 Sep 2020 17:58:44] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200369453/0123456789ABCDEFGHIJKLMNOPQRSTUVWXY1599051523M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:54] (viewOnlineReports) database connection response [02 Sep 2020 17:58:54] (viewOnlineReports) getConnection(): Resource id #1 [02 Sep 2020 17:58:54] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000629773', '001', '200369453', '1', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 17:58:54] (viewOnlineReports) p_Stop=N [02 Sep 2020 17:58:54] (viewOnlineReports) p_Alert= [02 Sep 2020 17:58:54] (viewOnlineReports) Flag = 1 [02 Sep 2020 17:58:54] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200369453', 'M01', '047', '1', '001000000000084296', 'M0100000629773_M01RCH20014412_1.PDF', 'M0100000629773', SYSDATE) [02 Sep 2020 17:58:54] (viewOnlineReports) database connection response [02 Sep 2020 17:58:54] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200369453' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Sep 2020 17:58:54] (viewOnlineReports) database connection response [02 Sep 2020 17:58:54] (viewOnlineReports) getConnectionClose() called.... [02 Sep 2020 17:58:54] (viewOnlineReports) creating directory structure../../TEMP_PDF/200369453/ [02 Sep 2020 17:58:54] (viewOnlineReports) directory structure created ../../TEMP_PDF/200369453/ [02 Sep 2020 17:58:54] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200810\M01\M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:54] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200369453/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051534M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:54] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200369453/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051534M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 17:58:54] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Sep 2020 17:58:54] (viewOnlineReports) Converting PDF to JPG with name as M0100000629773_M01RCH20014412_1.jpg [02 Sep 2020 17:58:54] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200369453/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051534M0100000629773_M01RCH20014412_1.PDF ../../TEMP_PDF/200369453/M0100000629773_M01RCH20014412_1.jpg [02 Sep 2020 17:58:54] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200369453/012345678ABCDEFGHIJKLMNOPQRSTUVWXYZ1599051534M0100000629773_M01RCH20014412_1.PDF [02 Sep 2020 23:57:50] (index) database connection response [02 Sep 2020 23:57:50] (index) getConnection(): Resource id #1 [02 Sep 2020 23:57:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'POP-UP' [02 Sep 2020 23:57:50] (index) database connection response [02 Sep 2020 23:57:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Sep 2020 23:57:50] (index) database connection response [02 Sep 2020 23:57:50] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'FIREFOX' AND BROWSER_VERSION = '80' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Sep 2020 23:57:50] (index) database connection response [02 Sep 2020 23:57:50] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' [02 Sep 2020 23:57:51] (index) database connection response [02 Sep 2020 23:57:51] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340809' AND ACCESS_CODE = '50635075' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Sep 2020 23:57:51] (index) database connection response [02 Sep 2020 23:57:51] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000564519' [02 Sep 2020 23:57:51] (index) database connection response [02 Sep 2020 23:57:51] (index) getPatientReportsDetail() entered [02 Sep 2020 23:57:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 23:57:51] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200340809', 'M0100000564519', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Sep 2020 23:57:51] (index) p_Stop=N [02 Sep 2020 23:57:51] (index) p_Alert= [02 Sep 2020 23:57:51] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [02 Sep 2020 23:57:51] (index) database connection response [02 Sep 2020 23:57:51] (index) getConnectionClose() called.... [02 Sep 2020 23:57:51] (index) getConnectionClose() called....