1 Reply Latest reply: Jan 29, 2012 10:13 PM by Edward RSS

    Issue creating ConnectionPool as per documentation in 974949.1

    Edward
      Hello all,

      I am using AIA 2.5 PMDM PIP to sync OPH and Seibel/BRM.
      We are configuring the connectionPool as described in 974949.1 in the SOA server (OC4J 10.3.1.4) hosting the AIA.
      However we are facing the below error as soon as we are trying to create the same.

      An error has occurred.
      Error invoking method: replaceProperties on MBean: oc4j:j2eeType=JDBCDriver,name="MyAppsDataSourceConnectionPool1-Connection Factory",J2EEApplication=default,J2EEServer=standalone
      Error invoking method: replaceProperties on MBean: oc4j:j2eeType=JDBCDriver,name="MyAppsDataSourceConnectionPool1-Connection Factory",J2EEApplication=default,J2EEServer=standalone

      Hide Additional Trace Information
      oracle.oc4j.admin.jmx.shared.exceptions.JMXRuntimeException: Error invoking method: replaceProperties on MBean: oc4j:j2eeType=JDBCDriver,name="MyAppsDataSourceConnectionPool1-Connection Factory",J2EEApplication=default,J2EEServer=standalone at oracle.oc4j.admin.jmx.distributed.SimpleInstanceMBeanServerDelegate.invoke(SimpleInstanceMBeanServerDelegate.java:970) at oracle.oc4j.admin.jmx.server.state.LocalizationFilterMBeanServer.invoke(LocalizationFilterMBeanServer.java:579)
      ...

      The same error mentioned by someone in https://kr.forums.oracle.com/forums/thread.jspa?threadID=2316596

      I checked the same in Oracle KM and found a note ID 1065009.1, which suggested the follwoing action:


      1> Replace GWYUID=APPLSYSPUB/null with GWYUID=APPLSYSPUB/PUB in the dbcFile if needed
      Make sure it is valid

      2> Restart default application or the entire server via the oc4j admin console, and retest the issue.

      If I ceck my dbFile, it has the following entry (I have removed the IP and Port), which is already conforming point1 mentioned above.

      bash-3.00$ more PRO_APPL_SOA.dbc
      #Desktop DB Settings
      #Fri Jan 26 14:14:23 SGT 2012
      FNDNAM=APPS
      APPL_SERVER_ID=B6F2AFF74FF75CF6E04400144F77FD0C14956825240300268321962714852956
      APPS_JDBC_URL=jdbc\:oracle\:thin\:@XXX.XXX.XXX.XXX\:YYYY\:PRO
      GWYUID=APPLSYSPUB/PUB
      bash-3.00$


      Any idea, how to resolve it?


      /Ed