"hashCodeIndexDistributionSize" error in FOM/OMLR application

"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.