This discussion is archived
4 Replies Latest reply: Dec 13, 2011 1:17 AM by 717634 RSS

Issues while Deploying using AID

AnishRaj Newbie
Currently Being Moderated
Hi All,

We are getting the following errors while deploying a xxxposite using the AID,

/oracle/product/Middleware/AIA/Infrastructure/Install/AID/AIAInstallDriver.xml:72: The following error occurred while executing this line:
/oracle/product/Middleware/AIA/Infrastructure/Install/AID/AIAExecuteDriver.xml:79: The following error occurred while executing this line:
/oracle/product/Middleware/AIA/Infrastructure/Install/AID/AIAExecuteDriver.xml:58: The following error occurred while executing this line:
/oracle/product/Middleware/AIA/aia_instances/AIA_DEV/tmp/AIDExecuteDP_temp_760097272.xml:6: The following error occurred while executing this line:
/oracle/product/Middleware/AIA/Infrastructure/Install/AID/lib/AIDConfigurationLibraryTasks.xml:379: Not provided valid values for jdbc-url, username, password for datasource tag in participatingapplications.Ebiz.db.EBIZ01

This is the xxxmand that I am running

ant -f AIAInstallDriver.xml -DDeploymentPlan=/oracle/product/Middleware/AIA/util/DeploymentPlanGenerator/POProviderDP.xml -DPropertiesFile=/oracle/product/Middleware/AIA/aia_instances/AIA_DEV/config/AIAInstallProperties.xml


I am not sure if the generated BOM and DP has the correct values, and whether AIAInstallProperties have been edited correctly.

They are pasted below,

BOM.xml
------------
<?xml version = '1.0' encoding = 'UTF-8'?>
<svcdoc:BOM xmlns="http://xmlns.oracle.xxx/sca/1.0" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:orawsp="http://schemas.oracle.xxx/ws/2006/01/policy" xmlns:ui="http://xmlns.oracle.xxx/soa/designer/" xmlns:svcdoc="http://xmlns.oracle.xxx/Services/Documentation/V1" xsi:noNameSpaceSchemaLocation="AIAPIP.xsd" projectCode="BAERPSOA" xmlns:xsi="http://xmlns.oracle.xxx/Services/Documentation/V1">
<svcdoc:xxxposite revision="1.0" name="PurchaseOrderListEbizProvider">
<svcdoc:ServiceSolutionxxxponentAssociation>
<svcdoc:GUID>def61380-d651-4fd7-87de-054e45eea195</svcdoc:GUID>
</svcdoc:ServiceSolutionxxxponentAssociation>
<svcdoc:service name="createpurchaseorderlistebizproviderservice_ep">
<svcdoc:ImplementationDetails>
<svcdoc:ApplicationName>Ebiz</svcdoc:ApplicationName>
<svcdoc:BaseVersion>1.0</svcdoc:BaseVersion>
<svcdoc:DevelopedBy>BAEIS</svcdoc:DevelopedBy>
<svcdoc:OracleCertified>Yes</svcdoc:OracleCertified>
<svcdoc:ArtifactType>TransportAdapter</svcdoc:ArtifactType>
<svcdoc:ServiceOperation>
<svcdoc:Name>process</svcdoc:Name>
</svcdoc:ServiceOperation>
</svcdoc:ImplementationDetails>
</svcdoc:service>
<svcdoc:reference name="InsertPurchaseOrderListEbizProviderDBAdapterService">
<svcdoc:ArtifactType>TransportAdapter</svcdoc:ArtifactType>
<svcdoc:ServiceOperation>
<svcdoc:Name>insert</svcdoc:Name>
</svcdoc:ServiceOperation>
<svcdoc:TransportDetails>
<svcdoc:DBAdapter>
<svcdoc:ResourceProvider>OracleDB</svcdoc:ResourceProvider>
<svcdoc:ConnectionFactory>eis/DB/APPS</svcdoc:ConnectionFactory>
<svcdoc:ApplicationName>Ebiz</svcdoc:ApplicationName>
<svcdoc:XAEnabled>True</svcdoc:XAEnabled>
<svcdoc:ResourceTargetIdentifier>EBIZ01</svcdoc:ResourceTargetIdentifier>
<svcdoc:ResourceName>BAPO_SOA_PO_HEADERS_STAGE</svcdoc:ResourceName>
<svcdoc:ResourceName>BAPO_SOA_PO_LINES_STAGE</svcdoc:ResourceName>
<svcdoc:ResourceName>BAPO_SOA_PO_DIST_STAGE</svcdoc:ResourceName>
</svcdoc:DBAdapter>
</svcdoc:TransportDetails>
</svcdoc:reference>
<svcdoc:reference name="PurchaseOrderAPICall">
<svcdoc:ArtifactType>TransportAdapter</svcdoc:ArtifactType>
<svcdoc:ServiceOperation>
<svcdoc:Name>Procedure</svcdoc:Name>
</svcdoc:ServiceOperation>
<svcdoc:TransportDetails>
<svcdoc:DBAdapter>
<svcdoc:ResourceProvider>OracleDB</svcdoc:ResourceProvider>
<svcdoc:ConnectionFactory>eis/DB/APPS</svcdoc:ConnectionFactory>
<svcdoc:ApplicationName>Ebiz</svcdoc:ApplicationName>
<svcdoc:XAEnabled>True</svcdoc:XAEnabled>
<svcdoc:ResourceTargetIdentifier>EBIZ01</svcdoc:ResourceTargetIdentifier>
<svcdoc:ResourceName>BAPO_SOA_STD_IMPORT_K.BAPO_SOA_VALIDATE_HEADERS_P</svcdoc:ResourceName>
</svcdoc:DBAdapter>
</svcdoc:TransportDetails>
</svcdoc:reference>
</svcdoc:xxxposite>
</svcdoc:BOM>

