Troubleshooting
Problem
When initUpgrade is run, the following error is thrown - ErrorCode="No entity exist for Name :null or TableName YFS_IBA_ORD_DEMAND_VW"
Symptom
The following error was seen in init upgrade log:
[java] -genschemadiffoftransaction:
[java] [echo] Generating schema differences for transaction
tables...
[java] [mkdir] Created dir:
C:\Sterling94UpgradeNew\Migration\9.3\database\scripts\oracle\transactio
n
[java] [mkdir] Created dir:
C:\Sterling94UpgradeNew\Migration\9.3\database\scripts\oracle\textsearch
[java] [echo] USE_OLD_INDEX_CHANGE_HANDLER : true
[java] [java] java version "1.7.0_79"
[java] [java] Java(TM) SE Runtime Environment (build
1.7.0_79-b15)
[java] [java] Java HotSpot(TM) 64-Bit Server VM (build
24.79-b02, mixed mode)
[java] [java]
[java] [java] Exception in thread "main" <?xml version="1.0"
encoding="UTF-8"?>
[java] [java] <Errors>
[java] [java] <Error
[java] [java] ErrorCode="No entity exist for Name
:null or TableName YFS_IBA_ORD_DEMAND_VW"
[java] [java] ErrorDescription="No entity exist for
Name :null or TableName YFS_IBA_ORD_DEMAND_VW" ErrorRelatedMoreInfo="">
[java] [java] <Attribute Name="ErrorCode" Value="No
entity exist for Name :null or TableName YFS_IBA_ORD_DEMAND_VW"/>
[java] [java] <Attribute Name="ErrorDescription"
Value="No entity exist for Name :null or TableName
YFS_IBA_ORD_DEMAND_VW"/>
[java] [java] <Attribute Name="FileBeingParsed"
Value="extensions/SMCF_85_attribute_default_extn.xml"/>
[java] [java]
<Stack>com.yantra.yfc.util.YFCException
[java] [java] at
com.yantra.tools.entityguru.generator.EntityRepository.parseDefaultExten
dedXmlFile(EntityRepository.java:653)
[java] [java] at
com.yantra.tools.entityguru.generator.EntityRepositoryLoader.getEntityRe
pository(EntityRepositoryLoader.java:143)
[java] [java] at
Cause
YFS_IBA_ORD_DEMAND_VW does not exist in <install_dir>/reposity/entity/omp_views.xml file
Diagnosing The Problem
This is a MCF 8.5 to SSFS9.4 nonsharded upgrade, customers have the option of reducing the size of some database tables by converting CHAR/NOT NULL columns to VARCHAR/NULL columns. Whether or not you plan to convert these columns, the following files must be extended and the corresponding XML files edited -
1. SMCF_85_attribute_default_extn.xml.sample
2. SMCF_920_attribute_default_extn.xml.sample
3. YCD_920_tables_modifications.xml.sample
Entity YFS_IBA_ORD_DEMAND_VW was referred to in SMCF_85_attribute_default_extn.xml.sample file. This led to the upgrade process verifying the view in omp_views.xml file but the view is not present.
From 9.3 onwards, Sterling supports zero downtime upgrade. If views are modified in a version, Sterling creates a new view with the changes and let the existing view remain, so as to not drop any view during upgrade process.
Since the view YFS_IBA_ORD_DEMAND_VW had been changed during 94, the new view YFS_IBA_ORD_DEMAND_VW_94 would be created while the existing YFS_IBA_ORD_DEMAND_VW would also remain. However it's not needed in <install_dir>/reposity/entity/omp_views.xml file
Resolving The Problem
Comment the entry of YFS_IBA_ORD_DEMAND_VW in SMCF_85_attribute_default_extn.xml.sample.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21974803