Project

General

Profile

Actions
Copy link

Bug #69

closed

Ecenter Administration - Deposit Approval Management - SQL Error - Function itself hit exception.

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

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

0%

Estimated time:
Resolution:
Wont fix

Description

SQL Error - Function itself hit exception.

Log:

10:20:13,544 INFO  [STDOUT] SQL State: 42703
10:20:13,544 INFO  [STDOUT] DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: A.ECENTER_ID

Related issues 2 (0 open — 2 closed)

Related to Bug #68: Ecenter Administration - Deposit Management - SQL Error - Function itself hit exception.ClosedChooi-Mey01/25/201101/28/2011

Actions
Related to Bug #71: Ecenter Administration - Withdrawal Approval - SQL Error - Function itself hit exception.ClosedChooi-Mey01/26/201101/28/2011

Actions
Actions
Copy link
 #1

Updated by chin-yeh over 13 years ago

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

additional log:

15:27:47,785 INFO  [STDOUT] DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: A.BANK_ACCT_NO

there's a bug in the SQL which both ecenter_id and bank_acct_no columns are ambiguous to the joining tables. this bug exists in the existing environment also.

Actions
Copy link
 #2

Updated by Chooi-Mey over 13 years ago

  • Status changed from Feedback to Closed
Actions
Copy link

Also available in: Atom PDF