DP
---
<DeploymentPlan xxxponent="BAERPSOA" version="3.0">
<PreInstallScript>
<if>
<equals arg1="${oer.server.publishtooer}" arg2="true"/>
<then>
<copy todir="${AIA_INSTANCE}/Infrastructure/LifeCycle/Install/PIPHarvest">
<fileset file="${AIA_HOME}/Infrastructure/LifeCycle/AIAHarvester/HarvesterSettings.xml" />
<filterchain>
<expandproperties/>
</filterchain>
</copy>
<for param="file">
<path>
<fileset dir="${AIA_INSTANCE}/Infrastructure/LifeCycle/Install/PIPHarvest">
<include name="*.xml"/>
</fileset>
</path>
<sequential>
<OEREncrypt sourceFile="@{file}" destinationFile="@{file}" />
</sequential>
</for>
</then>
</if>
</PreInstallScript>
<Configurations>
<EndpointConfigurator target-server="pips.BAERPSOA" dir="${AIA_HOME}">
</EndpointConfigurator>
<Datasource name="APPS" jndiLocation="jdbc/APPS" action="create" database="participatingapplications.Ebiz.db.EBIZ01" xa-enabled="true" wlserver="pips.BAERPSOA"/>
<UpdateMetadata wlserver="pips.BAERPSOA" >
<fileset dir="${AIA_HOME}/AIAMetaData">
<include name="AIAxxxponents/ApplicationObjectLibrary/Ebiz/**" />
<include name="AIAxxxponents/ApplicationConnectorServiceLibrary/Ebiz/**" />
</fileset>
</UpdateMetadata>
<ManagedServer wlserver="pips.BAERPSOA" action="shutdown" failonerror="true"/>
<DbAdapter connection-instance-jndi="eis/DB/APPS" datasource-jndi="jdbc/APPS" xa-enabled="true" action="create" wlserver="pips.BAERPSOA"/>
<ManagedServer wlserver="pips.BAERPSOA" action="start" failonerror="true"/>
</Configurations>
<Deployments>
<xxxposite xxxpositeName="PurchaseOrderListEbizProvider" xxxpositedir="${AIA_HOME}/xxxposites/PurchaseOrderListEbizProvider" revision="1.0" wlserver="pips.BAERPSOA" action="deploy" />
</Deployments>
<PostInstallScript>
</PostInstallScript>
</DeploymentPlan>


AIAInstallProperties
--------------------------
<?xml version="1.0" encoding="UTF-8"?>
<properties>
<aiainstance>
<aiaHome>/oracle/product/Middleware/AIA</aiaHome>
<name>AIA_DEV</name>
<javahome>/oracle/product/jdk16</javahome>
<remote_install>false</remote_install>
<domain_root>/oracle/product/Middleware/user_projects/domains/base_domain</domain_root>
<mwHome>/oracle/product/Middleware</mwHome>
<soaHome>/oracle/product/Middleware/Oracle_SOA1</soaHome>
<aiainstalltype>standard</aiainstalltype>
<isencrypted>false</isencrypted>
</aiainstance>
<fp>
<version>11.1.1.3.0</version>
<server>
<adminhostname>xxx.xxx.xxx.xxx</adminhostname>
<adminport>7001</adminport>
<domainname>base_domain</domainname>
<username>*****</username>
<password>*****</password>
<servertype>Server</servertype>
<soaserver>soa_server1</soaserver>
<soaserverhostname>xxx.xxx.xxx.xxx</soaserverhostname>
<soaserverport>8001</soaserverport>
</server>
<db>
<aia>
<jdbc-url*</jdbc-url>
<username>******</username>
<password>******</password>
<createschema>true</createschema>
<sysusername>system</sysusername>
<syspassword>********</syspassword>
<role>SYSDBA</role>
<defxxxlttablespace>aia_data</defxxxlttablespace>
<temptablespace>TEMP</temptablespace>
</aia>
<mds>
<jdbc-url>*</jdbc-url>
<username>*****</username>
<password>*****</password>
</mds>
<sr>
<jdbc-url>*</jdbc-url>
<username>*****</username>
<password>*****</password>
<createschema>true</createschema>
<sysusername>*****</sysusername>
<syspassword>*****</syspassword>
<role>SYSDBA</role>
<defxxxlttablespace>aia_data</defxxxlttablespace>
<temptablespace>TEMP</temptablespace>
</sr>
<jms>
<jdbc-url>jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521/SOAD</jdbc-url>
<username>AIA_DEV_JMSUSER</username>
<password>******</password>
<createschema>true</createschema>
<sysusername>*****</sysusername>
<syspassword>*****</syspassword>
<role>SYSDBA</role>
<defxxxlttablespace>aia_data</defxxxlttablespace>
<temptablespace>TEMP</temptablespace>
</jms>
<xref>
<jdbc-url>jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521/SOAD</jdbc-url>
<username>*****</username>
<password>*****</password>
<createschema>true</createschema>
<sysusername>*****</sysusername>
<syspassword>*****</syspassword>
<role>SYSDBA</role>
<defxxxlttablespace>aia_data</defxxxlttablespace>
<temptablespace>TEMP</temptablespace>
</xref>
<aialifecycle>
<jdbc-url>jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521/SOAD</jdbc-url>
<username>*****</username>
<password>*****</password>
<createschema>true</createschema>
<sysusername>*****</sysusername>
<syspassword>*****</syspassword>
<role>SYSDBA</role>
<defxxxlttablespace>aia_data</defxxxlttablespace>
<temptablespace>TEMP</temptablespace>
</aialifecycle>
</db>
</fp>
<oer>
<server>
<publishtooer>false</publishtooer>
<oerurl/>
<username/>
<password>*****</password>
</server>
</oer>
<participatingapplications>
<BAERPSOA>
<server>
<adminhostname>xxx.xxx.xxx.xxx</adminhostname>
<adminport>7001</adminport>
<domainname>base_domain</domainname>
<username>*****</username>
<password>*****</password>
<servertype>Server</servertype>
<soaserver>soa_server1</soaserver>
<soaserverhostname>xxx.xxx.xxx.xxx</soaserverhostname>
<soaserverport>8001</soaserverport>
</server>
<db>
<aiademoparticipatingapp>
<jdbc-url>jdbc:oracle:thin:@sbuxtdb4.xxx.xxx.xxx:1571/FINDL</jdbc-url>
<username>*****</username>
<password>*****</password>
<createschema>true</createschema>
<sysusername>*****</sysusername>
<syspassword>*****</syspassword>
<role>SYSDBA</role>
<defxxxlttablespace>apps_ts_data</defxxxlttablespace>
<temptablespace>TEMP</temptablespace>
</aiademoparticipatingapp>
</db>
</BAERPSOA>
</participatingapplications>
<pips>
<BAERPSOA>
<version>11.1.1.3.0</version>
<server>
<adminhostname>xxx.xxx.xxx.xxx</adminhostname>
<adminport>7001</adminport>
<domainname>base_domain</domainname>
<username>*****</username>
<password>*****</password>
<servertype>Server</servertype>
<soaserver>soa_server1</soaserver>
<soaserverhostname>xxx.xxx.xxx.xxx</soaserverhostname>
<soaserverport>8001</soaserverport>
</server>
</BAERPSOA>
</pips>
</properties>

