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&amp;ResourceKey=smasystem"
>
[java] <Attribute Name="ErrorCode" Value="YFS10145"/>
[java] <Attribute Name="ErrorDescription" Value=" "/>
[java] <Attribute Name="ErrorRelatedMoreInfo" Value="
Table=YFS_Resource&amp;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
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22001104