Troubleshooting
Problem
Migration from 50 SP2 to 70 sp3 throws YFS_UOM errors
Symptom
PART: Platform-Config 5.0 SP2 Platform
PRODUCT: Logistics
Management
COMPONENT: Users
OS: Windows NT - 4.0 SP 3
DATABASE: Oracle
- 9.2.0.4
WEB SERVER: WebLogic - 8.1 SP3
WEB BROWSER: Internet Explorer -
6.0 sp1
The Migrator gives error( listed below) while running the Yantra
70 SP3 migrator
Error 1 .
Error - ORA-904
INSERT
/*YANTRA*/
INTO
YFS_UOM(
UOM_KEY,ORGANIZATION_CODE,UOM_TYPE,UOM,
UOM_DESCRIPTION,VOLUME_UO
M,LOCKID,CREATETS,MODIFYTS,
CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROG
ID)
values ( CASE,DEFAULT,QUANTITY,CASE,Case,
,0,2004-11-12T11:18:41,
2004-11-12T11:18:41,SYSTEM,SYSTEM,XMLMigrator,XMLMigr
ator )
Error 2
Factory Setup Migration.
[java] 2004-11-12
11:14:37,846:FATAL :main:
[java]
<Errors>
[java] <Error ErrorCode="YFC0003" ErrorDescription="Database
Error." ErrorRelatedMoreInfo="">
[java] <Attribute Name="ErrorCode"
Value="YFC0003"/>
[java] <Attribute Name="ErrorDescription" Value="Database
Error."/>
[java] <Error ErrorCode="java.sql.SQLException"
ErrorDescription="" ErrorRelatedMoreInfo="ORA-00904: "A"."ORGANIZATION_CODE":
invalid identifier
">
[java] <Stack>java.sql.SQLException: ORA-00904:
"A"."ORGANIZATION_CODE": invalid identifier
Cause
Resolving The Problem
The above error is because the history tables were not migrated.
While
running the migrator follow the steps documented in the Yantra Migrator
documentation.
Even if there are no history tables to be migrated you still
need to go through the steps .
Historical Number
PRI49441
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21549592