Project

General

Profile

Actions
Copy link

Bug #62

closed

Refund Order Report - 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:

0%

Estimated time:
Spent time:
1:00 h
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
Copy link
 #1

Updated by chin-yeh almost 14 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #2

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 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
Copy link
 #3

Updated by Chooi-Mey almost 14 years ago

  • Status changed from Feedback to Closed

Not in used function. Can be ignored.

Actions
Copy link

Also available in: Atom PDF