Oracle 11g: Fusion Order Demo

I’m listing out all the problems which I faced during Oracle 11G Fusion Order Demo setup. This may help others who facing similar problem.


Key points I learned was, the correct version selection of Fusion Order Demo application. My JDeveloper version was 11.1.1.6, So I selected FusionOrderDemo_R1PS5.zip(http://www.oracle.com/technetwork/developer-tools/jdev/learnmore/fod1111-407812.html). Wrong selection of demo application leads to lot of trouble.

Problem:

BUILD FAILED

D:\Zia\SOA11g\11.1.1.6\FusionOrderDemo_R1\Infrastructure\Ant\build.xml:52: The following error occurred while executing this line:

D:\Zia\SOA11g\11.1.1.6\FusionOrderDemo_R1\Infrastructure\DBSchema\build.xml:334: C:\oracle\Middleware\jdeveloper\modules\oracle.javacache_11.1.1 not found.

Solution:

DatabaseSchema build.xml pointing to wrong module location

Search and replace '${jdeveloper.home}/modules' with '${jdeveloper.home}/../oracle_common/modules'

------------------------------------------------------------------------------------------------------------
Problem:

[java] oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoClassDefFoundError, msg=oracle/jdbc/OracleClob
at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)
at org.apache.tools.ant.taskdefs.Java.run(Java.java:764)
at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218)
at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:132)
at org.apache.tools.ant.taskdefs.Java.execute(Java.java:105)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)

Solution:
Move to directory $DEMO_HOME\Infrastructure\DBSchema
Edit build.xml and add below elements after ' '

<fileset dir="${jdeveloper.home}/../oracle_common/modules/oracle.jdbc_11.1.1">
<include name="ojdbc6dms.jar"/>
</fileset>

------------------------------------------------------------------------------------------------------------
Problem:

Error(9,6): The code of method _jspService(HttpServletRequest, HttpServletResponse) is exceeding the 65535 bytes limit

Solution:

Might be temporary memory issue repeat the step-> 6.Right click StoreFrontUI and choose Run. The home.jspx page within the StoreFrontUI project is the default run target and will launch the main application screen or follow below link

http://www.velocityreviews.com/forums/t146001-reached-the-65535-bytes-limit.html
------------------------------------------------------------------------------------------------------------
Problem:

<BEA-149265> <Failure occurred in the execution of deployment request with ID '1321910416823' for task '14'. Error is: 'weblogic.application.ModuleException: Failed to load webapp: 'StoreFrontModule''

weblogic.application.ModuleException: Failed to load webapp: 'StoreFrontModule'

Solution:

Error occured due to wrong version selection of the tutorial. Follow below link to get the correct version.

http://www.oracle.com/technetwork/developer-tools/jdev/learnmore/fod1111-407812.html

------------------------------------------------------------------------------------------------------------
Problem:

BUILD FAILED

D:\Zia\SOA11g\11.1.1.6\FusionOrderDemo_R1\CompositeServices\bin\build.xml:495: The following error occurred while executing this line:

D:\Zia\SOA11g\11.1.1.6\FusionOrderDemo_R1\CompositeServices\bin\build.xml:199: The following error occurred while executing this line:

D:\Zia\SOA11g\11.1.1.6\FusionOrderDemo_R1\CompositeServices\OrderApprovalHumanTask\bin\build.xml:89: C:\oracle\Middleware\jdeveloper\modules\oracle.javatools_11.1.1 not found.

Solution:

Error occured due to wrong version selection of the tutorial. Follow below link to get the correct version.

http://www.oracle.com/technetwork/developer-tools/jdev/learnmore/fod1111-407812.html

------------------------------------------------------------------------------------------------------------
Problem:

Error while trying to access http://hostname:port/StoreFrontModule/faces/home.jspx. FODDS is not found pop up message displayed continously and at the end shows NullPointerException message.

FOD user account also get locked.

Solution:

1) Release the lock from the database using below scripts as sys or system user.
i) select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where s.username = 'FOD' and p.addr (+) = s.paddr;
ii) alter system kill session '197,27241';


2) Global JNDI Name configuration
i) create a global JDBC Data Source for the FOD user created earlier via the infrastructure project. Go to the Weblogic Server Console and select Services - Data Sources - New - GenericDataSource. Define a FODDS similar as follows. It is important to use a JNDI name that will also be defined in the StoreFrontModule accordingly:

Use JNDI Name as 'jdbc/FODDS', Give proper hostname and credentials(FOD/fusion)

ii) In StoreFrontService - Application Sources - oracle.foddemo.storefront - store - service - StoreServiceAM (RightClick) - Configurations, define the correct JNDI name for JDBCDataSource in all available Names like StoreServiceAM, StoreServiceAMLocalWeb and StoreFrontService