Starting Oracle WebCenter Ensemble adminui

In some situations, a FQDN (Fully Qualified Domain Name) machine can lead to problems after a fresh install of Oracle Webcenter Ensemble, when accessing to Admin console http://mymachine:20070/ensembleadminui/run/ensemble.faces

The problems occurs on Windows XP or 2003 machines.
Version of ensemble wich is concerned: 10.3.0j.0 and above

In this case, have a look to the log into: <HOME_DIR>\ensembleadminui\10.3.0\wrapper.log

If you get an error as following

…<1.0.0-SNAPSHOT-SNAPSHOT nonfatal store error> kodo.jdo.DataStoreException: Syntax error: Encountered ")" at line 1, column 176. {SELECT t0.DOMN, t0.REALMN, t0.NAME, t1.URI FROM BEASAML2_SPPARTNER t0, BEASAML2_SP_AUDIENCEURI t1 WHERE (t0.DOMN = ? AND t0.REALMN = ? AND t0.NAME = ?) AND t0.DOMN = t1.DOMN(+) AND t0.REALMN = t1.REALMN(+) AND t0.NAME = t1.PARTNER_NAME(+) ORDER BY t0.DOMN ASC, t0.REALMN ASC, t0.NAME ASC} [code=-1, state=42X01….

then replace the FQDN by localhost into: <HOME_DIR>\settings\configuration.xml file.
Note: If you do a backup of this file, put it in an other directory. There must be remain only ONE config file.

Replace the original FQDN (ie: mymachine.mydomain.com) by localhost

<setting name="database-connection:dbhost">
   <value xsi:type="xsd:string">localhost</value>
</setting>

then restart all the Ensemble services.

In order to install the last version of WebCenter Ensemble for Windows, download the following softwares:

• Ensemble base Version 10.3.0 (07/2008)
• Ensemble Patch 10.3.0.1.0 (07/2009)
• Hibernate 3.2.0.GA
• Hibernate-Annotations 3.2.0.GA

Base version must be installed before the patch.

Source: Oracle Support and Release Notes for WebCenter Ensemble 10gR3