ESB Project Registration Fails After Upgrade to a 10.1.3.4 MLR or Execution of reset.sh with Entity Deployment Failed Error Code: 1001 : 5 (Doc ID 783475.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle ESB - Version 10.1.3.4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Sep-2010***


Symptoms

After upgrade to a 10.1.3.4 MLR or execution of the ESB reset.sh script found at $ORACLE_HOME/esb/bin, registration of projects to ESB fails from JDeveloper or ANT.

You get the following error at registration time:

Entity Deployment Failed

error code: 1001 : 5
summary: Failed to create Service "ESBService".
Fix: Ensure that the (a) Repository is available. (b) The Connection information for the Repository is Valid. Verify the detailed cause of error if available. Contact Oracle Support if error not fixable.



The ESB Designtime logfile at $ORACLE_HOME/j2ee/<ESB DT container name>/log/*_*_1/oc4j/log.xml will have the following similar errors:

<MESSAGE>
  <HEADER>
    <TSTZ_ORIGINATING>2009-02-16T13:09:48.858-05:00</TSTZ_ORIGINATING>
    <COMPONENT_ID>tip</COMPONENT_ID>
    <MSG_TYPE TYPE="ERROR"></MSG_TYPE>
    <MSG_LEVEL>1</MSG_LEVEL>
    <HOST_ID>t1-l1</HOST_ID>
    <HOST_NWADDR><Host IP Address></HOST_NWADDR>
    <MODULE_ID>esb.configuration.deployment</MODULE_ID>
    <THREAD_ID>17</THREAD_ID>
    <USER_ID>test</USER_ID>
  </HEADER>
  <CORRELATION_DATA>
    <EXEC_CONTEXT_ID><UNIQUE_ID><Host IP Address>:97790:1234807788280:19</UNIQUE_ID><SEQ>0</SEQ></EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT>Deployment failed due to :Failed to create Service "ESBService".
Ensure that the (a) Repository is available. (b) The Connection information for the Repository is Valid. Verify the detailed cause of error if available. Contact Oracle Support if error not fixable.</MSG_TEXT>
  </PAYLOAD>
</MESSAGE>



<MESSAGE>
  <HEADER>
    <TSTZ_ORIGINATING>2009-02-16T13:09:48.858-05:00</TSTZ_ORIGINATING>
    <COMPONENT_ID>tip</COMPONENT_ID>
    <MSG_TYPE TYPE="ERROR"></MSG_TYPE>
    <MSG_LEVEL>1</MSG_LEVEL>
    <HOST_ID>t1-l1</HOST_ID>
    <HOST_NWADDR><Host IP Address></HOST_NWADDR>
    <MODULE_ID>esb.configuration.deployment</MODULE_ID>
    <THREAD_ID>17</THREAD_ID>
    <USER_ID>test</USER_ID>
  </HEADER>
  <CORRELATION_DATA>
    <EXEC_CONTEXT_ID><UNIQUE_ID><Host IP Address>:97790:1234807788280:19</UNIQUE_ID><SEQ>0</SEQ></EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT>deployment failed with error </MSG_TEXT>
    <SUPPL_DETAIL><![CDATA[oracle.tip.esb.console.exception.ConsoleException: Failed to create Service "ESBService".
Ensure that the (a) Repository is available. (b) The Connection information for the Repository is Valid. Verify the detailed cause of error if available. Contact Oracle Support if error not fixable.
at oracle.tip.esb.console.XMLConsoleManagerImpl.createServiceInRepository(XMLConsoleManagerImpl.java:701)
at oracle.tip.esb.console.XMLConsoleManagerImpl.createServiceFromElement(XMLConsoleManagerImpl.java:657)
at oracle.tip.esb.configuration.deployment.JDevDeploymentManager.createEntity(JDevDeploymentManager.java:686)
at oracle.tip.esb.configuration.deployment.JDevDeploymentManager.createServices(JDevDeploymentManager.java:670)
at oracle.tip.esb.configuration.deployment.JDevDeploymentManager.deploy(JDevDeploymentManager.java:185)
at oracle.tip.esb.configuration.deployment.DeploymentServlet.doPost(DeploymentServlet.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.security.jazn.oc4j.JAZNFilter$1.run(JAZNFilter.java:400)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:414)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:623)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: oracle.tip.esb.model.repository.exception.RepositoryException: Unable to save Service entity with name ESBService and id 36A5E960F94711DDBFC15BB30BDFE1C9
Ensure that the repository is accessible
at oracle.tip.esb.model.repository.database.DatabaseRepository.createService(DatabaseRepository.java:188)
at oracle.tip.esb.console.XMLConsoleManagerImpl.createServiceInRepository(XMLConsoleManagerImpl.java:689)
... 25 more
Caused by: java.sql.SQLException: [POL-5205] column FQ_PATH not found
at oracle.lite.poljdbc.LiteThinJDBCConnection.thinSQLError(Unknown Source)
at oracle.lite.poljdbc.LiteThinJDBCStatement.thinSqlPrepare(Unknown Source)
at oracle.lite.poljdbc.LiteThinJDBCPreparedStatement.prepare(Unknown Source)
at oracle.lite.poljdbc.POLJDBCPreparedStatement.<init>(Unknown Source)
at oracle.lite.poljdbc.POLJDBCPreparedStatement.<init>(Unknown Source)
at oracle.lite.poljdbc.OraclePreparedStatement.<init>(Unknown Source)
at oracle.lite.poljdbc.POLJDBCConnection.prepareStatement(Unknown Source)
at oracle_lite_poljdbc_OracleConnection_Proxy.prepareStatement()
at oracle.tip.esb.model.repository.database.sql.SQLUtil.prepareStatement(SQLUtil.java:132)
at oracle.tip.esb.model.repository.database.sql.ServiceSQL.createService(ServiceSQL.java:177)
at oracle.tip.esb.model.repository.database.DatabaseRepository.createService(DatabaseRepository.java:183)
... 26 more
]]></SUPPL_DETAIL>
  </PAYLOAD>
</MESSAGE>



<MESSAGE>
  <HEADER>
    <TSTZ_ORIGINATING>2009-02-16T13:09:49.468-05:00</TSTZ_ORIGINATING>
    <COMPONENT_ID>tip</COMPONENT_ID>
    <MSG_TYPE TYPE="NOTIFICATION"></MSG_TYPE>
    <MSG_LEVEL>1</MSG_LEVEL>
    <HOST_ID>t1-l1</HOST_ID>
    <HOST_NWADDR><Host IP Address></HOST_NWADDR>
    <MODULE_ID>esb.configuration.deployment</MODULE_ID>
    <THREAD_ID>17</THREAD_ID>
    <USER_ID>test</USER_ID>
  </HEADER>
  <CORRELATION_DATA>
    <EXEC_CONTEXT_ID><UNIQUE_ID><Host IP Address>:97790:1234807788280:19</UNIQUE_ID><SEQ>0</SEQ></EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT> xml returned :&lt;deploymentSummary>
   &lt;message>Entity Deployment Failed&lt;/message>
   &lt;errors>
      &lt;error code="1001" severity="5">
         &lt;description>Failed to create Service "ESBService".&lt;/description>
         &lt;fix>Ensure that the (a) Repository is available. (b) The Connection information for the Repository is Valid. Verify the detailed cause of error if available. Contact Oracle Support if error not fixable.&lt;/fix>
      &lt;/error>
   &lt;/errors>
&lt;/deploymentSummary>
</MSG_TEXT>
  </PAYLOAD>

Changes

You have recently applied one of the 10.1.3.4 MLR patch sets or executed the script $ORACLE_HOME/esb/bin/reset.sh. 

MLR patch set information can be found here:
<Note 741499.1> Supplement to 10.1.3.4 MLR README.txt

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms