1
แจ้งข้อผิดพลาดการทำงานของ HOSxP V3 / การบันทึกคัดกรอง DM/HT ไม่ประมวลความเสี่ยง
« เมื่อ: พฤศจิกายน 18, 2016, 10:30:02 AM »
บันทึกแล้ว มีข้อมูล แต่ ในหน้ารายการสรุป ไม่มีการประมวลภาวะสุขภาพครับ
แสดงกระทู้
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
หน้า: [1]
2
แจ้งปัญหา / ขอความช่วยเหลือ / Re: พบข้อผิดพลาดของ triger
« เมื่อ: สิงหาคม 26, 2016, 09:48:14 AM »
hosxp_pcu ver 3.59.3.31 Mysql server 5.5.31 mariadb
ครับ น่าจะเป็นมาตั้งแต่เริ่มใช้งาน stock inventory ครับ
ครับ น่าจะเป็นมาตั้งแต่เริ่มใช้งาน stock inventory ครับ
3
แจ้งปัญหา / ขอความช่วยเหลือ / Re: พบข้อผิดพลาดของ triger
« เมื่อ: สิงหาคม 23, 2016, 15:41:58 PM »
ปัญหาคือขนาดของไฟล์ .err โตขึ้นเรื่อย ๆ ครับ เคยมีขนาดถึง 3 GB เลยครับ
4
แจ้งปัญหา / ขอความช่วยเหลือ / พบข้อผิดพลาดของ triger
« เมื่อ: สิงหาคม 23, 2016, 15:27:40 PM »
มีการเรียกใช้งาน ฟังก์ชั่น ของ triger แล้ว error ทำให้ mysqld เขียน error log ไฟล์ ไม่หยุด เขียนทุกครั้งที่เกิด error ทำให้ขนาด error log ไฟล์ โตขี้นไปเรื่อย ๆ โดยข้อความ ที่เขียน มีดังนี้
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:16 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:16 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:16 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:16 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:21 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:21 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:21 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:21 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:26 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:26 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:26 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:26 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' d...
ไม่ทราบว่าจะแก้ไขอย่างไรครับ
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:16 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:16 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:16 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:16 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:21 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:21 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:21 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:21 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:26 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:26 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:26 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:26 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' d...
ไม่ทราบว่าจะแก้ไขอย่างไรครับ
หน้า: [1]