This discussion is archived
2 Replies Latest reply: Sep 12, 2012 5:50 AM by user11978929 RSS

Concurrent programs failing during night batch run

user11978929 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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
  • 2. Re: Concurrent programs failing during night batch run
    user11978929 Newbie
    Currently Being Moderated
    Thanks for the answer

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points