IBM Support

"Error Message: ""ORA-01438: value larger than specified precision allows for this column."" when adding addtional account to customer"

Troubleshooting


Problem

16:59:00 [43446] ERROR SQLExecute: oexec(1:13) failed, ORA-01438: value larger than specified precision allows for this column. 16:59:00 [43446] ERROR ODBC [01000] ORA-01438: value larger than specified precision allows for this column (DBError=1438) 16:59:00 [43446] ERROR MAD_PkgExecStmt: SQLExecute(mpi_memhead) failed. 16:59:00 [43446] ERROR MAD_PkgDbxPutAcb: tabName 'mpi_memhead', row 0, op 'UPDATE' failed. 16:59:00 [43446] ERROR MPI_MemDbSegPut: MAD_PkgDbxPutAcb(mpi_memhead) failed. 16:59:00 [43446] ERROR MPI_MemDbPut: MPI_MemDbSegPut(101) failed. 16:59:00 [43446] ERROR USR=rwuser, IXN=MEMPUT, ERR=EODBC, MSG=member 00999:023729180013118, unable to insert/update/delete member data. 16:59:00 [43446] ERROR MPI_IxnExec_ODBC: ixn failed due to ODBC error, disconnecting. ORA-01438: value larger than specified precision allowed for this column

Resolving The Problem

This error was a result of using the same memrecno in testing an excessive number of updates. The excessive amount of updates to the single member caused the memseqno field to be constantly updated to the point it exceeded the number size of the database field, in this case it was Oracle number(5) making the max number 99999 (sql server would have been 32767).

[{"Product":{"code":"SSLVY3","label":"Initiate Master Data Service"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

328

Document Information

Modified date:
16 June 2018

UID

swg21471042

Page Feedback