BMS-HOSxP Community
HOSxP => HOSxP PCU => ข้อความที่เริ่มโดย: yut ที่ ธันวาคม 27, 2011, 08:55:58 AM
-
Bug เล็ก ๆ ของระบบ Inventory ตอนดู Stock Card หน้าจอรายงานสินค้าคงเหลือคลังใหญ่และรายการสินค้า(ในข้อมูลพื้นฐาน) อาจารย์ช่วยดูด้วยครับ ;D ;D
Exception:
--------------------------------------------------------------------------------
2.1 Date : Tue, 27 Dec 2011 08:48:26 +0700
2.2 Address : 009D6989
2.3 Module Name : Turbo_HOSxP_PCU.exe
2.4 Module Version: 3.54.12.26
2.5 Type : EZSQLException
2.6 Message : SQL Error: Unknown column 'l.total_price' in 'field list'.
2.7 ID : 59B6
2.8 Count : 1
2.9 Status : New
2.10 Note :
Call Stack Information:
------------------------------------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=1180; Priority=0; Class=; [Main] |
|----------------------------------------------------------------------------------------------------------------------------------|
|009D6989|Turbo_HOSxP_PCU.exe|ZDbcMySqlUtils.pas | |CheckMySQLError |363[7] |
|009D68AC|Turbo_HOSxP_PCU.exe|ZDbcMySqlUtils.pas | |CheckMySQLError |356[0] |
|00A11578|Turbo_HOSxP_PCU.exe|ZDbcMySqlStatement.pas |TZMySQLStatement |ExecuteQuery |187[15] |
|009C7425|Turbo_HOSxP_PCU.exe|ZDbcStatement.pas |TZEmulatedPreparedStatement|ExecuteQuery |1941[1] |
|009C7561|Turbo_HOSxP_PCU.exe|ZDbcStatement.pas |TZEmulatedPreparedStatement|ExecuteQueryPrepared |1982[1] |
|00A3D908|Turbo_HOSxP_PCU.exe|ZAbstractRODataset.pas |TZAbstractRODataset |CreateResultSet |1552[27] |
|00A3D764|Turbo_HOSxP_PCU.exe|ZAbstractRODataset.pas |TZAbstractRODataset |CreateResultSet |1525[0] |
|00A428B8|Turbo_HOSxP_PCU.exe|ZAbstractDataset.pas |TZAbstractDataset |CreateResultSet |308[11] |
|00A3D9F9|Turbo_HOSxP_PCU.exe|ZAbstractRODataset.pas |TZAbstractRODataset |InternalOpen |1576[11] |
|01179466|Turbo_HOSxP_PCU.exe|HOSxPDMU.pas | |HOSxP_GetDataSet |11839[57]|
|01179238|Turbo_HOSxP_PCU.exe|HOSxPDMU.pas | |HOSxP_GetDataSet |11782[0] |
|01186DA9|Turbo_HOSxP_PCU.exe|kskdmu.pas | |hosxp_getdataset |474[2] |
|01186D84|Turbo_HOSxP_PCU.exe|kskdmu.pas | |hosxp_getdataset |472[0] |
|0104C906|Turbo_HOSxP_PCU.exe|StockModuleU.pas | |HOSxP_GetDataSet |1245[2] |
|0104C8D4|Turbo_HOSxP_PCU.exe|StockModuleU.pas | |HOSxP_GetDataSet |1243[0] |
|01EF5872|Turbo_HOSxP_PCU.exe|StockCardU.pas |TStockCardForm |ShowStockCard |502[314] |
|01EF3FA8|Turbo_HOSxP_PCU.exe|StockCardU.pas |TStockCardForm |ShowStockCard |188[0] |
|01EF3F9F|Turbo_HOSxP_PCU.exe|StockCardU.pas |TStockCardForm |FormShow |179[1] |
|75FB53F5|USER32.dll | | |IsWindow | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|0060FC18|Turbo_HOSxP_PCU.exe|cxClasses.pas |TcxObjectLinkController |Destroy |1976[3] |
|0060FCD8|Turbo_HOSxP_PCU.exe|cxClasses.pas | |ReleaseObjectLinkControllerRefCount|2016[0] |
|0060FD2F|Turbo_HOSxP_PCU.exe|cxClasses.pas | |cxRemoveObjectLink |2038[4] |
|0060FD1C|Turbo_HOSxP_PCU.exe|cxClasses.pas | |cxRemoveObjectLink |2034[0] |
|0060764B|Turbo_HOSxP_PCU.exe|cxControls.pas |TcxControl |WndProc |3633[39] |
|77787760|ntdll.dll | | |RtlLeaveCriticalSection | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|75FB3654|USER32.dll | | |MonitorFromWindow | |
|75FB366A|USER32.dll | | |MonitorFromWindow | |
|023781DE|Turbo_HOSxP_PCU.exe|StockWareHouseItemListU.pas|TStockWareHouseItemListForm|cxButton2Click |128[11] |
|008E4279|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |Click |1659[8] |
|008E47D0|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |CNCommand |1883[4] |
|77792E7D|ntdll.dll | | |RtlAllocateHeap | |
|77793509|ntdll.dll | | |RtlMultiByteToUnicodeN | |
|77792CE3|ntdll.dll | | |RtlFreeHeap | |
|77792C6A|ntdll.dll | | |RtlFreeHeap | |
|777956E7|ntdll.dll | | |RtlDeleteBoundaryDescriptor | |
|008E474F|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |WndProc |1861[18] |
|77792E7D|ntdll.dll | | |RtlAllocateHeap | |
|77793509|ntdll.dll | | |RtlMultiByteToUnicodeN | |
|77792CE3|ntdll.dll | | |RtlFreeHeap | |
|77792C6A|ntdll.dll | | |RtlFreeHeap | |
|777956E7|ntdll.dll | | |RtlDeleteBoundaryDescriptor | |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|75FB557D|USER32.dll | | |SendMessageW | |
|75FD2BE9|USER32.dll | | |CallWindowProcA | |
|75FD2BD3|USER32.dll | | |CallWindowProcA | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F1115|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemGetMessageHook |106[1] |
|75997EE7|KERNELBASE.dll | | |WideCharToMultiByte | |
|75FA9DC7|USER32.dll | | |GetCapture | |
|759A7328|KERNELBASE.dll | | |GetLocaleInfoA | |
|008E474F|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |WndProc |1861[18] |
|764FC452|kernel32.dll | | |InterlockedDecrement | |
|75FB2E3C|USER32.dll | | |DispatchMessageA | |
|75FB2E32|USER32.dll | | |DispatchMessageA | |
|02473C8B|Turbo_HOSxP_PCU.exe|Turbo_HOSxP_PCU.dpr | | |720[28] |
|764FED6A|kernel32.dll | | |GetDriveTypeW | |
------------------------------------------------------------------------------------------------------------------------------------
-
เพิ่มเติมครับมี Error ในข้อมูลพื้นฐาน > รายการสินค้า > stock card
Application:
-------------------------------------------------------
1.1 Start Date : Tue, 27 Dec 2011 09:23:56 +0700
1.2 Name/Description: Turbo_HOSxP_PCU.exe
1.3 Version Number : 3.54.12.26
1.4 Parameters :
1.5 Compilation Date: Mon, 26 Dec 2011 12:05:44 +0700
1.6 Up Time : 2 minutes, 14 seconds
Exception:
-----------------------------------------------------
2.1 Date : Tue, 27 Dec 2011 09:26:11 +0700
2.2 Address : 005253A0
2.3 Module Name : Turbo_HOSxP_PCU.exe
2.4 Module Version: 3.54.12.26
2.5 Type : EDatabaseError
2.6 Message : Field 'price' not found.
2.7 ID : F510
2.8 Count : 1
2.9 Status : New
2.10 Note :
Call Stack Information:
-------------------------------------------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
-------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=4152; Priority=0; Class=; [Main] |
|-----------------------------------------------------------------------------------------------------------------------------------------|
|005253A0|Turbo_HOSxP_PCU.exe| | | | |
|02075D0B|Turbo_HOSxP_PCU.exe|StockCrad_SubStockFromU.pas |TStockCard_SubstockForm |ShowSubStockCard |854[706]|
|02072758|Turbo_HOSxP_PCU.exe|StockCrad_SubStockFromU.pas |TStockCard_SubstockForm |ShowSubStockCard |148[0] |
|0207274F|Turbo_HOSxP_PCU.exe|StockCrad_SubStockFromU.pas |TStockCard_SubstockForm |FormShow |140[1] |
|00E18653|Turbo_HOSxP_PCU.exe|JvFormPlacement.pas |TJvFormPlacement |FormShow |604[8] |
|75FB53F5|USER32.dll | | |IsWindow | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|0060FC18|Turbo_HOSxP_PCU.exe|cxClasses.pas |TcxObjectLinkController |Destroy |1976[3] |
|0060FCD8|Turbo_HOSxP_PCU.exe|cxClasses.pas | |ReleaseObjectLinkControllerRefCount|2016[0] |
|0060FD2F|Turbo_HOSxP_PCU.exe|cxClasses.pas | |cxRemoveObjectLink |2038[4] |
|0060FD1C|Turbo_HOSxP_PCU.exe|cxClasses.pas | |cxRemoveObjectLink |2034[0] |
|0060764B|Turbo_HOSxP_PCU.exe|cxControls.pas |TcxControl |WndProc |3633[39]|
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|75FB4D95|USER32.dll | | |IsWindowVisible | |
|75FB3654|USER32.dll | | |MonitorFromWindow | |
|75FB366A|USER32.dll | | |MonitorFromWindow | |
|0207C71C|Turbo_HOSxP_PCU.exe|StockDepartmentItemListNewU.pas|TStockDepartmentItemListNewForm|cxButton4Click |594[9] |
|008E4279|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |Click |1659[8] |
|008E47D0|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |CNCommand |1883[4] |
|77792E7D|ntdll.dll | | |RtlAllocateHeap | |
|77793509|ntdll.dll | | |RtlMultiByteToUnicodeN | |
|77792CE3|ntdll.dll | | |RtlFreeHeap | |
|77792C6A|ntdll.dll | | |RtlFreeHeap | |
|777956E7|ntdll.dll | | |RtlDeleteBoundaryDescriptor | |
|008E474F|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |WndProc |1861[18]|
|77792E7D|ntdll.dll | | |RtlAllocateHeap | |
|77793509|ntdll.dll | | |RtlMultiByteToUnicodeN | |
|77792CE3|ntdll.dll | | |RtlFreeHeap | |
|77792C6A|ntdll.dll | | |RtlFreeHeap | |
|777956E7|ntdll.dll | | |RtlDeleteBoundaryDescriptor | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F10F5|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemWndProcHook |101[1] |
|75FB557D|USER32.dll | | |SendMessageW | |
|00D057A8|Turbo_HOSxP_PCU.exe|cxSchedulerStorage.pas |TcxSchedulerEventLinks |GetItemLink |2891[0] |
|00CCD883|Turbo_HOSxP_PCU.exe|cxSchedulerGanttView.pas | |AddClones |1202[5] |
|75FD2BE9|USER32.dll | | |CallWindowProcA | |
|75FD2BD3|USER32.dll | | |CallWindowProcA | |
|005F1264|Turbo_HOSxP_PCU.exe|dxHooks.pas |TdxSystemHook |ProcessHookProcs |191[0] |
|005F1115|Turbo_HOSxP_PCU.exe|dxHooks.pas | |dxSystemGetMessageHook |106[1] |
|75997EE7|KERNELBASE.dll | | |WideCharToMultiByte | |
|75FA9DC7|USER32.dll | | |GetCapture | |
|759A7328|KERNELBASE.dll | | |GetLocaleInfoA | |
|008E474F|Turbo_HOSxP_PCU.exe|cxButtons.pas |TcxCustomButton |WndProc |1861[18]|
|764FC452|kernel32.dll | | |InterlockedDecrement | |
|75FB2E3C|USER32.dll | | |DispatchMessageA | |
|75FB2E32|USER32.dll | | |DispatchMessageA | |
|02473C8B|Turbo_HOSxP_PCU.exe|Turbo_HOSxP_PCU.dpr | | |720[28] |
|764FED6A|kernel32.dll | | |GetDriveTypeW | |
-------------------------------------------------------------------------------------------------------------------------------------------
-
มี error หน้า One Stop Service ขณะบันทึกการรับบริการ หรือ ส่งข้อมูล OPPP ด้วย
-
มี error หน้า One Stop Service ขณะบันทึกการรับบริการ หรือ ส่งข้อมูล OPPP ด้วย
เป็นเพราะ Data Center error อยู่ครับ เพิ่งรู้ว่า run บน windows นะเนี่ย ปิดระบบส่งข้อมูลตรงเข้า datacenter ก็เป็นปกติแล้วครับ