Concurrent Manager encountered an error while running SQL*Plus for your concurrent request


Symptoms :

while running specific report some times you may face this problem.



+---------------------------------------------------------------------------+
Purchasing: Version : 12.0.0

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

POXPOPDOI module: Import Standard Purchase Orders
+---------------------------------------------------------------------------+

Current system time is 19-JUL-2010 13:29:26

+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------

STANDARD

N

INCOMPLETE

------------
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 492644.

Review your concurrent request log and/or report output file for more detailed information.

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

Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 19-JUL-2010 13:29:27

+---------------------------------------------------------------------------+


Step 1)check for invalid object.
Step 2)if there is some objects then compile then.
Step 4)check for temp directory permission in my case it was /usr/tmp

if the issue is still there.
Step 5)check for spaces in /usr/tmp if u notice that disk space is low
Step 6)check for unwanted log and remove them like cups log.

if the issue is still exist

Step 7)enable concurrent debug on user level from define -> profile Step 8)issue tkprof on $ORACLE_HOME/admin/udump/xxxxx.trc folder.
Step 9)change the profile option again to default one.check for ora-erros errors etc.

Leave a comment