1 Reply Latest reply: Apr 27, 2012 6:35 AM by AbhishekJ RSS

    AIA Harvesting results in error

    Neeraj Sehgal
      Hi All,

      I'm trying to Harvest a composite (only PABCS for the time being) in AIA 11g to only Lifecycle Workbench as I don't have OER. I've followed the Developer's guide and made the required changes in my MY_HarvesterSettings.xml file. While trying to harvest the composite, I'm getting the following error. (The full log is available at the end of this post).

      <div class="jive-quote">ERROR com.oracle.aia.AIAComposite - JBO-25013: Too many objects match the primary key oracle.jbo.Key[406 ].
      oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[406 ].
      at oracle.jbo.server.OracleSQLBuilderImpl.doEntitySelectForAltKey(OracleSQLBuilderImpl.java:931</div>

      The command I'm using to harvest is

      AIAHarvest.sh -partial true -mode AIA -settings ../config/MY_HarvesterSettings.xml

      I had created the Composite using AIA Service constructor so I'm assuming that it is properly annotated.
      I've searched everywhere regarding this error but to no avail. The same error I had seen in a thread long back without any solution though but this thread does not seem to work now.

      Any clue about this. Please see the curtailed log below.

      Regards,
      Neeraj Sehgal

      Log*
      -bash-3.2$ AIAHarvest.sh -partial true -mode AIA -settings ../config/MY_HarvesterSettings.xml
      INFO: AIA_INSTANCE is found, configuration will load from instance folder.
      10:20:53,853 0    [Main Thread] INFO  com.oracle.aia.AIAHarvester  - Reading from /dbab6d/fmw/product/111/aia/aia_instances/DBAB6D/config/AIAInstallProperties.xml
      10:20:56,397 2544 [Main Thread] INFO  com.oracle.aia.AIAHarvester  - -mode is activated.
      10:20:57,055 3202 [Main Thread] INFO  com.oracle.aia.AIAHarvester  - DB harvesting mode, skip OER harvesting!
      10:21:08,388 14535 [Main Thread] DEBUG com.oracle.aia.AIAHarvester  - Finished initialize MDS
      10:21:08,396 14543 [Main Thread] INFO  com.oracle.aia.AIACompositeMain  - Passing setting files...
      10:21:08,487 14634 [Main Thread] INFO  com.oracle.aia.AIAXmlReader  - Feeding file /dbab6d/fmw/product/111/AIADeploymentBOMAppln/SyncWorkerBOMTestProvABCSImpl/composite.xml into Composite Parser...
      10:21:08,494 14641 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Opening Application Module...
      10:21:08,494 14641 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Reading from /dbab6d/fmw/product/111/aia/aia_instances/DBAB6D/config/AIAInstallProperties.xml
      10:21:12,214 18361 [Main Thread] DEBUG com.oracle.aia.AIACompositeParser  - Connecting to JDBC jdbc:oracle:thin:@vmohsbabe015.oracleoutsourcing.com:16710/DBAB6D.ORACLEOUTSOURCING.COM using jndi t3://vmohsbabe058.oracleoutsourcing.com:46711
      10:21:12,214 18361 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Connect application module to jdbc connection...
      10:21:13,264 19411 [Main Thread] DEBUG com.oracle.aia.util.AIAOpenURL  - enter AIAIOpenURL
      10:21:13,264 19411 [Main Thread] DEBUG com.oracle.aia.util.AIAOpenURL  - open as normal file
      10:21:13,265 19412 [Main Thread] DEBUG com.oracle.aia.util.AIAOpenURL  - open file: /dbab6d/fmw/product/111/AIADeploymentBOMAppln/SyncWorkerBOMTestProvABCSImpl/composite.xml
      10:21:13,379 19526 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - interface:http://xmlns.oracle.com/ABCSImpl/BOMTest/Core/SyncWorkerBOMTestProvABCSImpl/V1#wsdl.interface(SyncWorkerBOMTestProvABCSImpl)
      10:21:13,411 19558 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - interface:http://xmlns.oracle.com/AIAAsyncErrorHandlingBPELProcess#wsdl.interface(AIAAsyncErrorHandlingBPELProcess)
      10:21:13,411 19558 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - interface:http://xmlns.oracle.com/GenericUtilitiesAppln_jws/AssignVarReusableTargetService/AssignInputToOutputVar#wsdl.interface(AssignInputToOutputVar)
      
      <?xml version = '1.0' encoding = 'UTF-8'?>
      <composite name="SyncWorkerBOMTestProvABCSImpl" revision="1.0" mode="active" state="on" xmlns="http://xmlns.oracle.com/sca/1.0" xmlns:ui="http://xmlns.oracle.com/soa/designer/" xmlns:xs="http://www.w3.org/2001/XMLSchema">
      My Full Composite.xml
      </composite>
      
      10:21:13,513 19660 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - composite name:SyncWorkerBOMTestProvABCSImpl
      10:21:13,516 19663 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - aialist:svcdoc:AIA
      10:21:13,517 19664 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - parent:service
      10:21:13,518 19665 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - wsdl location:SyncWorkerBOMTestProvABCSImpl.wsdl
      10:21:13,519 19666 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - interface:http://xmlns.oracle.com/ABCSImpl/BOMTest/Core/SyncWorkerBOMTestProvABCSImpl/V1#wsdl.interface(SyncWorkerBOMTestProvABCSImpl)
      10:21:13,519 19666 [Main Thread] DEBUG com.oracle.aia.AIACompositeParser  - Operation name is: SyncWorker
      10:21:13,543 19690 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployElementVO Prepare Statement.
      10:21:14,061 20208 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployAttributeVO Prepare Statement.
      10:21:14,115 20262 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Object Owner:com.oracle.aia.AIACompositeService
      10:21:14,121 20268 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:WorkerEBSV1
      10:21:14,123 20270 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:http://xmlns.oracle.com/EnterpriseServices/Core/Worker/V1
      10:21:14,123 20270 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:EnterpriseBusinessService
      10:21:14,142 20289 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:SyncWorkerList
      10:21:14,143 20290 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:BOMTest
      10:21:14,144 20291 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:
      10:21:14,144 20291 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:Oracle
      10:21:14,145 20292 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:Yes
      10:21:14,146 20293 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:ProviderABCSImplementation
      10:21:14,147 20294 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:SyncWorker
      10:21:14,147 20294 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:
      . same as above line many times
      .
      10:21:14,421 20568 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - aialist:svcdoc:AIA
      10:21:14,421 20568 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - parent:reference
      10:21:14,428 20575 [Main Thread] DEBUG com.oracle.aia.AIACompositeParser  - Operation name is: initiate
      10:21:14,429 20576 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployElementVO Prepare Statement.
      10:21:14,439 20586 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployAttributeVO Prepare Statement.
      10:21:14,462 20609 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Object Owner:com.oracle.aia.AIACompositeServiceRef
      10:21:14,462 20609 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:UtilityService
      10:21:14,463 20610 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:initiate
      10:21:14,463 20610 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:
      .
      .
      10:21:14,663 20810 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - aialist:svcdoc:AIA
      10:21:14,663 20810 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - parent:reference
      10:21:14,664 20811 [Main Thread] DEBUG com.oracle.aia.AIACompositeParser  - Operation name is: process
      10:21:14,664 20811 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployElementVO Prepare Statement.
      10:21:14,666 20813 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployAttributeVO Prepare Statement.
      10:21:14,684 20831 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Object Owner:com.oracle.aia.AIACompositeServiceRef
      10:21:14,712 20859 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:Other
      10:21:14,713 20860 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:process
      .
      .
      10:21:14,925 21072 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - aialist:svcdoc:AIA
      10:21:14,925 21072 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - parent:composite
      10:21:14,927 21074 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployElementVO Prepare Statement.
      10:21:14,929 21076 [Main Thread] DEBUG com.oracle.aia.AIADeployObject  - Finish deployAttributeVO Prepare Statement.
      10:21:14,931 21078 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - Object Owner:com.oracle.aia.AIAComposite
      10:21:14,935 21082 [Main Thread] INFO  com.oracle.aia.AIACompositeParser  - nodevalue:02b5b0f1-5afb-4bdb-bc15-370dcb1d973b
      10:21:15,360 21507 [Main Thread] DEBUG com.oracle.aia.AIAComposite  - writing composite deployment objects
      10:21:15,365 21512 [Main Thread] DEBUG com.oracle.aia.AIAComposite  - Insert composite information into OER BOM tables...
      10:21:15,392 21539 [Main Thread] INFO  com.oracle.aia.XMLUtils  - Storing the XML Document............
      10:21:15,404 21551 [Main Thread] DEBUG com.oracle.aia.XMLUtils  - insert row:AIA_REV_ID
      10:21:16,516 22663 [Main Thread] INFO  com.oracle.aia.XMLUtils  - Storing the XML Document............
      10:21:16,523 22670 [Main Thread] DEBUG com.oracle.aia.XMLUtils  - insert row:AIA_COMPOSITES
      10:21:16,545 22692 [Main Thread] DEBUG com.oracle.aia.AIAComposite  - writing service deployment objects
      10:21:16,563 22710 [Main Thread] DEBUG com.oracle.aia.oer.plugin.writer.AIAWsdlParser  - getdoc: /dbab6d/fmw/product/111/AIADeploymentBOMAppln/SyncWorkerBOMTestProvABCSImpl/SyncWorkerBOMTestProvABCSImpl.wsdl
      10:21:16,563 22710 [Main Thread] DEBUG com.oracle.aia.util.AIAOpenURL  - enter AIAIOpenURL
      10:21:16,563 22710 [Main Thread] DEBUG com.oracle.aia.util.AIAOpenURL  - open as normal file
      10:21:16,563 22710 [Main Thread] DEBUG com.oracle.aia.util.AIAOpenURL  - open file: /dbab6d/fmw/product/111/AIADeploymentBOMAppln/SyncWorkerBOMTestProvABCSImpl/SyncWorkerBOMTestProvABCSImpl.wsdl
      10:21:16,653 22800 [Main Thread] DEBUG com.oracle.aia.AIAProductCode  - Service Type is: ProviderABCSImpl
      10:21:16,655 22802 [Main Thread] DEBUG com.oracle.aia.AIAProductCode  - Product Code is: Ebiz
      10:21:17,092 23239 [Main Thread] ERROR com.oracle.aia.AIAComposite  - JBO-25013: Too many objects match the primary key oracle.jbo.Key[406 ].
      oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[406 ].
              at oracle.jbo.server.OracleSQLBuilderImpl.doEntitySelectForAltKey(OracleSQLBuilderImpl.java:931)
              at oracle.jbo.server.BaseSQLBuilderImpl.doEntitySelect(BaseSQLBuilderImpl.java:554)
              at oracle.jbo.server.EntityImpl.doSelect(EntityImpl.java:8259)
              at oracle.jbo.server.EntityImpl.populate(EntityImpl.java:6933)
              at oracle.jbo.server.EntityDefImpl.createRowFromDatabase(EntityDefImpl.java:1569)
              at oracle.jbo.server.EntityDefImpl.findFromDatabase(EntityDefImpl.java:1589)
              at oracle.jbo.server.EntityDefImpl.findByPKExtended(EntityDefImpl.java:1737)
              at oracle.jbo.server.ViewObjectImpl.findAssociatedEntityForUpdate(ViewObjectImpl.java:14560)
              at oracle.jbo.server.ViewObjectImpl.findAssociatedEntity(ViewObjectImpl.java:14663)
              at oracle.jbo.server.ViewObjectImpl.updateReferenceEntities(ViewObjectImpl.java:14805)
              at oracle.jbo.server.ViewObjectImpl.afterRowUpdate(ViewObjectImpl.java:13468)
              at oracle.jbo.server.ViewObjectImpl.sourceChanged(ViewObjectImpl.java:13839)
              at oracle.jbo.server.EntityCache.sendEvent(EntityCache.java:1498)
              at oracle.jbo.server.EntityCache.deliverEntityEvent(EntityCache.java:1514)
              at oracle.jbo.server.EntityCache.notifyColumnAndBlgChange(EntityCache.java:1570)
              at oracle.jbo.server.EntityImpl.notifyAttributesChanged(EntityImpl.java:7385)
              at oracle.jbo.server.EntityImpl.notifyAttributesChanged(EntityImpl.java:7366)
              at oracle.jbo.server.EntityImpl.notifyAttributesAndBlgChanged(EntityImpl.java:7375)
              at oracle.jbo.server.EntityImpl.setAttributeValue(EntityImpl.java:3642)
              at oracle.jbo.server.AttributeDefImpl.set(AttributeDefImpl.java:3205)
              at oracle.jbo.server.EntityImpl.setAttributeInternal(EntityImpl.java:1971)
              at oracle.apps.aia.oer.entity.AiaDeployAttributeValuesImpl.setDeployAttributeId(AiaDeployAttributeValuesImpl.java:255)
              at oracle.apps.aia.oer.entity.AiaDeployAttributeValuesImpl$AttributesEnum$5.put(AiaDeployAttributeValuesImpl.java:70)
              at oracle.apps.aia.oer.entity.AiaDeployAttributeValuesImpl.setAttrInvokeAccessor(AiaDeployAttributeValuesImpl.java:405)
              at oracle.jbo.server.EntityImpl.setAttribute(EntityImpl.java:1879)
              at oracle.jbo.server.ViewRowStorage.setAttributeValue(ViewRowStorage.java:2327)
              at oracle.jbo.server.ViewRowStorage.setAttributeInternal(ViewRowStorage.java:2131)
              at oracle.jbo.server.ViewRowImpl.setAttributeInternal(ViewRowImpl.java:1427)
              at oracle.jbo.server.ViewRowImpl.setAttrInvokeAccessor(ViewRowImpl.java:1402)
              at oracle.jbo.server.ViewRowImpl.setAttribute(ViewRowImpl.java:1063)
              at oracle.jbo.server.ViewRowImpl.setAttribute(ViewRowImpl.java:1003)
              at com.oracle.aia.AIADeployObject.writeToDB(AIADeployObject.java:191)
              at com.oracle.aia.AIACompositeService.writeToDB(AIACompositeService.java:128)
              at com.oracle.aia.AIAComposite.writeToDB(AIAComposite.java:201)
              at com.oracle.aia.AIAXmlReader.feedToCompositeParser(AIAXmlReader.java:95)
              at com.oracle.aia.AIACompositeMain.main(AIACompositeMain.java:62)
              at com.oracle.aia.AIAHarvester.main(AIAHarvester.java:95)
      10:21:17,099 23246 [Main Thread] INFO  com.oracle.aia.AIAComposite  - Rolling back transaction...
      10:21:17,138 23285 [Main Thread] INFO  com.oracle.aia.AIAHarvester  - DB harvesting finished!