Troubleshooting
Problem
Maximum value 99,999 reached for LOCKID at YFS_INVENTORY_SUPPLY or YFS_INVENTORY_DEMAND table and caused transactions to fail.
Symptom
1. The following hotsku properties is used with the v10 runtime:
<Property Name="yfs.hotsku.lockItemOnInventoryChanges" Value="N"/>
2. The following error message appeared in the log
<Errors>
<Error ErrorCode="ORA-1438"
ErrorDescription="ORA-01438: value larger than specified
precision allowed for this column
"
ErrorRelatedMoreInfo="" ErrorUniqueExceptionId="
151.140.85.23515174374770170000000000050">
<Attribute Name="ErrorCode" Value="ORA-1438"/>
<Attribute Name="ErrorDescription" Value="ORA-01438: value
larger than specified precision allowed for this column
"/>
<Attribute Name="SQLState" Value="22003"/>
<Attribute Name="TableName" Value="YFS_INVENTORY_SUPPLY"/>
<Attribute Name="DBErrorCode" Value="1438"/>
<Attribute Name="SQLStatement" Value="update /* YANTRA */
YFS_INVENTORY_SUPPLY set QUANTITY = QUANTITY + ? ,MODIFYTS = ? ,
MODIFYUSERID = ? ,MODIFYPROGID = ? ,LOCKID = LOCKID + 1 WHERE
INVENTORY_SUPPLY_KEY = ?"/>
<Attribute Name="TransactionIsolationLevel" Value="2"/>
<Error ErrorCode="java.sql.SQLDataException"
ErrorDescription="" ErrorRelatedMoreInfo="ORA-01438: value larger than
specified precision allowed for this column
">
<Stack>java.sql.SQLDataException: ORA-01438: value larger
than specified precision allowed for this column
<Error ErrorCode="ORA-1438"
ErrorDescription="ORA-01438: value larger than specified
precision allowed for this column
"
ErrorRelatedMoreInfo="" ErrorUniqueExceptionId="
151.140.85.23515174374770170000000000050">
<Attribute Name="ErrorCode" Value="ORA-1438"/>
<Attribute Name="ErrorDescription" Value="ORA-01438: value
larger than specified precision allowed for this column
"/>
<Attribute Name="SQLState" Value="22003"/>
<Attribute Name="TableName" Value="YFS_INVENTORY_SUPPLY"/>
<Attribute Name="DBErrorCode" Value="1438"/>
<Attribute Name="SQLStatement" Value="update /* YANTRA */
YFS_INVENTORY_SUPPLY set QUANTITY = QUANTITY + ? ,MODIFYTS = ? ,
MODIFYUSERID = ? ,MODIFYPROGID = ? ,LOCKID = LOCKID + 1 WHERE
INVENTORY_SUPPLY_KEY = ?"/>
<Attribute Name="TransactionIsolationLevel" Value="2"/>
<Error ErrorCode="java.sql.SQLDataException"
ErrorDescription="" ErrorRelatedMoreInfo="ORA-01438: value larger than
specified precision allowed for this column
">
<Stack>java.sql.SQLDataException: ORA-01438: value larger
than specified precision allowed for this column
..
</Stsck>
</Error>
</Errors>
</Error>
</Errors>
Cause
The issue is fixed with v10 fp36 that resets the lockid filed once the maximum value is reached.
Resolving The Problem
Apply the latest v10 fixpack solves this issue.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"ARM Category":[{"code":"a8m0z000000cy00AAA","label":"Orders"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0.0"}]
Was this topic helpful?
Document Information
Modified date:
12 January 2024
UID
ibm17107355