DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, May 23, 2012

Concurrent Request completed with "sqlldr : Permission denied" error

While running the Concurrent Request it has completed with the following Error.

Arguments
------------
/testapps/apps/apps_st/appl/doyen/12.0.0/Interfaces/DOYENINBOUND/doyen2.csv

sqlldr: Permission denied
usdsop: exec failed during spawnusdsop cannot write to pipe

Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.

Action: Check the other process for abrupt termination. Check that you have sufficient resource: Broken pipe
usdsop cannot write to pipe

Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.

Cause:

Due to some reasons the permission has been changed or the binary may be corrupted.

solution:
=========
1. Check the permission for sqlldr file in (ORACLE_HOME) ie) 10.1.2 ORACLE_HOME/bin directory
2. Check the ORACLE_HOME path is set correctly for apps.

No comments: