E1: TC: Custom Table Conversion Based on a Foreign Table Fails to Execute Successfully with TC Log Error ' ODB0000164' 'Numeric value out of range'
(Doc ID 2971941.1)
Last updated on SEPTEMBER 07, 2023
Applies to:
JD Edwards EnterpriseOne Tools - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
A custom table conversion is designed to read from /write to a foreign table ( i.e a table not having JDE specifications). This TC works successfully when executed locally on fat client but fails when executed on server and ends in Error status in WSJ.
When submitting this TC on server, the TC jde log shows below error
TC jdedebug log shows below statements:
Jan 23 12:04:56.619000 - 6996/1928 SELECT * FROM <DBXXX>.<DBXXX>.<FOREIGNTABLENAME> (UPDLOCK) WHERE ( Processed IN ( 0,2 ) ) ORDER BY DT ASC,EmpNo ASC FOR UPDATE OF DT, Processed, Upload_ID
Jan 23 12:04:56.619001 - 6996/1928 Entering DBPerformRequest
Jan 23 12:04:56.619002 - 6996/1928 ODBC:S DBPerformRequest req=XXXX,con=XXXXX,env=XXXX,dbc=XXXXX,spid=393 XXXXXX A (jde@XXXXX)
Jan 23 12:04:56.619003 - 6996/1928 ODBC[jdbodbc.c,3908] wSQLExecute failure. rc = -1
Jan 23 12:04:56.619004 - 6996/1928 ODBC[jdbodbc.c,3908] STMT:00 [22003][0] [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
Jan 23 12:04:56.619005 - 6996/1928 ODB0000163 - wSQLExecute failure. rc=-1
Jan 23 12:04:56.619007 - 6996/1928 ODB0000164 - STMT:00 [22003][0][2] [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
Jan 23 12:04:56.619009 - 6996/1928 Exiting DBPerformRequest
Jan 23 12:04:56.619010 - 6996/1928 JDB9900401 - Failed to execute db request
Jan 23 12:04:56.619012 - 6996/1928 Exiting JDB_SelectKeyedForUpdate with Failure
Jan 23 12:04:56.619013 - 6996/1928 TCE009140 - JDB_SelectKeyedForUpdate failed.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |