Project

General

Profile

Actions
Copy link

Bug #63

closed

Adjustment Management - ISO Order Adjustment - SQL Error. - Function itself already hit error.

Added by chin-yeh almost 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Chooi-Mey
Category:
eCosway mall - control center
Target version:
1.0
Start date:
01/25/2011
Due date:
01/28/2011
% Done:

100%

Estimated time:
Spent time:
1:00 h
Resolution:
Fixed

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

Actions
Copy link
 #1

Updated by chin-yeh almost 14 years ago

  • 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.

Actions
Copy link
 #2

Updated by Chooi-Mey almost 14 years ago

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.

Actions
Copy link
 #3

Updated by chin-yeh almost 14 years ago

  • 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.

Actions
Copy link
 #4

Updated by chin-yeh almost 14 years ago

  • 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.

Actions
Copy link
 #5

Updated by Chooi-Mey almost 14 years ago

  • Status changed from Feedback to Closed
Actions
Copy link

Also available in: Atom PDF