Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JBO-25058: Definition AltKey of type Key Definition is not found in table

Tony007May 16 2013 — edited May 17 2013
hi am having this error when running my test model,but i do have variable in my entity 
my entity is
<?xml version="1.0" encoding="windows-1252" ?>
<!DOCTYPE Entity SYSTEM "jbo_03_01.dtd">
<!---->
<Entity
  xmlns="http://xmlns.oracle.com/bc4j"
  xmlns:validation="http://xmlns.oracle.com/adfm/validation"
  Name="UamOrganisations"
  Version="11.1.1.61.92"
  InheritPersonalization="true"
  DBObjectType="table"
  DBObjectName="UAM_ORGANISATIONS"
  AliasName="UamOrganisations"
  BindingStyle="OracleName"
  UseGlueCode="false"
  RowClass=".uam.model.entities.UamOrganisationsImpl">
  <DesignTime>
    <AttrArray Name="_publishEvents"/>
    <Attr Name="_codeGenFlag2" Value="Init|Delete|Access|DML"/>
    <Attr Name="_isCodegen" Value="true"/>
  </DesignTime>
  <Attribute
    Name="Organisationid"
    IsUpdateable="while_insert"
    IsNotNull="true"
    Precision="38"
    Scale="0"
    ColumnName="ORGANISATIONID"
    SQLType="NUMERIC"
    Type="oracle.jbo.domain.Number"
    ColumnType="NUMBER"
    TableName="UAM_ORGANISATIONS"
    PrimaryKey="true"
    RetrievedOnInsert="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="22"/>
    </DesignTime>
    <TransientExpression><![CDATA[(new oracle.jbo.server.SequenceImpl ("UAM_ORGANISATIONS_SEQ", object.getDBTransaction())).getSequenceNumber()]]></TransientExpression>
  </Attribute>
  <Attribute
    Name="Cadastreaccount"
    IsUnique="true"
    Precision="10"
    ColumnName="CADASTREACCOUNT"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    IsNotNull="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="10"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Organisationname"
    IsUnique="true"
    Precision="50"
    ColumnName="ORGANISATIONNAME"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    IsNotNull="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="50"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Organisationtradingasname"
    Precision="50"
    ColumnName="ORGANISATIONTRADINGASNAME"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="50"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Governmentdept"
    Precision="66"
    ColumnName="GOVERNMENTDEPT"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="66"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Registrationnumber"
    Precision="30"
    ColumnName="REGISTRATIONNUMBER"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="30"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Organisationemail"
    Precision="66"
    ColumnName="ORGANISATIONEMAIL"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    IsNotNull="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="66"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Registrationstatus"
    IsNotNull="true"
    Precision="1"
    ColumnName="REGISTRATIONSTATUS"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    RetrievedOnUpdate="true"
    RetrievedOnInsert="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="1"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Rejectionreason"
    Precision="100"
    ColumnName="REJECTIONREASON"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="100"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Datemodified"
    ColumnName="DATEMODIFIED"
    SQLType="TIMESTAMP"
    Type="oracle.jbo.domain.Date"
    ColumnType="DATE"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="7"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Status"
    Precision="10"
    ColumnName="STATUS"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="10"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Orgsubtypecode"
    Precision="50"
    ColumnName="ORGSUBTYPECODE"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    IsNotNull="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="5"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Organisationtypecode"
    Precision="10"
    ColumnName="ORGANISATIONTYPECODE"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="10"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Orgsubtypeid"
    IsPersistent="false"
    ColumnName='"Synchronize:Fix_SQL"'
    SQLType="NUMERIC"
    Type="oracle.jbo.domain.Number"
    ColumnType="NUMBER">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="39"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="Datecreated"
    ColumnName="DATECREATED"
    SQLType="TIMESTAMP"
    Type="java.sql.Timestamp"
    ColumnType="TIMESTAMP"
    TableName="UAM_ORGANISATIONS">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="7"/>
    </DesignTime>
    <TransientExpression><![CDATA[adf.currentDateTime]]></TransientExpression>
  </Attribute>
  <Attribute
    Name="Officecode"
    Precision="5"
    ColumnName="OFFICECODE"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    RetrievedOnUpdate="true"
    RetrievedOnInsert="true">
    <DesignTime>
      <Attr Name="_DisplaySize" Value="50"/>
    </DesignTime>
  </Attribute>
  <Attribute
    Name="AltKey"
    Precision="80"
    ColumnName="ALT_KEY"
    SQLType="VARCHAR"
    Type="java.lang.String"
    ColumnType="VARCHAR2"
    TableName="UAM_ORGANISATIONS"
    IsNotNull="true"/>
  <AccessorAttribute
    Name="UamFrequentusers"
    Association=".uam.model.entities.FrequentusersOrganisationsFkAssoc"
    AssociationEnd=".uam.model.entities.FrequentusersOrganisationsFkAssoc.UamFrequentusers"
    AssociationOtherEnd=".uam.model.entities.FrequentusersOrganisationsFkAssoc.UamOrganisations"
    Type="oracle.jbo.RowIterator"
    IsUpdateable="false"/>
  <AccessorAttribute
    Name="UamCompanyofficerdetails"
    Association=".uam.model.entities.OrgCompanyofficerFkAssoc"
    AssociationEnd=".uam.model.entities.OrgCompanyofficerFkAssoc.UamCompanyofficerdetails"
    AssociationOtherEnd=".uam.model.entities.OrgCompanyofficerFkAssoc.UamOrganisations"
    Type="oracle.jbo.RowIterator"
    IsUpdateable="false"/>
  <AccessorAttribute
    Name="UamCadastreaccounts"
    Association=".uam.model.entities.CadaccountOrgFkAssoc"
    AssociationEnd=".uam.model.entities.CadaccountOrgFkAssoc.UamCadastreaccounts"
    AssociationOtherEnd=".uam.model.entities.CadaccountOrgFkAssoc.UamOrganisations"
    Type="oracle.jbo.server.EntityImpl"
    IsUpdateable="true"/>
  <AccessorAttribute
    Name="UamOrganisationsAddress"
    Association=".uam.model.entities.OrgEntityaddressFkAssoc"
    AssociationEnd=".uam.model.entities.OrgEntityaddressFkAssoc.UamOrganisationsAddress"
    AssociationOtherEnd=".uam.model.entities.OrgEntityaddressFkAssoc.UamOrganisations"
    Type="oracle.jbo.RowIterator"
    IsUpdateable="false"/>
  <AccessorAttribute
    Name="UamOrganisationUser"
    Association=".uam.model.entities.OrguserlinkOrganisationsFkAssoc"
    AssociationEnd=".uam.model.entities.OrguserlinkOrganisationsFkAssoc.UamOrganisationUser"
    AssociationOtherEnd=".uam.model.entities.OrguserlinkOrganisationsFkAssoc.UamOrganisations"
    Type="oracle.jbo.RowIterator"
    IsUpdateable="false"/>
  <AccessorAttribute
    Name="CfgOffice"
    Association=".uam.model.entities.UamOrgCfgOfficeFkAssoc"
    AssociationEnd=".uam.model.entities.UamOrgCfgOfficeFkAssoc.CfgOffice"
    AssociationOtherEnd=".uam.model.entities.UamOrgCfgOfficeFkAssoc.UamOrganisations"
    Type="oracle.jbo.server.EntityImpl"
    IsUpdateable="true"/>
  <AccessorAttribute
    Name="UamOrganisationUser1"
    Association=".uam.model.entities.OrguserlinkOrganisationsFkAssoc1"
    AssociationEnd=".uam.model.entities.OrguserlinkOrganisationsFkAssoc1.UamOrganisationUser1"
    AssociationOtherEnd=".uam.model.entities.OrguserlinkOrganisationsFkAssoc1.UamOrganisations1"
    Type="oracle.jbo.RowIterator"
    IsUpdateable="false"/>
  <AccessorAttribute
    Name="UamOrganisationsAddress1"
    Association=".uam.model.entities.fk_UamOrganisationsAddress1Assoc"
    AssociationEnd=".uam.model.entities.fk_UamOrganisationsAddress1Assoc.UamOrganisationsAddress1"
    AssociationOtherEnd=".uam.model.entities.fk_UamOrganisationsAddress1Assoc.UamOrganisations1"
    Type="oracle.jbo.RowIterator"
    IsUpdateable="false"/>
  <Key
    Name="OrganisationUn">
    <DesignTime>
      <Attr Name="_isUnique" Value="true"/>
      <Attr Name="_DBObjectName" Value="ORGANISATION__UN"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Cadastreaccount"/>
    </AttrArray>
  </Key>
  <Key
    Name="OrganisationUnv1">
    <DesignTime>
      <Attr Name="_isUnique" Value="true"/>
      <Attr Name="_DBObjectName" Value="ORGANISATION__UNV1"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Organisationname"/>
    </AttrArray>
  </Key>
  <Key
    Name="Organisationpk"
    PrimaryKey="true">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="ORGANISATIONPK"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Organisationid"/>
    </AttrArray>
  </Key>
  <Key
    Name="SysC0038153">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="SYS_C0038153"/>
      <Attr Name="_checkCondition" Value='"ORGANISATIONID" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Organisationid"/>
    </AttrArray>
  </Key>
  <Key
    Name="SysC0038154">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="SYS_C0038154"/>
      <Attr Name="_checkCondition" Value='"CADASTREACCOUNT" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Cadastreaccount"/>
    </AttrArray>
  </Key>
  <Key
    Name="SysC0038155">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="SYS_C0038155"/>
      <Attr Name="_checkCondition" Value='"ORGANISATIONNAME" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Organisationname"/>
    </AttrArray>
  </Key>
  <Key
    Name="SysC0038156">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="SYS_C0038156"/>
      <Attr Name="_checkCondition" Value='"ORGANISATIONEMAIL" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Organisationemail"/>
    </AttrArray>
  </Key>
  <Key
    Name="SysC0038157">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="SYS_C0038157"/>
      <Attr Name="_checkCondition" Value='"REGISTRATIONSTATUS" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Registrationstatus"/>
    </AttrArray>
  </Key>
  <Key
    Name="SysC0038158">
    <DesignTime>
      <Attr Name="_DBObjectName" Value="SYS_C0038158"/>
      <Attr Name="_checkCondition" Value='"ORGSUBTYPECODE" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Orgsubtypecode"/>
    </AttrArray>
  </Key>
  <Key
    Name="UamOrganisationsAltKeyCheck">
    <DesignTime>
      <Attr Name="_isNotNull" Value="true"/>
      <Attr Name="_DBObjectName" Value="UAM_ORGANISATIONS_ALT_KEY_CHEC"/>
      <Attr Name="_checkCondition" Value='"ALT_KEY" IS NOT NULL'/>
      <Attr Name="_isCheck" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.AltKey"/>
    </AttrArray>
  </Key>
  <Key
    Name="CadaccountOrgFk">
    <DesignTime>
      <Attr Name="_isInitiallyDeferredConstraint" Value="true"/>
      <Attr Name="_isDeferrableConstraint" Value="true"/>
      <Attr Name="_referencedKey" Value="UAM_CADASTREACCOUNT_PK"/>
      <Attr Name="_isForeign" Value="true"/>
      <Attr Name="_DBObjectName" Value="CADACCOUNT_ORG_FK"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Cadastreaccount"/>
    </AttrArray>
  </Key>
  <Key
    Name="OrgOrgsubtypeFk">
    <DesignTime>
      <Attr Name="_referencedKey" Value="LUT_ORGSUBTYPE_PK"/>
      <Attr Name="_isForeign" Value="true"/>
      <Attr Name="_DBObjectName" Value="ORG_ORGSUBTYPE_FK"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Orgsubtypecode"/>
    </AttrArray>
  </Key>
  <Key
    Name="UamOrgCfgOfficeFk">
    <DesignTime>
      <Attr Name="_referencedKey" Value="CFG_OFFICES_PK"/>
      <Attr Name="_isForeign" Value="true"/>
      <Attr Name="_DBObjectName" Value="UAM_ORG_CFG_OFFICE_FK"/>
      <Attr Name="_isDisabledConstraint" Value="true"/>
    </DesignTime>
    <AttrArray Name="Attributes">
      <Item
        Value=".uam.model.entities.UamOrganisations.Officecode"/>
    </AttrArray>
  </Key>
  <validation:UniqueKeyValidationBean
    Name="UamOrganisations_Rule_0"
    ResId=".uam.model.entities.UamOrganisations_Rule_0"
    KeyName="AltKey">
    <validation:OnAttributes>
      <validation:Item
        Value="Organisationname"/>
    </validation:OnAttributes>
  </validation:UniqueKeyValidationBean>
  <ResourceBundle>
    <PropertiesBundle
      PropertiesFile="model.ModelBundle"/>
  </ResourceBundle>
