Bug #63
closed
Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.
Added by chin-yeh over 13 years ago.
Updated over 13 years ago.
Category:
eCosway mall - control center
Description
Adjustment Management - ISO Order Adjustment
================
SQL Error. - Function itself already hit error.
Log:
17:21:30,129 INFO [STDOUT] SQL State: 42818
17:21:30,129 INFO [STDOUT] DB2 SQL error: SQLCODE: -401, SQLSTATE: 42818, SQLERRMC: >=
17:21:30,129 ERROR [STDERR] oa_isoorder_li
- Status changed from New to Feedback
- Assignee changed from chin-yeh to Chooi-Mey
- % Done changed from 0 to 100
- Resolution set to Fixed
the trx_order_no value did not enclosed with single quotes in the SQL query. the fixes are already deployed and tested.
The sql query got error on "The data types of the operands for the operation ">=" are not compatible" for this part : trx.TRX_ORDER_NO >= '0'.
The String compare not supported.
- Status changed from Feedback to In Progress
- Assignee changed from Chooi-Mey to chin-yeh
- Resolution deleted (
Fixed)
Chooi-Mey wrote:
The sql query got error on "The data types of the operands for the operation ">=" are not compatible" for this part : trx.TRX_ORDER_NO >= '0'.
The String compare not supported.
query this BO ID, CN857380 for previous month and it displayed no data.
- Status changed from In Progress to Feedback
- Assignee changed from chin-yeh to Chooi-Mey
- Resolution set to Fixed
chin-yeh wrote:
Chooi-Mey wrote:
The sql query got error on "The data types of the operands for the operation ">=" are not compatible" for this part : trx.TRX_ORDER_NO >= '0'.
The String compare not supported.
query this BO ID, CN857380 for previous month and it displayed no data.
the particular record exists in transaction table only but not in orders table. this is reason why the page displayed nothing.
- Status changed from Feedback to Closed
Also available in: Atom
PDF