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
Commentaires