</Entity>

the log error is
970] An exception occured during checkout.
[971] oracle.jbo.NoDefException: JBO-25058: Definition AltKey of type Key Definition is not found in UamOrganisations.
	at oracle.jbo.server.RowDef.findAltKeyDef(RowDef.java:1220)
	at oracle.jbo.server.RowDef.getAltKeyAttrDefs(RowDef.java:1283)
	at oracle.jbo.server.EntityDefImpl.addUniqueKeyValidation(EntityDefImpl.java:5449)
	at oracle.jbo.server.EntityDefImpl.loadValidators(EntityDefImpl.java:4808)
	at oracle.jbo.server.EntityDefImpl.loadFromXML(EntityDefImpl.java:3941)
	at oracle.jbo.server.EntityDefImpl.loadFromXML(EntityDefImpl.java:3531)
	at oracle.jbo.server.EntityDefImpl.loadFromXML(EntityDefImpl.java:3515)
	at oracle.jbo.server.MetaObjectManager.loadFromXML(MetaObjectManager.java:550)
	at oracle.jbo.mom.DefinitionManager.loadLazyDefinitionObject(DefinitionManager.java:1232)
	at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:603)
	at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:523)
	at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:505)
	at oracle.jbo.server.MetaObjectManager.findMetaObject(MetaObjectManager.java:780)
	at oracle.jbo.server.EntityDefImpl.findDefObject(EntityDefImpl.java:661)
	at oracle.jbo.server.ViewDefImpl.doAddRowReference(ViewDefImpl.java:7293)
	at oracle.jbo.server.ViewDefImpl.loadEntityReference(ViewDefImpl.java:7570)
	at oracle.jbo.server.ViewDefImpl.loadFromXML(ViewDefImpl.java:4188)
	at oracle.jbo.server.ViewDefImpl.loadFromXML(ViewDefImpl.java:3946)
	at oracle.jbo.server.ViewDefImpl.loadFromXML(ViewDefImpl.java:3894)
	at oracle.jbo.server.MetaObjectManager.loadFromXML(MetaObjectManager.java:554)
	at oracle.jbo.mom.DefinitionManager.loadLazyDefinitionObject(DefinitionManager.java:1232)
	at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:603)
	at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:523)
	at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:505)
	at oracle.jbo.server.MetaObjectManager.findMetaObject(MetaObjectManager.java:780)
	at oracle.jbo.server.ViewDefImpl.findDefObject(ViewDefImpl.java:845)
	at oracle.jbo.server.AMViewUsage.createViewObject(AMViewUsage.java:112)
	at oracle.jbo.server.ApplicationModuleDefImpl.loadViewObject(ApplicationModuleDefImpl.java:660)
	at oracle.jbo.server.ApplicationModuleDefImpl.loadComponents(ApplicationModuleDefImpl.java:921)
	at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:493)
	at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:87)
	at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:158)
	at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:73)
	at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:2913)
	at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:580)
	at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2473)
	at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2347)
	at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3246)
	at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:572)
	at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:505)
	at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:500)
	at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:523)
	at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:869)
	at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:214)
	at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:906)
	at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:632)
	at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:597)
	at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:428)
Edited by: adf009 on 2013/05/16 2:20 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2013
Added on May 16 2013
#application-development-in-java, #jdeveloper-and-adf
2 comments
427 views