Edited by: Anish Raj on Dec 12, 2011 1:52 PM
  • 1. Re: Issues while Deploying using AID
    609722 Explorer
    Currently Being Moderated
    Hi Anish,

    You need to define the following in AIAInstallerProperties.xml for 'participatingapplications.Ebiz.db.EBIZ01' referred by DeploymentPlan -

    <participatingapplications>
    ..........
    <Ebiz>
              <db>
    <EBIZ01>
    <jdbc-url>jdbc:oracle:thin:@[ip]:[port]/[SID]</jdbc-url>
    <username>[username]</username>
    <password>[password]</password>
    </EBIZ01>
    </db>
              </Ebiz>
    ............
    </participatingapplications>

    Then try to redeploying.
    Rgds,
    Mandrita.
  • 2. Re: Issues while Deploying using AID
    AnishRaj Newbie
    Currently Being Moderated
    <?xml version="1.0" encoding="UTF-8"?>
    <properties>
    <aiainstance>
    <aiaHome>/oracle/product/Middleware/AIA</aiaHome>
    <name>AIA_DEV</name>
    <javahome>/oracle/product/jdk16</javahome>
    <remote_install>false</remote_install>
    <domain_root>/oracle/product/Middleware/user_projects/domains/base_domain</domain_root>
    <mwHome>/oracle/product/Middleware</mwHome>
    <soaHome>/oracle/product/Middleware/Oracle_SOA1</soaHome>
    <aiainstalltype>standard</aiainstalltype>
    <isencrypted>false</isencrypted>
    </aiainstance>
    <fp>
    <version>11.1.1.3.0</version>
    <server>
    <adminhostname>xxx.xxx.com.xxx</adminhostname>
    <adminport>7001</adminport>
    <domainname>base_domain</domainname>
    <username>xxx</username>
    <password>xxx</password>
    <servertype>Server</servertype>
    <soaserver>soa_server1</soaserver>
    <soaserverhostname>xxx.xxx.com.xxx</soaserverhostname>
    <soaserverport>8001</soaserverport>
    </server>
    <db>
    <aia>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:1521/SOAD</jdbc-url>
    <username>AIA_DEV_AIA</username>
    <password>xxx</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>******</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>aia_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </aia>
    <mds>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:1521/SOAD</jdbc-url>
    <username>DEV_MDS</username>
    <password>xxx</password>
    </mds>
    <sr>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:1521/SOAD</jdbc-url>
    <username>AIA_DEV_AIAEBOD</username>
    <password>xxx</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>*****</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>aia_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </sr>
    <jms>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:1521/SOAD</jdbc-url>
    <username>AIA_DEV_JMSUSER</username>
    <password>xxx</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>*****</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>aia_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </jms>
    <xref>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:1521/SOAD</jdbc-url>
    <username>AIA_DEV_XREF</username>
    <password>xxx</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>*****</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>aia_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </xref>
    <aialifecycle>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:1521/SOAD</jdbc-url>
    <username>AIA_DEV_AIALIFECYCLE</username>
    <password>xxx</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>*****</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>aia_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </aialifecycle>
    </db>
    </fp>
    <oer>
    <server>
    <publishtooer>false</publishtooer>
    <oerurl/>
    <username/>
    <password>*****</password>
    </server>
    </oer>
    <participatingapplications>
    <BAERPSOA>
    <server>
    <adminhostname>xxx.xxx.com.xxx</adminhostname>
    <adminport>7001</adminport>
    <domainname>base_domain</domainname>
    <username>xxx</username>
    <password>xxx</password>
    <servertype>Server</servertype>
    <soaserver>soa_server1</soaserver>
    <soaserverhostname>xxx.xxx.com.xxx</soaserverhostname>
    <soaserverport>8001</soaserverport>
    </server>
    <db>
    <aiademoparticipatingapp>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:9999/FINDL</jdbc-url>
    <username>apps</username>
    <password>******</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>*****</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>apps_ts_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </aiademoparticipatingapp>
    </db>
    </BAERPSOA>
    <Ebiz>
    <server>
    <adminhostname>xxx.xxx.com.xxx</adminhostname>
    <adminport>7001</adminport>
    <domainname>base_domain</domainname>
    <username>xxx</username>
    <password>xxx</password>
    <servertype>Server</servertype>
    <soaserver>soa_server1</soaserver>
    <soaserverhostname>xxx.xxx.com.xxx</soaserverhostname>
    <soaserverport>8001</soaserverport>
    </server>
    <db>
    <EBIZ01>
    <jdbc-url>jdbc:oracle:thin:@xxx.xxx.com.xxx:9999/FINDL</jdbc-url>
    <username>apps</username>
    <password>********</password>
    <createschema>true</createschema>
    <sysusername>system</sysusername>
    <syspassword>*****</syspassword>
    <role>SYSDBA</role>
    <defxxxlttablespace>apps_ts_data</defxxxlttablespace>
    <temptablespace>TEMP</temptablespace>
    </EBIZ01>
    </db>
    </Ebiz>
    </participatingapplications>
    <pips>
    <BAERPSOA>
    <version>11.1.1.3.0</version>
    <server>
    <adminhostname>xxx.xxx.com.xxx</adminhostname>
    <adminport>7001</adminport>
    <domainname>base_domain</domainname>
    <username>xxx</username>
    <password>xxx</password>
    <servertype>Server</servertype>
    <soaserver>soa_server1</soaserver>
    <soaserverhostname>xxx.xxx.com.xxx</soaserverhostname>
    <soaserverport>8001</soaserverport>
    </server>
    </BAERPSOA>
    </pips>
    </properties>

    I am still getting this error,
    /oracle/product/Middleware/AIA/Infrastructure/Install/AID/AIAInstallDriver.xml:72: The following error occurred while executing this line:
    /oracle/product/Middleware/AIA/Infrastructure/Install/AID/AIAExecuteDriver.xml:79: The following error occurred while executing this line:
    /oracle/product/Middleware/AIA/Infrastructure/Install/AID/AIAExecuteDriver.xml:58: The following error occurred while executing this line:
    /oracle/product/Middleware/AIA/aia_instances/AIA_DEV/tmp/AIDExecuteDP_temp_687973863.xml:6: The following error occurred while executing this line:
    /oracle/product/Middleware/AIA/Infrastructure/Install/AID/lib/AIDConfigurationLibraryTasks.xml:379: Not provided valid values for jdbc-url, username, password for datasource tag in null

    I think there is something wrong, and there are lot of unwanted sections in the file. Actually we took the defxxxlt file and modified it.

    BAERPSOA is the name of the Project from the AIA LCW, EBIZ01 is the SystemID and Ebiz is the short name. As of now, I am trying to deploy just one component, which is the db adapter composite connected to Oracle E Business Suite.

    Regards,
    ANish.

    Edited by: Anish Raj on Dec 12, 2011 2:05 PM
  • 3. Re: Issues while Deploying using AID
    729225 Newbie
    Currently Being Moderated
    Hi ,

    Even I'm facing the same issue.I have added the below tag to AIAInstallerProperties.xml file

    <participatingapplications.Agile.db.plmpip>
              <jdbc-url>jdbc:oracle:thin:@agilesappip02.in.corp.sa:1521/oradb</jdbc-url>
    <username>username</username>
    <password>password</password>
    <createschema>true</createschema>
    <sysusername>sys</sysusername>
    <syspassword>password</syspassword>
    <role>SYSDBA</role>
    <defaulttablespace>SYSTEM</defaulttablespace>
    <temptablespace>TEMP</temptablespace>
    <!-- </db> -->
    </participatingapplications.Agile.db.plmpip>

    Now the script did not throw "Not provided valid values for jdbc-url, username, password for participatingapplications" error but new error is thrown as

    "/u01/ora11g/Oracle/AIA_HOME/Infrastructure/Install/AID/lib/AIDConfigurationLibraryTasks.xml:97: Source file or resource collection, transactions or sql statement must be set"

    Can any one please help me out.

    Regards
    Srinivas Pusa
  • 4. Re: Issues while Deploying using AID
    717634 Newbie
    Currently Being Moderated
    Hi Srinivas,
    Check your deployment plan on what property values it requires during execution. Also in case, as per your use case you find something like ${participatingapplications.Agile.db.plmpip.jdbc-url} you need to add the following tag in the AIAInstallProperties.xml

    <participatingapplications>
    <Agile>
    <db>
    <plmpip>
    <jdbc-url>jdbc:oracle:thin:@agilesappip02.in.corp.sa:1521/oradb</jdbc-url>
    <username>username</username>
    <password>password</password>
    <createschema>true</createschema>
    <sysusername>sys</sysusername>
    <syspassword>password</syspassword>
    <role>SYSDBA</role>
    <defaulttablespace>SYSTEM</defaulttablespace>
    <temptablespace>TEMP</temptablespace>
    </plmpip>
    </db>
    </Agile>
    </participatingapplications>


    You can check for the properties AID has picked up by adding a -debug option while executing the deployment plan. If all of the above do not give you a clue of the exact issue please paste the complete logs for diagnosis.

    Thanks
    -Nipun

Legend

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