IBM Support

Sterling Order Management 9.5 installation fails during loadfactorysetup

Troubleshooting


Problem

Attempt to install IBM Sterling Order Management 9.5 using DB2 fails with the error Failed to Load entity: YFS_Menu

Symptom

Loading factory defaults fails for SMA module:
ERROR  :main: Failed to Load entity: YFS_Menu, while processing XML
File: SMA_YCP_YFS_MENU.xml [system]: [ ]: XMLMigrator
    [java]     <Error ErrorCode="YFS10145" ErrorDescription=""
ErrorRelatedMoreInfo="Table=YFS_Resource&ResourceKey=smasystem"
>
    [java]         <Attribute Name="ErrorCode" Value="YFS10145"/>
    [java]         <Attribute Name="ErrorDescription" Value=" "/>
    [java]         <Attribute Name="ErrorRelatedMoreInfo" Value="
Table=YFS_Resource&ResourceKey=smasystem"/>
    [java]         <Stack>com.yantra.yfc.util.YFCException

Cause

DB2_DEFERRED_PREPARE_SEMANTICS is set to YES.

Diagnosing The Problem

Execute db2set -all and check if the value of the db2 register variable DB2_DEFERRED_PREPARE_SEMANTICS is set to YES

Resolving The Problem

Set the value for DB2_DEFERRED_PREPARE_SEMANTICS to NO and restart DB2

Use the below command to set the DB2 variable.

  • db2set DB2_DEFERRED_PREPARE_SEMANTICS=NO

[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.5","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg22001104

Page Feedback