Project

General

Profile

Actions

Bug #62

closed

Refund Order Report - SQL Error. - Function itself already hit error.

Added by chin-yeh over 13 years ago. Updated over 13 years ago.

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

0%

Estimated time:
Spent time:
Resolution:
Wont fix

Description

SQL Error. - Function itself already hit error.

Log:

16:22:44,547 INFO  [STDOUT] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: TRX_CODE;Y_METHOD FROM  WHERE;WHERE

Actions #1

Updated by chin-yeh over 13 years ago

  • Status changed from New to In Progress
Actions #2

Updated by chin-yeh over 13 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from chin-yeh to Chooi-Mey
  • Resolution set to Wont fix

Based on the log entries, the SQL query did not specify the table name. If there's no matching records, the module won't able to get the correct table name, therefore, it'd thrown the SQL code -104.

By the way, we won't able to verify if the module is working, as there's no matching records for whatever range of dates you entered.

Actions #3

Updated by Chooi-Mey over 13 years ago

  • Status changed from Feedback to Closed

Not in used function. Can be ignored.

Actions

Also available in: Atom PDF