Friday, 21 January 2011

The composite XYZ is not available

After the soa instance restart migrated, updated process don't come back ("Status Pending"). When click on it then error:

The composite XYZ is not available. This could happen because either the composite has been undeployed or soa-infra has not yet loaded this composite.
Unable to find a WSDL that has a definition for service {XYZ}ABC and port DEG. Please make sure that the port attribute for the binding defined in the composite file is correct by checking the namespace, service name, and port name. In addition, check that the WSDL associated with the binding namespace is imported and currently reachable (check the import nodes at the top of the composite file). Finally, validate the HTTP proxy settings for the server.

Solution: Open project composite in jDeveloper and replace
"http://MyGreatestSoaInstanceKillsMeSoulfly:8001/soa-infra/services/default/AIAAsyncErrorHandlingBPELProcess/client?WSDL"
with
"oramds:/apps/AIAMetaData/AIAComponents/InfrastructureServiceLibrary/V1/wsdls/AIAAsyncErrorHandlingBPELProcess.wsdl"

The reson for error is that during the load of composite mentioned AIAAsyncErrorHandlingBPELProcess might not be loaded.

Oracle Customer Hub

Oracle Customer Hub looks BIG. Looks SERIOUS. Let's open http://www.oracle.com/us/products/applications/master-data-management/oracle-customer-hub-081990.html
Sales persons can talk for hours about positive things it could bring to Your company (well, it would - we are running eBS, PeopleSoft and JDE). Ok, let's go back to citic:
1. OCH lonely nice thing is MDM (let's "ASS U ME" that design + build for simplified version might take 1 month);
2. OCH suggest to build custom flows - MDM will decide which systems should be notified and let You custom BPEL process know..
3. OCH have a lot of prebuilt stuff - might be but to sort it out You need to outsource dude with tie from Oracle.
Friday's beer is comming!

Thursday, 20 January 2011

Harvest Project and error raised like: Unable to read plugin file % jdeveloper\harvester\plugins\biz.introspector

Solution: Lookup OER repository installation directory <OER_HOME>/core/tools/solutions/*-OER-Harvester-Solution-Pack.zip
Login to OER and navigate: Admin -> Import/Export -> Import / Export Client -> Applet started -> Import -> Select file and press "Next"..
Run "Harvest Project" in jDeveloper again.  

jDeveloper 11g shows oramds as unrecognized

In case DB used then make sure the Application adf-config.xml file looks similar to this:

<?xml version="1.0" encoding="UTF-8" ?>
<adf-config xmlns="http://xmlns.oracle.com/adf/config"
            xmlns:sec="http://xmlns.oracle.com/adf/security/config">
<adf-mds-config xmlns="http://xmlns.oracle.com/adf/mds/config">
<mds-config xmlns="http://xmlns.oracle.com/mds/config">
<persistence-config>
<metadata-namespaces>
<!-- shared namespace for soa artifacts, such as xsd / wsdl -->
<namespace metadata-store-usage="mstore-usage_1" path="/soa/shared"/>
<!-- customer namespace for sharing stuff -->
<namespace metadata-store-usage="mstore-usage_1" path="/apps"/>
<!-- configuration namespace for the SE/BCs, only exists on the server -->
<namespace metadata-store-usage="mstore-usage_1" path="/soa/configuration"/>
</metadata-namespaces>
<metadata-store-usages>
<metadata-store-usage id="mstore-usage_1">
<metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
<property name="jdbc-userid" value="dev_mds"/>
<property name="jdbc-password" value="password"/>
<property name="jdbc-url"
value="jdbc:oracle:thin:@host:1521:sid"/>
<property name="partition-name" value="soa-infra"/>
</metadata-store>
</metadata-store-usage>
</metadata-store-usages>
</persistence-config>
</mds-config>
</adf-mds-config>
  <sec:adf-security-child xmlns="http://xmlns.oracle.com/adf/security/config">
    <CredentialStoreContext credentialStoreClass="oracle.adf.share.security.providers.jps.CSFCredentialStore"
                            credentialStoreLocation="../../src/META-INF/jps-config.xml"/>
  </sec:adf-security-child>
</adf-config>

AIA Migration

Prerequisites:
1. Running 10g server
2. Running 11g server
3. jDeveloper 11g installed
4. SOA suite installed

under the MW_HOME/Oracle_SOA/util/AIAMigrationUtility script AIAMigrationUtility.xml
As input AIAMigrationUtility.properties with following params:
jdev.home=<jDev HOME>
oracle.home=<PATH to SOA home>
service.home=<Service to migrate PATH>
service.name=<Service name>
http.hostname=<Target HOST>
http.port=<Target SOA PORT>
application.name=<Application name>
target.dir=<Target directory>
process.type=<Provider, Requestor, DBAdapter, JMSAdapter, OracleAppsAdapter, EBF, EBS>

Before execution make sure following environment variables are set (Win):
MW_HOME (set MW_HOME=Directory where Middleware installed)
ANT_HOME (set ANT_HOME=<MW_HOME>\\Oracle_SOA\\ant)
SOA_HOME (set SOA_HOME=<MW_HOME>\\Oracle_SOA)
ORACLE_HOME (set ORACLE_HOME=<MW_HOME>\\Oracle_SOA1)
CLASSPATH (set CLASSPATH=.;<MW_HOME>\\wlserver_10.3\\server\\lib\\weblogic.jar;<MW_HOME>\\Oracle_SOA\\lib\\aia.jar;<MW_HOME>\\modules\\net.sf.antcontrib_1.0.0.0_1-0b2\\lib\\ant-contrib.jar)
PATH (set PATH=<MW_HOME>\\Oracle_SOA1\\ant\\bin;<MW_HOME>\\jrockit_160_14_R27.6.5-32\\jre\\bin;<MW_HOME>\\wlserver_10.3\\server\\lib\\weblogic.jar)

Run the migration for each process:
ant -f AIAMigrationUtility.xml > Process-1.log

Migrate DVM

ant -f AIAMigrationUtility.xml upgradeDVM -DinputDir=C:\SVN\DVMs -DoutputDir=C:\NEW


Don't forget to add path afterwards (not created by default):
xmlns="http://xmlns.oracle.com/dvm"
Btw, good manual available for this!

BPEL HTTP connection error code is 407

JDeveloper -> Tools -> Preferences -> Web Browser and Proxy -> Uncheck "Use HTTP Proxy Server"
There might be some issues for "Update" functionality later. But then You can check it on if needed.