This discussion is archived
1 Reply Latest reply: Apr 27, 2012 4:35 AM by AbhishekJ RSS

AIA Harvesting results in error

NeerajSehgal Journeyer
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points