2 Replies Latest reply: Sep 12, 2012 7:50 AM by user11978929 RSS

    Concurrent programs failing during night batch run

    user11978929
      Hi All,

      Concurrent programs failing with below message. Any help is appreciated.

      ---------------------------------------------------------------------------
      Bills of Material: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      CSTCRACC module: Create Accounting - Cost Management
      ---------------------------------------------------------------------------

      Current system time is 05-SEP-2012 01:01:30

      ---------------------------------------------------------------------------

      Exception in thread "main" oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
           at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
           at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
           at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
           at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:602)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:579)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:533)
           at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:301)
           at oracle.apps.fnd.cp.request.CpContext.<init>(CpContext.java:144)
           at oracle.apps.fnd.cp.request.CpContext.<init>(CpContext.java:127)
           at oracle.apps.fnd.cp.request.Run.main(Run.java:127)
      Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.fnd.common.Pool.createObject(Pool.java:1286)
           at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)
           at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
           at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:330)
           at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
           at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2314)
           at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2251)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2108)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1918)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1762)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1775)
           at oracle.apps.fnd.cp.request.CpContext.getJDBCConnection(CpContext.java:254)
           at oracle.apps.fnd.cp.request.CpContext.getJDBCConnection(CpContext.java:238)
           at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
           at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
           ... 17 more
      Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Socket read timed out
           at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:937)
           at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:1016)
           at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:814)
           at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:230)
           at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
           at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
           at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
           at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
           at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)
           ... 31 more
      Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Socket read timed out
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1522)
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1425)
           at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:919)
           ... 39 more
      Caused by: java.sql.SQLException: Socket read timed out
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
           at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
           at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
           at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
           at java.sql.DriverManager.getConnection(DriverManager.java:582)
           at java.sql.DriverManager.getConnection(DriverManager.java:154)
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1509)
           ... 41 more
      Caused by: oracle.net.ns.NetException: Socket read timed out
           at oracle.net.ns.Packet.receive(Packet.java:320)
           at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
           at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
           ... 48 more
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------

      oracle.apps.xdo.oa.cp.JCP4XDODataEngine
      Program exited with status 1
      Successfully resubmitted concurrent program CSTCRACC with request ID 11227291 to start at 05-SEP-2012 02:00:00 (ROUTINE=AFPSRS)


      ---------------------------------------------------------------------------
      Executing request completion options...

      Output file size:
      0

      ------------- 1) PUBLISH -------------
      Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
      --------------------------------------

      ------------- 2) PRINT   -------------
      Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
      --------------------------------------

      ------------- 3) NOTIFY  -------------
      Sending notification to PSINGH.
      Notification ID is 3091905.
      --------------------------------------

      ------------- 4) NOTIFY  -------------
      Sending notification to DTHIBODEAUX.
      Notification ID is 3091906.
      --------------------------------------

      ------------- 5) NOTIFY  -------------
      Sending notification to HZ_PARTY:25178.
      Notification ID is 3091907.
      --------------------------------------


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 05-SEP-2012 01:11:44

      ---------------------------------------------------------------------------
        • 1. Re: Concurrent programs failing during night batch run
          Deborahcrm-Oracle
          Hello,

          Please open an SR with the Cost Accounting team and provide the FND logs. Advise if this is a cloned instance and if any other concurrent programs have errors.

          Steps to get the FND log messages:

          1. Navigate Responsibility: System Administrator > Profile > System >Query
          User: User submitting the Report
          Profile: FND:%Debug%

          2. Set the following Profile values at the user level:

          FND: Debug Log Enabled Yes
          FND: Debug Log Filename <empty>
          FND: Debug Log Level STATEMENT
          FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing
          FND: Debug Log Module %

          For the Create Accounting process happens in Concurrent mode:
          3. Reproduce the issue by submitting the Create Accounting program

          4. Get the fnd_log_messages in excel format:

          SELECT log_sequence, message_text,substr(module,1,100)
          FROM fnd_log_messages msg, fnd_log_transaction_context tcon
          WHERE msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID
          AND tcon.TRANSACTION_ID= /*Give the request id of accounting program*/
          order by log_sequence desc



          Thank you,
          Deborah Bourgeois, Oracle Customer Support