"hashCodeIndexDistributionSize" error in FOM/OMLR application
book
Article ID: KB0073739
calendar_today
Updated On:
Products
Versions
TIBCO Order Management
5.0
Description
It may happen that omsServer starts successfully but does not work properly and below error gets logged: == 09 Feb 2021 08:59:22,569 ERROR [] [] [] [com.tibco.aff.oms.server.impl.OrderServiceImpl] [] - [LogID = ID:EMS-T3-FOM.45D5F6089421:15248ED] [ThreadID:1] [Tenant ID:TIBCO] ***** Setting hashCodeIndexDistributionSize to -1 for tenant [TIBCO] since seed data for hashing is not available ***** ==
Issue/Introduction
This KB article explains how to resolve the error "Setting hashCodeIndexDistributionSize to -1 for tenant [TIBCO] since seed data for hashing is not available"
Resolution
A/ OMLR 5.0
Issue occurs in case the procedure "OMS_Seed_OrderAddress" was not executed. In the installation guide: https://docs.tibco.com/pub/om-lr/5.0.0/doc/html/GUID-346E2D57-2B69-48B2-9C0D-772E80E9D3B4.html == Run the script OMS_Seed_OrderAddress.sql, which creates the procedure OMS_Seed_OrderAddress. Note: While executing the procedure, keep the exponent value between 7 to 12 ==
The procedure "OMS_Seed_OrderAddress" should be executed after having created it with the script OMS_Seed_OrderAddress.sql.
B/ FOM 402-HF6(and later HFs)
Same as above, issue occurs in case the procedure "OMS_Seed_OrderAddress" was not executed. In the HF6 readme there is below step: === 8. To upgrade the Order Management Server database in Oracle, run the following scripts: - $AF_HOME/db/oracle/oms/UpgradeOMS_FOM4.0.2HF5_to_FOM4.0.2HF6.sql - $AF_HOME/db/oracle/oms/upgrade-admin-fom4.0.2hf5_to_fom4.0.2hf6.sql - $AF_HOME/db/oracle/oms/OMS_Seed_OrderAddress.sql === Note the OMS_Seed_OrderAddress.sql script will create the procedure but does not execute it.